Advertisement:

Author Topic: MySQL Errors with boards in RC2  (Read 7915 times)

Offline Redeye

  • Jr. Member
  • **
  • Posts: 182
  • Gender: Male
    • RAM's
MySQL Errors with boards in RC2
« on: January 01, 2006, 03:21:56 AM »
Hi

This is happening on a test installation with only a couple of dummy members and no posts.

Ran upgrade from RC1 to RC2. No problems.
Deleted "General" category and created "Member Map" category.
Added "Member Map" board in category.
So I only have 1 category and 1 board.
If I click the board name to make a post I get the following error:

Code: [Select]
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 1, 2)' at line 3
File: /home/training/public_html/smf1/Sources/MessageIndex.php
Line: 102

I know the MySQL and everything else is correct and up to date at my host, so there's no problem with old versions of MySQL.
Also there were no problems prior to the upgrade.
« Last Edit: January 01, 2006, 08:57:19 PM by xenovanis »

Offline Redeye

  • Jr. Member
  • **
  • Posts: 182
  • Gender: Male
    • RAM's
Re: MySQL Errors with boards in RC2
« Reply #1 on: January 01, 2006, 04:58:21 AM »
OK, just done a complete fresh install of RC2.

Checked the default installed board and was able to select the board and then select the "Welcome" post.

Then did as before, and deleted the default installed board and category, and then created a new one.

Result, same error message!

So, RC2 will work with the default boards/category but if you delete you get error?
« Last Edit: January 01, 2006, 05:17:59 AM by Redeye »

Offline Grudge

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 10,742
  • Gender: Male
  • Unofficial nuisance
Re: MySQL Errors with boards in RC2
« Reply #2 on: January 01, 2006, 05:33:26 AM »
Bugger, that's a bug.

Seems to be that maxMsgID is getting lost somewhere. Can you do this in phpMyAdmin:
Code: [Select]
REPLACE INTO smf_settings (variable, value) VALUES ('maxMsgID', 1);

Once you have one post in your board this will go away.

Added ; at the end of the query
« Last Edit: January 04, 2006, 09:00:38 PM by JayBachatero »
I'm only a half geek really...

Offline Redeye

  • Jr. Member
  • **
  • Posts: 182
  • Gender: Male
    • RAM's
Re: MySQL Errors with boards in RC2
« Reply #3 on: January 01, 2006, 05:37:10 AM »
Cheers Grudge, that fixed it.

Happy New Year  ;)

Offline Ted_G

  • Semi-Newbie
  • *
  • Posts: 12
  • Gender: Male
Re: MySQL Errors with boards in RC2
« Reply #4 on: January 04, 2006, 07:52:42 PM »
Bugger, that's a bug.

Seems to be that maxMsgID is getting lost somewhere. Can you do this in phpMyAdmin:
Code: [Select]
REPLACE INTO smf_settings (variable, value) VALUES ('maxMsgID', 1)

Once you have one post in your board this will go away.

Fixed my issue too although I needed to add a ; at the end of the query in order for is to work.

Thanks for the help that fixed it.

Offline andyhornby

  • Semi-Newbie
  • *
  • Posts: 11
Re: MySQL Errors with boards in RC2
« Reply #5 on: January 19, 2006, 07:03:56 AM »
Bugger, that's a bug.

Seems to be that maxMsgID is getting lost somewhere. Can you do this in phpMyAdmin:
Code: [Select]
REPLACE INTO smf_settings (variable, value) VALUES ('maxMsgID', 1);

Once you have one post in your board this will go away.

Added ; at the end of the query

I'm not quite sure what phpMyAdmin is - can anyone elaborate, as to where I put this code?

Offline Ben_S

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 11,702
  • xxx
Re: MySQL Errors with boards in RC2
« Reply #6 on: January 19, 2006, 07:05:50 AM »
Liverpool FC Forum with 14 million+ posts.

Offline andyhornby

  • Semi-Newbie
  • *
  • Posts: 11
Re: MySQL Errors with boards in RC2
« Reply #7 on: January 19, 2006, 07:22:14 AM »
What is phpMyAdmin?

Thanks, I can use this through my server, but I'm not sure what it is or how/where to add the code.

Sorry to be a pain, but can you elaborate?

Offline Ben_S

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 11,702
  • xxx
Re: MySQL Errors with boards in RC2
« Reply #8 on: January 19, 2006, 07:26:06 AM »
Login to phpMyAdmin,

On the left hand frame will be a list of databases, select the database your SMF board uses and wait for the main frame to load.

Click the sql tab at the top of the main frame and paste in the code provided and click go.
Liverpool FC Forum with 14 million+ posts.

Offline andyhornby

  • Semi-Newbie
  • *
  • Posts: 11
Re: MySQL Errors with boards in RC2
« Reply #9 on: January 19, 2006, 07:32:30 AM »
Im getting an error message;

Quote
SQL query:

REPLACE INTO smf_settings( variable, value )
VALUES (

'maxMsgID', 1
)


MySQL said: 

#1146 - Table 'rozzers_smf11.smf_settings' doesn't exist

I'm adding the query in the root databaes - Do I need to add it to the "_board" database instead...?

Offline andyhornby

  • Semi-Newbie
  • *
  • Posts: 11
Re: MySQL Errors with boards in RC2
« Reply #10 on: January 19, 2006, 07:37:02 AM »
Doh...!

it's ok I forgot to change the smf_ to rozzers_!!!

All is working fine, thanks for your help

Andy

Offline RvDam

  • Newbie
  • *
  • Posts: 4
Re: MySQL Errors with boards in RC2
« Reply #11 on: July 04, 2006, 08:19:25 AM »
Is this a bug. And if so, why isn’t it solved yet?  :(