Can't create new user in Coppermine via SQL Can't create new user in Coppermine via SQL
 

News:

CPG Release 1.6.27
change DB IP storage fields to accommodate IPv6 addresses
remove use of E_STRICT (PHP 8.4 deprecated)
update README to reflect new website
align code with new .com CPG website
correct deprecation in captcha

Main Menu

Can't create new user in Coppermine via SQL

Started by jpeg, January 17, 2006, 02:54:16 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

jpeg

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

Paver

How about this?
INSERT INTO cpr_users(user_regdate, user_active, user_password) VALUES (NOW(), 'YES','')

jpeg