This topic has 2 voices, contains 4 replies, and was last updated by  TB Support 3975 days ago.

search problem After recent update installed

Tagged: 

ThemeBurn Support › Forums › OpenCart Themes › Shoppica 2 OpenCart Theme › search problem After recent update installed

This topic has been marked as not resolved.

Installed the latest package today and have a search error.

Search Criteria
Notice: Undefined variable: category_id in /home/content/62/8659562/html/catalog/view/theme/shoppica2/template/product/search.tpl on line 45 Notice: Undefined variable: category_id in /home/content/62/8659562/html/catalog/view/theme/shoppica2/template/product/search.tpl on line 45 Notice: Undefined variable: category_id in /home/content/62/8659562/html/catalog/view/theme/shoppica2/template/product/search.tpl on line 51 Notice: Undefined variable: category_id in /home/content/62/8659562/html/catalog/view/theme/shoppica2/template/product/search.tpl on line 51

Notice: Undefined variable: sub_category in /home/content/62/8659562/html/catalog/view/theme/shoppica2/template/product/search.tpl on line 72 /> Search in subcategories Notice: Undefined variable: description in /home/content/62/8659562/html/catalog/view/theme/shoppica2/template/product/search.tpl on line 74 /> Search in product descriptions
 ebeing
June 19, 2013 at 3:27 pm #24571

Can you enable the default theme and try the search again ? Please, tell us if works without issues with the default theme activated.

Also, can you post the opencart version you are currently using ?

Regards,
ThemeBurn team
 TB Support
June 19, 2013 at 3:37 pm #24572

1.5.4

default theme search also busted.
 ebeing
June 19, 2013 at 4:05 pm #24575

Here is a new error I have after install the core files for OC 1.5.4 and the latest Shoppica release for same:

Notice: Error: Can’t find FULLTEXT index matching the column list
Error No: 1191
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) WHERE pd.language_id = ’1′ AND p.status = ’1′ AND p.date_available <= NOW() AND p2s.store_id = '0' AND (LCASE(pd.name) LIKE '%jetlev%' OR MATCH(pd.tag) AGAINST('jetlev')) OR LCASE(p.model) = 'jetlev' OR LCASE(p.sku) = 'jetlev' OR LCASE(p.upc) = 'jetlev' OR LCASE(p.ean) = 'jetlev' OR LCASE(p.jan) = 'jetlev' OR LCASE(p.isbn) = 'jetlev' OR LCASE(p.mpn) = 'jetlev' in /home/content/62/8659562/html/system/database/mysql.php on line 49
 ebeing
June 19, 2013 at 4:18 pm #24576

This problem is not related to Shoppica, but it’s rather issue with your opencart installation or the server settings. Please, make sure everythig works with the default theme without errors and then enable Shoppica.

Regards,
ThemeBurn team
 TB Support
June 19, 2013 at 4:34 pm #24578
Viewing 5 posts - 1 through 5 (of 5 total)
  • You must be logged in to reply to this topic.