ISPConfig 3.0.5.4p1 | ERROR - Replication failed. Err... | Bug Report

Discussion in 'General' started by Ator, May 3, 2014.

  1. Ator

    Ator New Member

    I just received an error via email.
    I fixed this with: sql_mode=NO_ENGINE_SUBSTITUTION (Default: NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES)

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

    02.05.2014-22:27 - ERROR - Replication failed. Error: (web_database) in MySQL server: (localhost) Incorrect integer value: '' for column 'database_quota' at row 1 # SQL: REPLACE INTO web_database (`database_id`,`sys_userid`,`sys_groupid`,`sys_perm_user`,`sys_perm_group`,`sys_perm_other`,`server_id`,`parent_domain_id`,`type`,`database_name`,`database_name_prefix`,`database_quota`,`last_quota_notification`,`database_user_id`,`database_ro_user_id`,`database_charset`,`remote_access`,`remote_ips`,`backup_interval`,`backup_copies`,`active`) VALUES ('1','1','2','riud','riud','','2','1','mysql','c1xxxxxx','c1','','','1','0','utf8','y','xxx.xx.xx.xx','none','1','y')

    Related thread: http://www.howtoforge.com/forums/showthread.php?t=65666

    Just reporting.
    :)
     
    Last edited: May 3, 2014
    Ator, May 3, 2014
    #1
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    The option mysql ption "STRICT_TRANS_TABLES" is not suppoerted by ispconfig.
     
    till, May 4, 2014
    #2

Share This Page