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.
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?
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
Cheers Grudge, that fixed it.
Happy New Year ;)
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.
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?
What is phpMyAdmin? (http://www.simplemachines.org/community/index.php?topic=21919.0)
Quote from: Ben_S on January 19, 2006, 07:05:50 AM
What is phpMyAdmin? (http://www.simplemachines.org/community/index.php?topic=21919.0)
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?
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.
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...?
Doh...!
it's ok I forgot to change the smf_ to rozzers_!!!
All is working fine, thanks for your help
Andy
Is this a bug. And if so, why isn't it solved yet? :(