SQL error when creating a nodereferer CCK field with multiple possible values
zmove - April 6, 2009 - 07:22
| Project: | NodeReferrer |
| Version: | 6.x-1.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed |
Jump to:
Description
Hi,
I created a nodereferer in one content type with only one possible value : no problem.
But when I edit the nodereferer field to choose multiple values in the options, I get an 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 ') SELECT vid, nid, 0, FROM content_type_problematique' at line 1 query: INSERT INTO content_field_solution_referer (vid, nid, delta, ) SELECT vid, nid, 0, FROM content_type_problematique in /www/sites/all/modules/cck/includes/content.admin.inc on line 1506.Any suggestions to fix it ?
#1
same here under same conditions
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_show' at line 1 query: INSERT INTO content_field_venues (vid, nid, delta, ) SELECT vid, nid, 0, FROM content_type_show in xxx\sites\all\modules\cck\includes\content.admin.inc on line 1506.i had used 5x version recently with mulitple referrers and didnt get this problem
thanks
#2
This depends on #347712: when inserting multiple field, there is mysql syntax error: Duplicate entry '1-0' for key 1
#3
Fixed http://drupal.org/cvs?commit=194918
#4
Automatically closed -- issue fixed for 2 weeks with no activity.
#5
Thanks.