The following error occurs when trying to add an existing matrix field to another content type

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 ') SELECT vid, nid, FROM content_type_productalpha' at line 1 query: INSERT INTO content_field_specifications (vid, nid, ) SELECT vid, nid, FROM content_type_productalpha in /home/drupaladmin/public_html/drupal-612/sites/all/modules/cck/includes/content.admin.inc on line 1527.

Comments

rena_obadia’s picture

rena_obadia commented

I have the same problem. Using Drupal version 6.13, last CCK.

aaron1234nz’s picture

aaron1234nz commented
Status: Active » Closed (won't fix)

I've just taken a look at this issue and found that, as far as I know, it cannot be solved. Matrix field does not use the database layer provided by CCK (because it does not allow for an n x n matrix of values). When copying the field from one content type to another, CCK assumes there will be data. The error message is not fatal and I don't think I can easily fix it.