dwilden Posted December 21, 2022 Share Posted December 21, 2022 (edited) Hi, I try to install new version 1.7.8.8 on a clean server but the installation stops creating the tables with this error "An exception occured while establishing a connection to figure out your platform version" I using PHP 7.2.34, MySQL 5.7.40, InnoDB and DbPDO driver (Upgrading from a working 1.7.8.7 to 1.7.8.8 same error) Can somebody help me? Edited March 10, 2023 by dwilden (see edit history) Link to comment Share on other sites More sharing options...
juanrojas Posted December 21, 2022 Share Posted December 21, 2022 Hi, I'm not sure but try it with PHP 7.4 Link to comment Share on other sites More sharing options...
Sanyesz Posted December 22, 2022 Share Posted December 22, 2022 Hi, same error! PHP 7.4 does not help! Is there any solution? Link to comment Share on other sites More sharing options...
Marquys Posted January 7, 2023 Share Posted January 7, 2023 Same problem, did you find a solution ? Link to comment Share on other sites More sharing options...
Nickz Posted January 7, 2023 Share Posted January 7, 2023 9 minutes ago, Marquys said: Same problem, did you find a solution ? Do you use the same versions? If not dot them down. Did you guys went thru some updates prior to the intent of going even higher? Link to comment Share on other sites More sharing options...
Marquys Posted January 7, 2023 Share Posted January 7, 2023 PHP 7.4.33 MySQL : 10.5.17-MariaDB-1:10.5.17+maria~deb11-log Moteur MySQL : InnoDB Connecteur MySQL : DbPDO I have error during upgrade 1.7.7.6 --> 1.7.7.8 with 1 click upgrade Link to comment Share on other sites More sharing options...
Nickz Posted January 7, 2023 Share Posted January 7, 2023 19 minutes ago, Marquys said: I have error during upgrade 1.7.7.6 --> 1.7.7.8 with 1 click upgrade OK the very same Error? Link to comment Share on other sites More sharing options...
Marquys Posted January 7, 2023 Share Posted January 7, 2023 14:28:35 ERROR [console] Error thrown while running command "prestashop:schema:update-without-foreign --env=prod". Message: "An exception occurred while executing 'ALTER TABLE ps_axepta_order_reference CHANGE id_cart id_cart INT UNSIGNED AUTO_INCREMENT NOT NULL': SQLSTATE[23000]: Integrity constraint violation: 1062 ALTER TABLE causes auto_increment resequencing, resulting in duplicate entry '1' for key 'PRIMARY'" ["exception" => Doctrine\DBAL\Exception\UniqueConstraintViolationException { …},"command" => "prestashop:schema:update-without-foreign --env=prod","message" => """ An exception occurred while executing 'ALTER TABLE ps_axepta_order_reference CHANGE id_cart id_cart INT UNSIGNED AUTO_INCREMENT NOT NULL':\n \n SQLSTATE[23000]: Integrity constraint violation: 1062 ALTER TABLE causes auto_increment resequencing, resulting in duplicate entry '1' for key 'PRIMARY' """] In AbstractMySQLDriver.php line 55: An exception occurred while executing 'ALTER TABLE ps_axepta_order_referenc e CHANGE id_cart id_cart INT UNSIGNED AUTO_INCREMENT NOT NULL': SQLSTATE[23000]: Integrity constraint violation: 1062 ALTER TABLE causes au to_increment resequencing, resulting in duplicate entry '1' for key 'PRIMAR Y' In PDOConnection.php line 90: SQLSTATE[23000]: Integrity constraint violation: 1062 ALTER TABLE causes au to_increment resequencing, resulting in duplicate entry '1' for key 'PRIMARY' In PDOConnection.php line 88: SQLSTATE[23000]: Integrity constraint violation: 1062 ALTER TABLE causes au to_increment resequencing, resulting in duplicate entry '1' for key 'PRIMAR Y' 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]] [--] Error during database upgrade. You may need to restore your database. Error upgrading Doctrine schema Link to comment Share on other sites More sharing options...
Nickz Posted January 7, 2023 Share Posted January 7, 2023 Do you have a module called axepta? Disable it. Link to comment Share on other sites More sharing options...
Marquys Posted January 7, 2023 Share Posted January 7, 2023 Yes but it's my PSP module, I need it... Link to comment Share on other sites More sharing options...
Nickz Posted January 7, 2023 Share Posted January 7, 2023 26 minutes ago, Marquys said: Yes but it's my PSP module, I need it... well if the module interrupts your installation/ update? Check if the module is capable of working with the Pstashop version you woant to update to. Link to comment Share on other sites More sharing options...
Marquys Posted January 7, 2023 Share Posted January 7, 2023 On the editor website it's write 1.7.8 but not 1.7.8.8. I have contacted their support, I'm waiting... Link to comment Share on other sites More sharing options...
Nickz Posted January 7, 2023 Share Posted January 7, 2023 2 minutes ago, Marquys said: On the editor website it's write 1.7.8 but not 1.7.8.8. I have contacted their support, I'm waiting... There is also Thirtybees, a prestashop fork. Install that locally and test it there. Link to comment Share on other sites More sharing options...
dwilden Posted January 9, 2023 Author Share Posted January 9, 2023 On 1/7/2023 at 2:49 PM, Marquys said: Same problem, did you find a solution ? No, I don't have solution 😞 Link to comment Share on other sites More sharing options...
metlive Posted January 12, 2023 Share Posted January 12, 2023 I was updating from 1.7.8.5 to 1.7.8.8 and I got this error. Can you tell me what it is? The e-shop works correctly, the orders work. I have PHP 7.4 and MariaDB 10.5 Thank you Link to comment Share on other sites More sharing options...
dwilden Posted February 15, 2023 Author Share Posted February 15, 2023 (edited) I have solved the problem to install a clean prestashop and for upgrade to the latest 1.7.8.8 MySQL don't support the MYSQL_ATTR_MULTI_STATEMENTS And I have commented the next lines from the follow files : \classes\db\DbPDO.php line 92 //PDO::MYSQL_ATTR_MULTI_STATEMENTS => _PS_ALLOW_MULTI_STATEMENTS_QUERIES_, \app\config\doctrine.yml line 22 # 1013: '%env(const:runtime:_PS_ALLOW_MULTI_STATEMENTS_QUERIES_)%' After the installation or the upgrade, you can back to the original lines. Any information about this is wellcome Edited February 15, 2023 by dwilden (see edit history) 2 1 Link to comment Share on other sites More sharing options...
oserrano Posted February 27, 2023 Share Posted February 27, 2023 Thanks a lot for sharing this fix... This works well on mi side. The older version 1.7.8.7 did not have this problem. Link to comment Share on other sites More sharing options...
oserrano Posted March 9, 2023 Share Posted March 9, 2023 On 2/14/2023 at 7:37 PM, dwilden said: I have solved the problem to install a clean prestashop and for upgrade to the latest 1.7.8.8 MySQL don't support the MYSQL_ATTR_MULTI_STATEMENTS And I have commented the next lines from the follow files : \classes\db\DbPDO.php line 92 //PDO::MYSQL_ATTR_MULTI_STATEMENTS => _PS_ALLOW_MULTI_STATEMENTS_QUERIES_, \app\config\doctrine.yml line 22 # 1013: '%env(const:runtime:_PS_ALLOW_MULTI_STATEMENTS_QUERIES_)%' After the installation or the upgrade, you can back to the original lines. Any information about this is wellcome Thanks a lot for sharing this fix... This works well on mi side. The older version 1.7.8.7 did not have this problem. Link to comment Share on other sites More sharing options...
PPSA Posted September 5, 2023 Share Posted September 5, 2023 (edited) On 2/15/2023 at 2:37 AM, dwilden said: I have solved the problem to install a clean prestashop and for upgrade to the latest 1.7.8.8 MySQL don't support the MYSQL_ATTR_MULTI_STATEMENTS And I have commented the next lines from the follow files : \classes\db\DbPDO.php line 92 //PDO::MYSQL_ATTR_MULTI_STATEMENTS => _PS_ALLOW_MULTI_STATEMENTS_QUERIES_, \app\config\doctrine.yml line 22 # 1013: '%env(const:runtime:_PS_ALLOW_MULTI_STATEMENTS_QUERIES_)%' After the installation or the upgrade, you can back to the original lines. Any information about this is wellcome Thank you, this solved my problem as well while installing 1.7.8.9 Edited September 5, 2023 by PPSA (see edit history) Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now