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
Enable debug for everyone, then post the actual error message.
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
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.
There appears to be a single quote at the end, right before the closing bracket, that isn't closed (I highlighted it for you).
Quote"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).
Where did user_dateofbirth come from ?