Where's the Database Error?

[Bison]

I get this error:

Database error in vBulletin Control Panel 2.2.6:

Invalid SQL: SELECT userid FROM user WHERE username= wizard86 AND userid <> 
mysql error: You have an error in your SQL syntax near '' at line 1

mysql error number: 1064

In the "forum/admin/user.php" file...


Here's The Code (From the user.php file):

	if ($exists=$DB_site->query_first("SELECT userid FROM user WHERE username='".addslashes(htmlspecialchars($ausername))."' AND userid <> $userid")) {
		echo "There is already an ".makelinkcode('user',"user.php?do=edit&userid=$exists[userid]",1)." named <b>".htmlspecialchars($ausername)."</b>";
		exit;
	}

It was working fine before and then POOF!

[FlyingDutchman]

shouldn't userid <> $userid be replaced by: userid='$userid'?

try this code instead then:

PHP Code:

    if ($exists=$DB_site->query_first("SELECT userid FROM user WHERE username='".addslashes(htmlspecialchars($ausername))."' AND userid='$userid'")) {
        echo "There is already an ".makelinkcode('user',"user.php?do=edit&userid=$exists[userid]",1)." named <b>".htmlspecialchars($ausername)."</b>";
        exit;
    } 


[Bison]

I'll try it ... but that generally means the same thing (<>).

Thanks for responding!

[Bison]

That didn't work ... I got another error using that <> qualifer that pointed to "Check Not Removing Last Admin"