Names beginning with the letter b in Views
mrweaver - June 19, 2008 - 12:36
| Project: | Fullname field for CCK |
| Version: | 5.x-1.5 |
| Component: | Miscellaneous |
| Category: | support request |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | active |
Jump to:
Description
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
#1
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.
#2
oops, this seems to be a duplicate of #165611: 'b...' breaks filters - avoid double query argument replacement