Admin Info box

[will32]

Hi,

 

I am trying to install the admin info box. But i don't know how to install the sql part of this which is called box_selection.sql . Does any one know how this can be done

 

I use Cpanel and ms2

Thanks

[FrancineNJ]

Hi,

 

I am trying to install the admin info box. But i don't know how to install the sql part of this which is called box_selection.sql . Does any one know how this can be done

 

I use Cpanel and ms2

Thanks

 

 

How to install any sql files. Always backup first

 

Go to your cpanel. Find and click on MySql Database. I like to view it through a web based environment, so I then click on phpMyAdmin. Select your database on the left hand side. Select SQL from top.

 

At the bottom where it says "Or Location of the text file"....browse to where the sql file is then click "go".

 

If there is no problem, it will tell you across the top that it was executed correctly.

 

Hope this helps you.

 

Francine

[will32]

Hi,

 

Thanks for the help. Ok i followed the instructions and it created a section on my database called themes. But when i got os commerce admin i don't get the section. Any ideas.

 

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.

 

Thanks

[Anemic]

I almost have the same problem. I have the Infobox admin section, but the only thing there is Infobox admin no other 20 info box display options. I did the install, and I checked it again, but nothing...The big problem is this thread seems kinda dead

[Vier]

I'm trying to install InfoBox Admin into my OSC and the first step is:

 

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.

 

In phpMyAdmin, i select my database>SQL>Import files>Browse to my box_selection.sql>click go

 

And i got the following error

 

Error

 

SQL query:

 

CREATE TABLE theme_configuration(

configuration_id int( 11 ) NOT NULL AUTO_INCREMENT ,

configuration_title varchar( 64 ) NOT NULL default '',

configuration_key varchar( 64 ) NOT NULL default 'BOX_HEADING_',

configuration_value varchar( 255 ) NOT NULL default '',

configuration_description varchar( 255 ) NOT NULL default '',

configuration_group_id int( 11 ) NOT NULL default '1',

configuration_column varchar( 64 ) NOT NULL default 'left',

location int( 5 ) NOT NULL default '',

sort_order int( 5 ) default NULL ,

last_modified datetime default NULL ,

date_added datetime NOT NULL default '0000-00-00 00:00:00',

box_heading varchar( 64 ) NOT NULL default '',

PRIMARY KEY ( configuration_id )

) TYPE = MYISAM ;

 

MySQL said: Documentation

#1067 - Invalid default value for 'location'

 

Do anyone have an idea on how can i solve this?

[krobinson]

I had the same problem - I found an earlier verson of the contribution & made the change "location varchar(64) NOT NULL default ''," and I was able to complete the installation. http://www.oscommerce.com/forums/lofiversion/i...hp/t222144.html

 

Thanks,

Kristine

 

I'm trying to install InfoBox Admin into my OSC and the first step is:

 

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.

 

In phpMyAdmin, i select my database>SQL>Import files>Browse to my box_selection.sql>click go

 

And i got the following error

 

Error

 

SQL query:

 

CREATE TABLE theme_configuration(

configuration_id int( 11 ) NOT NULL AUTO_INCREMENT ,

configuration_title varchar( 64 ) NOT NULL default '',

configuration_key varchar( 64 ) NOT NULL default 'BOX_HEADING_',

configuration_value varchar( 255 ) NOT NULL default '',

configuration_description varchar( 255 ) NOT NULL default '',

configuration_group_id int( 11 ) NOT NULL default '1',

configuration_column varchar( 64 ) NOT NULL default 'left',

location int( 5 ) NOT NULL default '',

sort_order int( 5 ) default NULL ,

last_modified datetime default NULL ,

date_added datetime NOT NULL default '0000-00-00 00:00:00',

box_heading varchar( 64 ) NOT NULL default '',

PRIMARY KEY ( configuration_id )

) TYPE = MYISAM ;

 

MySQL said: Documentation

#1067 - Invalid default value for 'location'

 

Do anyone have an idea on how can i solve this?

[krobinson]

I am having an issue though, I have other customized infoboxes I need to display. On the admin side everything appears to be correct, and I have the infobox to show on the left side, however it does not appear at all. Any assistance on this will be GREATLY appreciated.

 

Thanks,

Kristine

[krobinson]

Now I feel stupid :blush: - I swear everytime I finally breakdown and make a post asking a question, I finally figure out what I was doing wrong. The reason it didn't work for me is cuz... where it asks for filename - i kept putting the entire file name. I was finally going to breakdown and just add the infobox manually, but thought I would take a look at the code and saw it adds the .php to it :D. Well on to my next problem!

 

Great contribution, it will save me lots and lots of time.

 

 

I am having an issue though, I have other customized infoboxes I need to display. On the admin side everything appears to be correct, and I have the infobox to show on the left side, however it does not appear at all. Any assistance on this will be GREATLY appreciated.

 

Thanks,

Kristine