Upgrade from 1.7.7.7 to 1.7.8.X [Resolved]

[sylvainlepetit]

Hello

I tryied to upgrade my shop from the version 1.7.7.7 to the 1.7.8.X. I used the 1-click module or manually I have the same error during the doctrine update porcess.

I tried to upgrade a fresh install ( empty product BDD) of the 1.7.7.7 (without any custom module) to 1.7.8 with the same result.

The error message is the table ps_lang already exists...

If I comment the doctrine update process line into the Upgrade.php It works. But I think something should be missed no?

I an under php7.3 and use MariaDb

I'm alone is this case?

Sylvain

[ComGrafPL]

For 1.7.8 you need to use Php 7.4.

[sylvainlepetit]

Hi,

 

ok when I have to migrate php7.3 to php7.4, at the same time I upgrade the code? before launch script?

Due to the 1.7.7.7 seems to be not compatible with php7.4, can I migrate to php7.4 and use 1-click upgrade before? 

[racemaniac]

My system - settings 

PrestaShop-versie: 1.7.8.2

info_outline Servergegevens

Serverinformatie: Linux #1 SMP Thu Jun 11 14:05:04 MSK 2020 x86_64

Server softwareversie: Apache/2

PHP-versie: 7.3.33

Geheugenlimiet: 256M

Maximale uitvoeringstijd: 30

Maximale bestandsgrootte voor uploads: 64M

[sylvainlepetit]

Hello,

 

I upgrape php from 7.3 to 7.4 before lauch the install, it works!

thanks to ComGrafPL

[ComGrafPL]

10 hours ago, sylvainlepetit said:

Hello,

 

I upgrape php from 7.3 to 7.4 before lauch the install, it works!

thanks to ComGrafPL

Enjoy it.

[sylvainlepetit]

Hello,

I tried by use the same process to upgrade to the last 1.7.8.3 version, but I have error id=43 when call php install/upgrade/upgrade.php.

I tried from 1.7.8.2 to 1.7.8.3 and tried from 1.7.7.7 to 1.7.8.3 too with the same result.

php 7.4.24
MariaDb : mysql  Ver 15.1 Distrib 10.3.32-MariaDB

Any idea??

Thanks

Sylvain

[sylvainlepetit]

I found into the var/cache/prod/20220127_upgrade.log this error message:

*ERROR*   v1.7.8.3  2022/01/27 - 21:18:23: Error upgrading doctrine schema

*ERROR*   v1.7.8.3  2022/01/27 - 21:18:23: Doctrine SQL Error : Updating database schema...

*ERROR*   v1.7.8.3  2022/01/27 - 21:18:23: Doctrine SQL Error : 21:18:23 ERROR     [console] Error thrown while running command "prestashop:schema:update-without-foreign --env=prod". Message: "The table with name 'prestashop.ps_product' already exists." ["exception" => Doctrine\DBAL\Schema\SchemaException { …},"command" => "prestashop:schema:update-without-foreign --env=prod","message" => "The table with name 'prestashop.ps_product' already exists."]

*ERROR*   v1.7.8.3  2022/01/27 - 21:18:23: Doctrine SQL Error :

*ERROR*   v1.7.8.3  2022/01/27 - 21:18:23: Doctrine SQL Error : In SchemaException.php line 108:

*ERROR*   v1.7.8.3  2022/01/27 - 21:18:23: Doctrine SQL Error :                                                                

*ERROR*   v1.7.8.3  2022/01/27 - 21:18:23: Doctrine SQL Error :   The table with name 'prestashop.ps_product' already exists.  

*ERROR*   v1.7.8.3  2022/01/27 - 21:18:23: Doctrine SQL Error :                                                                

*ERROR*   v1.7.8.3  2022/01/27 - 21:18:23: Doctrine SQL Error :

*ERROR*   v1.7.8.3  2022/01/27 - 21:18:23: Doctrine SQL Error : prestashop:schema:update-without-foreign [-h|--help] [-q|--quiet] [-v|vv|vvv|--verbose] [-V|--version] [--ansi] [--no-ansi] [-n|--no-interaction] [-e|--env ENV] [--no-debug] [--id_shop [ID_SHOP]] [--id_shop_group [ID_SHOP_GROUP]] [--] <command>

*ERROR*   v1.7.8.3  2022/01/27 - 21:18:23: Doctrine SQL Error :

*ERROR*   v1.7.8.3  2022/01/27 - 21:18:23: Doctrine SQL Error :

 

A false error message?  A bug into the script?

[nicolas_fco]

Same error upgrading 1.7.8 to 1.7.10 do you have any update on this error ?