ERROR - When mod trys to edit a post, but user can edit fine.

[GSX-Racing]

Hey there tech support...

I am getting this error... for ONE user only. The user can edit their post fine... but when a moderator trys this error comes up.

Can anyone help?

Database error in vBulletin 3.5.4:

Invalid SQL:
SELECT userid FROM vb3_user WHERE username = 'ThreeB's';

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 's'' at line 1
Error Number : 1064
Date         : Tuesday, April 4th 2006 @ 06:23:37 PM
Script       : http://www.domain.com/vb/editpost.phtml
Referrer     : http://www.domain.com/vb/showthread.phtml?t=18677
IP Address   : ??.???.???.??
Username     : DoC
Classname    : vb_database

Thanks in advance.

[Steve Machol]

SQL Syntax errors are almost always related to modified code. To troubleshoot this, the first thing you need to do is remove any hacks or plugins, then see if you still have this problem.

If so, reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server.

Next, create a new style and choose no parent style. This will force it to use the default templates. Finally empty your browser cache, close all browser windows then try again. Make sure you change to the new style and view your forums with it. Do you have the same problem?