Error No: 1146
Posted: Tue Feb 19, 2013 11:53 pm
Hi guys, I have just updated my OC from Version 1.5.4 to 1.5.5.1. all is working great but the Products. When I try and click edit on any of them I get this error message....
Notice: Error: Table 'MY SITE ADDRESS.com.category_path' doesn't exist
Error No: 1146
SELECT DISTINCT *, (SELECT GROUP_CONCAT(cd1.name ORDER BY level SEPARATOR ' > ') FROM category_path cp LEFT JOIN category_description cd1 ON (cp.path_id = cd1.category_id AND cp.category_id != cp.path_id) WHERE cp.category_id = c.category_id AND cd1.language_id = '1' GROUP BY cp.category_id) AS path, (SELECT keyword FROM url_alias WHERE query = 'category_id=20') AS keyword FROM category c LEFT JOIN category_description cd2 ON (c.category_id = cd2.category_id) WHERE c.category_id = '20' AND cd2.language_id = '1' in E:\Domains\'MY SITE ADDRESS.com\wwwroot\system\database\mysql.php on line 50
I have done a Google search for Error No: 1146 but did not find any fix.
Does anyone know how to fix this?
Any help would be greatly appreciated
James.
Notice: Error: Table 'MY SITE ADDRESS.com.category_path' doesn't exist
Error No: 1146
SELECT DISTINCT *, (SELECT GROUP_CONCAT(cd1.name ORDER BY level SEPARATOR ' > ') FROM category_path cp LEFT JOIN category_description cd1 ON (cp.path_id = cd1.category_id AND cp.category_id != cp.path_id) WHERE cp.category_id = c.category_id AND cd1.language_id = '1' GROUP BY cp.category_id) AS path, (SELECT keyword FROM url_alias WHERE query = 'category_id=20') AS keyword FROM category c LEFT JOIN category_description cd2 ON (c.category_id = cd2.category_id) WHERE c.category_id = '20' AND cd2.language_id = '1' in E:\Domains\'MY SITE ADDRESS.com\wwwroot\system\database\mysql.php on line 50
I have done a Google search for Error No: 1146 but did not find any fix.
Does anyone know how to fix this?
Any help would be greatly appreciated
James.