PleskMainDBException: MySQL query failed: Data truncated for column 'fp' at row 1

[dickyj]

Hi,
We are using Plesk 8.1 and we did some mySQL performance tuning and we suspect somehow it breaks Plesk. Right now, we cannot successfully create a domain. We keep getting these errors, can someone point us to the right fix for this problem? The last time we had this error, we have to re-install the whole server, we hope we do not have to resort to that again. Thanks.

Here is the details of the error:

0: /usr/local/psa/admin/plib/common_func.php3:211
db_query(string 'replace hosting set `dom_id`='5', `sys_user_id`='10', `ip_address_id`='2', `ssl`='true', `same_ssl`='true', `fp`='', `fp_ssl`='', `fp_enable`='', `fp_adm`='', `fp_pass`='', `ssi`='', `php`='', `php_safe_mode`='true', `cgi`='', `perl`='', `python`='', `fastcgi`='', `miva`='', `coldfusion`='', `asp`='', `asp_dot_net`='', `webstat`='none', `at_domains`=''')
1: /usr/local/psa/admin/plib/class.Table.php:328
Table->update(array)
2: /usr/local/psa/admin/plib/class.cObject.php:347
cObject->update()
3: /usr/local/psa/admin/plib/class.PHosting.php:776
PHosting->update()
4: /usr/local/psa/admin/plib/class.PHostingManager.php:610
PHostingManager->update()
5: /usr/local/psa/admin/htdocs/domains/hosting/phosting_setup.php:217

 

[stefanb]

It is something of the sql-mode. I had same case with a client and they have set these modes in my.cnf

sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

I believe it is caused but the STRICT_TRANS_TABLES
I commented that line , restarted mysql and it worked fine.