Using Content Profile I have created a node that can be used as user profile (! Use this content type as a content profile for users) . However once I create a CCK field of tyoe image and I give the option unlimited values I get the following SQL error:
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.
NOTE: If at Global Settings of the CCK field of the profile I choose 1 (only one value) I do not get the error.
Comments
Comment #1
darren ohComment #2
fagoComment #3
markus_petrux commentedI think this is fixed in CVS. Please, see: #522112: Ugly mysql warning when empty $vids for prerender in content_handler_field_multiple
You can try that particular fix alone (patch linked in that issue), or try with latest development snapshot of CCK 2.