Magento Forum

catalog search in “like” only mode error
 
andreladocruz
Guru
 
Total Posts:  322
Joined:  2008-05-07
Brazil
 

when configuring the catalog search mode to “like” only option I receive the following error:

SQLSTATE[42000]: Syntax error or access violation: 1064 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 `store_id`=’1’)’ at line 1

I have to stay with fulltext or fulltext + like condition.

any help?

regards

 
Magento Community Magento Community
Magento Community
Magento Community
 
andreladocruz
Guru
 
Total Posts:  322
Joined:  2008-05-07
Brazil
 

Friends,

Any help on this?

regards,

 
Magento Community Magento Community
Magento Community
Magento Community
 
andreladocruz
Guru
 
Total Posts:  322
Joined:  2008-05-07
Brazil
 

no one had the same error?

go to configuration -> Catalog and change de search mode to “like” and try do do a advanced search by name only.

Regards,

 
Magento Community Magento Community
Magento Community
Magento Community
 
andreladocruz
Guru
 
Total Posts:  322
Joined:  2008-05-07
Brazil
 

friends,

this issue is teste by magento team on

http://www.magentocommerce.com/bug-tracking/issue?issue=5034

regards

 
Magento Community Magento Community
Magento Community
Magento Community
 
ACruz
Jr. Member
 
Total Posts:  16
Joined:  2009-03-03
 

sirs,

any help?

I just found that the problem is caused by advanced search.

if you search using only name field for exemple.

regards,

 
Magento Community Magento Community
Magento Community
Magento Community
 
weckl
Member
 
Total Posts:  50
Joined:  2008-07-13
Singapore
 

Hi

Did anyone manage to find a solution for this ?

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top