easy Populate probleem mysql
ik wil graag artikelen er in gooien alleen het is een beetje teveel om stuk voor stuk te doen.
dus heb ik gebruik gemaakt van easy Populate nu het volgend als ik de.
dezen tabbelen wil toevoegen in de mysql.
INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES ('17', 'Easy Populate', 'Easy Populate', '17', '1');
INSERT INTO configuration VALUES ('', 'Temp Directory', 'EP_TEMP_DIR', 'temp/', 'If you changed your directory structure from stock and do not have /catalog/temp/, then you need to change this accordingly.', 17, 1, now(), now(), NULL, NULL);
INSERT INTO configuration VALUES ('', 'Set Time Limt', 'EP_SET_TIME_LIMIT', 'false', 'Set to "true" if you are not on a safe mode server and you are getting timeouts.', 17, 2, now(), now(), NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration VALUES ('', 'Max Split Records', 'EP_MAX_RECS', '300', 'If you are splitting files, this will set the maximum number of records to put in each file.', 17, 3, now(), now(), NULL, NULL);
INSERT INTO configuration VALUES ('', 'Default Category Image', 'EP_CAT_IMAGE', '', 'Default category image used when auto-creating categories (eg. "no_image_category.gif")', 17, 4, now(), now(), NULL, NULL);
INSERT INTO configuration VALUES ('', 'Default Manufacturer Image', 'EP_MANF_IMAGE', '', 'Default manufacturer image used when auto-creating manufacturers (eg. "no_image_manufacturer.gif")', 17, 5, now(), now(), NULL, NULL);
INSERT INTO configuration VALUES ('', 'Default Products Image', 'EP_PROD_IMAGE', '', 'Default product image used when auto-creating products (eg. "no_image_product.gif")', 17, 6, now(), now(), NULL, NULL);
INSERT INTO configuration VALUES ('', 'Zero Qty Behavior', 'EP_ZERO_QTY', 'false', 'If this is set to "true" then all items imported with zero qty will automatically be set to "Inactive".', 17, 7, now(), now(), NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration VALUES ('', 'Price Includes Tax', 'EP_PRICE_INC_TAX', 'false', 'If this is set to "true" you want the price to be defined for import & export including tax.', 17, 8, now(), now(), NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration VALUES ('', 'Replace Quotes', 'EP_REPLACE_QUOTES', 'true', 'If you have extensive html in your descriptions and it\'s getting mangled on upload, turn this to "false."', 17, 9, now(), now(), NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration VALUES ('', 'Delimiter', 'EP_DELIMITER', '\t', 'Remember, if your descriptions contain this character, you will confuse EP! (common delimiters - "(\\t - TAB will have be set using phpmyadmin or other utility as osc converts it into a string)"," ";" "~" "|" "-" "*").', 17, 10, now(), now(), NULL, NULL);
INSERT INTO configuration VALUES ('', 'Maximum Categories', 'EP_MAX_CAT', '7', 'Max Category Levels to create.', 17, 11, now(), now(), NULL, NULL);
INSERT INTO configuration VALUES ('', 'Products With Attributes', 'EP_PROD_ATTR', 'true', 'If you do not want to download product attributes, change this to "false."', 17, 12, now(), now(), NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration VALUES ('', 'Froogle Product Info URL', 'EP_FROOGLE_PROD', '', 'Set this to the url of your products_info.php page (http://www.domain.com/catalog/product_info.php).', 17, 13, now(), now(), NULL, NULL);
INSERT INTO configuration VALUES ('', 'Froogle Images URL', 'EP_FROOGLE_IMG', '', 'Set this to the url of your catalog images directory (http://www.domain.com/catalog/images/).', 17, 14, now(), now(), NULL, NULL);
INSERT INTO configuration VALUES ('', 'Froogle SEF URLs', 'EP_SEF_URLS', 'false', 'If your store has SEARCH ENGINE FRIENDLY URLS set, then turn this to "true".', 17, 15, now(), now(), NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
daar na geeft hij dit aan.
Fout
SQL-query:
INSERT INTO configuration_group( configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible )
VALUES (
'17', 'Easy Populate', 'Easy Populate', '17', '1'
);
MySQL retourneerde:
#1062 - Duplicate entry '17' for key 1
en ik kom er zelf niet uit wat dezen melding betekent
Gewijzigd op 01/01/1970 01:00:00 door Melvin
Quote:
Er bestaat blijkbaar al een record met de waarde 17 in de kolom configuration_group_id. Dat levert hier het probleem op...Duplicate entry '17'
configuration_group_id int(11) Nee auto_increment
configuration_group_title varchar(64) latin1_swedish_ci Nee
configuration_group_description varchar(255) latin1_swedish_ci Nee
sort_order int(5) Ja NULL
visible int(1) Ja 1
Gewijzigd op 01/01/1970 01:00:00 door melvin
SQL Beginnershandleiding
Lees deze handleiding maar eens door, daarin wordt in het hoofdstuk over debuggen dit probleem ook besproken.