MessageIndex error on fresh install

[dangerine]

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  )

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:

Code Select Expand

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.

[ThisForumRules]

http://www.simplemachines.org/community/index.php?topic=67053.0  might help.

[JayBachatero]

Bugger, that's a bug.

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

Code Select Expand


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