Viewing order error

Hi guys,

After doing a sandbox test on my site with an order, I discovered that at the top of the screen when I view my order under the Orders section, an error comes up related to my database. This is what came up on screen:


Also, it seemed to occur when my stock level was -1. I since updated the stock level under the product section and it still showed the same problem.

I have added (and used) only PayPal Express as the payment method, but not added normal PayPal. Could this be an issue?

Middleman wrote:Hi guys,

After doing a sandbox test on my site with an order, I discovered that at the top of the screen when I view my order under the Orders section, an error comes up related to my database. This is what came up on screen:

Code: Select all

Notice: Error: Table 'db1023109_opencart.paypal_order' doesn't exist
Error No: 1146
SELECT * FROM `paypal_order` WHERE `order_id` = '3' LIMIT 1 in /var/www/vhosts/12/107431/webspace/httpdocs/mysite.com/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /var/www/vhosts/12/107431/webspace/httpdocs/mysite.com/admin/model/payment/pp_express.php on line 72

Also, it seemed to occur when my stock level was -1. I since updated the stock level under the product section and it still showed the same problem.

I have added (and used) only PayPal Express as the payment method, but not added normal PayPal. Could this be an issue?

Is it installed admin > Extension > Payments > PayPal Express Checkout?

Is it installed admin > Extension > Payments > PayPal Express Checkout?

Yes. Still under sandbox mode, with only the sandbox APIs filled. The main APIs are blank at the moment.
Could that be an issue?

Middleman wrote:

Is it installed admin > Extension > Payments > PayPal Express Checkout?

Yes. Still under sandbox mode, with only the sandbox APIs filled. The main APIs are blank at the moment.
Could that be an issue?

As you can see from that error, table `paypal_order` missing. This table to create, than press `Install` in line "PayPal Express Checkout". You try uninstall and install again.

Thanks PM-Netti, that worked!