Post by martharrazi » Thu Apr 18, 2013 1:06 pm

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!

Newbie

Posts

Joined
Thu Apr 18, 2013 12:59 pm

Post by the9mm » Sun Jul 28, 2013 10:29 pm

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

Newbie

Posts

Joined
Sun Jul 28, 2013 10:28 pm

Post by linuxos » Wed Jul 31, 2013 5:30 pm

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 :o

Newbie

Posts

Joined
Wed Jul 31, 2013 5:27 pm

Post by the9mm » Wed Jul 31, 2013 9:53 pm

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.

Newbie

Posts

Joined
Sun Jul 28, 2013 10:28 pm

Post by butte » Thu Sep 05, 2013 6:22 am

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.

Guru Member

Posts

Joined
Wed Mar 20, 2013 6:58 am
Who is online

Users browsing this forum: No registered users and 9 guests