[mikelbeck]

I just installed 1.0.4 over 1.0.3, I got this error message:

Database error in vBulletin 3.5.2:

Invalid SQL:
SELECT *,
(SELECT COUNT(*) FROM photoplog_ratecomment WHERE fileid = 14) AS num,
(SELECT IF(SUM(photoplog_ratecomment.rating) > 0, SUM(photoplog_ratecomment.rating) / SUM(IF(photoplog_ratecomment.rating > 0, 1, 0)), 0) FROM photoplog_ratecomment WHERE fileid = 14) AS ave
FROM photoplog_ratecomment
WHERE fileid = 14
AND moderate = 0
ORDER BY dateline DESC
LIMIT 1;

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(*) FROM photoplog_ratecomment WHERE fileid = 14) A
Error Number : 1064