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
|
|
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
|
|