[Forum] 1064 Error: Guests Cannot Register

[L-Mane]

I saw that I hadn't had any new users in weeks and then saw the E-Mails about the error. I disabled and uninstalled all plugins, re-installed VB, and it still happens.

Database error in vBulletin 4.0.3:

Invalid SQL:

SELECT
SUM(IF(lastvisit >= 1271062716, 1, 0)) AS active,
COUNT(*) AS users,
MAX(userid) AS maxid
FROM user
WHERE;

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
Error Number : 1064
Request Date : Wednesday, May 12th 2010 @ 04:58:36 AM
Error Date : Wednesday, May 12th 2010 @ 04:58:36 AM
Script : http://www.wordofsouth.com/myblock/register.php?do=addmember
Referrer : http://www.wordofsouth.com/myblock/register.php
IP Address :
Username : yotsisit
Classname : vB_Database
MySQL Version : 4.1.22-standard

[Lynne]

That is from the functions_databuild.php page and this query:

    $members = $vbulletin->db->query_first("
        SELECT
        $sumsql
        COUNT(*) AS users,
        MAX(userid) AS maxid
        FROM " . TABLE_PREFIX . "user
        WHERE
        usergroupid NOT IN (3,4)
    ");

If you are going to remove the usergroup line, you need to remove the WHERE also:

    $members = $vbulletin->db->query_first("
        SELECT
        $sumsql
        COUNT(*) AS users,
        MAX(userid) AS maxid
        FROM " . TABLE_PREFIX . "user
    ");

[L-Mane]

I got this error when I followed your directions.

Invalid SQL:
SELECT userid, username FROM user WHERE userid = 22023 AND;
 
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 1

then

Invalid SQL:
SELECT userid, username FROM user  userid = 22024 AND;
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 '= 22024 AND' at line 1

[Lynne]

The query I wrote above looks nothing like the one you are having problems with. Did you make sure to modify the correct query? It's in the build_user_statistics function.

[L-Mane]

Ok, I might not be following you correctly. I have to do what you said somewhere else other then editing functions_databuild.php manually?

[Lynne]

It looks like you had already edited that file and done so incorrectly. You may want to just download a fresh version from the members area and upload it. Or, find the exact query I am talking about and edit it correctly (are you sure you did the correct one?). I cannot find any query like the one you posted in post 3. So, I'd suggest disabling your plugins and seeing if this error goes away.
Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

define('DISABLE_HOOKS', true); 

[L-Mane]

Thank you for your help. Problem fixed :-)