| unenergizer |
03-19-2006 01:46 PM |
im getting a simple error... can u help?
My first one, on my homepage says:
Code:
Database error in vBulletin 3.5.2:
Invalid SQL:
SELECT IF(votenum >= 1, votenum, 0) AS numbvote, IF(votenum >= 1 AND votenum != 0, votetotal / votenum, 0) AS voteavg,
thread.threadid, post.title, thread.replycount, postusername, postuserid, thread.dateline AS postdateline, thread.lastposter, thread.lastpost, IF(views<=thread.replycount, thread.replycount+1, views) AS views, thread.forumid, post.postid, pagetext, allowsmilie, forum.title AS forumtitle
,thread.iconid AS threadiconid, iconpath AS threadiconpath
, NOT ISNULL(subscribethread.subscribethreadid) AS subscribed
FROM ghthread AS thread
LEFT JOIN ghforum AS forum USING (forumid)
LEFT JOIN ghpost AS post ON (post.postid = thread.firstpostid)
LEFT JOIN ghicon USING (iconid)
LEFT JOIN ghsubscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = '1')
LEFT JOIN ghdeletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')
WHERE thread.threadid IN(263,260,239,217,189,164,148,139,136,130,129,128,126,117,115)
GROUP BY post.postid
ORDER BY thread.dateline DESC
LIMIT 15;
MySQL Error : Got error 28 from table handler
Error Number : 1030
Date : Sunday, March 19th 2006 @ 09:36:59 AM
Script : http://www.gamehaxs.com/
Referrer :
IP Address : ********
Username : ********
Classname : vb_database
im getting this error on my cmps_index.php (vBadvanced CMPS)
and i get this error on my index.php page...
Code:
Database error in vBulletin 3.5.2:
Invalid SQL:
SELECT *
FROM photoplog_fileuploads
WHERE moderate = 0
ORDER BY RAND()
LIMIT 5;
MySQL Error : Got error 28 from table handler
Error Number : 1030
Date : Sunday, March 19th 2006 @ 09:38:02 AM
Script : http://www.gamehaxs.com/index.php
Referrer :
IP Address : *******
Username : *******
Classname : vb_database
I would appericiate it, if someone could help me out!
Thanks in advanced,
andrew |
More Information