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

dawehner’s picture

Status: Active » Fixed

A patch was commited to fix this problem.

dave reid’s picture

Can you perhaps link to a CVS commit? I don't see anything off had that would fix it.

dawehner’s picture

/me sighs about himself

It was commited as part of http://drupal.org/cvs?commit=437286

Status: Fixed » Closed (fixed)

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