Hi all, in resync operation for website the server give a "warning" with the log of operation.....below sample: #0 db->query(UPDATE `web_domain` SET `domain_id` = '1',`sys_userid` = '1',`sys_groupid` = '2',`s....... Someone can help me for disable this? Thanks..
The resync works fine here on my p8 server without errors. most likely your system is missing database tables. Have you copied this ispconfig database from a different server?
I installed on a clean server. Directly with last version, without update. How can i try to find where is the error?
Copy the sql query that is shown in the error message and execute it in phpmyadmin in the dbispconfig database to get the mysql error message. The query is the part from UPDATE .....to .... 1,1,)
Server: Localhost via UNIX socket Tipo di server: MySQL Versione del server: 5.6.25 - MySQL Community Server (GPL) Versione protocollo: 10 Utente: root@localhost Codifica caratteri del server: UTF-8 Unicode (utf8) Web server Apache/2.4.6 (CentOS) OpenSSL/1.0.1e-fips mod_fcgid/2.3.9 PHP/5.4.16 mod_python/3.5.0- Python/2.7.5 Versione del client del database: libmysql - mysqlnd 5.0.10 - 20111026 - $Id: e707c415db32080b3752b232487a435ee0372157 $ Estensione PHP: mysqli Versione PHP: 5.4.16 Centos 7.1
Try to set: sql_mode=NO_ENGINE_SUBSTITUTION in mysql my.cnf file (within the [mysqld] section, then restart mysql and check if the error persists.
It's already... # Recommended in standard MySQL setup sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
