[HELP] I've got a weird error...

S

Smeker

New Member
Hello,

I'm getting this weird error when editing users:
Code: 
Database error in vBulletin 3.7.4:

Invalid SQL:


                UPDATE;

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
Error Number  : 1064
Request Date  : Monday, December 1st 2008 @ 05:18:13 AM
Error Date    : Monday, December 1st 2008 @ 05:18:13 AM
Script        : http://xxxxxxxxxxxx/admincp/user.php?do=update
Referrer      : http://xxxxxxxxxxxx/admincp/user.php?do=edit&u=7
IP Address    : xxxxxxxxxxx
Username      : xxxxxxxxxx
Classname     : vb_database
MySQL Version : 4.1.22-standard-log
Can anyone please help me out?
I'm using a nulled version.
 
This seems to be a known issue with:

vBulletin.v3.7.4.PHP.NULLIFIED.PROPER-GYSN

The easiest way to update the users information (while living with this error) is to visit the users profile via the forum (not admin CP) & select edit user from their.

No error will be displayed.

I will work on fiing this error on my lunch as I have seen this before as well.

Should be a simple fix.
 
Nope, the problem is not within the GYSN release but within vBulletin 3.7.4 itself.
That was a known issue over at vbulletin.com but has been resolved in the latest available version for download.

To manually fix it just do a code change as outlined in this thread at vbulletin.com
Code: 
http://www.vbulletin.com/forum/project.php?issueid=26742
 
Thanks lordsyntax, here is the code from that post:

Try this. On includes/class_dm_user.php, find this:

PHP: 
            // visitormessage 'postusername'
            $this->dbobject->query_write("

                UPDATE " . TABLE_PREFIX , "visitormessage
                SET postusername = '" . $this->dbobject->escape_string($username) . "'
            ");
And replace by this :

PHP: 
          // visitormessage 'postusername'
            $this->dbobject->query_write("

                UPDATE " . TABLE_PREFIX . "visitormessage
                SET postusername = '" . $this->dbobject->escape_string($username) . "'
                WHERE postuserid = $userid
            ");
I have only changed the , to a . in the TABLE_PREFIX variable ;)
 
You must log in or register to reply here.
Back
Top