Error during installation using Percona 5.7

[SilvaRafael]

Hello,

We are setting up a high availability environment with Prestashop version 8.1.3, however, when performing ht e installaction via CLI, an error is always presented when using Percona 5.7 as a cluster.

[console] Error thrown while running command "prestashop:schema:update-without-foreign --env=prod". Message: "There is no active transaction" ["exception" => PDOException { …},"command" => "prestashop:schema:update-without-foreign --env=prod","message" => "There is no active transaction"]

*ERROR*         v8.1.3  2024/02/19 - 14:50:36: In Connection.php line 1854:
*ERROR*         v8.1.3  2024/02/19 - 14:50:36:                                   
*ERROR*         v8.1.3  2024/02/19 - 14:50:36:   There is no active transaction  
*ERROR*         v8.1.3  2024/02/19 - 14:50:36:                                   
*ERROR*         v8.1.3  2024/02/19 - 14:50:36: 
*ERROR*         v8.1.3  2024/02/19 - 14:50:36: 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*         v8.1.3  2024/02/19 - 14:50:36: 
*ERROR*         v8.1.3  2024/02/19 - 14:50:36: 

Is Prestashop compatible with Percona in a cluster?

I am attaching a txt file with the Percona variables.

Thanks.

vars.txt

[musicmaster]

I don't know about this CLI installation stuff.

However, you don't need to run the installation under Pecona. You can just install the shop on your local pc and then transfer the database and files to the server. You could also install it on directly on the server using Mysql and then ex/import the database towards Pecona.

Note also that other people reported the same error with MariaDb. So it is unlikely to be a Pecona problem.