Page 1 of 1

Error No: 1146

Posted: Tue Feb 19, 2013 11:53 pm
by jim1984
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.

Re: Error No: 1146

Posted: Fri Feb 22, 2013 12:19 am
by ravidevt
Hi,

I have purchased and istalled a module called Sales Promotion. after that I am getting this error and can't able to open my site http://excellentmart.in/shop

I am getting these 2 error.

Errro no 1: while opening the site
Notice: Error: Table 'ecpoint_ei10.ocart_sales_promotion' doesn't exist
Error No: 1146
SELECT * FROM ocart_sales_promotion c WHERE ((c.date_start = '0000-00-00' OR c.date_start < NOW()) AND (c.date_end = '0000-00-00' OR c.date_end > NOW())) AND c.status = '1' in /home/www/excellentmart.in/shop/system/database/mysql.php on line 49


Error no 2: from admin screen
Permission Denied!You do not have permission to access this page, please refer to your system administrator.

Does anyone know how to fix this?