Error in query to CCK-field
morgunl - August 20, 2009 - 17:53
| Project: | Views Filter Pack |
| Version: | 6.x-1.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Description
The correct query (with views_filter_pack module off):
SELECT ......................
LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid
WHERE (node_data_field_direction.field_direction_value IN ('Направление 1', 'Направление 2')) AND (node.type in ('countryhouse')) AND (node_data_field_rent.field_rent_value = 'Аренда')
ORDER BY node_title ASCAnd the wrong query (with the module on):
SELECT ......................
LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid
WHERE (node_data_field_direction.field_direction_value IN ('Направление 1', 'Направление 2')) AND (node.type in ('Аренда')) AND
(node_data_field_rent.field_rent_value = '')
ORDER BY node_title ASCIt seems there's a misprint in the code because 'Аренда' is not the node type at all. It's just one of the available values for field_rent_value property.