i need your help database error

[aim4fun]

my site gives me this database error

Database error in vBulletin 3.6.5:

Invalid SQL:

				SELECT * FROM user AS user
				LEFT JOIN usergroup AS usergroup ON (user.usergroupid = usergroup.usergroupid)
				WHERE user.username = 'Dr Mo'men';

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 'men'' at line 3
Error Number : 1064
Date         : Friday, October 19th 2007 @ 07:14:15 PM
Script       : http://aim4fun.com/vb/index.php
Referrer     : 
IP Address   : 41.235.132.127
Username     : dr-killer
Classname    : vb_database

any one can solve this problem ?

--------------- Added [DATE]1192850934[/DATE] at [TIME]1192850934[/TIME] ---------------

some one help

[MoT3rror]

SELECT * FROM user AS user
LEFT JOIN usergroup AS usergroup ON (user.usergroupid = usergroup.usergroupid)
WHERE user.username = 'Dr Mo\'men';

That should make it work.

[aim4fun]

and how can i change it
????
this is an error massage

[MoT3rror]

In your where statement you have this.

WHERE user.username = 'Dr Mo'men';

The value Dr Mo'men was entered. The quote(') would stop the value at Dr Mo. You have to escape the quote(') with a slash(\) so it doesn't stop the query at the quote.

[aim4fun]

i know but how may i change it
take look into my website
aim4fun.com/vb

i mean what should i do in order to fix this problem?

[MoT3rror]

Do you have any mods installed?
Did you edit the vBulletin code?

[aim4fun]

Do you have any mods installed?
i don`t think so

Did you edit the vBulletin code?
not at all



--------------- Added [DATE]1192853300[/DATE] at [TIME]1192853300[/TIME] ---------------

i can`t even loginto my cpanel

--------------- Added [DATE]1192853519[/DATE] at [TIME]1192853519[/TIME] ---------------

there is an addon " name of members for the last 24 hr "
and the member mo`men is one of them

but i placed this addon long time ago and nothing happen

[MoT3rror]

Sounds like a server problem if you can't sign into Cpanel. Also after you can sign in again, I reupload all of the files for vBulletin overwriting the ones on the server. Make sure you are uploading the files for your version of vBulletin that you are currently running.

Probably would be best to contact your hosting company.

[aim4fun]

nothing wrong with the server

using the query

WHERE user.username = 'Dr Mo'men';

at the database gives you the error
but in case i use

WHERE user.username = 'Dr Mo/'men';

this query is comletely right
but how may i force the script to use it
or how may i change it
i don`t know thats the problem

[MoT3rror]

Try downloading the files from vBulletin.com and reuploading all your vBulletin files. If that doesn't work post the bug here.