Using phpMyAdmin to load columns controller

[Sam Hobbs 0]

I am trying to install the Column Controller w Admin v2.1. I think it is installed, except I encountered an error loading the database. I used phpMyAdmin to load the one record for the configuration_group table; it worked. I then selected the configuration table and then copied and pasted the SQL (provided with the contribution) to insert to that table. I got an error; the following is most of it:

 

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 ( 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

 

I assume the answer is simple but if I can get a little help then I do appreciate that. Note that this was the first and only time I tried to execute that SQL.

[241 21]

see this post Click

[Sam Hobbs 0]

Thank you, I will try that.

 

I assume my question got moved; I had forgotten about this other forum.

 

Now that I look at the SQL, I see that there are about 39 records that got inserted preceding the one that got the error. I assume that I need to remove the hard-coded configuration_id for the remaining few records also.

 

I also assume that the hard-coded configuration_id values (182-186) do not need to be hard-coded; I hope so. I did understand that the error message is saying that the configuration_id already exists, but I was not sure what to do about it.

[241 21]

I dont know about questions being moved, it just happened that I had just finished giving a post on the exact same error to someone else, when you happened to make your post so I thought it was quicker to send you to that reply.

 

yes you can treat them in the same fashion as the one in the post or you can manually change the numbers to have all of the queries id to run consecutive.

[Sam Hobbs 0]

Well, thank you for the help. I did try to find previous answers, but I limited the search and did not search this forum. So I would not have found the (your) other answer.

 

So the remaining records are now inserted and the Column Controller seems to be working now. My modifications to column_left.php and column_right.php are gone, of course; I expected that. So now I have my columns reset to the defaults and now I can proceed to modify the columns using the Column Controller. The Column Controller is under the Administration Tools, so as I said, it seems to be working.

 

This contribution does add some useful flexibility. I wonder if it can be generalized further; I see that there is coding that is specific to each box that perhaps could be generalized somehow. That is another possible project for me to add to my long list of things to try.

[241 21]

The position would not be afffected in the admin as this is relative to configuration_group table rather than the configuration table to which the error was reporting. ;)

 

It may not have shown in your search as there was not that much time between the other posting and your own post.

 

Anyway glad that you have things in hand now and good luck with your moding :D

[241 21]

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.

 

this is because there is more of the sql file that has not been run.

 

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''),');

[Sam Hobbs 0]

I have those entries. The problem is the existance of the php file, not the configuration data. 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.

 

The problem I encountered next is described in the other thread.

Edited August 26, 2004 by Sam Hobbs