MyBB Community Forums

Full Version: [Dup] PR2 - bug in signature field
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hi all (:

If you try, from adminCP, to add a new user, and you put the ' char in the signature field, you obtain something like this:

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 '''')' at line 1
Query: INSERT INTO mybb_users (uid, username, password, salt, loginkey, email, usergroup, usertitle, regdate, lastactive, lastvisit, avatar, website, icq, aim, yahoo, msn, birthday, allownotices, hideemail, emailnotify, invisible, style, timezone, receivepms, pmpopup, pmnotify, signature) VALUES ('NULL', 'someuser', 'd1a93fc3001808ded2bbf2dc9eb046d5', '2GycgkEu', 'jsMnmlnsY3qIqnHJhF8Kw67sfWuLczbLMozYzHMtE65ULfatK9', '[email protected]', '2', '', '1129303061', '1129303061', '1129303061', '', '', '', '', '', '', '', 'yes', 'no', 'yes', 'no', '-1', '', 'yes', 'yes', 'yes', ''');

...and so on.
its already been fixed

check the fixed bugs archive
squall_leonhart69r Wrote:its already been fixed

check the fixed bugs archive

Oh, I'm sorry. Useless 3d.