Prestashop 8.0.4 to 8.1.1 error

[AquileNere]

Hello, i've tried to update prestashop from version 8.0.4 to 8.1.1 but i got those error when it start to update the databe:

 

Quote

[INTERNAL] /home/yrqmdaeo/public_html/src/PrestaShopBundle/Command/UpdateSchemaCommand.php line 141 - TypeError: Unsupported operand types: int + Doctrine\DBAL\ForwardCompatibility\Result #0 /home/yrqmdaeo/public_html/src/PrestaShopBundle/Command/UpdateSchemaCommand.php(76): PrestaShopBundle\Command\UpdateSchemaCommand->dropExistingForeignKeys() #1 /home/yrqmdaeo/public_html/vendor/symfony/symfony/src/Symfony/Component/Console/Command/Command.php(255): PrestaShopBundle\Command\UpdateSchemaCommand->execute() #2 /home/yrqmdaeo/public_html/vendor/symfony/symfony/src/Symfony/Component/Console/Application.php(1039): Symfony\Component\Console\Command\Command->run() #3 /home/yrqmdaeo/public_html/vendor/symfony/symfony/src/Symfony/Bundle/FrameworkBundle/Console/Application.php(97): Symfony\Component\Console\Application->doRunCommand() #4 /home/yrqmdaeo/public_html/vendor/symfony/symfony/src/Symfony/Component/Console/Application.php(275): Symfony\Bundle\FrameworkBundle\Console\Application->doRunCommand() #5 /home/yrqmdaeo/public_html/vendor/symfony/symfony/src/Symfony/Bundle/FrameworkBundle/Console/Application.php(83): Symfony\Component\Console\Application->doRun() #6 /home/yrqmdaeo/public_html/vendor/symfony/symfony/src/Symfony/Component/Console/Application.php(149): Symfony\Bundle\FrameworkBundle\Console\Application->doRun() #7 /home/yrqmdaeo/public_html/src/PrestaShopBundle/Service/Command/AbstractCommand.php(81): Symfony\Component\Console\Application->run() #8 /home/yrqmdaeo/public_html/modules/autoupgrade/classes/UpgradeTools/SymfonyAdapter.php(56): PrestaShopBundle\Service\Command\AbstractCommand->execute() #9 /home/yrqmdaeo/public_html/modules/autoupgrade/classes/UpgradeTools/CoreUpgrader/CoreUpgrader80.php(68): PrestaShop\Module\AutoUpgrade\UpgradeTools\SymfonyAdapter->runSchemaUpgradeCommand() #10 /home/yrqmdaeo/public_html/modules/autoupgrade/classes/UpgradeTools/CoreUpgrader/CoreUpgrader.php(110): PrestaShop\Module\AutoUpgrade\UpgradeTools\CoreUpgrader\CoreUpgrader80->upgradeDb() #11 /home/yrqmdaeo/public_html/modules/autoupgrade/classes/UpgradeTools/CoreUpgrader/CoreUpgrader81.php(46): PrestaShop\Module\AutoUpgrade\UpgradeTools\CoreUpgrader\CoreUpgrader->doUpgrade() #12 /home/yrqmdaeo/public_html/modules/autoupgrade/classes/TaskRunner/Upgrade/UpgradeDb.php(43): PrestaShop\Module\AutoUpgrade\UpgradeTools\CoreUpgrader\CoreUpgrader81->doUpgrade() #13 /home/yrqmdaeo/public_html/admin658/autoupgrade/ajax-upgradetab.php(53): PrestaShop\Module\AutoUpgrade\TaskRunner\Upgrade\UpgradeDb->run() #14 {main}

 

 

PHP Version: 8.1.21

MySQL Version: 10.6.14-MariaDB-cll-lve-log

1 click upgradde module version: 4.16.2

What could it be? I get the same error even if i try to update to version 8.0.5.

Thank you in advance.

[musicmaster]

The problem is in the file /modules/autoupgrade/upgrade/sql/8.1.0.sql.

In the last line of that file that was executed you see two commands on one line. 

In Advanced Settings-> Database there is an option whether to allow multiple commands on one line. I suspect that blocks the upgrade.

[AquileNere]

Hello,

