Adding customer: Field 'pw' doesn't have a default value

[STT]

Hi all,

I'm having an issue here with an OTRS 3.0.9 installation.
Trying to add a customer, gives me an error "Field 'pw' doesn't have a default value", whether or not a password has been entered in the user creation interface.
The same error as the german user here, i think: http://forums.otrs.org/viewtopic.php?f= ... 41&p=33235
(i don't understand much german, but it looks like my error)

Looking at the column in the DB, the NN flag is not set, so i can't really figure out why that error shows.

Any others out there with an issue like this?

Thanks

--
/Sune T.

[M-100it]

I had the same error,

It is caused by OTRS inserting without a value for the password field. It they crypts the password and updates the line.

It is only a problem when 'sql-mode="STRICT_TRANS_TABLES"' is set, otherwise MySQL accepts the insert.

[STT]

Thanks a lot... Removing STRICT_TRANS_TABLES from my.ini seems to resolve the issue.

--
/Sune T.