need help installing "infobox admin" contribution

[pugs421]

Step 1 of the installation readme states

"Run the included box_selection.sql on your catalog database. "

 

I did this from the PhpMyAdmin. After that, according to the instructions, a new set of options are supposed to be found on the admin controll panel.

I cant find them. If anyone has installed this contribution and has an idea of what I'm doing wrong or what I'm missing please let me know. Thanks.

[Guest]

pugs421

 

You will need to complete all the below to administer the boxes

 

2 - PHP editing ADMIN

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





STEP 1.



copy all files to their respective folders





STEP 2.



open file adminincludescolumn_left.php 

and add the following



 require(DIR_WS_BOXES . 'info_boxes.php');





STEP 2.

open file admin/includes/application_top.php



and add the following 



 define('FILENAME_INFOBOX_CONFIGURATION', 'infobox_configuration.php');

 define('FILENAME_POPUP_INFOBOX_HELP', 'popup_infobox_help.php');

also



 define('TABLE_THEME_CONFIGURATION', 'theme_configuration');



STEP 3.



open file adminincludeslanguagesenglish.php



and add the following:





// Boxes box text in includes/boxes/info_boxes.php

define('BOX_HEADING_BOXES', 'Infobox Admin');

 

If after doing the above you still can't find the link in admin let me know.

[pugs421]

oh ok. in the directions it says that I should see the controlls in the admin panel after step 1 so I didnt want to continue if I did step 1 wrong. Thanks. Ill try that.

[pugs421]

It still didn't work. Actually , after I transferred the files to their folders I get the following error message when viewing the default page of osc:

 

1146 - Table 'smart1_shop.TABLE_THEME_CONFIGURATION' doesn't exist

 

select configuration_column as cfgcol, configuration_title as cfgtitle, configuration_value as cfgvalue, configuration_key as cfgkey, box_heading from TABLE_THEME_CONFIGURATION order by location

 

[TEP STOP]

 

I dont get this message after I run the box_selection.sql on the database, only when the files are transferred to their respective folders. I was hoping the message would go away after the changes to the code were made but it didnt.

 

I really appreciate the help. I hope the error message gives you an idea of what I might be doing wrong.

[Guest]

The reason for the error is the last define here.

Have you input this into the file below?

If you have take a closer look to see there are no typo mistakes.

 

 

STEP 2.

open file admin/includes/application_top.php



and add the following 



 define('FILENAME_INFOBOX_CONFIGURATION', 'infobox_configuration.php');

 define('FILENAME_POPUP_INFOBOX_HELP', 'popup_infobox_help.php');

also



 define('TABLE_THEME_CONFIGURATION', 'theme_configuration');

[pugs421]

I double checked and there doesnt seem to be any errors.

 

  define('TABLE_SESSIONS', 'sessions');

 define('TABLE_SPECIALS', 'specials');

 define('TABLE_TAX_CLASS', 'tax_class');

 define('TABLE_TAX_RATES', 'tax_rates');

 define('TABLE_THEME_CONFIGURATION', 'theme_configuration');

 define('TABLE_WHOS_ONLINE', 'whos_online');

 define('TABLE_ZONES_TO_GEO_ZONES', 'zones_to_geo_zones');

 define('TABLE_ZONES', 'zones');

 

Was the new box of options supposed to show up in admin panel after step 1 was completed? Maybe something went wrong there? Thanks again for your help.

[pugs421]

As far as troubleshooting, I tried to install the "info box display" contribution that "infobox admin" was based on. It also stated that after step 1 a "shiny new subsection under 'Configuration' called 'Info Box Selection' will be added to the admin controll panel. Well I ran the info-box-display.sql file on the database and the new subsection is still not there.

 

Could it be something on my server that is causing the problem?

 

This is my first time "running files on a database" but I'm sure I followed the directions given to me in another post.

 

PhpMyAdmin:

 

select the database for OSC>hit the SQL tab on top>select the file to run using the browse button> hit GO.

 

I have reinstalled OSC several times trying the same thing to no avail. Any thoughts to why this is happenening would be great.

 

I appreciate the work you (and others) put into these contributions and understand that 'customer support' is not in your best interest. I would be more than happy to donate to you paypal if you could help me get to the bottom of this problem as it would make this project much easier for me. Thanks again.

[pugs421]

Well I actually got the new set of options to come up for the infobox display contribution. According to the readme files the options appear in a different place than the options for your contribution.

 

Is the options for your contribution supposed to appear on the first page of admin controll panel? For the other contribution you have to go to configuration. I'm sure the problem isn't that I'm just not seeing the new box of options, but at this point I'm grasping at straws.

[Guest]

pugs421

 

I can see you are having trouble installing this contribution!

I have PM'd you with a link to download Ian wilson's loaded5 snapshot with this installed.

Hope this of benefit to you.

If not do you have a link I can view your work?

I might be able to see where you are going wrong, or maybe install for you.

 

By the way a donation is not necessary to recieve help this comes free:!:

[Guest]

hi lango,

 

I was wondering if you help me on this..

 

this is a really good contibution, I was about to attempt a project like this but then came across this, much better then what I planned anyway.

 

I installed it, everything is fine --> works tops!

 

anyway i just have a question, is it possible to have the Left and Right options set-up like Activate Box and De-Activate, on - off, by selecting the dot.... rather then typing in the words Left or Right , I also attempted to alter it to work like that and to also include the red and green dots for left and right quick changes, but its got me stumped.

 

$value_field_value = (tep_cfg_select_option(array('yes', 'no'),$cInfo->configuration_value));

 

$value_field_column = tep_draw_input_field('configuration_column', $cInfo->configuration_column);

 

this is the part the create the o yes o no

 

$value_field_value = (tep_cfg_select_option(array('yes', 'no'),$cInfo->configuration_value));

 

$value_field_column = (tep_cfg_select_option(array('left', 'right'),$cInfo->configuration_column));

 

It almost worked i got:

 

Activate this box?

o yes o no

 

Which column?

o left o right

 

only problem was --> I could only select 1 of dots out of the 4, not what I was hoping for, i wanted to be select one from o yes o no AND select 1 from o left o right,

 

A view source revealed all dots are called configuration_value --> the reason i could only select one..

 

any ideas.

Cheers Lee

[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?

[swamyg1]

I am getting the exact same errors!!!

[ramstainedglass]

Did anybody figure out how to do this? I need to know how to do it!

[Guest]

Hi,

 

I'm stuck with this as well. ..been stuck for 2 hours!

 

I've run the SQL on the database and it said it was executed correctly.

Now I'm supposed to have the new section on admin interface ....but haven't!

 

...anyone any idea?

 

Thanks

Jackie

:)

[Guest]

...me again.

 

I've followed all the instructions and now have the ability to change the boxes in my admin but what I changed doesn't actually change on the site.

 

Does anyone know which part I may have done wrong?

 

Thanks

Jackie

:)

[guy7]

I have a different problem. I installed the sql and all the necessary files but now when i access my shop, the entire shop appears within the content section of the page?

 

So at present i have the frame of an oscommerce page with a category drop box and then down the left and right columns i have the php tags (i.e. $catergorybox, cartbox etc)and then within the content section a fully working page with the header section again and then working info boxes?!

 

Can anyone help? I'm guessing i perhaps put a line of text somewhere i shouldn't of when installing the add on?

 

Any help would be much appreciated!