Hi. I have created a View of a content type that uses the full name. In the View, I have added the "full name" component so the name can be searched in these content types.

It works fine with all of the names I have tested except those beginning with the letter "b". Then I get:

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 'node'lansten%')))' at line 1 query: SELECT count( DISTINCT(node.nid)) FROM node node LEFT JOIN content_type_incidentreport node_data_field_patrons_name ON node.vid = node_data_field_patrons_name.vid LEFT JOIN content_type_incidentreport node_data_field_date_of_incident ON node.vid = node_data_field_date_of_incident.vid WHERE (node.type IN ('incidentreport')) AND ((UPPER(node_data_field_patrons_name.field_patrons_name_last) LIKE UPPER(''node'lansten%'))) in C:\Program Files\Apache Group\Apache2\htdocs\includes\database.mysql.inc on line 172.

In this case, the name I was testing with is "Blansten". I tried other names beginning with b and got the same thing. Note this: "'node'lansten%')))'" in the error message.

Any ideas? Can I correct this with an argument?

thanks
mrweaver

Comments

xamount’s picture

Priority: Normal » Critical

I can also confirm this. I have a view filter block that searches cck fields. Once the first keywords starts with b I get the same error as mentioned above.

If i search for "barbados" I get the error but if i search for "arbados" I dont. This is very weird and seems kinda critical...

I am not sure if this error is related to the full name field for cck only. I don't think so though.

xamount’s picture

rconstantine’s picture

Status: Active » Closed (fixed)

Good to hear it wasn't this module.

No longer supporting D5 version.