Unable to register

[ian ditch]

I hope that someone can help me.

I have installed my second Coppermine Gallery but people can not register, they get a messages saying
'There was an error while processing a database query'

I can log-in as Admin but then If I try to register as a different name I get the above Error

Please Help

[kegobeer]

Enable debug for everyone, then post the actual error message.

[ian ditch]

Ok, this is what I get when I try to register...


While executing query "INSERT INTO models_users (user_regdate, user_active, user_actkey, user_name, user_password, user_email, user_location, user_interests, user_website, user_occupation, user_dateofbirth) VALUES (NOW(), 'NO', 'b491503da92edefb7bfe25af0d2cd206', 'james', '****', 'ianditchfield@ntlworld.com', '', '', '', '', ' )" on 0

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 '' )' at line 1

[Tranz]

It seemed the password was included in debug, so I have removed it. Please make sure not to use that one, or to change it if the account is open.

[Joachim Müller]

There appears to be a single quote at the end, right before the closing bracket, that isn't closed (I highlighted it for you).

"INSERT INTO models_users (user_regdate, user_active, user_actkey, user_name, user_password, user_email, user_location, user_interests, user_website, user_occupation, user_dateofbirth) VALUES (NOW(), 'NO', 'b491503da92edefb7bfe25af0d2cd206', 'james', '****', 'ianditchfield@ntlworld.com', '', '', '', '', ' )"

Do you have the most up-to-date coppermine version? Please post a link to your site, and post the html output of versioncheck.php (don't post a link, we will not be able to access it) as an attachment to your next posting (rename to .txt or zip it).

[Nibbler]

Where did user_dateofbirth come from ?