| Selene |
06-20-2009 05:55 PM |
It was running fine for the last 10 days, but I just got the following error on my forums:
PHP Code:
Database error in vBulletin 3.8.2:
Invalid SQL:
SELECT tagthread.tagid, tag.tagtext, COUNT(*) AS searchcount
FROM tagthread AS tagthread
INNER JOIN tag AS tag ON (tagthread.tagid = tag.tagid)
INNER JOIN thread AS thread ON (tagthread.threadid = thread.threadid)
WHERE thread.open <> 10
AND thread.visible = 1
AND thread.forumid IN (1,9,44,19,94,71,8,18,3,10,66,41,21,11,20,14,4,51,12,45,46,55,36,52,25,53,54,57,38,58,59,60,61,62,70,93,81,79,76,80,5,69,15,200,211,35,210,29,100,102,101,82,83,84,212,97,98,109,110,107,108,13,206,209,204,205,201,202,203,207,208,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,197,198,199,138,139,140,141,142,143,144,145,146,147,148,151,149,150,152,153,154,155,156,157,158,161,162,163,164,165,166,167,168,169,159,171,170,172,173,174,175,176,177,186,160,178,179,180,181,182,183,184,185,187,188,194,189,190,191,192,193,195,196,85,86,87,88,89,90,91,92,6,96,72,16,78)
AND tagthread.dateline > 1213988111
GROUP BY tagthread.tagid, tag.tagtext
ORDER BY searchcount DESC
LIMIT 70;
MySQL Version : 5.0.51a-3ubuntu5.4
I tried to disable the tag plugin but still that error. So how should I fix it now. |
More Information