Post by m3kds » Mon Aug 19, 2013 11:57 am

Hi,
I don't understand why I have this error when I clicked the "View"my order.
The only orders that I can view without getting the error are placed when I had opencart 1.5.5.1

I recently upgraded to version 1.5.6. All orders after I upgraded to the latest oc ver. give me the following error:

Notice: Error: Table 'xxxx_opencartsewjewel.oc_paypal_order' doesn't exist
Error No: 1146
SELECT * FROM `oc_paypal_order` WHERE `order_id` = '45' LIMIT 1 in /home/xxxx/public_html/system/database/mysql.php on line 50

Please tell me how I can fix this. Thank you.

Visit http://www.sewjewel.com for sewing & crafts.


New member

Posts

Joined
Sat Apr 20, 2013 12:35 am


Post by m3kds » Mon Aug 19, 2013 1:17 pm

Just a little update.

I've disabled the paypal express and enabled paypal standard. Now, I'm able to view all of my orders. Somehow paypal express is not working properly on my site.

Visit http://www.sewjewel.com for sewing & crafts.


New member

Posts

Joined
Sat Apr 20, 2013 12:35 am


Post by MarketInSG » Mon Aug 19, 2013 5:42 pm

it's a long story on v1.5.6. You will need to create that table into your database as it's missing from the upgrade


User avatar
Guru Member

Posts

Joined
Wed Nov 16, 2011 11:53 am
Location - Singapore

Post by m3kds » Thu Aug 22, 2013 12:25 am

I like opencart. I had no prob. with 1.5.5.1. I shouldn't have rushed to upgrade to 1.5.6. None of my vqmod entensions are working (even after I've upgraded the vqmod). I was clueless. (I should've wait for the .1 version). Now I know.

I'm not familiar with the database. So, I'll just wait for the 1.5.6.1 to come out and hopefully my vqmod ext.'s will work again.

Visit http://www.sewjewel.com for sewing & crafts.


New member

Posts

Joined
Sat Apr 20, 2013 12:35 am


Post by MarketInSG » Thu Aug 22, 2013 12:52 am

you need to upgrade your vqmod, and reinstall it after you move to v1.5.6


User avatar
Guru Member

Posts

Joined
Wed Nov 16, 2011 11:53 am
Location - Singapore

Post by arizos » Thu Dec 04, 2014 7:17 am

I logged into myPhpMyAdmin and checked to see if the table didn't exist. Thankfully another installation of Opencart did have these so I exported the SQL from here, and imported it into the site with the problem and this fixed the issue.

I have attached the two tables that I had to import.

Hope this helps.

Attachments

Paypal Tables.


Newbie

Posts

Joined
Wed Nov 30, 2011 2:45 pm

Post by haxcop » Mon Jun 27, 2016 7:42 pm

Thank you guys this helps me on oc 2.1.0.2 !

New member

Posts

Joined
Tue Jan 14, 2014 9:38 pm
Location - Dublin

Post by IP_CAM » Tue Jun 28, 2016 2:42 am

I never tried that PayPal Stuff yet, in real Action, but the above linked ZIP made it easy,
to add the DB-Content, seemengly required to make this work in the first place.
Thanks for this fine Info !
Ernie

My Github OC Site: https://github.com/IP-CAM
5'600 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland
Who is online

Users browsing this forum: No registered users and 2 guests