Log in

View Full Version : im getting a simple error... can u help?


unenergizer
03-19-2006, 01:46 PM
My first one, on my homepage says:

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...

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