Can't create new user in Coppermine via SQL

[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?

Code Select Expand

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

[jpeg]

It is working now, thanks for the help.