Andrea D. Posted May 8, 2022 Share Posted May 8, 2022 Hello, for some reason after the update I am facing this database issue. How can i solve it? Link to comment Share on other sites More sharing options...
Kian Posted May 8, 2022 Share Posted May 8, 2022 Download the latest version released few minutes ago or run the following queries: DROP TABLE IF EXISTS `bx_paypalsubscriptions`; CREATE TABLE `bx_paypalsubscriptions` ( `subscription_id` varchar(255) NOT NULL, `data` text DEFAULT NULL, `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8; ALTER TABLE `bx_paypalsubscriptions` ADD PRIMARY KEY (`subscription_id`) USING BTREE; Link to comment Share on other sites More sharing options...
Andrea D. Posted May 8, 2022 Author Share Posted May 8, 2022 7 minutes ago, Kian said: Download the latest version released few minutes ago or run the following queries: DROP TABLE IF EXISTS `bx_paypalsubscriptions`; CREATE TABLE `bx_paypalsubscriptions` ( `subscription_id` varchar(255) NOT NULL, `data` text DEFAULT NULL, `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8; ALTER TABLE `bx_paypalsubscriptions` ADD PRIMARY KEY (`subscription_id`) USING BTREE; Thank you Kian. Link to comment Share on other sites More sharing options...
Recommended Posts