There are a number of SQL errors when using the table widget with any more than 1 value. Here are some of the errors I'm getting:

When adding a field I get: 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, 0, FROM content_type_courses' at line 1 query: INSERT INTO content_field_courseopttext (vid, nid, delta, ) SELECT vid, nid, 0, FROM content_type_courses in /WebData/Drupal6/sites/all/modules/cck/includes/content.admin.inc on line 1549.

When adding content I get: user warning: Duplicate entry '20-0' for key 'PRIMARY' query: INSERT INTO content_field_coursereqtext (vid, nid, delta) VALUES (20, 20, 0) in /WebData/Drupal6/sites/all/modules/cck/content.module on line 1213.

Comments

develcuy’s picture

subscribing

amaisano’s picture

Same problem. Subscribing.

ckidow’s picture

subscribing

phantomvish’s picture

Same problem, subscribing

danzsmith’s picture

+1 - Same problem - man this is so close to working perfect! I need this functionality....

Thanks very much...

FYI - in looking over at the CCK issue queue, this does not seem to be isolated to just this module:

http://drupal.org/node/445034

Anyway I hope we can get this fixed!

danzsmith’s picture

Guys - I was able to fix this with a small patch to the CCK module:

http://drupal.org/files/issues/content.module_27.patch

described here:

http://drupal.org/node/347712

Not sure if this affects anything else so be careful - so far it seems to work great for me but I will report if anything weird happens!

Cheers!

WinstonC’s picture

This is great! Works perfect for me. Thanks a lot.

intrafusion’s picture

Status: Active » Closed (won't fix)

Marking as Closed (won't fix) as the new co-maintainer will be focusing on D7