[lordnex]

Gah .. i seem to have the database problem others have.

vBulletin 3.5.1:

Invalid SQL:
SELECT *,
(SELECT COUNT(*) FROM photoplog_ratecomment WHERE fileid = 1) 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 = 1) AS ave
FROM photoplog_ratecomment
WHERE fileid = 1
AND moderate = 0
ORDER BY dateline DESC
LIMIT 1;

MySQL Error : You have an error in your SQL syntax near 'SELECT COUNT(*) FROM photoplog_ratecomment WHERE fileid = 1) AS num,
' at line 2
Error Number : 1064
Date : Thursday, December 15th 2005 @ 02:05:53 PM



I checked the "view PHP info" in the admin CP to check on what version of mysql and it's 3.23.58 according to the print out. It's a unix system from what I understand and my webhosts seem to be twits at times. I fear asking them to upgrade the version ...
It worked up to the categories before, just installed the 1.0.4 patch and got this error. Yay for outdated computers!