Articles in this section

See more

Plesk upgrade fails: Incorrect datetime value: '0000-00-00 00:00:00' for column 'received' at row 1

Avatar
Maxim Krasikov
Updated
Follow

Applicable to:

  • Plesk Onyx for Linux

Note: This article has the reference to the issue with the fix available:

Please consider updating your server:

Symptoms

  • Unable to upgrade Plesk from version 17.0, one of the outputs below is shown in the Plesk installer:

    CONFIG_TEXT: Migration failed: 17.5.0/2016-12-26-09-56-48_change_dates_default_value.php
    Query failed: UPDATE `APSCatalogUpdates` SET `received` = '1970-01-01 00:00:00' WHERE `received` = '0000-00-00 00:00:00'
    Incorrect datetime value: '0000-00-00 00:00:00' for column 'received' at row 1
    ...
    ***** problem report *****
    ===> Plesk database scheme was not upgraded completely. See installation log for details.
    Error: An error occurred during performing of installation PREP actions (see log for details). Installation was rolled back.
    Warning! Not all packages were installed.
    Please check if your system services are operable.
    Please resolve this issue and try to install the packages again.
    If you cannot resolve the issue on your own, contact product technical support for assistance.
    =========

    OR

    CONFIG_TEXT: ===> Plesk database scheme upgrade has been started.

    ===> Plesk database scheme was not upgraded completely. See installation log for details.


    Stopping sw-cp-serverd: [ OK ]
    cat: /proc/net/if_inet6: No such file or directory
    Starting sw_engine service... done
    Starting sw_cp_server service... done
    Starting mysql service... already started
    Starting named service... not installed
    Starting mailer service... already started
    Starting spamfilter service... already started
    Starting drweb service... unused
    Starting tomcat service... not installed
    Starting apache service... already started
    Starting xinetd service... already started
    ***** problem report *****
    ===> Plesk database scheme was not upgraded completely. See installation log for details.

    ERROR: An error occurred during performing of installation PREP actions (see log for details). Installation was rolled back.
    Warning! Not all packages were installed.
    Please check if your system services are operable.
    Please resolve this issue and try to install the packages again.
    If you cannot resolve the issue on your own, contact product technical support for assistance.
    exit status 1

    OR

    CONFIG_TEXT: ERROR while trying to execute SQL query, the query was: ALTER TABLE `avstatistics` ADD KEY `date_type` (type,`date`)

  • MySQL version 5.7 is installed:

    # mysql -V
    mysql Ver 14.14 Distrib 5.7.18, for Linux (x86_64)

  • The SQL strict mode is enabled:

    # MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -uadmin -i -BN -e 'SELECT @@sql_mode' | egrep 'ONLY_FULL_GROUP_BY|STRICT_TRANS_TABLES' IGNORE_SPACE,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

Cause

This is a Plesk bug with ID PPPM-6145, which is fixed in Plesk 17.8.

Resolution

Note: This article may require additional administrative knowledge to apply. If any help required, contact server’s administrator or hosting support.

Apply the workaround below:

For CentOS

  1. Connect to the server via SSH.

  2. Create a backup of the MySQL configuration file:

    # cp -a /etc/my.cnf{,.bak}

  3. Open file /etc/my.cnf in a text editor and add the following line under the [mysqld] section:

    CONFIG_TEXT: sql_mode=IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

  4. Restart the MySQL service:

    # service mariadb restart

  5. Perform Plesk upgrade.

  6. After the upgrade is completed, roll back the changes: open file /etc/my.cnf and remove the following string:

    CONFIG_TEXT: sql_mode=IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

  7. Restart the MySQL service:

    # service mariadb restart

For Ubuntu/Debian

  1. Connect to the server via SSH.

  2. Create a backup of the MySQL configuration file:

    # cp -a /etc/mysql/my.cnf{,.bak}

  3. Open file /etc/mysql/my.cnf in a text editor and add the following line under the [mysqld] section:

    CONFIG_TEXT: sql_mode=IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

  4. Restart the MySQL service:

    # service mysql restart

  5. Perform Plesk upgrade.

  6. After the upgrade is completed, roll back the changes: open file /etc/mysql/my.cnf and remove the following string:

    CONFIG_TEXT: sql_mode=IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

  7. Restart the MySQL service:

    # service mysql restart

Comments

0 comments

Please sign in to leave a comment.

Have more questions? Submit a request

Related articles