Hello

I get always this error after typing some values in the cck field.I created a normal cck textfield with autocomplete. I use the latest versions of drupal and modules a lot.

This is the error:

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 ') )ORDER BY f.field_backlink_project_value LIMIT 0, 10' at line 1 query: SELECT f.field_backlink_project_value FROM xxx_content_type_backlink f INNER JOIN xxx_node n ON f.vid = n.vid WHERE (n.language ='de' OR n.language ='' OR n.language IS NULL) AND ( f.field_backlink_project_value IN () )ORDER BY f.field_backlink_project_value LIMIT 0, 10 in /home/xxx/public_html/sites/all/modules/autocomplete_widgets/autocomplete_widgets.common.inc on line 143.

How can I fix this? Any ideas

Comments

drupalnesia’s picture

drupalnesia commented
Category: task » bug 
SELECT f.field_backlink_project_value 
FROM xxx_content_type_backlink f 
INNER JOIN xxx_node n ON f.vid = n.vid 
WHERE (n.language ='de' OR n.language ='' OR n.language IS NULL) 
  AND ( f.field_backlink_project_value IN () )
ORDER BY f.field_backlink_project_value LIMIT 0, 10

Above code f.field_backlink_project_value IN () must have a value.
Look like the variable before your SQL command was missing.

It should be f.field_backlink_project_value IN ('123') for example.

drupalnesia’s picture

drupalnesia commented
Category: bug » task