Hallo,
ich wollte das Modul:
Fehlertolerante Suche – Fuzzy Search in meinem doch sehr alten modified eCommerce Shopsoftware Shop einbauen nur bei dem einspielen des SQL Befehls:
INSERT INTO configuration VALUES ('', 'SEARCH_ACTIVATE_SUGGEST', 'true', 22, 7, NULL, '0000-00-00 00:00:00', NULL, 'xtc_cfg_select_option(array(''true'', ''false''),');
INSERT INTO configuration VALUES ('', 'SEARCH_PRODUCT_KEYWORDS', 'false', 22, 8, NULL, '0000-00-00 00:00:00', NULL, 'xtc_cfg_select_option(array(''true'', ''false''),');
INSERT INTO configuration VALUES ('', 'SEARCH_PRODUCT_DESCRIPTION', 'false', 22, 9, NULL, '0000-00-00 00:00:00', NULL, 'xtc_cfg_select_option(array(''true'', ''false''),');
INSERT INTO configuration VALUES ('', 'SEARCH_PROXIMITY_TRIGGER', '70', 22, 10, NULL, '0000-00-00 00:00:00', NULL, NULL);
INSERT INTO configuration VALUES ('', 'SEARCH_WEIGHT_LEVENSHTEIN', '0', 22, 11, NULL, '0000-00-00 00:00:00', NULL, NULL);
INSERT INTO configuration VALUES ('', 'SEARCH_WEIGHT_SIMILAR_TEXT', '100', 22, 12, NULL, '0000-00-00 00:00:00', NULL, NULL);
INSERT INTO configuration VALUES ('', 'SEARCH_WEIGHT_METAPHONE', '0', 22, 13, NULL, '0000-00-00 00:00:00', NULL, NULL);
INSERT INTO configuration VALUES ('', 'SEARCH_SPLIT_MINIMUM_LENGTH', '3', 22, 14, NULL, '0000-00-00 00:00:00', NULL, NULL);
INSERT INTO configuration VALUES ('', 'SEARCH_SPLIT_PRODUCT_NAMES', 'true', 22, 15, NULL, '0000-00-00 00:00:00', NULL, 'xtc_cfg_select_option(array(''true'', ''false''),');
INSERT INTO configuration VALUES ('', 'SEARCH_SPLIT_PRODUCT_CHARS', '[ ,.]', 22, 16, NULL, '0000-00-00 00:00:00', NULL, NULL);
INSERT INTO configuration VALUES ('', 'SEARCH_MAX_KEXWORD_SUGGESTS', '6', 22, 17, NULL, '0000-00-00 00:00:00', NULL, NULL);
INSERT INTO configuration VALUES ('', 'SEARCH_COUNT_PRODUCTS', 'true', 22, 18, NULL, '0000-00-00 00:00:00', NULL, 'xtc_cfg_select_option(array(''true'', ''false''),');
INSERT INTO configuration VALUES ('', 'SEARCH_ENABLE_PROXIMITY_COLOR', 'true', 22, 19, NULL, '0000-00-00 00:00:00', NULL, 'xtc_cfg_select_option(array(''true'', ''false''),');
INSERT INTO configuration VALUES ('', 'SEARCH_PROXIMITY_COLORS', '#9f6;#cf6;#ff6;#fc9;#f99', 22, 20, NULL, '0000-00-00 00:00:00', NULL, NULL);
INSERT INTO configuration VALUES ('', 'SEARCH_ENABLE_PRODUCTS_SUGGEST', 'true', 22, 21, NULL, '0000-00-00 00:00:00', NULL, 'xtc_cfg_select_option(array(''true'', ''false''),');
INSERT INTO configuration VALUES ('', 'SEARCH_MAX_PRODUCTS_SUGGEST', '15', 22, 22, NULL, '0000-00-00 00:00:00', NULL, NULL);
INSERT INTO configuration VALUES ('', 'SEARCH_SHOW_PARSETIME', 'false', 22, 23, NULL, '0000-00-00 00:00:00', NULL, 'xtc_cfg_select_option(array(''true'', ''false''),');
bekomme ich immer folgenden Fehler:
SQL-Befehl: Dokumentation
INSERT INTO configuration
VALUES (
'', 'SEARCH_ACTIVATE_SUGGEST', 'true', 22, 7, NULL , '0000-00-00 00:00:00', NULL , 'xtc_cfg_select_option(array(''true'', ''false''),'
);
MySQL meldet: Dokumentation
#1136 - Column count doesn't match value count at row 1
Kann mir damit jemand helfen?
Besten Dank,
Benny
Linkback: https://www.modified-shop.org/forum/index.php?topic=11479.0