Hi there -
I'm rebuilding my heavily-converted board to a spankin' new version of RC2 and I've hit my first problem. (It took me longer than I thought to hit one, but I did :P)
The main index is loading fine, but when I try to look at a specific board's index I get:
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, 6)' at line 3
File: /home/mysite/public_html/forum/Sources/MessageIndex.php
Line: 102
Here's line 102:
VALUES ($modSettings[maxMsgID], $ID_MEMBER, $board)", __FILE__, __LINE__);
After lots of tinkering and comparing it to previous versions, it seems like it doesn't know what $modSettings[maxMsgID] is. And neither do I, frankly. That's different to what was there on my last version (which I copied and pasted - didn't work). There's no maxMsgID variable in my ModSettings.php. I uninstalled all mods and reinstalled those two files to be on the safe side, but still not working.
Any ideas?
Thanks in advance.
http://www.simplemachines.org/community/index.php?topic=67053.0 might help.
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