Код:
Database error in vBulletin 3.8.4:
Invalid SQL:
SELECT post.postid, post.pagetext, IFNULL( user.username , post.username ) AS username, dateline
FROM post AS post
LEFT JOIN user AS user ON (user.userid = post.userid)
WHERE threadid = 27060
AND visible = 1
and privatethread <> 1
ORDER BY dateline ASC
LIMIT 0,250;
MySQL Error : Unknown column 'privatethread' in 'where clause'
Error Number : 1054
Request Date : Wednesday, March 2nd 2011 @ 01:02:38 PM
Error Date : Wednesday, March 2nd 2011 @ 01:02:38 PM
Script : http://www.bormotuhi.net/forum/archive/...p/t-27060.html
Referrer : http://www.bormotuhi.net/forum/archive/index.php/f-54.html
IP Address : 92.243.166.184
Username : puma
Classname : vB_Database
MySQL Version : 5.0.26-log
Тогда нужно в файле archive/
index.php найти код:
Код:
$posts = $db->query_read_slave("
SELECT post.postid, post.pagetext, IFNULL( user.username , post.username ) AS username, dateline
FROM " . TABLE_PREFIX . "post AS post
LEFT JOIN " . TABLE_PREFIX . "user AS user ON (user.userid = post.userid)
WHERE threadid = $threadinfo[threadid]
AND visible = 1
$globalignore
ORDER BY dateline ASC
LIMIT " . (($p - 1) * $vbulletin->options['archive_postsperpage']) . ',' . $vbulletin->options[archive_postsperpage]
);
и заменить его кодом:
Код:
$posts = $db->query_read_slave("
SELECT post.postid, post.pagetext, IFNULL( user.username , post.username ) AS username, post.dateline
FROM " . TABLE_PREFIX . "post AS post
LEFT JOIN " . TABLE_PREFIX . "user AS user ON (user.userid = post.userid)
LEFT JOIN " . TABLE_PREFIX . "thread AS thread ON (thread.threadid = post.threadid)
WHERE post.threadid = $threadinfo[threadid]
AND post.visible = 1
$globalignore
ORDER BY post.dateline ASC
LIMIT " . (($p - 1) * $vbulletin->options['archive_postsperpage']) . ',' . $vbulletin->options[archive_postsperpage]
);
Фикс от Luvilla