This topic has 2 voices, contains 8 replies, and was last updated by  kwaek 3950 days ago.

Search Error

Tagged: 

ThemeBurn Support › Forums › OpenCart Themes › Shoppica 2 OpenCart Theme › Search Error

This topic has been marked as not resolved.

Opencart version: 1.5.5.1
Shoppica 2 version: 2.2.2

I have recently noticed a problem with the search function, resulting in the following error:

Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘LEFT JOIN product_field pf ON (p.product_id = pf.product_id) FROM product p LEFT’ at line 1
Error No: 1064
SELECT COUNT(DISTINCT p.product_id) AS total LEFT JOIN product_field pf ON (p.product_id = pf.product_id) 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 ( pd.name LIKE '%bmw%'OR LCASE(pf.text) LIKE '%bmw%' AND pf.language_id = '1' OR pd.tag LIKE '%bmw%' OR LCASE(p.model) = 'bmw' OR LCASE(p.sku) = 'bmw' OR LCASE(p.upc) = 'bmw' OR LCASE(p.ean) = 'bmw' OR LCASE(p.jan) = 'bmw' OR LCASE(p.isbn) = 'bmw' OR LCASE(p.mpn) = 'bmw') in /var/www/vhosts/website.co.uk/httpdocs/system/database/mysql.php on line 50

Please can you help?
 kwaek
May 25, 2013 at 6:12 pm #23586

Could you please activate the default theme and try the search again. Does it work, or it throws the same error ?

Regards ,
ThemeBurn team
 TB Support
May 27, 2013 at 4:47 pm #23682

Hi,
Having tried the default theme, it doesn’t throw an error and works just fine.

I seem to remember having an issue after upgrading to latest version of Shoppica 2; more specifically after replacing either ‘controller.php’ or ‘extension.php’ the problem occurred.

It’s strange, because I have another site with the same setup running just fine. Is there anything you could suggest?

Best Regards,
 kwaek
May 29, 2013 at 1:55 pm #23749

Can you give us a link to your site ?
 TB Support
May 31, 2013 at 5:25 pm #23855

Of course, the site is: http://www.dgdiecast.co.uk
 kwaek
May 31, 2013 at 9:15 pm #23897

We need to investigate this issue further as we are not 100% sure where the problem is and if it is connected to Shoppica or not. Could you provide admin and ftp access ?
You can use hidepost to share private information with the support staff.

Best,
ThemeBurn team
 TB Support
June 3, 2013 at 12:32 pm #23975
 kwaek
June 3, 2013 at 12:56 pm #23978

Your search issue is caused by one of the vqmod extensions you have installed. Try to disable them one by one (just delete the extension’s xml file) to see which one is problematic. Don’t forget to delete all of the files in vqcache folder, after disabling the extension.

Regards,
ThemeBurn team
 TB Support
June 7, 2013 at 12:46 pm #24121

Thanks very much, it turns out it was caused by a plugin – “Custom Fields 1.5.x v3.0.4 [vQmod]”
I’m still waiting for a fix unfortunately, appreciate you looking into this one for me though.
 kwaek
July 10, 2013 at 8:49 pm #25373
Viewing 9 posts - 1 through 9 (of 9 total)
  • You must be logged in to reply to this topic.