Post by europes4u » Sun Aug 25, 2013 6:41 pm

I have upgraded through wordpress to oc 1.5.6...I followed all instructions...but have an error!!

Notice: Error: Table 'europ307_ezstore.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 = '62' in /home/europ307/public_html/ezstore/system/database/mysql.php on line 50


I have tried everything to fix but the message above is what I see when I try to see my store...Please help!!!
my store is www.europes4u.com/ezstore ..here you can see the error...

Newbie

Posts

Joined
Sun Aug 25, 2013 5:43 pm
Location - Ireland

Post by butte » Sun Aug 25, 2013 10:49 pm

Version upgraded from? The oc_category_path table has these fields: category_id, path_id, level . The LEFT JOIN error may indicate mistakenly shared IDs between two tables (top right, search LEFT JOIN for a quick overdose of where it can lead). You might retry, directly addressing OC in its own /install/ directory, NOT "through" WordPress. There is enough going on during the upgrade that it does not need the "help" of WordPress cms or anything else.

Guru Member

Posts

Joined
Wed Mar 20, 2013 6:58 am

Post by MarketInSG » Mon Aug 26, 2013 9:42 am

upgraded wordpress? Are you mixing things up or...?

Anyway, you are just missing a table. If you're on v1.5.5 and above, there is this new table. Run the below code to add the table

Code: Select all

DROP TABLE IF EXISTS `oc_category_path`;
CREATE TABLE `oc_category_path` (
  `category_id` int(11) NOT NULL,
  `path_id` int(11) NOT NULL,
  `level` int(11) NOT NULL,
  PRIMARY KEY (`category_id`,`path_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;


User avatar
Guru Member

Posts

Joined
Wed Nov 16, 2011 11:53 am
Location - Singapore

Post by europes4u » Mon Sep 23, 2013 6:46 pm

I'm sorry but I'm new to this!!!!!!
How and where do I run the code...
Many thanks for all who are helping...

Newbie

Posts

Joined
Sun Aug 25, 2013 5:43 pm
Location - Ireland

Post by MarketInSG » Mon Sep 23, 2013 10:06 pm

go over to phpmyadmin and select your database. Then run the sql statement. The magic will do the rest of the job


User avatar
Guru Member

Posts

Joined
Wed Nov 16, 2011 11:53 am
Location - Singapore

Post by butte » Mon Sep 23, 2013 10:27 pm

You need to remember, europes4u, when you work on OC go into OC through its own directory, and approach OC as standalone in its own directory, do NOT try to manipulate, set, upgrade, populate, fix, or otherwise fiddle with OC "through" wordpress. OC does NOT need the "help" of wordpress. If all went well, the two do NOT share the same database.

And since you have wordpress, there is a file somewhere in it named whereami.cgi that is an open door to budding hackers. Kill that file -- just kill it. Killing that file should not change anything of consequence. Anything that relies upon that file can be done without.
http://forum.opencart.com/viewtopic.php ... gi#p411726
http://forum.opencart.com/viewtopic.php ... gi#p431998
http://forum.opencart.com/viewtopic.php ... gi#p430870
http://forum.opencart.com/viewtopic.php ... gi#p417554

Guru Member

Posts

Joined
Wed Mar 20, 2013 6:58 am

Post by europes4u » Tue Sep 24, 2013 4:59 pm

FIXED... Thanks to all for the help ;D ;D ;D

Newbie

Posts

Joined
Sun Aug 25, 2013 5:43 pm
Location - Ireland

User avatar
Guru Member

Posts

Joined
Wed Nov 16, 2011 11:53 am
Location - Singapore

Post by europes4u » Thu Sep 26, 2013 6:44 pm

Hello again
I thought all was fixed BUT NO....Now when I click on and product I get This,,,,,
Notice: Error: Table 'europ307_ezstore.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` = 62 AND `status` = 1 AND `customer_group_id` = 1 ORDER BY `sort_order` ASC in /home/europ307/public_html/ezstore/system/database/mysql.php on line 50

Also the add to cart buttons don't work...
A little more help PLEASE....
Europes4u

Newbie

Posts

Joined
Sun Aug 25, 2013 5:43 pm
Location - Ireland

Post by butte » Thu Sep 26, 2013 8:46 pm

Search "Error No 1146 solved" yields "About 1,790 results (0.34 seconds)" at
https://www.google.com/search?q=Error+N ... encart.com
and from the top you will see quite a few occurrences of and solutions for No. 1146. Happy reading.

Guru Member

Posts

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

Users browsing this forum: No registered users and 7 guests