Product search does not work

ThemeBurn SupportForumsOpenCart ThemesShoppica 2 OpenCart ThemeProduct search does not work

This topic has been marked as not resolved.

If i use product search does not work I get this:

Notice: Error: Table ‘db17083_Dinshop.product_tag’ doesn’t exist
Error No: 1146
SELECT COUNT(DISTINCT p.product_id) AS total FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN product_tag pt ON (p.product_id = pt.product_id) WHERE pd.language_id = ’2′ AND p.status = ’1′ AND p.date_available <= NOW() AND p2s.store_id = ’0′ AND ( LCASE(pd.name) LIKE ‘%aan%’ OR LCASE(pd.name) LIKE ‘%de%’ OR LCASE(pt.tag) LIKE ‘%aan%’ AND pt.language_id = ’2′ OR LCASE(pt.tag) LIKE ‘%de%’ AND pt.language_id = ’2′) in /var/www/vhosts/6/114847/webspace/httpdocs/system/database/mysql.php on line 49

http://www.dinshop.nl/index.php?route=product/search&filter_name=aan%20de

 Ousama
January 5, 2013 at 9:49 pm #16749

It seems this issue is not related to Shoppica. It will arise with the default theme also and is caused by improper opencart installation or ugprade. Please, make sure you installed/upgraded opencart correctly and the search works with the default theme. Then change to Shoppica and see if everything is alright.

Regards,
ThemeBurn team

January 8, 2013 at 1:15 pm #16902
Viewing 2 posts - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.