Jump to content

Paypal Error Viewing Orders in Backoffice ps_paypal_braintree doesn't exist


matthewboehm

Recommended Posts

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

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

 

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

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...