OpenCart Community

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

I'm also getting the same error.

Hi,

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

Thanks

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.

Same here, can someone help us?

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!

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

DL

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.