Coppermine blocks in sql the New user creation

[Yabba]

I have a big issue regarding creating new user.
Sometimes when im using the manual create user in admin mode im receving an error
The workaround for this is to open the sql database open up cpg149_users and  edit the table and go to User password and uncheck the Not Noll function. ---> save changes and then it works fine again fo maximum 1 day.

What do i have to do to prevent Coppermine to setup the Not Null again?

Some related issue maybe (dont jknow but posting this link to an other issue that is very close to this issue)
http://forum.coppermine-gallery.net/index.php?topic=37084.0

[Yabba]

I have manage to isolate the issue.
Its recomended from Coppermine crew to run the AdminTools/Update Database (If you have replaced coppermine files, added a modification or upgraded from a previous version of coppermine, make sure to run the database update once. This will create the necessary tables and/or config values in your coppermine database.)

Some modifications has been done and of of course i have performed as requested.
The bug in this thing is that this update also updates the "ALTER TABLE `cpg149_users` CHANGE `user_password` `user_password` VARCHAR( 40 ) NOT NULL" to just NOT NULL

Debug error:
While executing query "INSERT INTO cpg149_users(user_regdate, user_active) VALUES (NOW(), 'YES')" on 0
mySQL error: Field 'user_password' doesn't have a default value
In file:
include\functions.inc.php - Line: 249
This is my 249 line:
cpg_die(CRITICAL_ERROR, $out, __FILE__, __LINE__);

The strange thing is that when i am performing the update in English language the change will not take place, but if i have Swedish activated then i have to change the sql-database?

[kint]

I have this problem too.  I'm not sure I understand - did your problem go away
after you ran "Update Database?"  I ran Update Database, and I still get the problem.

My error message is the same as yours, when I try to create new user:

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

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


Any ideas?  Thanks..

[Nibbler]

A fix for this issue was added to 1.4.10. Do you experience this issue when running that version?

[kint]

No, I got this on 1.4.9.  I will try 1.4.10 now.  Thanks for the fast reply!!