1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice

Resolved Plesk 17.0 -> 17.5 upgrade fails on database prep

Discussion in 'Plesk Onyx for Linux' started by Joost de Bruijn, Apr 3, 2017.

  1. Joost de Bruijn

    Joost de Bruijn New Pleskian

    1
    20%
    Joined:
    Dec 27, 2016
    Messages:
    4
    Likes Received:
    0
    Location:
    Netherlands
    I tried to upgrade my current Plesk Onyx 17.0 (running on Ubuntu 16.04.2, MySQL 5.7.17-0ubuntu0.16.04.1). installation to Plesk Onyx 17.5. However, during the preparation stage of the upgrade via the both the cli installer as the web interface, an error occured:

    Code:
    Installation started in background
    Controleren of de onderlinge afhankelijkheid van pakketten is vastgesteld.
    Bezig met installatie van pakketten
    is running
    Stopping sw_engine service... done
    ===> Cumulative APS controller database (apsc) upgrade has been started.
    ===> Cumulative upgrade of APS controller database has been completed.
    ===> Cumulative Plesk database upgrade (revertable stage) has been started.
    ===> Preparing Plesk database upgrade (revertable stage).
    ===> Cumulative upgrade of Plesk database (revertable stage) has been completed.
    ===> Plesk database scheme upgrade has been started.
    Applying migrations from: /opt/psa/bootstrapper/pp17.5.3-bootstrapper/migrations/
    Migration 17.5.0/2016-12-16-10-20-39_change_dns_recs_val_length.php applied
    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
    However, the table is empty. How can I resolve this problem and continue the upgrade?

     
    Last edited: Apr 3, 2017
  2. IgorG

    IgorG Forums Analyst Staff Member

    47
    64%
    Joined:
    Oct 27, 2009
    Messages:
    24,166
    Likes Received:
    1,163
    Location:
    Novosibirsk, Russia
    Affiliate:
    https://plesk.com/?a_aid=59ae552b0731c
    Do you have any related errors in mysql log?
    Have you tried 'plesk repair db' before upgrade?
     
  3. Antrax1

    Antrax1 Basic Pleskian

    13
     
    Joined:
    Jul 7, 2012
    Messages:
    35
    Likes Received:
    0
    Hi,
    I have the same error, how was solved?

    Code:
    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
     
  4. IgorG

    IgorG Forums Analyst Staff Member

    47
    64%
    Joined:
    Oct 27, 2009
    Messages:
    24,166
    Likes Received:
    1,163
    Location:
    Novosibirsk, Russia
    Affiliate:
    https://plesk.com/?a_aid=59ae552b0731c
    Run

    # plesk repair db
     
    dd360 likes this.
  5. Antrax1

    Antrax1 Basic Pleskian

    13
     
    Joined:
    Jul 7, 2012
    Messages:
    35
    Likes Received:
    0
  6. eminiarts

    eminiarts New Pleskian

    4
     
    Joined:
    Jan 5, 2017
    Messages:
    6
    Likes Received:
    1
    Location:
    Schweiz
    I get the same Error.

    I run 'plesk repair db' several times, everything seems to be ok.

    Does it have anything to do with it being MySQL 5.7?

    Any help is appreciated!

    Thanks in advance.

    Kind regards,
    Emini
     
  7. Daedalus3

    Daedalus3 New Pleskian

    3
    20%
    Joined:
    Dec 6, 2015
    Messages:
    7
    Likes Received:
    1
    Best Answer
    dd360 likes this.
  8. eminiarts

    eminiarts New Pleskian

    4
     
    Joined:
    Jan 5, 2017
    Messages:
    6
    Likes Received:
    1
    Location:
    Schweiz
    Thanks. This solved it for me too! Thank you Daedalus3! :)
     
Loading...