#1  
Old 23rd February 2008, 22: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
  #2  
Old 2nd September 2008, 17:17
vinamil vinamil is offline
Junior Member
 
Join Date: Sep 2008
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default

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
Reply

Bookmarks

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 09:11
High Availability Samba cluster - DRBD + Heartbeat djalex Server Operation 58 25th May 2007 19:38
mysql clustering problem : cannot create table in database prince.fer Server Operation 2 16th April 2007 17:03
Messed up ISPConfig-2.2.8 Upgrade Morons Installation/Configuration 4 29th November 2006 12:17
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 16:04


All times are GMT +2. The time now is 12:11.


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