[cgarossi]

Im getting this error:

Database error in vBulletin 3.0.7:

Invalid SQL: SELECT donor.userid, donor.total, user.username, user.showdonor
FROM donation_donors AS donor
LEFT JOIN user AS user ON(user.userid = donor.userid)
WHERE donor.userid != '0'
ORDER BY total 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 6

mysql error number: 1064

Date: Tuesday 05th of July 2005 11:46:28 AM
Script: http://www.northeasternswat.com/index.php
Referer:
Username: Rossi
IP Address: 81.178.239.171

It seems that

$query_users = $DB_site->query("SELECT donor.userid, donor.total, user.username, user.showdonor
FROM ".TABLE_PREFIX."donation_donors AS donor
LEFT JOIN ".TABLE_PREFIX."user AS user ON(user.userid = donor.userid)
WHERE donor.userid != '0'
ORDER BY total DESC
LIMIT 0,".$vboptions['donate_CMPS_users']);

This variable .$vboptions['donate_CMPS_users'] is returning nothing!

How can I fix this? I am using cmps v1.0.