Closed (fixed)
Project:
Views (for Drupal 7)
Version:
7.x-3.x-dev
Component:
taxonomy data
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
28 Sep 2010 at 15:15 UTC
Updated:
9 Nov 2010 at 21:00 UTC
taxonomy_autocomplete() has changed in D7 in that you can no longer use it with a vocabulary ID like in D6 (e.g. taxonomy/autocomplete/2) since it now expects a taxonomy field name (e.g. taxonomy/autocomplete/field_name). Currently when exposing an taxonomy filter, you can have the option to add autocompletion, but it results in an AJAX error:
An AJAX HTTP error occurred.
HTTP Result Code: 500
Debugging information follows.
Path: taxonomy/autocomplete/1
StatusText: Service unavailable (with message)
ResponseText: PDOException: 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 (t.name LIKE '%s%' ESCAPE '\\')
LIMIT 10 OFFSET 0' at line 1: SELECT t.tid AS tid, t.name AS name
FROM
{taxonomy_term_data} t
WHERE (t.vid IN ()) AND (t.name LIKE :db_condition_placeholder_0 ESCAPE '\\')
LIMIT 10 OFFSET 0; Array
(
[:db_condition_placeholder_0] => %s%
)
in taxonomy_autocomplete() (line 110 of modules/taxonomy/taxonomy.pages.inc).
I think we may have to provide our own taxonomy auto-completion callback in views that works via vocabulary ID.
Comments
Comment #1
dawehnerA patch was commited to fix this problem.
Comment #2
dave reidCan you perhaps link to a CVS commit? I don't see anything off had that would fix it.
Comment #3
dawehner/me sighs about himself
It was commited as part of http://drupal.org/cvs?commit=437286