Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.Once I use a cck field of type image and I select more than one values in global options (i.e. unlimitted values) , I get a sql error.
CASE: Create a Node Profile, with a CCK image field (field_userphoto) with Global Options Number of values:8
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 node.nid ASC, node_data_field_userphoto.delta ASC' at line 1 query: SELECT node.vid AS _vid, node_data_field_userphoto.delta as _delta, node.nid AS _nid, node_data_field_userphoto.field_userphoto_fid AS fid, node_data_field_userphoto.field_userphoto_list AS list, node_data_field_userphoto.field_userphoto_data AS data FROM content_field_userphoto node_data_field_userphoto LEFT JOIN node node ON node.vid = node_data_field_userphoto.vid WHERE node.vid IN () ORDER BY node.nid ASC, node_data_field_userphoto.delta ASC in /var/www/gossiptv/sites/all/modules/cck/includes/views/handlers/content_handler_field_multiple.inc on line 157.
Comments
Comment #1
fagoCPR doesn't create this query itself, much more likely this is a cck or imagefield problem. Search those issue queues.