Add Client - ISPConfig 3.0.5.4 - SQL Error?

Hi,

I just installed ISPConfig 3.0.5.4 and i have some problems while trying to add a client.

Specs:
- CentOS 6.5
- MySQL 5.6.17
- Apache 2.2.15
- PHP 5.3.3
- phpMyAdmin 3.5.8.2

Error:

Code:

#0 db->query(INSERT INTO `client` (`company_name`, `gender`, `contact_name`, `customer_no`,
 `username`, `language`, `usertheme`, `street`, `zip`, `city`, `state`, `country`, `telephone`, `mobile`,
 `fax`, `email`, `internet`, `icq`, `vat_id`, `company_id`, `bank_account_owner`, `bank_account_number`,
 `bank_code`, `bank_name`, `bank_account_iban`, `bank_account_swift`, `notes`, `paypal_email`, `locked`,
 `canceled`, `added_date`, `added_by`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, 
`sys_perm_other`) VALUES ('', '', 'own2', 'C1', 'own2', 'en', 'default', '', '', '', '', 'AF', '', '', '', '', 
'http://', '', '', '', '', '', '', '', '', '', '', '', 'n', 'n', '2014-4-23', 'admin', '1', '1', 'riud', 'riud', '')) called at [/usr/local/ispconfig/interface/lib/classes/tform_actions.inc.php:256] #1 
tform_actions->onInsertSave(INSERT INTO `client` (`company_name`, `gender`, `contact_name`, 
`customer_no`, `username`, `language`, `usertheme`, `street`, `zip`, `city`, `state`, `country`, 
`telephone`, `mobile`, `fax`, `email`, `internet`, `icq`, `vat_id`, `company_id`, `bank_account_owner`, 
`bank_account_number`, `bank_code`, `bank_name`, `bank_account_iban`, `bank_account_swift`,
 `notes`, `paypal_email`, `locked`, `canceled`, `added_date`, `added_by`, `sys_userid`, `sys_groupid`,
 `sys_perm_user`, `sys_perm_group`, `sys_perm_other`) VALUES ('', '', 'own2', 'C1', 'own2', 'en', '
default', '', '', '', '', 'AF', '', '', '', '', 'http://', '', '', '', '', '', '', '', '', '', '', '', 'n', 'n', '2014-4-23', 'admin', '1', '1', 'riud', 'riud', '')) 
called at [/usr/local/ispconfig/interface/lib/classes/tform_actions.inc.php:200] #2 tform_actions->onInsert()
 called at [/usr/local/ispconfig/interface/lib/classes/tform_actions.inc.php:97] #3 tform_actions->onSubmit() 
called at [/usr/local/ispconfig/interface/web/client/client_edit.php:121] #4 page_action->onSubmit() 
called at [/usr/local/ispconfig/interface/lib/classes/tform_actions.inc.php:68] #5 tform_actions->onLoad()
 called at [/usr/local/ispconfig/interface/web/client/client_edit.php:592] Field 'mail_servers' doesn't hav
e a default value

I patched this by changing some fields in table "clients". Fields:
- mail_servers
- web_servers
- db_servers
- dns_servers
- template_additional

Those fields are blob/text without default value. Maybe the MySQL version doesn't like that.

I will check my installation for missing components.

Thanks for the help,
Greetings.

 

Excellent till!

I'm using MySQL "Community" 5.6.17 (mysql-community-release-el6-5.noarch.rpm).

Default "my.cnf":

Code:

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

After change:

Code:

sql_mode=NO_ENGINE_SUBSTITUTION

I can add clients now!

Thanks!