Quote:
I got this error below: Can anyone help me out with this error?
Warning: Division by zero in /home/vietmyen/public_html/album.php on line 149
Warning: Division by zero in /home/vietmyen/public_html/includes/functions.php on line 1707
There seems to have been a slight problem with the VietSuperModel Net database.
Please try again by pressing the refresh button in your browser.
An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.
We apologise for any inconvenience.
Database error in vBulletin 3.0.0:
Invalid SQL:
SELECT user.userid, dateline,
comment, user.username, user.usertitle,
user.joindate, user.usergroupid
FROM customprofilepic
LEFT JOIN user USING (userid)
WHERE visible=0
ORDER BY posts desc
LIMIT 0,
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 '' at line 9
mysql error number: 1064
|
Did you run the MySQL queries?
It's giving a division by zero because the $perpage variable is empty. You should have this field set in AdminCP -> vB3 Member Photo -> Settings.
Also..
Code:
FROM customprofilepic
LEFT JOIN user USING (userid)
WHERE visible=0
In my code, it is not visible=0 but visible=1. It would be good to change that.