[derrene]

Hi,

i wont like trying Recount but i get a Error..

Datenbankfehler in vBulletin 3.8.2:

Invalid SQL:
SELECT
COUNT(p.postid) as mycount
FROM vb3_post as p
INNER JOIN vb3_thread AS t ON (p.threadid = t.threadid)
WHERE p.visible=1 AND p.dateline>1280792040 AND t.forumid NOT IN(7,106,32,80,35,51,33,74,12,67,100,101,99,103,10 4,105,142,68,3,18,17,70,34,97,57,122,116,128,11,14 1,41,98,119,53,42,69,48,8,47,79,63,78,88,58,)
GROUP BY p.userid
ORDER BY mycount DESC
LIMIT 0,10;

MySQL-Fehler : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
GROUP BY p.userid
ORDER BY mycount DESC
LIMIT 0,10' at line 5
Fehler-Nr. : 1064
Fehler-Zeit : Tuesday, 24.08.2010 @ 01:34:46
Datum : Tuesday, 24.08.2010 @ 01:34:47
IP-Adresse : 84.148.191.152
Benutzername : XXXXXX
Klassenname : vB_Database
MySQL-Version : 5.0.51a-24+lenny4-log

What can i do?

edit: solved a comma to much in end of line in "ignore forums"