Advertisement:

The installation seemed to work, but... "You have an error in your SQL syntax"

Aloittaja headspin, elokuu 07, 2006, 04:37:02 AP

« edellinen - seuraava »

headspin

SMF Version: SMF 1.1 RC2
When I'm not logged in as the administrator (just guest), clicking on a forum name displays the empty forum (I created 4 or 5). But when I'm logged in, what I get is:

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, 7)' at line 3
File: (...web_server_root/f/Sources/MessageIndex.php
Line: 102

I haven't installed any mods, just the board itself and the security update.

And line 102 reads something like:

           db_query("
           REPLACE INTO {$db_prefix}log_boards
           (ID_MSG, ID_MEMBER, ID_BOARD)
->102   VALUES ($modSettings[maxMsgID], $ID_MEMBER, $board)", __FILE__, __LINE__);

Help?

Aaron

This is a bug in SMF 1.1 RC2 which has been addressed in SMF 1.1 RC3. For a workaround, please click here. :)

headspin

Thanks.. sounds simple enough, I should be able to do it once I get some sleep.

Harzem

You don't need to have a sleep before it ;) Just goto Admin > Maintenance > Recount all forum totals and statistics.

Advertisement: