matthewboehm Posted October 19, 2016 Share Posted October 19, 2016 Hi, I just upgraded Prestashop from 1.4.7 to 1.6.1.7 that also upgraded my paypal module to 3.11.1 When I go into Backoffice and try to view orders to get an error Table 'bokbok_vmtest.ps_paypal_braintree' doesn't exist SELECT `transaction`FROM `ps_paypal_braintree`WHERE `id_order` = 1895 LIMIT 1 Does this mean the paypal module upgrade didn't upgrade the database properly? How can I fix it without affecting my old orders? The front office side of things works ok, I can make and pay for orders with paypal in my test system. Link to comment Share on other sites More sharing options...
bellini13 Posted October 19, 2016 Share Posted October 19, 2016 Yes, it means the module did not properly upgrade itself. You can either reset (uninstall/install) the module again. Or you can manually create the missing database tables using phpmyadmin CREATE TABLE IF NOT EXISTS `ps_paypal_braintree` ( `id_paypal_braintree` int(11) NOT NULL AUTO_INCREMENT, `id_cart` int(11) NOT NULL, `nonce_payment_token` varchar(255) NOT NULL, `client_token` text NOT NULL, `transaction` varchar(255) NULL, `datas` varchar(255) NULL, `id_order` int(11) NULL, PRIMARY KEY (`id_paypal_braintree`) ) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 CREATE TABLE IF NOT EXISTS `ps_paypal_plus_pui` ( `id_paypal_plus_pui` int(11) NOT NULL AUTO_INCREMENT, `id_order` int(11) NOT NULL, `pui_informations` text NOT NULL, PRIMARY KEY (`id_paypal_plus_pui`) ) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 You should also confirm that these 2 hooks/positions are registered for the paypal module actionOrderStatusPostUpdate displayOrderConfirmation Link to comment Share on other sites More sharing options...
matthewboehm Posted October 19, 2016 Author Share Posted October 19, 2016 Yes, it means the module did not properly upgrade itself. You can either reset (uninstall/install) the module again. Or you can manually create the missing database tables using phpmyadmin Awesome, thanks for the response. what would I lose if I uninstalled and reinstalled? are the paypal tables deleted then recreated? is there anything stored in the paypal tables that I would lose from my older orders? Link to comment Share on other sites More sharing options...
bellini13 Posted October 21, 2016 Share Posted October 21, 2016 The module does not delete its custom database tables or records, it only deletes its configuration information. When you re-install the module, it will try to re-create any database tables that do not already exist. However if those tables already exist, but changes have been made to the tables (like adding a new column), then you might not have those changes. So you might want to review your existing tables and compare them to the definition found in paypal_install.php. 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