OpenCart Community

I got a blank page after upgrading, so I restored previous version. At first, the site would open, but with an error message atop, using my work computer. Now on my home computer, all I get is:

Notice: Error: Table 'pnc_f5acikgngg.oc_category_path' doesn't exist
Error No: 1146
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '17' in /hermes/bosoraweb023/b2154/ipg.dcradleunderwearcom/system/database/mysql.php on line 50

Please help!

Does anyone have any insight on this? I am having the same problem after "upgrading".

Edit: After doing some research on these forums, the solution is that the install isn't complete. You have to access the /install directory and complete the steps there to alter the database. However, when I try to complete the install, instead I get this error:
Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AFTER `price`' at line 1
Error No: 1064
ALTER TABLE `oc_profile` CHANGE `frequency` `frequency` ENUM AFTER `price` in /home/themmber/public_html/ocart/system/database/mysql.php on line 50

Heres my error:

Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AFTER `price`' at line 1
Error No: 1064
ALTER TABLE `oc_profile` CHANGE `frequency` `frequency` ENUM AFTER `price` in /home/USERNAME/public_html/MYSITE.co.za/system/database/mysql.php on line 50

seems i've got into the same Dilemma

Well. This is quite obnoxious. I wish I knew more about MySQL to really figure out what the issue is. All I know is I can't complete the install and right now I can't even access the shop.

One thread offers a practical solution:
http://forum.opencart.com/viewtopic.php?f=19&t=106677

to this problem:
Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AFTER `price`' at line 1
Error No: 1064
ALTER TABLE `oc_profile` CHANGE `frequency` `frequency` ENUM AFTER `price` in

Plural threads and isolated posts accordingly bear cross-linkage, at least for the sake of noting its prevalence:
http://forum.opencart.com/viewtopic.php ... 21#p424887 (with a user's editorial comment below it)
http://forum.opencart.com/viewtopic.php?f=20&t=106706 (with perspectives)
http://forum.opencart.com/viewtopic.php?f=20&t=106973

Instances are beginning to proliferate a little bit, perhaps according to whether people search carefully first (or don't search). The problem is known, it will undoubtedly be remedied in 1.5.6.1 in due course.