[bryanb]

Fantastic mod :up: but I'm having one minor problem. I hope you can help.

I have the "Top Thread Starters" enabled, but it is showing nothing - it's blank. I read through this thread and someone seemed to have had the same problem - he was told to ensure that the "Hourly Clean-up" was enabled in the forum scheduled tasks. Mine is. And at every hour it runs - and since I enabled "Top thread Starters" I receive this vBulletin database error:

Database error in vBulletin 3.6.7:


Invalid SQL:


UPDATE user AS user
SET user.threads =
(
SELECT COUNT(threadid)
FROM thread AS thread
LEFT JOIN forum AS forum ON forum.forumid = thread.forumid
WHERE visible = 1
AND (forum.options & 4096)
AND user.userid=postuserid
);


MySQL Error : 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 'SELECT COUNT(threadid)
FROM thread AS thread
LEFT
Error Number : 1064

I am database stupid. Is there an easy fix to this? Please help. Thanks!