Infobox admin installion for UK Based osCommerce 2.2rc2a

[wisdomlife]

Hello,

 

I have installed the UK version of oscommerce and want to install the Infobox Admin v2.26 add-on. I've followed the instructions for installation. But when I paste the files into the SQL text box in phpMyadmin or try importing, I get the following results for tep_cfg_select_option.sql and box_selection.sql respectively as follows:

 

Error

SQL query:

# Adds the function to select 'left' / 'right' from a

# radio box so we don't have to use the keyboard too much...

# Add new function colum

ALTER TABLE theme_configuration ADD set_function varchar( 255 ) NULL DEFAULT 'tep_cfg_select_option(array(\'left\', \'right\'),';

MySQL said:

#1060 - Duplicate column name 'set_function'

 

 

Error

SQL query:

# MySQL-Front Dump 2.5 # # Host: localhost Database: oscommerce # -------------------------------------------------------- # Server version 3.23.49-max-nt # # Table structure for table 'theme_configuration' # -- -- `theme_configuration` -- CREATE TABLE `theme_configuration` ( `configuration_id` int(11) NOT NULL auto_increment, `configuration_title` varchar(64) collate latin1_general_ci NOT NULL default '', `configuration_key` varchar(64) collate latin1_general_ci NOT NULL default 'BOX_HEADING_', `configuration_value` varchar(255) collate latin1_general_ci NOT NULL default '', `configuration_description` varchar(255) collate latin1_general_ci NOT NULL default '', `configuration_group_id` int(11) NOT NULL default '1', `configuration_column` varchar(64) collate latin1_general_ci NOT NULL default 'left', `location` int(5) NOT NULL default '0', `sort_order` int(5) default NULL, `last_modified` datetime default NULL, `date_added` dateti[...]

MySQL said:

#1050 - Table 'theme_configuration' already exists

 

I don't know whether these add-ons were integrated into the UK version of oscommerce (although there is nothing in my admin board to confirm this) or else I'm not doing something right - this is new territory for me. I'll appreciate your help. Thank you.

[johnnybebad]

Hello,

 

I have installed the UK version of oscommerce and want to install the Infobox Admin v2.26 add-on. I've followed the instructions for installation. But when I paste the files into the SQL text box in phpMyadmin or try importing, I get the following results for tep_cfg_select_option.sql and box_selection.sql respectively as follows:

 

Error

SQL query:

# Adds the function to select 'left' / 'right' from a

# radio box so we don't have to use the keyboard too much...

# Add new function colum

ALTER TABLE theme_configuration ADD set_function varchar( 255 ) NULL DEFAULT 'tep_cfg_select_option(array(\'left\', \'right\'),';

MySQL said:

#1060 - Duplicate column name 'set_function'

 

 

Error

SQL query:

# MySQL-Front Dump 2.5 # # Host: localhost Database: oscommerce # -------------------------------------------------------- # Server version 3.23.49-max-nt # # Table structure for table 'theme_configuration' # -- -- `theme_configuration` -- CREATE TABLE `theme_configuration` ( `configuration_id` int(11) NOT NULL auto_increment, `configuration_title` varchar(64) collate latin1_general_ci NOT NULL default '', `configuration_key` varchar(64) collate latin1_general_ci NOT NULL default 'BOX_HEADING_', `configuration_value` varchar(255) collate latin1_general_ci NOT NULL default '', `configuration_description` varchar(255) collate latin1_general_ci NOT NULL default '', `configuration_group_id` int(11) NOT NULL default '1', `configuration_column` varchar(64) collate latin1_general_ci NOT NULL default 'left', `location` int(5) NOT NULL default '0', `sort_order` int(5) default NULL, `last_modified` datetime default NULL, `date_added` dateti[...]

MySQL said:

#1050 - Table 'theme_configuration' already exists

 

I don't know whether these add-ons were integrated into the UK version of oscommerce (although there is nothing in my admin board to confirm this) or else I'm not doing something right - this is new territory for me. I'll appreciate your help. Thank you.

 

 

okay you got to phpmyadmin, so you can check the tables have the correct setup in them manually, but a duplicate or already exists error suggests that at least part of the information your trying to add already exists so you may need to check manually what you have and remove fromwhat you are trying to insert what you already have.

[wisdomlife]

okay you got to phpmyadmin, so you can check the tables have the correct setup in them manually, but a duplicate or already exists error suggests that at least part of the information your trying to add already exists so you may need to check manually what you have and remove fromwhat you are trying to insert what you already have.

 

Thanks a lot, Johnny. Checked and realised files were added. Everything okay. Suggestions appreciated!