Tweet
Wollte folgende SQL Datei einbinden dabei schreibt er mir die Fehlermeldung:
SQL-Befehl:
INSERT INTO `configuration_group`
VALUES (
'', 'Compare products side-by-side', 'The options for the product comparison script are stored here.', @sortorder +1, 1
)
MySQL meldet: Dokumentation
#2014 - Commands out of sync; you can't run this command now
Die Datei sieht wie folgt aus:
SELECT @sortorder:=max(sort_order) from configuration_group;
INSERT INTO `configuration_group` VALUES ('', 'Compare products side-by-side', 'The options for the product comparison script are stored here.', @sortorder+1, 1);
SELECT @productcomparisonid:=max(configuration_group_id) from configuration_group;
select @productcomparisonid;
INSERT INTO configuration( configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function )
VALUES ( '', 'Debug', 'COMPARE_PRODUCTS_SIDEBYSIDE_DEBUG', 'false', 'When set additional debug info is included onscreen at the top', @productcomparisonid , 10, curdate( ) , curdate( ) , NULL , 'tep_cfg_select_option(array(\'true\', \'false\'),' );
INSERT INTO configuration( configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function )
VALUES ( '', 'Display Product Name', 'COMPARE_PRODUCTS_SIDEBYSIDE_NAME', 'true', 'If true this is included in the side-by-side comparison', @productcomparisonid , 20, curdate( ) , curdate( ) , NULL , 'tep_cfg_select_option(array(\'true\', \'false\'),' );
INSERT INTO configuration( configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function )
VALUES ( '', 'Display Product Model', 'COMPARE_PRODUCTS_SIDEBYSIDE_MODEL', 'true', 'If true this is included in the side-by-side comparison', @productcomparisonid , 30, curdate( ) , curdate( ) , NULL , 'tep_cfg_select_option(array(\'true\', \'false\'),' );
INSERT INTO configuration( configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function )
VALUES ( '', 'Display Manufacturer', 'COMPARE_PRODUCTS_SIDEBYSIDE_MANUFACTURER', 'true', 'If true this is included in the side-by-side comparison', @productcomparisonid , 40, curdate( ) , curdate( ) , NULL , 'tep_cfg_select_option(array(\'true\', \'false\'),' );
INSERT INTO configuration( configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function )
VALUES ( '', 'Display Description', 'COMPARE_PRODUCTS_SIDEBYSIDE_DESCRIPTION', 'true', 'If true this is included in the side-by-side comparison', @productcomparisonid , 50, curdate( ) , curdate( ) , NULL , 'tep_cfg_select_option(array(\'true\', \'false\'),' );
INSERT INTO configuration( configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function )
VALUES ( '', 'Display Price', 'COMPARE_PRODUCTS_SIDEBYSIDE_PRICE', 'true', 'If true this is included in the side-by-side comparison', @productcomparisonid , 60, curdate( ) , curdate( ) , NULL , 'tep_cfg_select_option(array(\'true\', \'false\'),' );
INSERT INTO configuration( configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function )
VALUES ( '', 'Display Quantity', 'COMPARE_PRODUCTS_SIDEBYSIDE_QUANTITY', 'true', 'If true this is included in the side-by-side comparison', @productcomparisonid , 70, curdate( ) , curdate( ) , NULL , 'tep_cfg_select_option(array(\'true\', \'false\'),' );
INSERT INTO configuration( configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function )
VALUES ( '', 'Display Weight', 'COMPARE_PRODUCTS_SIDEBYSIDE_WEIGHT', 'false', 'If true this is included in the side-by-side comparison', @productcomparisonid , 80, curdate( ) , curdate( ) , NULL , 'tep_cfg_select_option(array(\'true\', \'false\'),' );
INSERT INTO configuration( configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function )
VALUES ( '', 'Display Image', 'COMPARE_PRODUCTS_SIDEBYSIDE_IMAGE', 'true', 'If true this is included in the side-by-side comparison', @productcomparisonid , 90, curdate( ) , curdate( ) , NULL , 'tep_cfg_select_option(array(\'true\', \'false\'),' );
INSERT INTO configuration( configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function )
VALUES ( '', 'Display Buy Now', 'COMPARE_PRODUCTS_SIDEBYSIDE_BUY_NOW', 'false', 'If true this is included in the side-by-side comparison - this is not yet supported', @productcomparisonid , 100, curdate( ) , curdate( ) , NULL , 'tep_cfg_select_option(array(\'true\', \'false\'),' );
INSERT INTO configuration( configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function )
VALUES ( '', 'Display Static Attributes', 'COMPARE_PRODUCTS_SIDEBYSIDE_STATIC', 'false', 'If true this is included in the side-by-side comparison', @productcomparisonid , 110, curdate( ) , curdate( ) , NULL , 'tep_cfg_select_option(array(\'true\', \'false\'),' );
INSERT INTO configuration( configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function )
VALUES ( '', 'Display Options', 'COMPARE_PRODUCTS_SIDEBYSIDE_OPTIONS', 'true', 'If true this is included in the side-by-side comparison', @productcomparisonid , 120, curdate( ) , curdate( ) , NULL , 'tep_cfg_select_option(array(\'true\', \'false\'),' );
INSERT INTO configuration( configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function )
VALUES ( '', 'Display Column Left', 'COMPARE_PRODUCTS_SIDEBYSIDE_COLUMN_LEFT', 'false', 'If true standard left column is shown in the side-by-side comparison', @productcomparisonid , 130, curdate( ) , curdate( ) , NULL , 'tep_cfg_select_option(array(\'true\', \'false\'),' );
INSERT INTO configuration( configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function )
VALUES ( '', 'Display Column Right', 'COMPARE_PRODUCTS_SIDEBYSIDE_COLUMN_RIGHT', 'false', 'If true standard right column is shown in the the side-by-side comparison', @productcomparisonid , 140, curdate( ) , curdate( ) , NULL , 'tep_cfg_select_option(array(\'true\', \'false\'),' );
INSERT INTO configuration( configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function )
VALUES ( '', 'Display Footer', 'COMPARE_PRODUCTS_SIDEBYSIDE_FOOTER', 'false', 'If true standard footer is shown in the side-by-side comparison', @productcomparisonid , 150, curdate( ) , curdate( ) , NULL , 'tep_cfg_select_option(array(\'true\', \'false\'),' );
INSERT INTO configuration( configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function )
VALUES ( '', 'Minimum Number of Products', 'COMPARE_PRODUCTS_SIDEBYSIDE_MINIMUM', '2', 'Minimum number of products that need to be selected to allow side-by-side comparison', @productcomparisonid , 160, curdate( ) , curdate( ) , NULL , NULL );
INSERT INTO configuration( configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function )
VALUES ( '', 'Display Product Extra Fields', 'COMPARE_PRODUCTS_SIDEBYSIDE_PEF', 'false', 'If true Product Extra Fields will be shown in the side-by-side comparison', @productcomparisonid , 125, curdate( ) , curdate( ) , NULL , 'tep_cfg_select_option(array(\'true\', \'false\'),' );
kenne mich leider mit SQL nicht aus hoffe hier kann mir jemand helfen. vielen dank schonmal
SQL-Befehl:
INSERT INTO `configuration_group`
VALUES (
'', 'Compare products side-by-side', 'The options for the product comparison script are stored here.', @sortorder +1, 1
)
MySQL meldet: Dokumentation
#2014 - Commands out of sync; you can't run this command now
Die Datei sieht wie folgt aus:
SELECT @sortorder:=max(sort_order) from configuration_group;
INSERT INTO `configuration_group` VALUES ('', 'Compare products side-by-side', 'The options for the product comparison script are stored here.', @sortorder+1, 1);
SELECT @productcomparisonid:=max(configuration_group_id) from configuration_group;
select @productcomparisonid;
INSERT INTO configuration( configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function )
VALUES ( '', 'Debug', 'COMPARE_PRODUCTS_SIDEBYSIDE_DEBUG', 'false', 'When set additional debug info is included onscreen at the top', @productcomparisonid , 10, curdate( ) , curdate( ) , NULL , 'tep_cfg_select_option(array(\'true\', \'false\'),' );
INSERT INTO configuration( configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function )
VALUES ( '', 'Display Product Name', 'COMPARE_PRODUCTS_SIDEBYSIDE_NAME', 'true', 'If true this is included in the side-by-side comparison', @productcomparisonid , 20, curdate( ) , curdate( ) , NULL , 'tep_cfg_select_option(array(\'true\', \'false\'),' );
INSERT INTO configuration( configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function )
VALUES ( '', 'Display Product Model', 'COMPARE_PRODUCTS_SIDEBYSIDE_MODEL', 'true', 'If true this is included in the side-by-side comparison', @productcomparisonid , 30, curdate( ) , curdate( ) , NULL , 'tep_cfg_select_option(array(\'true\', \'false\'),' );
INSERT INTO configuration( configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function )
VALUES ( '', 'Display Manufacturer', 'COMPARE_PRODUCTS_SIDEBYSIDE_MANUFACTURER', 'true', 'If true this is included in the side-by-side comparison', @productcomparisonid , 40, curdate( ) , curdate( ) , NULL , 'tep_cfg_select_option(array(\'true\', \'false\'),' );
INSERT INTO configuration( configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function )
VALUES ( '', 'Display Description', 'COMPARE_PRODUCTS_SIDEBYSIDE_DESCRIPTION', 'true', 'If true this is included in the side-by-side comparison', @productcomparisonid , 50, curdate( ) , curdate( ) , NULL , 'tep_cfg_select_option(array(\'true\', \'false\'),' );
INSERT INTO configuration( configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function )
VALUES ( '', 'Display Price', 'COMPARE_PRODUCTS_SIDEBYSIDE_PRICE', 'true', 'If true this is included in the side-by-side comparison', @productcomparisonid , 60, curdate( ) , curdate( ) , NULL , 'tep_cfg_select_option(array(\'true\', \'false\'),' );
INSERT INTO configuration( configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function )
VALUES ( '', 'Display Quantity', 'COMPARE_PRODUCTS_SIDEBYSIDE_QUANTITY', 'true', 'If true this is included in the side-by-side comparison', @productcomparisonid , 70, curdate( ) , curdate( ) , NULL , 'tep_cfg_select_option(array(\'true\', \'false\'),' );
INSERT INTO configuration( configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function )
VALUES ( '', 'Display Weight', 'COMPARE_PRODUCTS_SIDEBYSIDE_WEIGHT', 'false', 'If true this is included in the side-by-side comparison', @productcomparisonid , 80, curdate( ) , curdate( ) , NULL , 'tep_cfg_select_option(array(\'true\', \'false\'),' );
INSERT INTO configuration( configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function )
VALUES ( '', 'Display Image', 'COMPARE_PRODUCTS_SIDEBYSIDE_IMAGE', 'true', 'If true this is included in the side-by-side comparison', @productcomparisonid , 90, curdate( ) , curdate( ) , NULL , 'tep_cfg_select_option(array(\'true\', \'false\'),' );
INSERT INTO configuration( configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function )
VALUES ( '', 'Display Buy Now', 'COMPARE_PRODUCTS_SIDEBYSIDE_BUY_NOW', 'false', 'If true this is included in the side-by-side comparison - this is not yet supported', @productcomparisonid , 100, curdate( ) , curdate( ) , NULL , 'tep_cfg_select_option(array(\'true\', \'false\'),' );
INSERT INTO configuration( configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function )
VALUES ( '', 'Display Static Attributes', 'COMPARE_PRODUCTS_SIDEBYSIDE_STATIC', 'false', 'If true this is included in the side-by-side comparison', @productcomparisonid , 110, curdate( ) , curdate( ) , NULL , 'tep_cfg_select_option(array(\'true\', \'false\'),' );
INSERT INTO configuration( configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function )
VALUES ( '', 'Display Options', 'COMPARE_PRODUCTS_SIDEBYSIDE_OPTIONS', 'true', 'If true this is included in the side-by-side comparison', @productcomparisonid , 120, curdate( ) , curdate( ) , NULL , 'tep_cfg_select_option(array(\'true\', \'false\'),' );
INSERT INTO configuration( configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function )
VALUES ( '', 'Display Column Left', 'COMPARE_PRODUCTS_SIDEBYSIDE_COLUMN_LEFT', 'false', 'If true standard left column is shown in the side-by-side comparison', @productcomparisonid , 130, curdate( ) , curdate( ) , NULL , 'tep_cfg_select_option(array(\'true\', \'false\'),' );
INSERT INTO configuration( configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function )
VALUES ( '', 'Display Column Right', 'COMPARE_PRODUCTS_SIDEBYSIDE_COLUMN_RIGHT', 'false', 'If true standard right column is shown in the the side-by-side comparison', @productcomparisonid , 140, curdate( ) , curdate( ) , NULL , 'tep_cfg_select_option(array(\'true\', \'false\'),' );
INSERT INTO configuration( configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function )
VALUES ( '', 'Display Footer', 'COMPARE_PRODUCTS_SIDEBYSIDE_FOOTER', 'false', 'If true standard footer is shown in the side-by-side comparison', @productcomparisonid , 150, curdate( ) , curdate( ) , NULL , 'tep_cfg_select_option(array(\'true\', \'false\'),' );
INSERT INTO configuration( configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function )
VALUES ( '', 'Minimum Number of Products', 'COMPARE_PRODUCTS_SIDEBYSIDE_MINIMUM', '2', 'Minimum number of products that need to be selected to allow side-by-side comparison', @productcomparisonid , 160, curdate( ) , curdate( ) , NULL , NULL );
INSERT INTO configuration( configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function )
VALUES ( '', 'Display Product Extra Fields', 'COMPARE_PRODUCTS_SIDEBYSIDE_PEF', 'false', 'If true Product Extra Fields will be shown in the side-by-side comparison', @productcomparisonid , 125, curdate( ) , curdate( ) , NULL , 'tep_cfg_select_option(array(\'true\', \'false\'),' );
kenne mich leider mit SQL nicht aus hoffe hier kann mir jemand helfen. vielen dank schonmal
Comment