Register Members List Search Today's Posts Mark Forums Read

Thread Tools
Old 29 Nov 2008, 08:31
rooban12's Avatar
rooban12 rooban12 is offline
Join Date: May 2007
Thumbs up database error

I got this error masage
can anyone help me to solve this problem please

the massage
Database error in vBulletin 3.7.3:
Invalid SQL:
IF(votenum >= 1, votenum, 0) AS votenum
IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg

thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, postusername, postuserid, thread.iconid AS threadiconid,
thread.dateline, notes, thread.visible, sticky, votetotal, thread.attach, thread.lastpost, thread.lastposter
thread.lastpostid, replycount, IF(views<=replycount, replycount+1, views) AS views
thread.prefixid, thread.taglist, hiddencount, deletedcount

FROM vb_thread AS thread

WHERE thread.threadid IN
(0,10198,10199,6978,7065,7691,8185,8174,8125,8120,6957,6523,5662,6965,6985,7647, 7268,7585,7016,7499,6601,6598,7525,7569,7511,7612,7616,7605,7676,7272,7690,7592, 7736,7603,7669,7015,7735,7734,7767,7732,7793,7733,7809,7822,7510,7816,7794,7812, 7887,7884,7909,8049,7906,7886,8166,8119,8208,8211,8224,8235,8236,8239,8243,8247, 8255,8244,8355,8227,8531,8502,8536,8798,8865,8896,8902,5702,8834,8503,8951,8850, 8981,8986,9027,8510,8413,9068,9096,9155,9202,9206,9233,9154,9242,9280,9294,9296, 9298,9324,9332,9390,9379,7755,9460,9462,9488,9492,9498,9538,9570,9572,9450,9577, 9578,9583,9585,9588,9597,9608,9609,9613,9617,9611,9711,9706,9731,9790,9629,9785, 9875,9732,9932,9969,10193,9920,10195,10220,10222,10226,10235,10240,10225,10252,1 0273,10274,10279) ORDER BY sticky DESC, lastpost DESC;
MySQL Error : Unknown table 'post' in field list
Error Number : 1109
Request Date : Saturday, November 29th 2008 @ 03:31:00 AM
Error Date : Saturday, November 29th 2008 @ 03:31:00 AM
Script :
Referrer :
IP Address :
Username : Unregistered
Classname : vB_Database
MySQL Version :

Last edited by rooban12; 29 Nov 2008 at 08:37.
Reply With Quote
Old 29 Nov 2008, 11:19
ReCom ReCom is offline
Join Date: Mar 2008
Uninstall the last mod/plugin you installed, it's lousy ...
Reply With Quote
Old 29 Nov 2008, 17:39
Lynne's Avatar
Lynne Lynne is offline
Join Date: Sep 2004
Real name: Lynne
It looks like you are missing the prefix in front of post. The modification should be fixed, so post in the modification thread and ask them to fix it.
Former Staff Member

Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
Old 29 Nov 2008, 20:10
rooban12's Avatar
rooban12 rooban12 is offline
Join Date: May 2007
thank you Recom and Lynne
Reply With Quote

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

New To Site? Need Help?

All times are GMT. The time now is 06:43.

Layout Options | Width: Wide Color: