Pewnie zostanę upokorzony,ale naprawdę nie wiem już co zrobić........Userzy napierniczają mnie że forum nie działa a po próbie logowania otwiera się takie coś Database error in vBulletin 4.0.1:

Invalid SQL:

SELECT thread.threadid, thread.title, thread.prefixid, post.attach,
thread.postusername, thread.dateline, thread.lastpostid, thread.lastpost, thread.lastposterid, thread.lastposter, thread.replycount,
forum.forumid, forum.title_clean as forumtitle,
post.pagetext AS message, post.allowsmilie, post.postid,
user.*
,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight
FROM thread AS thread
INNER JOIN forum AS forum ON(forum.forumid = thread.forumid)
LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN user AS user ON (thread.postuserid = user.userid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
WHERE 1=1
AND thread.forumid IN(192,193,88,126,71,18,58,189,195,70,72,196,76,83 ,79,62,77,75,3,7,15,81,143,141,190,191,14,19,176,1 77,178,179,180,181,182,183,184,20,152,153,154,155, 156,157,158,159,185,21,144,145,146,147,148,149,150 ,151,186,22,160,161,162,163,164,165,166,167,187,23 ,168,169,170,171,172,173,174,175,188,34,139,36,37, 38,39,40,41,42,43,44,45,46,47,48,49,50,197,33,110, 111,112,113,114,115,116,117,118,119,120,121,122,12 3,124,125,198,5,67,11,55,87,12,13,29,30,31,32,10,9 3,4,92,24,26,25,28,85,201,86,6,17,57,68,69,8,9,51, 52,56,53,54,65,82)
AND thread.visible = 1
AND post.visible = 1
AND open <> 10
AND thread.dateline > 1277247015


ORDER BY thread.dateline DESC
LIMIT 0,10;

MySQL Error : Table './baza10330/post' is marked as crashed and should be repaired
Error Number : 145
Request Date : Friday, July 23rd 2010 @ 12:50:15 AM
Error Date : Friday, July 23rd 2010 @ 12:50:15 AM
Script : http://www.hcforum.pl/forum.php
Referrer :
IP Address : 193.59.13.89
Username : BeatleJohn
Classname : vB_Database
MySQL Version : 5.0.45



Poradżcie bo mam zasypane gg

Próbowałeś naprawiać, optymalizować tabele w bazie? Czy błąd pojawił nagle, czy może po jakieś czynności np. aktualizacja forum?

Moim zdaniem jest to błąd w tabelach bazy danych. Proponuję przywrócić bazę danych z kopii zapasowej wykonanej przed pojawieniem się tego problemu.
W wersji 4.01 występował problem z logowanie, ale nie było takiego błędu. Jednak po przywróceniu bazy danych i zniknięciu tego problemu proponuję dokonać aktualizacji do wersji 4.05

Dzięki za porady

Zamieszczone przez BeatleJohn

Pewnie zostanę upokorzony,ale naprawdę nie wiem już co zrobić........Userzy napierniczają mnie że forum nie działa a po próbie logowania otwiera się takie coś Database error in vBulletin 4.0.1:

Invalid SQL:

SELECT thread.threadid, thread.title, thread.prefixid, post.attach,
thread.postusername, thread.dateline, thread.lastpostid, thread.lastpost, thread.lastposterid, thread.lastposter, thread.replycount,
forum.forumid, forum.title_clean as forumtitle,
post.pagetext AS message, post.allowsmilie, post.postid,
user.*
,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight
FROM thread AS thread
INNER JOIN forum AS forum ON(forum.forumid = thread.forumid)
LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN user AS user ON (thread.postuserid = user.userid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
WHERE 1=1
AND thread.forumid IN(192,193,88,126,71,18,58,189,195,70,72,196,76,83 ,79,62,77,75,3,7,15,81,143,141,190,191,14,19,176,1 77,178,179,180,181,182,183,184,20,152,153,154,155, 156,157,158,159,185,21,144,145,146,147,148,149,150 ,151,186,22,160,161,162,163,164,165,166,167,187,23 ,168,169,170,171,172,173,174,175,188,34,139,36,37, 38,39,40,41,42,43,44,45,46,47,48,49,50,197,33,110, 111,112,113,114,115,116,117,118,119,120,121,122,12 3,124,125,198,5,67,11,55,87,12,13,29,30,31,32,10,9 3,4,92,24,26,25,28,85,201,86,6,17,57,68,69,8,9,51, 52,56,53,54,65,82)
AND thread.visible = 1
AND post.visible = 1
AND open <> 10
AND thread.dateline > 1277247015


ORDER BY thread.dateline DESC
LIMIT 0,10;

MySQL Error : Table './baza10330/post' is marked as crashed and should be repaired
Error Number : 145
Request Date : Friday, July 23rd 2010 @ 12:50:15 AM
Error Date : Friday, July 23rd 2010 @ 12:50:15 AM
Script : Honda Civic FanKlub Forum
Referrer :
IP Address : 193.59.13.89
Username : BeatleJohn
Classname : vB_Database
MySQL Version : 5.0.45



Poradżcie bo mam zasypane gg

"is marked as crashed " . Zobacz logi ....