liquidlens Posted August 25, 2004 Share Posted August 25, 2004 I've just loaded the column controller contribution. Unfortunately I seem to have lost some info boxes; namely "tell a friend" and "currency". When i ran the SQL query, I received the following error message: 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?', 400, 40, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'tep_cfg_select_option(array(''true'', ''false''),' ) MySQL said: #1062 - Duplicate entry '182' for key 1 have I buggered the whole lot up? I'm a little worried! All help gratefully received. Thanks, Mark Quote Link to comment Share on other sites More sharing options...
liquidlens Posted August 25, 2004 Author Share Posted August 25, 2004 Err, the tell a friend infobox is still there - it's just the currency infobox that has disappeared. Sorry for any confusion. Thanks, Mark Quote Link to comment Share on other sites More sharing options...
241 Posted August 25, 2004 Share Posted August 25, 2004 (edited) the error states that there is already an entry in your database configuration table at location 182 backup your database and then run this 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 ( '', 'Currencies Box', 'BOX_CURRENCIES_IS_ON', 'true', 'Would you like to display the Currencies Box?', 400, 40, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'tep_cfg_select_option(array(''true'', ''false''),' ) this will put the insert into the next available location in the configuration table Edited August 25, 2004 by 241 Quote No longer giving free advice. Please place deposit in meter slot provided. Individual: [=] SME: [==] Corporation: [===] If deposit does not fit one of the slots provided then you are asking too much! Is your Osc dated try Phoenix raising oscommerce from the ashes. Link to comment Share on other sites More sharing options...
liquidlens Posted August 26, 2004 Author Share Posted August 26, 2004 many thanks for your help. This has now added the currency infobox to the column controller, but doesn't allow you to specify left or right column like all the other infoboxes. Any ideas? thanks, Mark Quote Link to comment Share on other sites More sharing options...
241 Posted August 26, 2004 Share Posted August 26, 2004 (edited) this is because there is more of the sql file that has not been run. do you have these entries: Would you like to display the Currencies Box? In which column would you like to display the Currencies Box? Would you like to display the Currencies Box? Which Banner Group would you like to display in the Right Banner Box? In which column would you like to display the Right Banner Box? If not then you will need to run this sql queries. 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 ('', 'Currencies Box Column?', 'BOX_CURRENCIES_COLUMN', 'right', 'In which column would you like to display the Currencies Box?', 400, 41, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'tep_cfg_select_option(array(''left'', ''right''),'); 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 ('', 'Right Banner Box', 'BOX_BANNER_RIGHT_IS_ON', 'false', 'Would you like to display the Currencies Box?', 400, 42, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', '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 ('', 'Right Banner Group', 'BANNER_RIGHT_GROUP_IS', '100X100', 'Which Banner Group would you like to display in the Right Banner Box?', 400, 43, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', ''); 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 ('', 'Right Banner Box Column?', 'BOX_BANNER_RIGHT_COLUMN', 'right', 'In which column would you like to display the Right Banner Box?', 400, 44, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'tep_cfg_select_option(array(''left'', ''right'', ''both''),'); Edited August 26, 2004 by 241 Quote No longer giving free advice. Please place deposit in meter slot provided. Individual: [=] SME: [==] Corporation: [===] If deposit does not fit one of the slots provided then you are asking too much! Is your Osc dated try Phoenix raising oscommerce from the ashes. Link to comment Share on other sites More sharing options...
Sam Hobbs Posted August 26, 2004 Share Posted August 26, 2004 many thanks for your help. This has now added the currency infobox to the column controller, but doesn't allow you to specify left or right column like all the other infoboxes. I have also installed the Column Controller. My Column Controller tool page does allow me to specify left or right column like all the other infoboxes. So I think your table has not been fully loaded, as Steve (241) says. See for a snapshot of the bottom portion of my configuration data. That portion only shows a portion of my Column Controller tool page but it shows the relevant portion. After getting that working, I had a problem with a loginbox.php file not being found; that problem is described in another thread. Quote Link to comment Share on other sites More sharing options...
liquidlens Posted August 26, 2004 Author Share Posted August 26, 2004 Top stuff. Thanks to Steve for that extra code. I've run it and all looks like Sam's screenshot - so it seems to have worked. I'll be aware for the loginbox.php issue and look separately if necessary. Thanks again. Mark Quote Link to comment Share on other sites More sharing options...
MrsPhim Posted April 27, 2006 Share Posted April 27, 2006 I have installed Column Controller, made all the changes, ran the SQL file, and when I go to my Oscommerce Admin page, I see Column Controller in the Tools section, and also in the Configuration section, but the pages are blank - I believe it is supposed to have a Column Controller Tool page like the one shown here: Column Controller Tool But I just have a blank table =( What could I have done wrong? I double-checked all of the file modifications, additions, etc., everything seems to be in order. Please someone help! Thank you. 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.