Post by azoresstore » Wed Oct 02, 2013 7:34 pm

I upgraded my OpenCart from 1.5.5.1 to 1.5.6 through Softaculous. While doing backup it told me "Oops... connection lost" but still the store seems to be upgraded.

Only problem I've ran into is when trying to go to a product page, it gives me following error:

Code: Select all

Notice: Error: Table 'heinveh_sw672.oc_product_profile' doesn't exist
Error No: 1146
SELECT `pd`.* FROM `oc_product_profile` `pp` JOIN `oc_profile_description` `pd` ON `pd`.`language_id` = 1 AND `pd`.`profile_id` = `pp`.`profile_id` JOIN `oc_profile` `p` ON `p`.`profile_id` = `pd`.`profile_id` WHERE `product_id` = 56 AND `status` = 1 AND `customer_group_id` = 2 ORDER BY `sort_order` ASC in /home/heinveh/public_html/system/database/mysql.php on line 50
I'm assuming this oc_product_profile table should have been created during upgrade but it wasn't. What should I do?

I do have the files from 1.5.5.1 still on my PC stored before I did the upgrade so if I just downgrade back to 1.5.5.1 should it work?

Then I could try the upgrade through FTP. I should have known that it's not good idea to upgrade through Softaculous...

New member

Posts

Joined
Fri Apr 26, 2013 4:43 pm

Post by azoresstore » Wed Oct 02, 2013 8:22 pm

Solved the problem!

I installed a fresh install of 1.5.6 into a different directory and different MySQL database. I then copied the tables from there to my own website. There was a total of 4 tables I had to copy.

Everything seems to be working fine now :)

New member

Posts

Joined
Fri Apr 26, 2013 4:43 pm

Post by SteampunkMuseum » Sun Oct 06, 2013 1:21 pm

I had this same issue after upgrading to 1.5.6 -
My store existing and the home page displayed (although needed cleanup work)(had to reinstall vqmod)
the categories showed the list or grid of products
but clicking on a product would not display it. Just a white page displayed.

I checked the /system error log and found this error
2013-10-06 4:43:22 - PHP Notice: Error: Table 'cremst_ocart23.oc_product_profile' doesn't exist<br />Error No: 1146<br />SELECT `pd`.* FROM `oc_product_profile` `pp` JOIN `oc_profile_description` `pd` ON `pd`.`language_id` = 1 AND `pd`.`profile_id` = `pp`.`profile_id` JOIN `oc_profile` `p` ON `p`.`profile_id` = `pd`.`profile_id` WHERE `product_id` = 62 AND `status` = 1 AND `customer_group_id` = 1 ORDER BY `sort_order` ASC in /home/cremst/public_html/giftshop/system/database/mysql.php on line 50

Following the notes above, I installed a new instance of opencart into a new directory
Then using the phpMyAdmin tool, copied the STRUCTURE ONLY for the following tables from the new instance to the original instance
oc_product_profile
oc_profile
oc_profile_description

I went back to my storefront webpage, refreshed it, clicked through the category to a product and then the product page displayed.

I'll see if any other errors come up, and then I'll delete that new instance of opencart.


Posts

Joined
Mon Apr 29, 2013 1:20 am

Post by afeefksd » Tue May 20, 2014 9:10 pm

After uploading the files please goto WWW.{yourdomain}/install
Then follow the steps provided on that page.

Newbie

Posts

Joined
Tue May 20, 2014 9:05 pm
Who is online

Users browsing this forum: Majestic-12 [Bot] and 132 guests