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
Comment #1
develcuy commentedsubscribing
Comment #2
amaisano commentedSame problem. Subscribing.
Comment #3
ckidowsubscribing
Comment #4
phantomvish commentedSame problem, subscribing
Comment #5
danzsmith commented+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!
Comment #6
danzsmith commentedGuys - 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!
Comment #7
WinstonC commentedThis is great! Works perfect for me. Thanks a lot.
Comment #8
intrafusionMarking as Closed (won't fix) as the new co-maintainer will be focusing on D7