News:

Want to get involved in developing SMF, then why not lend a hand on our github!

Main Menu

MySQL Errors with boards in RC2

Started by Redeye, January 01, 2006, 03:21:56 AM

Previous topic - Next topic

Redeye

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:

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.

Redeye

#1
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?

Grudge

#2
Bugger, that's a bug.

Seems to be that maxMsgID is getting lost somewhere. Can you do this in phpMyAdmin:

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 only a half geek really...

Redeye

Cheers Grudge, that fixed it.

Happy New Year  ;)

Ted_G

Quote from: Grudge 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:

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.

andyhornby

Quote from: Grudge 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:

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?

Ben_S

Liverpool FC Forum with 14 million+ posts.

andyhornby

Quote from: Ben_S on January 19, 2006, 07:05:50 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?

Ben_S

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.

andyhornby

Im getting an error message;

QuoteSQL 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...?

andyhornby

Doh...!

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

All is working fine, thanks for your help

Andy

RvDam

Is this a bug. And if so, why isn't it solved yet?  :(

Advertisement: