Errors when re syncing dns

Discussion in 'ISPConfig 3 Priority Support' started by rob_morin, May 31, 2017.

  1. rob_morin

    rob_morin Member

    I get a lot emails with the below in them, i guess one per domain
    ispconfig 3.1 ubuntu 16.04 after upgrade from 14.04

    31.05.2017-09:18 - WARNING - Falsche Anfrage / Wrong QuerySQL-Query = REPLACE INTO `dns_rr` (`id`,`sys_userid`,`sys_groupid`,`sys_perm_user`,`sys_perm_group`,`sys_perm_other`,`server_id`,`zone`,`name`,`type`,`data`,`aux`,`ttl`,`active`,`stamp`,`serial`) VALUES ('3628','123','122','riud','ru','',7,'128','','TXT','v=DKIM1; t=s; p=MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAzy1goAbhSDWyI7sydc5FDHZPSFN86ufgU2NcXb2HeeyX53esxBhxJ1Jcmgkb0N/fsHIWH+WnzztjcfRWF2Ga3IeXy0e1hi0GcA3yNxRJOC/dlpbknUUVHiTKFlzEZCWnsIBY1tcVF4kjWxpJRA1w7hz5UllmcWopmoAligh+dmCSdej9K4y5U4y7w2xtfuwLdJA/UxmTivfPLHleayEb+VYb2BvhvqUG4FE+cBMGafGVoL3TxzrAycj/BVtkpUXgRBNzjCwfuW1X93UqAsPQIMxLxPCCpMK4/OJ9aPCcmnvZHAVg5qc9zKfLCV7UI9BXxTxiX6WPvyU5sX0wMCeL+wIDAQAB','0','300','Y','2016-12-16 09:41:12','2017053101') -> 1406 (Data too long for column 'data' at row 1)
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Change the type of the data column in the dns_rr table on the slave from varchar 255 to txt. ISPConfig has changed the type in one of the 3.0.5.x updates, but maybe this change did not got applied correctly on your DB.

Share This Page