Paypal Error Viewing Orders in Backoffice ps_paypal_braintree doesn't exist

[matthewboehm]

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.

[bellini13]

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

[matthewboehm]

 

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?

[bellini13]

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.