What can be this problem, how te resolve?

Query:

SELECT COUNT(*) FROM `bx_store_products`  left JOIN `Profiles` ON `Profiles`.`ID`=`bx_store_products`.`author_id` WHERE (`bx_store_products`.`tags` LIKE '%dxn%' OR `bx_store_products`.`tags` LIKE '%coffee%' OR `bx_store_products`.`tags` LIKE '%tea%' OR `bx_store_products`.`tags` LIKE '%alo%') AND `bx_store_products`.`id` != AND `bx_store_products`.`status` ='approved' 

Mysql 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 'AND `bx_store_products`.`status` ='approved'' at line 1

Found error in the file '/home/busimatc/public_html/inc/classes/BxDolSearch.php' at line 506.
Called 'db_value' function with erroneous argument #0.

http://www.busimatch.club ( The most exclusive business club)
Quote · 15 Jun 2015

It looks like it isn't native Dolphin code. 

It maybe that it is some 3rd-party module which displays related products in Store module.

I would suggest to try to uninstall 3rd-party module which do something similar or try to contact the module author.

Rules → http://www.boonex.com/terms
Quote · 23 Jun 2015

If you do uninstall the module, realise it will wipe the store products.

Geeks, making the world a better place
Quote · 23 Jun 2015

I had resolved the issue for him, he most likely forgot to return to this forum and indicate that it was resolved.

Paypal email is jeromemingo@gmail.com - http://www.boonex.com/market/posts/modzzz
Quote · 23 Jun 2015
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.