Print Page - Can't create new user in Coppermine via SQL

Title: Can't create new user in Coppermine via SQL
Post by: jpeg on January 17, 2006, 02:54:16 AM

Everything is working better than I could of imagined, being the first time trying something like this.

But...when I try to create a new user I get this error:

While executing query "INSERT INTO cpr_users(user_regdate, user_active) VALUES (NOW(), 'YES')" on 0

mySQL error: Field 'user_password' doesn't have a default value

I have added a new user in SQL, one with a password and a guest without.
Thanks in advance for your help

Title: Re: Can't create new user in Coppermine via SQL
Post by: Paver on January 17, 2006, 03:23:42 AM

How about this?

Code Select

INSERT INTO cpr_users(user_regdate, user_active, user_password) VALUES (NOW(), 'YES','')

Title: Re: Can't create new user in Coppermine via SQL
Post by: jpeg on January 17, 2006, 11:41:23 PM

It is working now, thanks for the help. ;D

coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 install => Topic started by: jpeg on January 17, 2006, 02:54:16 AM