dragon5 Posted July 20, 2004 Posted July 20, 2004 When I run this script from Master Password v1.2, 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 ('188', 'Master Password', 'MASTER_PASS', 'yourpassword', 'This password will allow you to login to any customers account.', 1, 23, '2004-06-15 07:10:52', '2004-06-15 07:10:52', NULL, NULL); I get, Error SQL-query : 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 ( '188', 'Master Password', 'MASTER_PASS', 'yourpassword', 'This password will allow you to login to any customers account.', 1, 23, '2004-06-15 07:10:52', '2004-06-15 07:10:52', NULL , NULL ) MySQL said: #1062 - Duplicate entry '188' for key 1 What's the problem, or what am I doing wrong? Thanks d5 Quote
♥ecartz Posted July 20, 2004 Posted July 20, 2004 INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Master Password', 'MASTER_PASS', 'yourpassword', 'This password will allow you to login to any customers account.', 1, 23, '2004-06-15 07:10:52', '2004-06-15 07:10:52', NULL, NULL); might work better for you. No need to declare the configuration_id. The database should handle that for you. Hth, Matt Quote Always back up before making changes.
dragon5 Posted July 20, 2004 Author Posted July 20, 2004 Thanks will try tonight. Are you familiar with this contrib? Does it function well? Thanks d5 Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.