WARNING - Falsche Anfrage / Wrong QuerySQL-Query emails

Discussion in 'General' started by Entangled, Sep 19, 2017.

  1. Entangled

    Entangled Member

    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.
     
  2. ztk.me

    ztk.me ISPConfig Developer ISPConfig Developer

    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?
     
  3. Entangled

    Entangled Member

    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.
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    Just create the missing field as integer field. One f the patch updates of the database that added this field must have failed.
     
  5. ztk.me

    ztk.me ISPConfig Developer ISPConfig Developer

  6. Entangled

    Entangled Member

    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.
     

Share This Page