content.admin.inc on line 1506 - You have an error in your SQL syntax
kenorb - December 16, 2008 - 11:57
| Project: | NodeReferrer |
| Version: | 6.x-1.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed |
Jump to:
Description
When changing some parameter of Node Referrers type of field, I've got following MySQL syntax 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_parent' at line 1 query: INSERT INTO content_field_ref_childrens (vid, nid, delta, ) SELECT vid, nid, 0, FROM content_type_parent in D:\bro\workspace\Websites\ClownTown\trunk\sites\all\modules\contributions\cck\includes\content.admin.inc on line 1506.Some backtrace:
-> array_intersect_assoc(array ('vid' => array ('type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, 'default' => 0), 'nid' => array ('type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, 'default' => 0), 'delta' => array ('type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, 'default' => 0)), array ('vid' => array ('type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, 'default' => 0), 'nid' => array ('type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, 'default' => 0))) all\modules\contributions\cck\includes\content.admin.inc:1468
>=> array ('vid' => array ('type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, 'default' => 0), 'nid' => array ('type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, 'default' => 0))
-> array_keys(array ()) all\modules\contributions\cck\includes\content.admin.inc:1503
>=> array ()
-> implode(', ', array ()) all\modules\contributions\cck\includes\content.admin.inc:1505
>=> ''
-> implode(', ', array ()) all\modules\contributions\cck\includes\content.admin.inc:1506
>=> ''
-> db_query($query = 'INSERT INTO {content_field_ref_childrens} (vid, nid, delta, ) SELECT vid, nid, 0, FROM {content_type_parent}') all\modules\contributions\cck\includes\content.admin.inc:1506
#1
content_alter_db has been run with following parameters:
0.9576 22156256 -> content_alter_schema($previous_field = array ('field_name' => 'field_ref_childrens', 'type_name' => 'parent', 'display_settings' => array ('weight' => '36', 'parent' => '', 'label' => array ('format' => 'above'), 'teaser' => array ('format' => 'teaser', 'exclude' => 0), 'full' => array ('format' => 'full', 'exclude' => 0), 0 => array ('format' => 'above', 'exclude' => 0), 1 => array ('format' => 'default', 'exclude' => 0), 2 => array ('format' => 'default', 'exclude' => 0), 'token' => array ('format' => 'default', 'exclude' => 0)), 'widget_active' => '1', 'type' => 'nodereferrer', 'required' => '0', 'multiple' => '0', 'db_storage' => '1', 'module' => 'nodereferrer', 'active' => '1', 'locked' => '0', 'columns' => array (), 'referrer_types' => array ('child' => 'child', 'page' => 0, 'parent' => 0, 'party' => 0, 'poll' => 0, 'profile' => 0, 'story' => 0), 'referrer_fields' => array ('field_ref_node_parent' => 'field_ref_node_parent'), 'referrer_translations' => 0, 'referrer_nodes_per_page' => '20', 'referrer_pager_element' => '0', 'referrer_order' => 'TITLE_ASC', 'widget' => array ('label' => 'Childrens', 'weight' => 0, 'description' => '', 'type' => 'nodereferrer_list', 'module' => 'nodereferrer')), $new_field = array ('field_name' => 'field_ref_childrens', 'type_name' => 'parent', 'display_settings' => array ('weight' => '36', 'parent' => '', 'label' => array ('format' => 'above'), 'teaser' => array ('format' => 'teaser', 'exclude' => 0), 'full' => array ('format' => 'full', 'exclude' => 0), 0 => array ('format' => 'above', 'exclude' => 0), 1 => array ('format' => 'default', 'exclude' => 0), 2 => array ('format' => 'default', 'exclude' => 0), 'token' => array ('format' => 'default', 'exclude' => 0)), 'widget_active' => '1', 'type' => 'nodereferrer', 'required' => 0, 'multiple' => '1', 'db_storage' => 0, 'module' => 'nodereferrer', 'active' => '1', 'locked' => '0', 'columns' => array (), 'referrer_types' => array ('child' => 'child', 'page' => 0, 'parent' => 0, 'party' => 0, 'poll' => 0, 'profile' => 0, 'story' => 0), 'referrer_fields' => array ('field_ref_node_parent' => 'field_ref_node_parent'), 'referrer_translations' => 0, 'referrer_nodes_per_page' => '20', 'referrer_pager_element' => '0', 'referrer_order' => 'TITLE_ASC', 'widget' => array ('label' => 'Childrens', 'weight' => 0, 'description' => '', 'type' => 'nodereferrer_list', 'module' => 'nodereferrer'), 'change' => 'Change basic information', 'group' => FALSE, 'previous_field' => 'a:19:{s:10:"field_name";s:19:"field_ref_childrens";s:9:"type_name";s:6:"parent";s:16:"display_settings";a:9:{s:6:"weight";s:2:"36";s:6:"parent";s:0:"";s:5:"label";a:1:{s:6:"format";s:5:"above";}s:6:"teaser";a:2:{s:6:"format";s:6:"teaser";s:7:"exclude";i:0;}s:4:"full";a:2:{s:6:"format";s:4:"full";s:7:"exclude";i:0;}i:0;a:2:{s:6:"format";s:5:"above";s:7:"exclude";i:0;}i:1;a:2:{s:6:"format";s:7:"default";s:7:"exclude";i:0;}i:2;a:2:{s:6:"format";s:7:"default";s:7:"exclude";i:0;}s:5:"token";a:2:{s:6:"format";s:7:"default";s:7:"exclude";i:0;}}s:13:"widget_active";s:1:"1";s:4:"type";s:12:"nodereferrer";s:8:"required";s:1:"0";s:8:"multiple";s:1:"0";s:10:"db_storage";s:1:"1";s:6:"module";s:12:"nodereferrer";s:6:"active";s:1:"1";s:6:"locked";s:1:"0";s:7:"columns";a:0:{}s:14:"referrer_types";a:7:{s:5:"child";s:5:"child";s:4:"page";i:0;s:6:"parent";i:0;s:5:"party";i:0;s:4:"poll";i:0;s:7:"profile";i:0;s:5:"story";i:0;}s:15:"referrer_fields";a:1:{s:21:"field_ref_node_parent";s:21:"field_ref_node_parent";}s:21:"referrer_tra...', 'op' => 'Save field settings', 'submit' => 'Save field settings', 'form_build_id' => 'form-f2a4670a2ff209c8caa06cfe440f04e7', 'form_token' => '1396773b099d2e2ae82f3ebda6c18584', 'form_id' => 'content_field_edit_form')) sites\all\modules\contributions\cck\includes\content.crud.inc:3450.9578 22156272 -> content_alter_db($previous_field = array ('field_name' => 'field_ref_childrens', 'type_name' => 'parent', 'display_settings' => array ('weight' => '36', 'parent' => '', 'label' => array ('format' => 'above'), 'teaser' => array ('format' => 'teaser', 'exclude' => 0), 'full' => array ('format' => 'full', 'exclude' => 0), 0 => array ('format' => 'above', 'exclude' => 0), 1 => array ('format' => 'default', 'exclude' => 0), 2 => array ('format' => 'default', 'exclude' => 0), 'token' => array ('format' => 'default', 'exclude' => 0)), 'widget_active' => '1', 'type' => 'nodereferrer', 'required' => '0', 'multiple' => '0', 'db_storage' => '1', 'module' => 'nodereferrer', 'active' => '1', 'locked' => '0', 'columns' => array (), 'referrer_types' => array ('child' => 'child', 'page' => 0, 'parent' => 0, 'party' => 0, 'poll' => 0, 'profile' => 0, 'story' => 0), 'referrer_fields' => array ('field_ref_node_parent' => 'field_ref_node_parent'), 'referrer_translations' => 0, 'referrer_nodes_per_page' => '20', 'referrer_pager_element' => '0', 'referrer_order' => 'TITLE_ASC', 'widget' => array ('label' => 'Childrens', 'weight' => 0, 'description' => '', 'type' => 'nodereferrer_list', 'module' => 'nodereferrer')), $new_field = array ('field_name' => 'field_ref_childrens', 'type_name' => 'parent', 'display_settings' => array ('weight' => '36', 'parent' => '', 'label' => array ('format' => 'above'), 'teaser' => array ('format' => 'teaser', 'exclude' => 0), 'full' => array ('format' => 'full', 'exclude' => 0), 0 => array ('format' => 'above', 'exclude' => 0), 1 => array ('format' => 'default', 'exclude' => 0), 2 => array ('format' => 'default', 'exclude' => 0), 'token' => array ('format' => 'default', 'exclude' => 0)), 'widget_active' => '1', 'type' => 'nodereferrer', 'required' => 0, 'multiple' => '1', 'db_storage' => 0, 'module' => 'nodereferrer', 'active' => '1', 'locked' => '0', 'columns' => array (), 'referrer_types' => array ('child' => 'child', 'page' => 0, 'parent' => 0, 'party' => 0, 'poll' => 0, 'profile' => 0, 'story' => 0), 'referrer_fields' => array ('field_ref_node_parent' => 'field_ref_node_parent'), 'referrer_translations' => 0, 'referrer_nodes_per_page' => '20', 'referrer_pager_element' => '0', 'referrer_order' => 'TITLE_ASC', 'widget' => array ('label' => 'Childrens', 'weight' => 0, 'description' => '', 'type' => 'nodereferrer_list', 'module' => 'nodereferrer'), 'change' => 'Change basic information', 'group' => FALSE, 'previous_field' => 'a:19:{s:10:"field_name";s:19:"field_ref_childrens";s:9:"type_name";s:6:"parent";s:16:"display_settings";a:9:{s:6:"weight";s:2:"36";s:6:"parent";s:0:"";s:5:"label";a:1:{s:6:"format";s:5:"above";}s:6:"teaser";a:2:{s:6:"format";s:6:"teaser";s:7:"exclude";i:0;}s:4:"full";a:2:{s:6:"format";s:4:"full";s:7:"exclude";i:0;}i:0;a:2:{s:6:"format";s:5:"above";s:7:"exclude";i:0;}i:1;a:2:{s:6:"format";s:7:"default";s:7:"exclude";i:0;}i:2;a:2:{s:6:"format";s:7:"default";s:7:"exclude";i:0;}s:5:"token";a:2:{s:6:"format";s:7:"default";s:7:"exclude";i:0;}}s:13:"widget_active";s:1:"1";s:4:"type";s:12:"nodereferrer";s:8:"required";s:1:"0";s:8:"multiple";s:1:"0";s:10:"db_storage";s:1:"1";s:6:"module";s:12:"nodereferrer";s:6:"active";s:1:"1";s:6:"locked";s:1:"0";s:7:"columns";a:0:{}s:14:"referrer_types";a:7:{s:5:"child";s:5:"child";s:4:"page";i:0;s:6:"parent";i:0;s:5:"party";i:0;s:4:"poll";i:0;s:7:"profile";i:0;s:5:"story";i:0;}s:15:"referrer_fields";a:1:{s:21:"field_ref_node_parent";s:21:"field_ref_node_parent";}s:21:"referrer_tra...', 'op' => 'Save field settings', 'submit' => 'Save field settings', 'form_build_id' => 'form-f2a4670a2ff209c8caa06cfe440f04e7', 'form_token' => '1396773b099d2e2ae82f3ebda6c18584', 'form_id' => 'content_field_edit_form')) sites\all\modules\contributions\cck\includes\content.admin.inc:1331
#2
#3
Automatically closed -- issue fixed for 2 weeks with no activity.