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

darren oh’s picture

Project: Secure Site » Content Profile
Version: 6.x-2.3 » 6.x-1.x-dev
Component: Code » Base module
fago’s picture

Project: Content Profile » Content Construction Kit (CCK)
Component: Base module » General
markus_petrux’s picture

Status: Active » Fixed

I 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.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.