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

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

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.

Print
Go Down Pages1
User actions

jpeg

January 17, 2006, 02:54:16 AM Last Edit: January 17, 2006, 11:57:42 PM by GauGau
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

#1
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','')

jpeg

#2
January 17, 2006, 11:41:23 PM
It is working now, thanks for the help. ;D
Print
Go Up Pages1
User actions