InfoBox Admin problem

[cyberology]

Yes, it's sad but true, I have been fiddling under the bonnet with OSCommerce on Boxing Day ;)

 

Anyway, I was hoping someone might be able to help me. I'm running Os Commerce v2.2 RC2a and tried to install InfoBox Admin v2.26.

I've double checked that I've gone through the install correctly but unfortunately I'm getting the following message in Admin;

 

1146 - Table '********_osc1.theme_configuration' doesn't exist

 

select configuration_id, configuration_title, configuration_value, configuration_column, location, set_function from theme_configuration where configuration_group_id = '1' order by configuration_column, location

 

[TEP STOP]

 

plus this message on the test site;

 

Fatal error: Call to a member function add_current_page() on a non-object in /home/*********/public_html/includes/application_top.php on line 312

 

 

The referenced code on line 312 is;

 

$navigation->add_current_page();

 

I've combed the forums for help on other bugs I've encountered and it's come up trumps, but this one is stumping me. I've come across a couple of references to very similar errors but no solution to them. As a result I thought I'd ask here to see if anyone could point me in the right direction before I give up and roll back the site to before the install.

 

Thanks in advance!

[germ]

The error on line 312 I can help with.

 

Follow the links in my posts here: Click Me

[cyberology]

Interesting. I had assumed it was related to the problem with InfoBox Admin, although a refresh after relogging into Admin would cause the website to return temporarily .

Thanks for the info.

[germ]

About the other problem....

 

It appears you haven't successfully executed the MYSQL statements to add the table to the DB.

 

That's what it looks like to me.

[cyberology]

About the other problem....

 

It appears you haven't successfully executed the MYSQL statements to add the table to the DB.

 

That's what it looks like to me.

 

Oooooh, I could hug you! That's the pointer I needed- I've never worked with SQL before so didn't realise you had to do that. Steep learning curve for me :)

 

For posterity for anyone with the same problem, here's what I did;

 

To execute box_selection.sql-

 

If you have phpMyAdmin on your CPanel click on it and select the database used by OsCommerce (whatevernameyougaveit_osc1). Then select the sql tab at the top which will open a window. Copy and paste the contents of box_selection.sql into the window and click on Go.

You might get the same Error message I did;

 

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

 

...but if you refresh or log in to Admin you will find that InfoBox Admin is there and working.

 

That seems to have done the trick for me, fingers crossed.

[germ]

Well.... Gee.....

:blush:

 

I suppose if you're a hug wouldn't be totally out of the realm of possibility, but if you're could we just settle for a handshake?

:unsure:

 

:lol:

 

(Glad you have it sorted :thumbsup: )