[LJR]

Okay, I just upgraded from 1.0.3 and I get the following SQL error. Looks like superfluous ) after the fileid in the query. Any suggestions? Thanks

Database error in vBulletin 3.5.2:

Invalid SQL:
SELECT *,
											(SELECT COUNT(*) FROM photoplog_ratecomment WHERE fileid = 41) 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 = 41) AS ave
											FROM photoplog_ratecomment
											WHERE fileid = 41
											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 = 41) A
Error Number : 1064
Date         : Saturday, December 17th 2005 @ 05:28:14 PM
Script       : http://www.ourspaceonthenet.com/osotn/community/photoplog/index.php
Referrer     : http://www.ourspaceonthenet.com/osotn/community/photoplog/index.php