WARNING - Falsche Anfrage / Wrong QuerySQL-Query emails

Hello,

I am getting these Warning emails:

18.09.2017-23:59 - WARNING - Falsche Anfrage / Wrong QuerySQL-Query = REPLACE INTO `web_domain` (`domain_id`,`sys_userid`,`sys_groupid`,`sys_perm_user`,`sys_perm_group`,`sys_perm_other`,`server_id`,`ip_address`,`ipv6_address`,`domain`,`type`,`parent_domain_id`,`vhost_type`,`document_root`,`web_folder`,`system_user`,`system_group`,`hd_quota`,`traffic_quota`,`cgi`,`ssi`,`suexec`,`errordocs`,`is_subdomainwww`,`subdomain`,`php`,`ruby`,`python`,`perl`,`redirect_type`,`redirect_path`,`seo_redirect`,`rewrite_to_https`,`ssl`,`ssl_letsencrypt`,`ssl_state`,`ssl_locality`,`ssl_organisation`,`ssl_organisation_unit`,`ssl_country`,`ssl_domain`,`ssl_request`,`ssl_cert`,`ssl_bundle`,`ssl_key`,`ssl_action`,`stats_password`,`stats_type`,`allow_override`,`apache_directives`,`nginx_directives`,`php_fpm_use_socket`,`pm`,`pm_max_children`,`pm_start_servers`,`pm_min_spare_servers`,`pm_max_spare_servers`,`pm_process_idle_timeout`,`pm_max_requests`,`php_open_basedir`,`custom_php_ini`,`backup_interval`,`backu
p_copies`,`backup_excludes`,`active`,`traffic_quota_lock`,`fastcgi_php_version`,`proxy_directives`,`enable_spdy`,`last_quota_notification`,`rewrite_rules`,`added_date`,`added_by`,`directive_snippets_id`,`enable_pagespeed`,`http_port`,`https_port`,`log_retention`)
.... blah, blah, blah.

What do I need to do to get these to stop?

Thank you.

 

uhm I'd say fix the issue, have you eventually updated your database server recently to lets say from mysql 5.something to mariadb 10.something and now facing an issue with the sql compatibility mode maybe?

 

Thanks for the reply.

No, I have not switched database engines. Still running mySQL. I think the only thing I have done is to keep ISPConfig current.

Now I am getting the same error every time I update a site. The line of the error contains:

(Unknown column 'log_retention' in 'field list')

I guess I could create the field 'log_retention' in the field list table, but, the question remains: how did this happen since I have upgraded ISPConfig many time in the past without such an error occurring.

 

https://git.ispconfig.org/ispconfig/ispconfig3/commit/114c275613fd4806660fca84a26a0da4c058f003

Code:

ALTER TABLE `web_domain` CHANGE `folder_directive_snippets` `folder_directive_snippets` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
ALTER TABLE `web_domain` ADD `log_retention` INT NOT NULL DEFAULT '30' AFTER `https_port`;
ALTER TABLE `web_database` CHANGE `database_quota` `database_quota` INT(11) NULL DEFAULT NULL;

you might check for those aswell

 

OK.

The CP server has the web_domain/log_retention, however, the slave servers don't.

The CP server has web_database/database_quota set as mentioned as does the slave servers.

However, none of the servers have web_domain/folder_directive_snippets.

All servers have been updated now.

Thank you.