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...
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...
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.
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
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;
go over to phpmyadmin and select your database. Then run the sql statement. The magic will do the rest of the job
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
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
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
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
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.
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.
Who is online
Users browsing this forum: No registered users and 7 guests