Advanced search  

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]

Pages: [1]   Go Down

Author Topic: Can't create new user in Coppermine via SQL  (Read 3075 times)

0 Members and 1 Guest are viewing this topic.

jpeg

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Can't create new user in Coppermine via SQL
« 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
« Last Edit: January 17, 2006, 11:57:42 pm by GauGau »
Logged

Paver

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 1609
  • Paul V.
Re: Can't create new user in Coppermine via SQL
« Reply #1 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','')
Logged

jpeg

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Re: Can't create new user in Coppermine via SQL
« Reply #2 on: January 17, 2006, 11:41:23 pm »
It is working now, thanks for the help. ;D
Logged
Pages: [1]   Go Up
« previous next »
 

Page created in 0.013 seconds with 17 queries.