Simple Machines Community Forum

Archived Boards and Threads... => Archived Boards => Install and Upgrade Help => Aiheen aloitti: hjiljgkl - kesäkuu 16, 2006, 04:44:14 AP

Otsikko: Upgrade SQL error!
Kirjoitti: hjiljgkl - kesäkuu 16, 2006, 04:44:14 AP
SMF Version: SMF 1.0.7
I am trying to upgrade from SMF 1.0.7 to SMF 1.1rc2.

Everything says it is succesful except for the "Upgrading log system".

This message is coming up:

LainaaThis query:

    UPDATE smf_log_boards
    SET ID_MSG = 0
    WHERE logTime >=;

Caused the 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 '' at line 3

can any body help?
Otsikko: Re: Upgrade SQL error!
Kirjoitti: hjiljgkl - kesäkuu 17, 2006, 01:39:32 AP
okay, ive done a bit of research and i figured out the problem:
UPDATE smf_log_boards
SET ID_MSG = 0
WHERE logTime >=;

needs to be:

UPDATE smf_log_boards
SET ID_MSG = 0
WHERE logTime >= [number]


but i don't know what number to put there or where the file that contains this query is :-[