Simple Machines Community Forum

Archived Boards and Threads... => Archived Boards => Install and Upgrade Help => Aiheen aloitti: headspin - elokuu 07, 2006, 04:37:02 AP

Otsikko: The installation seemed to work, but... "You have an error in your SQL syntax"
Kirjoitti: headspin - elokuu 07, 2006, 04:37:02 AP
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?
Otsikko: Re: The installation seemed to work, but... "You have an error in your SQL syntax"
Kirjoitti: Aaron - elokuu 07, 2006, 05:45:08 AP
This is a bug in SMF 1.1 RC2 which has been addressed in SMF 1.1 RC3. For a workaround, please click here (http://www.simplemachines.org/community/index.php?topic=70038.msg483380#msg483380). :)
Otsikko: Re: The installation seemed to work, but... "You have an error in your SQL syntax"
Kirjoitti: headspin - elokuu 07, 2006, 06:56:13 AP
Thanks.. sounds simple enough, I should be able to do it once I get some sleep.
Otsikko: Re: The installation seemed to work, but... "You have an error in your SQL syntax"
Kirjoitti: Harzem - elokuu 07, 2006, 07:09:39 AP
You don't need to have a sleep before it ;) Just goto Admin > Maintenance > Recount all forum totals and statistics.