MySQL error after profile edit

This is a way I get the bug.

1) I joined community with login Maestro on the Dolphin 7 beta7 demo on the demozzz.com

2) after some simple activity (avatar upload, some comments) i have edited my profile and set Relationship to: "It's complicated"

3) I have changed password.

After this I can't login anymore neither old password nor new. When I try to reset password with "forgot password" link, I see

If I recall correctly, I read some posts on here that indicated a problem in MySQL using an apostrophe in certain things. So it's possible that since "It's Complicated" has an apostrophe in it, this may be causing a syntax error in MySQL.

Just a possibility.

I think zarcon is right.

SELECT `ID` FROM `Profiles` WHERE `ID` != 255 AND `RelationshipStatus` = 'It's Complicated'

isn't the apostrophy on It's improply escaped so that the databse is reading

SELECT `ID` FROM `Profiles` WHERE `ID` != 255 AND `RelationshipStatus` = 'It'  with extra s Complicated'   ?

can this be fixed by renaming It's to It\'s ?

I just checked and anything in the profiels with '  are not properly entering into the database.  This error was recieved on the relationship status, the default height (i.e. 6'0, etc) and anywhere else where a ' is being inserted in the middle of the sentense.

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 '2";s:6:"Height";s:3:"6'2";i:35;s:3:"225";s:6:"Weight";s:3:"225";i:36;s:1:"1";s:6' at line 1

edit: the error seems to only appear when your typing something into a box that is trying to matchup to a predefined list.  So the height and relationship status are trying to matchup with their corresponding list and that's where the '  erorr seems to occur

Its an error that was fixed by AntonL and it works if you implement the code change in your current database, find the changes here: http://www.boonex.com/trac/dolphin/browser/trunk/modules/boonex/wall/classes

you want the ticket 1286