Adding customer: Field 'pw' doesn't have a default value
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=33&t=8441&p=33235 (i don't understand much german, but it looks like my error, I have also posted in the English area of the forum) 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 or any ideas how to resolve? Thanks -- /Sune T.
Removing STRICT_TRANS_TABLES from my.ini seems to resolve the issue. (thanks to M-100it from the forums) -- /Sune T. -----Original Message----- From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Sune T. Tougaard Sent: 24. august 2011 12:03 To: otrs@otrs.org Subject: [otrs] Adding customer: Field 'pw' doesn't have a default value 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=33&t=8441&p=33235 (i don't understand much german, but it looks like my error, I have also posted in the English area of the forum) 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 or any ideas how to resolve? Thanks -- /Sune T. --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
participants (1)
-
Sune T. Tougaard