Re: Сбой в работе Форума!
#29
При нажатии на кнопку "Новые сообщения"
Ошибка база данных в vBulletin 3.6.4:
Invalid SQL:
SELECT post.pagetext AS preview,
thread.threadid, thread.threadid AS postid, thread.title AS threadtitle, thread.iconid AS threadiconid, thread.dateline, thread.forumid,
thread.replycount, IF(thread.views=0, thread.replycount+1, thread.views) as views, thread.sticky,
thread.pollid, thread.open, thread.lastpost AS postdateline, thread.visible, thread.hiddencount, thread.deletedcount,
thread.lastpost, thread.lastposter, thread.lastpostid, thread.attach, thread.postusername, thread.forumid,
deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,
user.userid AS postuserid
, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
, threadread.readtime AS threadread
FROM vb3_thread AS thread
LEFT JOIN vb3_user AS user ON(user.userid = thread.postuserid)
LEFT JOIN vb3_deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
LEFT JOIN vb3_threadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = 7271)
LEFT JOIN vb3_subscribethread AS subscribethread
ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 7271 AND canview = 1)
LEFT JOIN vb3_post AS post ON(post.postid = thread.firstpostid)
WHERE thread.threadid IN
(14098, 14103, 14094, 14011, 14104, 14008, 14099, 10862, 13073, 14045, 14095, 3104, 10101, 14092, 14091, 14090, 14089, 14079, 4189, 14086, 14087, 10838, 14059, 14076, 13234);
Ошибка MySQL : Table 'vb3_post' is marked as crashed and should be repaired
Номер ошибки : 1194
Дата : Sunday, February 3rd 2008 @ 11:13:19 AM
Скрипт :
http://www.mcrf.ru/forum/search.php?searchid=633910
Реферрер :
http://www.mcrf.ru/forum/index.php
IP адрес : 213...........
Имя пользователя : slalom666
Имя класса : vB_Database