Unable to register Unable to register
 

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Main Menu

Unable to register

Started by ian ditch, May 24, 2005, 01:06:09 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

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.
Do not send me a private message unless I ask for one.  Make your post public so everyone can benefit.

There are no stupid questions
But there are a LOT of inquisitive idiots

ian ditch

#2
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).
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).

Nibbler

Where did user_dateofbirth come from ?