Infobox Admin v2.25-need help-update SQL

[gartex]

Hi. I need to install infobox Admin. I downloaded v.2.25 but I'm confused. The info says update the sql, but doesn't say how. it says:

 

UPDATE SQL 2.24 to 2.25

=============

for use set_function to edit 'left' and 'right' :

(update by Thomas Schittli 31.7.2006)

 

Execute the SQL Script

update for tep_cfg_select_option.sql

 

This should add the new column set_function

to theme_configuration and define for all

rows the default value

'tep_cfg_select_option(array(\'left\', \'right\'),'

 

AND THIS:

 

1 - Database modification

-------------------------

 

Run the included box_selection.sql on your catalog database. This will add the new section to the administration interface. Load up the admin interface and look around. You should now have a shiny new section AT THE BASE OF THE RIGHT COLUMN called "InfoBox Admin", with the 20 info box display options in that subsection. But they won't do anything - yet.

 

I don't know where to put these? Please help! Thanks.

[dmnalven]

These are "put" into a SQL window in a front end such as phpmyadmin or run directly on a database server from the command line as mysql arguments.

[gartex]

These are "put" into a SQL window in a front end such as phpmyadmin or run directly on a database server from the command line as mysql arguments.

 

 

Thanks. I have - MySQL DataBases / MySQL DataBase Wizard / phpMyAdmin - could you explain which of these to use & how to do this? Thanks so much!

[♥geoffreywalton]

Try this link

 

http://www.oscommerce.com/forums/index.php?showtopic=274968

[gartex]

Try this link

 

http://www.oscommerce.com/forums/index.php?showtopic=274968

 

 

here's where I am in the install info:

 

UPDATE SQL 2.24 to 2.25

=============

for use set_function to edit 'left' and 'right' :

(update by Thomas Schittli 31.7.2006)

 

Execute the SQL Script

update for tep_cfg_select_option.sql

 

This should add the new column set_function

to theme_configuration and define for all

rows the default value

'tep_cfg_select_option(array(\'left\', \'right\'),'

...............................................................................

 

1 - Database modification

-------------------------

 

Run the included box_selection.sql on your catalog database. This will add the new section to the administration interface. Load up the admin interface and look around. You should now have a shiny new section AT THE BASE OF THE RIGHT COLUMN called "InfoBox Admin", with the 20 info box display options in that subsection. But they won't do anything - yet.

..............................................................................

 

I followed these instructions from your link:

 

24. I have installed a contribution but the instructions tell me to alter the database with the supplied SQL file. How do I do that?

Most hosting packages include a utility called phpMyAdmin and that is where you can make your database alterations.

From your host's control panel, locate the link to phpMyAdmin. Once inside, select your database from the drop down menu in the left column. Now you have 2 choices. Either click on the "Import" tab at the top of the screen, navigate to the contribution SQL file and click "Go" or, click on the "SQL" tab, also top of the screen, copy the SQL file content and paste into the text area and then click the "Go" button. Either way is good.

 

I have 2 problems:

 

1. when I tried to install update for tep_cfg_select_option.sql I got this error message:

 

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'

................................................................................

.

 

and,

 

2. I installed box_selection.sql but I don't see the "shiny new section AT THE BASE OF THE RIGHT COLUMN called "InfoBox Admin", with the 20 info box display options in that subsection."

 

I looked all around & couldn't see any difference. Please help. Thanks.