Hi,
I have this error when trying to perform a search with finder :

* user warning: 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 '%0%))) AND node.status = 1)' at line 1 query: SELECT COUNT(*) FROM node node INNER JOIN ng_access nga ON node.nid = nga.nid WHERE (nga.access_type = 0) AND ( ((node.type IN ('blog','audio','node_gallery_gallery','prestation','projet','video') AND (node.nid LIKE %0%))) AND node.status = 1) in /.../modules/finder/finder.module on line 662.

* user warning: 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 '%0%))) AND node.status = 1) LIMIT 0, 20' at line 1 query: SELECT node.nid, node.nid FROM node node INNER JOIN ng_access nga ON node.nid = nga.nid WHERE (nga.access_type = 0) AND ( ((node.type IN ('blog','audio','node_gallery_gallery','prestation','projet','video') AND (node.nid LIKE %0%))) AND node.status = 1) LIMIT 0, 20 in /home/greg/toulezarts/sites/all/modules/finder/finder.module on line 662.

I also don't have any search box on the page........

Thx for helping :-)

Comments

danielb’s picture

danielb commented

OK it seems as though autocomplete is currently broken on fields stored as numeric values in the database.

(I assume this is what you've done)

Amenostoff’s picture

Amenostoff commented

Mhhh, I'm not sure if I understand what you say but : all concerned fields are cck taxonomy fields. They sure are stored as numeric in the db, term id I figure...

aaronelborg’s picture

aaronelborg commented

I get a sql error too. But it looks like that's due to the fact that I'm trying to search through nodes.

Nevertheless, I'm subscribing.

danielb’s picture

danielb commented
Status: Active » Fixed

I have fixed the autocomplete LIKE matching, if you have other SQL problems please start a new issue.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.