Uploaded image for project: 'PrestaShop 1.7'
  1. PrestaShop 1.7
  2. BOOM-3946

1-click autoupgrade 1.6 to 1.7 database upgrade error

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Cannot Reproduce
    • Affects Version/s: 1.7.2.2
    • Fix Version/s: None
    • Component/s: upgrade

      Description

      I try to upgrade a big shop from 1.6.15 to 1.7.1.

      The upgrade system is stuck at
      All files upgraded. Now upgrading database...

      and after reaching the timeout it shows:
      [Ajax / Server Error for action upgradeDb] textStatus: "error " errorThrown:"Gateway Time-out " jqXHR: "

      The Database general log shows the following queries repeating for days.
      528029 Query SELECT *
      FROM `ps_group` a
      LEFT JOIN `ps_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 0
      WHERE (a.`id_group` = 3) LIMIT 1
      528029 Query SELECT *
      FROM `ps_group_lang`
      WHERE `id_group` = 3
      528029 Query SELECT *
      FROM `ps_employee` a
      LEFT JOIN `ps_employee_shop` `c` ON a.`id_employee` = c.`id_employee` AND c.`id_shop` = 0
      WHERE (a.`id_employee` = 1) LIMIT 1
      528029 Query SELECT id_shop FROM `ps_employee_shop` WHERE `id_employee` = 1
      528029 Query SELECT l.*, ls.`id_shop`
      FROM `ps_lang` l
      LEFT JOIN `ps_lang_shop` ls ON (l.id_lang = ls.id_lang)
      528029 Quit
      528030 Connect prestasql@localhost as anonymous on prestashop
      528030 Query SET NAMES 'utf8'
      528030 Query SET SESSION sql_mode = ''

      Strange thing:
      Sometimes I don't get this error but an error about prestashop not finding the install directory autoinst-blabla... I tracked this down to the uniqid() in the AdminSelfUpgrade.php The uniqid changes during the upgrade so the upgrade doesn't find the directory.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Quetzacoalt Thomas Nabord
                Reporter:
                netdrag Thomas Andergassen
              • Votes:
                15 Vote for this issue
                Watchers:
                21 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: