Old 23rd February 2008, 23:24
Skylinux Skylinux is offline
Junior Member
Join Date: Jun 2006
Posts: 6
Thanks: 0
Thanked 1 Time in 1 Post
Default Error with MySQL Strict mode

I just installed my new server and I am getting the error message "Field 'client_salutatory_email_message' doesn't have a default value" when I try to create a new reseller.

Once I commented sql-mode="STRICT_ALL_TABLES" in /etc/my.cnf the error went away. I will try to find more incorrect SQL inserts and post them here.
Reply With Quote
The Following User Says Thank You to Skylinux For This Useful Post:
till (25th February 2008)
Sponsored Links
Old 2nd September 2008, 18:17
vinamil vinamil is offline
Junior Member
Join Date: Sep 2008
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts

Look into database:
table isp_isp_reseller have some TEXT filed mark as NOT NULL but don't have default value for it.
When ISPconfig add a record. It don't have value to those filed.
I don't know what is the default value.
So mark it as NULL (uncheck NOT NULL propertie) of those record will resolve error.
Reply With Quote


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 10:11
High Availability Samba cluster - DRBD + Heartbeat djalex Server Operation 58 25th May 2007 20:38
mysql clustering problem : cannot create table in database prince.fer Server Operation 2 16th April 2007 18:03
Messed up ISPConfig-2.2.8 Upgrade Morons Installation/Configuration 4 29th November 2006 13:17
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 17:04

All times are GMT +2. The time now is 14:16.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.