Post by jim1984 » 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.

Newbie

Posts

Joined
Sun Mar 25, 2012 5:52 am

Post by ravidevt » Fri Feb 22, 2013 12:19 am

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?

Newbie

Posts

Joined
Sat Feb 16, 2013 2:18 am
Who is online

Users browsing this forum: No registered users and 9 guests