Uutiset:

Want to get involved in developing SMF, then why not lend a hand on our github!

Main Menu
Advertisement:

Database Error after Upgrading

Aloittaja nsn3, elokuu 29, 2006, 01:41:02 IP

« edellinen - seuraava »

nsn3

Hi.

I upgrade my forum today from 1.09 to 1.1 RC3 and all appeared to went right.

Now I noticed that I can't open any board, as it appears this error:

Database Erro:
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 ' 2, 4)' at line 3
File: /home/pwp10001/public_html/forum/Sources/MessageIndex.php
Line: 102


The Admin and the Profile sections are working file.

I Just don't get where the problem is. Down is the mesaggeindex.php file from line 91 to 110

// We can't know they read it if we allow prefetches.
if (isset($_SERVER['HTTP_X_MOZ']) && $_SERVER['HTTP_X_MOZ'] == 'prefetch')
{
ob_end_clean();
header('HTTP/1.1 403 Prefetch Forbidden');
die;
}

db_query("
REPLACE INTO {$db_prefix}log_boards
(ID_MSG, ID_MEMBER, ID_BOARD)
VALUES ($modSettings[maxMsgID], $ID_MEMBER, $board)", __FILE__, __LINE__);
if (!empty($board_info['parent_boards']))
{
db_query("
UPDATE {$db_prefix}log_boards
SET ID_MSG = $modSettings[maxMsgID]
WHERE ID_MEMBER = $ID_MEMBER
AND ID_BOARD IN (" . implode(',', array_keys($board_info['parent_boards'])) . ")
LIMIT " . count($board_info['parent_boards']), __FILE__, __LINE__);


The 102nd line is this:

VALUES ($modSettings[maxMsgID], $ID_MEMBER, $board)", __FILE__, __LINE__);

Thanks in advance for the support.

J. Williams

Did you try re-uploading the file to see if that does anything?
Joshua Jon Williams
Back in Action.

Lew Cipher

Lainaus käyttäjältä: J J Williams - elokuu 29, 2006, 01:44:22 IP
Did you try re-uploading the file to see if that does anything?

I agree. Make sure it uploads in ASCII (text) mode and not binary mode.

Version: SMF 1.1.2
Many mods installed

nsn3

#3
Already did that. No I will try to upload the messageindex.php from SMF 1.08.

What do you think?

EDIT: With messageindex.php form v1.08 appears this error, but I guess it's because the versions are different.

Unknown column 'lt.logTime' in 'field list'
File: /home/pwp10001/public_html/forum/Sources/MessageIndex.php
Line: 367

nsn3


J. Williams

Try re-uploading the proper file, and check its uploaded correctly :P
Joshua Jon Williams
Back in Action.

Advertisement: