After i upgrade twice my panel from ubuntu 12 to Ubuntu 14 then to Ubuntu 16 using do-release-upgrade. I have this error when is try to add a new emailbox on my panel #0 db->query(INSERT INTO `mail_user` (`server_id`, `email`, `login`, `password`, `name`, `quota`, `cc`, `maildir`, `homedir`, `uid`, `gid`, `postfix`, `disablesmtp`, `disableimap`, `disablepop3`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`) VALUES ('33', '[email protected]', '[email protected]', '$1$gfJan/Po$2F1BZcKN4cnQ20zOi99ir0', 'Vavau', '0', '', '/var/virtual/kalianet.to/vavagent', '/var/virtual', '5000', '5000', 'y', 'n', 'n', 'n', '1', '1', 'riud', 'riud', '')) called at [/usr/local/ispconfig/interface/lib/classes/tform_actions.inc.php:256] #1 tform_actions->onInsertSave(INSERT INTO `mail_user` (`server_id`, `email`, `login`, `password`, `name`, `quota`, `cc`, `maildir`, `homedir`, `uid`, `gid`, `postfix`, `disablesmtp`, `disableimap`, `disablepop3`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`) VALUES ('33', '[email protected]', '[email protected]', '$1$gfJan/Po$2F1BZcKN4cnQ20zOi99ir0', 'Vavau', '0', '', '/var/virtual/kalianet.to/vavagent', '/var/virtual', '5000', '5000', 'y', 'n', 'n', 'n', '1', '1', 'riud', 'riud', '')) called at [/usr/local/ispconfig/interface/lib/classes/tform_actions.inc.php:200] #2 tform_actions->onInsert() called at [/usr/local/ispconfig/interface/lib/classes/tform_actions.inc.php:97] #3 tform_actions->onSubmit() called at [/usr/local/ispconfig/interface/web/mail/mail_user_edit.php:230] #4 page_action->onSubmit() called at [/usr/local/ispconfig/interface/lib/classes/tform_actions.inc.php:68] #5 tform_actions->onLoad() called at [/usr/local/ispconfig/interface/web/mail/mail_user_edit.php:328] Incorrect datetime value: '0000-00-00 00:00:00' for column 'autoresponder_start_date' at row 1 Anyone with a hint would very much appreciate. Note : I dont have any error on ispconfig log , this is print on the page load with bunch of other lines as wel ..
Did you update ISPConfig to 3.1.2 already? If not, update it. Or has this value be set e.g. by roundcube, in that case, you will have to update the roundcube ispconfig plugin.
ok great .. to upgrade i have to upgrate the panel first then upgrade all my clients or clients first then my panel to the latest version ???
The master server first and then the slave servers. The update is necessary because MySQL dropped support for the value '0000-00-00 00:00:00' as 'not set' in datetime fields, instead the new MySQL version that you have installed now requires NULL in that field, and that's what ISPConfig since 3.1 is using.
ok will do that now .. thanks for the info though ... will let you how it result afterwards. ..thanks any way
After starting the update i got this error PHP Fatal error: Class 'mysqli' not found in /tmp/ispconfig3_install/install/lib/mysql.lib.php on line 31
Btw, there is also a way to stay at the old ispconfig version if you prefer that, you will have to configure mysql to be less strict then so that it is compatible with older mysql versions.
After upgrading my dns client i have ths warning as well 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 ('7572','69','69','riud','riud','',39,'219','','MX','mx1.tcc.to.','10','172800','Y','2014-10-03 21:59:06','2016090101') -> 2006 (MySQL server has gone away)
The SQL error means that MySQL was offline at the time the query was run. Regarding login: empty the browser cache and delete all cookies related to the server URL in your browser.
Yes Till Both my issue now is fixed. 1. For mysql error is reboot my server and all is back to normal. 2. I delete cookie and reload my browser and all good now. Thank you so much for your support. Maile.
Now one of my webser got this Checking ISPConfig database .. OK Unable to read server configuration from database when run update
now i manage to fix my upgrade with correcting server_id and server_name on my client server table. but i run in to this error .. i think it is to do with my php below when start apache2 afterwards but if you have any lead please let me know Invalid command 'php_admin_value', perhaps misspelled or defined by a module not included in the server configuration BR
I got the same error due to upgrade mysql server from 5.6 to 5.7; ISPConfig ver. 3.0.5.4p, CentOS 6.10 You can check your current strick mode: Code: # mysql -u root -p -e "SHOW VARIABLES LIKE 'sql_mode';" Eg. output contains NO_ZERO_IN_DATE and NO_ZERO_DATE which causes this problem. Code: +---------------+-------------------------------------------------------------------------------------------------------------------------------------------+ | Variable_name | Value | +---------------+-------------------------------------------------------------------------------------------------------------------------------------------+ | sql_mode | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION | +---------------+-------------------------------------------------------------------------------------------------------------------------------------------+ then edit /etc/my.cnf and put this code: Code: [mysqld] sql_mode = STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION Restart your mysql server.
