We have a suburb/venue dropdown set as a nodereference field that uses autocomplete. If you type in a single character which is either 'b', 'd', 'f' or 's' there is an error generated in the sql syntax. If you type in '%s' or 'S' then the autocomplete works. I'm assuming that these characters are reserved cases (when prefixed with '%').

Comments

gustav’s picture

gustav commented

I have an autocomplete nodereference field and it does not produce any errors for any characters. So I can not reproduce this problem. Perhaps the problem is specfic to your mysql or php version?

Kat_Sweden’s picture

Kat_Sweden commented

We are using PHP 5.2.3 and MySQL version 5.0.45. Which versions do you have?

lyngve’s picture

lyngve commented

I have same problem with letters b, d, f etc. But no visible errors, only zero results even there are nodes that contains the letters b, d, f etc. This is only a problem when I use the autocomplete nodereference widget in combination with views (Nodes that can be referenced View).

Mysql version 5.0.51
PHP 5.2.5
Drupal 5.7

I really need this views-feature to give more information than node-title for the autocomplete results.

jesss’s picture

jesss commented

Subscribing

moshe weitzman’s picture

moshe weitzman commented
Status: Active » Closed (duplicate)

This is a Views bug which is fixed in CVS and will be fixed in 5.x-1.7 if that ever comes out. is fixed in Views2 as well.