Edit History

Hi!

I took over a 1.6.1.6 Prestashop version, with a lot of problems.
I will setup a new version soon, and correct all the problems, but for now I need to install Stripe on this one.

I have downloaded the "v2.0.0-stripe_official.zip" file and uploaded it from the admin.

But when I activated the module, this happened : 

Quote

[PrestaShopDatabaseException]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT' at line 1
 

CREATE TABLE IF NOT EXISTS `ps_stripe_payment_intent` (`id_stripe_payment_intent` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `id_payment_intent` VARCHAR(40) NOT NULL, `status` VARCHAR(30) NOT NULL, `amount` DECIMAL(10,2) NOT NULL, `currency` VARCHAR(3) NOT NULL, `date_add` DATETIME NOT NULL, `date_upd` DATETIME NOT NULL, PRIMARY KEY (`id_stripe_payment_intent`)) ENGINE=InnoDB CHARSET=utf8 COLLATE=DEFAULT;

at line 791 in file classes/db/Db.php

786. if ($webservice_call && $errno) { 787. $dbg = debug_backtrace(); 788. WebserviceRequest::getInstance()->setError(500, '

 '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97); 789. } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) { 790. if ($sql) { 791. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>'); 792. } 793. 794. throw new PrestaShopDatabaseException($this->getMsgError()); 795. } 796. }
		

		

DbCore->displayError - [line 425 - classes/db/Db.php] - [1 Arguments]

DbCore->query - [line 601 - classes/db/Db.php] - [1 Arguments]

DbCore->execute - [line 97 - modules/stripe_official/vendor/totpsclasslib/src/Db/DbTable.php] - [1 Arguments]

Stripe_officialClasslib\Db\DbTable->create - [line 100 - modules/stripe_official/vendor/totpsclasslib/src/Db/ObjectModelExtension.php]

Stripe_officialClasslib\Db\ObjectModelExtension->createTable - [line - ] - [1 Arguments]

array_map - [line 91 - modules/stripe_official/vendor/totpsclasslib/src/Db/ObjectModelExtension.php] - [2 Arguments]

Stripe_officialClasslib\Db\ObjectModelExtension->createTables - [line 64 - modules/stripe_official/vendor/totpsclasslib/src/Db/ObjectModelExtension.php] - [1 Arguments]

Stripe_officialClasslib\Db\ObjectModelExtension->install - [line 328 - modules/stripe_official/vendor/totpsclasslib/src/Install/AbstractInstaller.php]

Stripe_officialClasslib\Install\AbstractInstaller->installObjectModel - [line 44 - modules/stripe_official/upgrade/Upgrade-2.0.0.php] - [1 Arguments]

upgrade_module_2_0_0 - [line 499 - classes/module/Module.php] - [1 Arguments]

ModuleCore->runUpgradeModule - [line 1494 - controllers/admin/AdminModulesController.php]

AdminModulesControllerCore->initContent - [line 189 - classes/controller/Controller.php]

ControllerCore->run - [line 367 - classes/Dispatcher.php]

DispatcherCore->dispatch - [line 58 - admin/index.php]

 

Also, when I'm going back to the module list page, it's always the same message.
I tried to deactivate the module on the "ps_module" table, but it doesn't fix it.

Any idea ?

Thanks