MyBB Community Forums

MyBB Community Forums > Community Archive > Archived Forums > Archived Development and Support > MyBB 1.2 Series > MyBB 1.2 General Support > error when edit user in admin cp
Full Version: error when edit user in admin cp
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

Tsakalos

2006-02-10, 04:16 PM
mySQL error: 1064
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 'girl' AND username!='MP\'girl' at line 1
Query: SELECT username FROM mybb_users WHERE username='MP'girl' AND username!='MP\'girl'

the username is MP'girl maybe its the ' in the username that create the error ? how to fix it and edit this users pass without the error ? i use MySQL version: 4.1.14-standard

squirrel

2006-02-10, 08:07 PM
I have a similar problem, have you tried upgrading?

Dennis Tsang

2006-02-11, 02:33 AM
What is the version number of the MyBB you are using?
MyBB Community Forums > Community Archive > Archived Forums > Archived Development and Support > MyBB 1.2 Series > MyBB 1.2 General Support > error when edit user in admin cp