Weird errors after upgrade to latest ispconfig Replication failed??

Discussion in 'ISPConfig 3 Priority Support' started by rob_morin, Oct 17, 2016.

  1. rob_morin

    rob_morin Member

    I am now gettign these emails every 5 mins , not sure what they mean exactly?

    17.10.2016-12:08 - ERROR - Replication failed. Error: (sys_ini) in MySQL server: (localhost) Unknown column 'default_logo' in 'field list' # SQL: REPLACE INTO sys_ini (`sysini_id`,`config`,`default_logo`,`custom_logo`) VALUES ('1','[permissions]\nallow_shell_user=yes\nadmin_allow_server_config=superadmin\nadmin_allow_server_services=superadmin\nadmin_allow_server_ip=superadmin\nadmin_allow_remote_users=superadmin\nadmin_allow_system_config=superadmin\nadmin_allow_server_php=superadmin\nadmin_allow_langedit=superadmin\nadmin_allow_new_admin=superadmin\nadmin_allow_del_cpuser=superadmin\nadmin_allow_cpuser_group=superadmin\nadmin_allow_firewall_config=superadmin\nadmin_allow_osupdate=superadmin\nadmin_allow_software_packages=superadmin\nadmin_allow_software_repo=superadmin\nremote_api_allowed=yes\npassword_reset_allowed=yes\nsession_regenerate_id=yes\n\n[ids]\nids_enabled=no\nids_log_level=1\nids_warn_level=5\nids_block_level=100\nsql_scan_enabled=yes\nsql_scan_action=warn\napache_dire
    ctives_scan_enabled=yes\n\n[systemcheck]\nsecurity_admin_email=root@localhost\nsecurity_admin_email_subject=Security alert from server\nwarn_new_admin=yes\nwarn_passwd_change=no\nwarn_shadow_change=no\nwarn_group_change=no\n\n[mail]\nenable_custom_login=n\nmailbox_show_autoresponder_tab=y\nmailbox_show_mail_filter_tab=y\nmailbox_show_custom_rules_tab=y\nmailboxlist_webmail_link=y\nwebmail_url=/webmail\ndkim_path=/var/lib/amavis/dkim\nmailmailinglist_link=n\nmailmailinglist_url=\[email protected]\nadmin_name=Rob Morin\nsmtp_enabled=y\nsmtp_host=localhost\nsmtp_port=25\nsmtp_user=admin\nsmtp_pass=!WereFucked9\nsmtp_crypt=\n\n[sites]\ndbname_prefix=[CLIENTID]_\ndbuser_prefix=[CLIENTID]_\nftpuser_prefix=\nshelluser_prefix=\nwebdavuser_prefix=\ndblist_phpmyadmin_link=n\nphpmyadmin_url=\nwebftp_url=\nvhost_subdomains=n\nvhost_aliasdomains=n\nclient_username_web_check_disabled=n\nbackups_include_into_web_quota=n\nreseller_can_use_options=n\ndefault_webserver=1\ndefault_dbserver=3\n\
    n[domains]\nuse_domain_module=n\nnew_domain_html=Please contact our support to create a new domain for you.\n\n[misc]\ncompany_name=\ncustom_login_text=\ncustom_login_link=\ndashboard_atom_url_admin=http://www.ispconfig.org/atom\ndashboard_atom_url_reseller=http://www.ispconfig.org/atom\ndashboard_atom_url_client=http://www.ispconfig.org/atom\nmonitor_key=\ntab_change_discard=n\ntab_change_warning=n\nuse_loadindicator=y\nuse_combobox=y\nmaintenance_mode=n\nadmin_dashlets_left=\nadmin_dashlets_right=\nreseller_dashlets_left=\nreseller_dashlets_right=\nclient_dashlets_left=\nclient_dashlets_right=\ncustomer_no_template=C[CUSTOMER_NO]\ncustomer_no_start=1\ncustomer_no_counter=12\nsession_timeout=0\nsession_allow_endless=n\nmin_password_length=5\nmin_password_strength=\n\n','data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAMgAAABBCAYAAACU5+uOAAAItUlEQVR42u1dCWwVVRStUJZCK6HsFNAgWpaCJkKICZKApKUFhURQpEnZF4EEUJZYEEpBIamgkQpUQBZRW7YCBqQsggsQEAgKLbIGCYsSCNqyQ8D76h18Hd/MvJk/n/bXc5KT+TNz79vPzNv+/
    2FhAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAOAe++s0akTsRZxMnE6cGkKcxkwhPofaBPwWRzxxB/EO8UGI8xhxEGoV8EscY8qBKFRcgdoFAhXHC+VUHAbHo5aBQASyrZwL5DoxEjUNeBXI9XIuEMEE1DTgVSA3FA3qIDEtBLnTQiBDUNOAV4EUKhpURojmZQQEAjwKgSwK0bykWQgEU74ABAKBABAIBOIJffoNrkRsS0whDiMO5uNw4gBiSxvfGOJrbDtMOgr2JNa18HmZmETsopnGp4h9xdF0TcQRb8NEPkawTzv2qaWIoybnZYRUBoJD+difGAuBlCy0qsRM4mfERcTFfGygsBUF/xFxE/EQ8RixwIbi/j7il8R3iE8qwuxAXMJxuuFiTvNMYleb/E0gXiI+cOBaISTJrzLxcw2/+8Q5pjjfNNkM0RDILLadpbimw+bsc4DPkxRpuqkZ1orisoBAiguuhkUhPSvZRBA3u6gsK94g9jDFP9aHcAV3EKNNYX8i3RcNJ4M4nTiROJCYykIzbGZKvouk68vYbyS/cUbz+RrJZpzkO5Sv3eajaJhRDvUwg21nKK4VcF5WKPgFH6PZZw/7dJXC6S6lczunfbIQLpeDkZ+lJcoCAikuvChioaLBtfD4JHPiXSFKKexBPoa9Wwr3ael6skMZDGO7K3z+uOSb5OA7mu2KiOGmPH3ADVh8/sohnDS2S1NcG+uiO/kd+8RL146YRWzj359tb0Eg+gIpsHkjFNrQqiF3DZJABDtyuCP5/FuNRlHN8Ofz9nx+XLNR3jR1c4w8TSFGSmnr4FEgU7wKhI51jAeTpv+/ZQGBOAuEu1d/Ku6LV35t9rdigkUjHuMgkHPEecQsxdjjUx4zHbMI+10OdzqfZ2o0iiqSfzgPfMXnzZqN6iTbJ5jytMTU0E97FEhaAAJ5kc/PuJjQOCoIgegJpKbUl5b5vGaBT+A+vOgn5/JYIdFBIOs1wo1kIZl93+
    P70/h8oUZYFXkmKInPU9h3m2YeT8lvRilPyyWbi3xt4iMWSDc+P4lp3uAIRDxdryjui6dmuujXcr91IDcMmaJv31WISfTrLeJXCUT3yb1a4Ztmalyu61MaZG/XtD9tapRGnpZKNp2lNNZ3KZARAQgk3untBYEEPgbJ92FsIAax34v1AQ2B5Go2BlW60n0QyCC/BWISdJ5LgewWU8k86DdTzMyNh0BKVyAzfB5I93YQyBGeTlW9lQbwIle2Rdgzy7BAxJT6Hb6X6EIgTrznRSCiHli02cwcPor1pbkQiL5AKvOA+ZZPAtkfxFms3j4IZHAwBGJaRPxdjH00BSImJRqKOlEwjtjUo0Dm2pWla4HMzsyqQIxSMKI8C8RkL9YXuhDf5gqcw4NweaZJiGkh8UeLwi+Utkb4KZCrYszkVSDiQRDMN4hkf5DvZ2gKZJyLPJgFkmAjEDEF3EYSWzPeklO8Q8CLQGKJhQquK+eDdLFNZBJxFLEf8XUXFTbcYv2kRhAEIq+vGNO88zTTKVaRzxPrSSvPW11O8yZqCiROSnMsX0sP0ixWops1Hfbx/AaJIz5QcFc5n+ZVNcbxmoWtEsBNB4EU8Tgk32Gv1wneEybeWG1N8RoNbplmOo2neiyxE3/eoun7G9t31hGIqXuzl8/HB0kgxhvhD03/KoEIpIWFQPLK+UJhkWpgKLZP8IKhajNhJg8A7yt8/5K6QoFM8z5mc68Ph3VWM6wTbN+a+AR/vqThV13KYyMXAgmXps9FnK8GSSA17KaXFf7R3gUyd8H/TiBss9fngfQehzfMpkDLgxcS73J4k1y85WrxtTtOjZPuVZA2O55RhLfUId5XpI2UHwZDIHxtp7HtRrVL25SfhWy7z7VAMuYvipszd0FJcfxzHspdrMctGnGcZNPTZ4F0VszqyPSlPHm8JG9f2SDtgF3Nq/rnJZssyXeUdP0CN64c9l/FDfGyZNNNkaeVGmnMM+Vdtd19los8/2e
    7Ow/E70lxiG7pRmkn8AaeULlcoo4sBDLfKvL0nLUxablfX0hfmfuQ01avI65fUQYEkupRIJHcAMwbDWNNdmLgupV4zeMO3stcIZ1M4aYo4vZt0oO7Locd0ndGTEQofN+QxiZ22+y7W+RpgUb66vOU7232SZXupZqvaYT3Dfu8ZLrejtc47mvkJ9FoVEWKBmW7dyc7ZXD1Nb2TH3JVn5Tqa3r1repzY6/gwWeqhUCGO/XjWSTmjYYVLOzFoP0Z/qJTks033brxrtjmxCbGtK4ivEqKuH2fNuc0tDatIYgna4yGbz2eeTL8WhJbic2aDnmqqpm2KlLeK5vWn0pc0wirGvtUtBkzNdPKDzWe24oGdZX4CzGfWCD4U93GBQdqNSw4Uiny8K9h4buOhlU2scq+Q1G1i233k63hFwBPEfcS04l1FGJoynbH+fgz8ZKFQJLDAMDjk/psCPzw20XxE6mmdLd24d8KNQ14FciUEPl1xHvEhlK6W2j65aOWgUAEUpV4NEREstyDQNqjloFARVKL/xukrAvkGjGC09zGwfYKsQdqF/BTKMnEJcTtxC3EPAU3iic5cRkfjc/ZFvZuuZm4gXjOouG35LQ2Yfutkq/4pfpN/E9TDVCjQGkJqQExho+CjYlRPseRiQE3EIriaMZTw4K3mOJv23J8jme23RsEAMqqQJrb9PnnEbPEVpUAuJD4Mf/PoCqeONQCUJYFElGKf7ojpnqjUQtAWRdJaf1t2w8ofSAUBNKulATSEaUPhIpIRj9icbyFUgdCTSRTeR0i2HwfpQ0AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQBnG392D9QU+JXhxAAAAAElFTkSuQmCC','')
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Seems as if the database structure on master and slave differs, either the slave has not been updated yet or the database structure has not been fully updated. As the error message explains, the field default_logo is missing in the sys_ini table on the slave server.
     
  3. rob_morin

    rob_morin Member

    Ah, ok we had one server down so we upgraded 3 out of 4 slaves, plus the master, when its up i will upgrade it.
    tHANKS
     
  4. rob_morin

    rob_morin Member

    All is well since i updated that last server once it came up.
    Thanks..
     
    till likes this.

Share This Page