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.
Did you try re-uploading the file to see if that does anything?
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.
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
I'm stuck. Help please.
Try re-uploading the proper file, and check its uploaded correctly :P