Post by faceplantproductions » Thu Jan 24, 2013 3:49 am

the error received is below, any help would be much appreciated. I do have a site and dbase backup if needed,

Notice: Error: Table 'baits_dbase.category_path' doesn't exist
Error No: 1146
SELECT COUNT(DISTINCT p.product_id) AS total FROM category_path cp LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN 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 = '182' in /home/baits/public_html/system/database/mysql.php on line 50


Posts

Joined
Fri May 13, 2011 2:54 am

Post by prkayy » Thu Jan 24, 2013 8:02 pm

I'm also getting the same error.

Newbie

Posts

Joined
Thu Jan 24, 2013 8:01 pm

Post by flaming » Sat Feb 02, 2013 5:22 am

Hi,

Did anyone get a resolution on this? I am also getting this error.

Thanks

Newbie

Posts

Joined
Sat Feb 18, 2012 3:14 am

Post by opencartchina » Sat Feb 02, 2013 4:25 pm

I think you got the errors when you visit your website before you run http://www.yourwebsite.com/install.

Pleas run the upgrade scripts and you will get success message.

I just run two times and got no errors.

OpenCart中国(http://www.opencartchina.com)
OpenCart中文论坛:http://www.opencartchina.com/bbs
Email: opencartchina@qq.com
QQ: 1487063622
OpenCart技术交流QQ 1群:282797742
OpenCart技术交流QQ 2群:298317506
OpenCart技术交流QQ 3群:198384554
OpenCart技术交流QQ 4群:227297836
中国版MyCnCart官方QQ群:473071696


New member

Posts

Joined
Thu Jan 31, 2013 10:38 am

Post by aquilla » Thu Jul 25, 2013 10:47 pm

Same here, can someone help us?

Newbie

Posts

Joined
Thu Apr 26, 2012 3:31 pm

Post by WillBest » Fri Jul 26, 2013 12:33 am

aquilla wrote:Same here, can someone help us?

I'd suggest you to try upgrade via migration service called cart2cart.
As for me, it's the easiest way. I upgraded my store and was happy, cause It's really quick and quite cheap.
Install a new version of OpenCart and then transfer data with cart2cart.
Of course, you'll need to customize your design after migration, but it's not difficult at all.

Hope it'll help you!

Good luck!

Newbie

Posts

Joined
Tue Aug 21, 2012 10:06 pm

Post by cwswebdesign » Sun Jul 28, 2013 7:47 am

Looks to me like you just need to go into php myadmin and add the table and then run the upgrade script again.

DL

This account is inactive. Look for us under the name 'EvolveWebHosting' and contact us under that username.

Thanks!


User avatar
Active Member

Posts

Joined
Sun Dec 11, 2011 12:26 am
Location - USA

Post by IanF1 » Tue Jul 30, 2013 5:11 pm

I was getting this error also. Looking at many options to resolve this.

Simple don't upload the config-dist.php

in either the basic or admin directories.

.. Simply solved.

Thanks everyone,
IanF1
Refer to http://www.OzSuper.com


User avatar
Newbie

Posts

Joined
Fri Apr 20, 2012 11:06 am
Location - Sydney, Australia
Who is online

Users browsing this forum: No registered users and 115 guests