[gulf4cars]

Dear Paul


I have installed an older version of the mod on my forum (forum version is 4.1.7). After that a problem in registration is occurred. The below error in database is received to website mail every time a new user registers.


Now i have uninstalled the mod but the problem is still there

Database error in vBulletin 4.1.7:

Invalid SQL:

        SELECT
        SUM(IF(lastvisit >= 1316585215, 1, 0)) AS active,
        COUNT(*) AS users,
        MAX(userid) AS maxid
        FROM user
        AND
        usergroupid NOT IN (3,4);

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 'AND
        usergroupid NOT IN (3,4)' at line 6
Error Number  : 1064
Request Date  : Friday, October 21st 2011 @ 10:06:55 AM
Error Date    : Friday, October 21st 2011 @ 10:06:55 AM
Script        : http://www.gulf4cars.com/vb/cron.php?rand=1319177208
Referrer      : http://www.gulf4cars.com/vb/content/2008-toyota-land-cruiser-113/
IP Address    : 196.1.197.202
Username      : غير مسجل
Classname    : vB_Database
MySQL Version :

Please help me to solve the problem as many advised me to upgrade the forum to 4.1.8 and i dont want to upgrade while the problem is still on.



Thanks man for this useful mod