i've tried with that option enable, but i receive the same error:
 

Quote

[INTERNAL] /home/yrqmdaeo/public_html/src/PrestaShopBundle/Command/UpdateSchemaCommand.php line 141 - TypeError: Unsupported operand types: int + Doctrine\DBAL\ForwardCompatibility\Result #0 /home/yrqmdaeo/public_html/src/PrestaShopBundle/Command/UpdateSchemaCommand.php(76): PrestaShopBundle\Command\UpdateSchemaCommand->dropExistingForeignKeys() #1 /home/yrqmdaeo/public_html/vendor/symfony/symfony/src/Symfony/Component/Console/Command/Command.php(255): PrestaShopBundle\Command\UpdateSchemaCommand->execute() #2 /home/yrqmdaeo/public_html/vendor/symfony/symfony/src/Symfony/Component/Console/Application.php(1039): Symfony\Component\Console\Command\Command->run() #3 /home/yrqmdaeo/public_html/vendor/symfony/symfony/src/Symfony/Bundle/FrameworkBundle/Console/Application.php(97): Symfony\Component\Console\Application->doRunCommand() #4 /home/yrqmdaeo/public_html/vendor/symfony/symfony/src/Symfony/Component/Console/Application.php(275): Symfony\Bundle\FrameworkBundle\Console\Application->doRunCommand() #5 /home/yrqmdaeo/public_html/vendor/symfony/symfony/src/Symfony/Bundle/FrameworkBundle/Console/Application.php(83): Symfony\Component\Console\Application->doRun() #6 /home/yrqmdaeo/public_html/vendor/symfony/symfony/src/Symfony/Component/Console/Application.php(149): Symfony\Bundle\FrameworkBundle\Console\Application->doRun() #7 /home/yrqmdaeo/public_html/src/PrestaShopBundle/Service/Command/AbstractCommand.php(81): Symfony\Component\Console\Application->run() #8 /home/yrqmdaeo/public_html/modules/autoupgrade/classes/UpgradeTools/SymfonyAdapter.php(56): PrestaShopBundle\Service\Command\AbstractCommand->execute() #9 /home/yrqmdaeo/public_html/modules/autoupgrade/classes/UpgradeTools/CoreUpgrader/CoreUpgrader80.php(68): PrestaShop\Module\AutoUpgrade\UpgradeTools\SymfonyAdapter->runSchemaUpgradeCommand() #10 /home/yrqmdaeo/public_html/modules/autoupgrade/classes/UpgradeTools/CoreUpgrader/CoreUpgrader.php(110): PrestaShop\Module\AutoUpgrade\UpgradeTools\CoreUpgrader\CoreUpgrader80->upgradeDb() #11 /home/yrqmdaeo/public_html/modules/autoupgrade/classes/UpgradeTools/CoreUpgrader/CoreUpgrader81.php(46): PrestaShop\Module\AutoUpgrade\UpgradeTools\CoreUpgrader\CoreUpgrader->doUpgrade() #12 /home/yrqmdaeo/public_html/modules/autoupgrade/classes/TaskRunner/Upgrade/UpgradeDb.php(43): PrestaShop\Module\AutoUpgrade\UpgradeTools\CoreUpgrader\CoreUpgrader81->doUpgrade() #13 /home/yrqmdaeo/public_html/admin658/autoupgrade/ajax-upgradetab.php(53): PrestaShop\Module\AutoUpgrade\TaskRunner\Upgrade\UpgradeDb->run() #14 {main}

Every SQL line is green and says [OK]

After this error message, the site will load the 8.1.1 version, but i don't think that everything is ok even if it seems to work.

Thank you

Edited August 14, 2023 by AquileNere (see edit history)

[musicmaster]

Try to change the double change in /modules/autoupgrade/upgrade/sql/8.1.0.sql that causes the error. Remove the second word "change" or split it in two commands.

Prestashop doesn't allow me to include sql to show you how it is done.

 

[zod]

Probably it is fixed with this: https://github.com/PrestaShop/PrestaShop/pull/33573

But i just updated to 8.1.2 because it has the fix, and did not break going from 8.0.4 to major release 8.1.2.

[AquileNere]

I will try these update, thank you