Everything was working fine until today. Now when I want to add a new user from the ACP I get the following error:
DB Error: Bad SQL Query: INSERT INTO 4images_users (user_id, user_level, user_name, user_password, user_email, user_showemail, user_allowemails, user_invisible, user_joindate, user_activationkey, user_lastaction, user_lastvisit, user_comments, user_homepage, user_icq, user_limit, user_country, user_first, user_height, user_weight, user_DOB, user_religion, user_ed, user_meet, user_self, user_phone, user_cell, user_job, user_age, user_sex) VALUES (215, 2, 'jack', 'eac572796cb9c7590471c38157f91cf2', 'jack@jack.com', 1, 1, 0, 1173991795, '9a63dea52c857dfec51aa1fd2d6cd6b7', 1173991795, 1173991795, 0, '', '', , 'usa', 'jack', '5\'10\"', '180', 'jan 14 1953', 'none', 'college', 'pretty and kind', 'good looking', 'none', 'none', 'retired', 'none', '1')
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 ' 'usa', 'jack', '5\'10\"', '180', 'jan 14 1953', 'none', 'college', 'pretty and ' at line 4
I did modify the profile of 1.7.4 weeks ago but like I said all was working fine until today. I'm not sure what went wrong or if I have been hacked.
The user can still register from the front end. And once they are registered, I can still edit the user from the ACP.
I only get the above error when I try to register a NEW user from the ACP. I'm not sure where the new user FORM for the ACP is controlled from nor do I have any clue about SQL.
Any help would be appreciated?
Thanks
Steve