marianama Posted January 10, 2010 Share Posted January 10, 2010 Hi there, I got a fresh osCommerce V2.2rc2a installed and tried to install the column controller w admin v2.0 for MS2(http://addons.oscommerce.com/info/169) while there was an sql error: SQL query: -- phpMyAdmin SQL Dump -- version 2.6.0-beta2 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Jul 28, 2004 at 09:08 PM -- Server version: 3.23.58 -- PHP Version: 4.3.6 -- -- Database: `catalog` -- -- -------------------------------------------------------- -- -- Dumping data for table `configuration_group` -- INSERT INTO `configuration_group` ( `configuration_group_id` , `configuration_group_title` , `configuration_group_description` , `sort_order` , `visible` ) VALUES ( 400, 'Column Controller', 'Configure Column width which boxes will display and where.', '', 0 ) MySQL said: #1062 - Duplicate entry '400' for key 1 I don't understand sql. Would anyone help? Thank you very much. Quote Link to comment Share on other sites More sharing options...
marianama Posted January 10, 2010 Author Share Posted January 10, 2010 cancel - have fixed Quote Link to comment Share on other sites More sharing options...
Guest Posted January 10, 2010 Share Posted January 10, 2010 Mariana, That means that KEY 400 is already in use. Run the SQL again, but change 400 to another number.....405, 410 Chris Quote Link to comment Share on other sites More sharing options...
marianama Posted January 10, 2010 Author Share Posted January 10, 2010 Thank you Chris! Quote Link to comment Share on other sites More sharing options...
Maria Cafe Posted March 28, 2010 Share Posted March 28, 2010 Thank you Chris! Hi! I have the exact same problem. Tryed changing the value "400" to "416", but then another error occurred: " Error SQL query: Documentation 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 ( 182, 'Currencies Box', 'BOX_CURRENCIES_IS_ON', 'true', 'Would you like to display the Currencies Box?', 416, 40, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'tep_cfg_select_option(array(''true'', ''false''),' ) ; MySQL said: Documentation #1062 - Duplicate entry '182' for key 1 " I changed the value 182 to other values, but the same error occurred. What should I do? I know nothing about sql... Thanks, Maria Cafe Quote Link to comment Share on other sites More sharing options...
Guest Posted March 28, 2010 Share Posted March 28, 2010 Maria, Change it to a much higher number. (usually the 400's are pretty safe) Chris Quote Link to comment Share on other sites More sharing options...
Maria Cafe Posted March 28, 2010 Share Posted March 28, 2010 Thanks Chris, I'll try that right away. Should I change all the "400" values in the query to the same 416 value I previously changed? Tnx, Maria Quote Link to comment Share on other sites More sharing options...
Guest Posted March 28, 2010 Share Posted March 28, 2010 Maria, just change 182 to another number Chris Quote Link to comment Share on other sites More sharing options...
Maria Cafe Posted March 28, 2010 Share Posted March 28, 2010 Maria, just change 182 to another number Chris Well, the same error again and again. I changed 182 to 415, 450, 403... Thanks anyway. I will uninstall the add on. Maria Quote Link to comment Share on other sites More sharing options...
Guest Posted March 28, 2010 Share Posted March 28, 2010 Marie, Did you un-install the changes it did make before trying to run it again ? Chris Quote Link to comment Share on other sites More sharing options...
Maria Cafe Posted March 28, 2010 Share Posted March 28, 2010 her... no, but I thought it could be necessary, just don't know how to do it. Can you tell me how to do it? Tnx, Maria Quote Link to comment Share on other sites More sharing options...
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.