Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Column Control Problems


ranted

Recommended Posts

I set up everything just the way the readme said to. I log into my admin interface and go to tools>column control. I get this error: Fatal error: Call to undefined function: tep_array_merge() in /home/bigwayco/public_html/catalog/admin/column_controller.php on line 96

 

any ideas?

thanks in advance.

Link to comment
Share on other sites

it sounds like you might have someting messed up from the install

 

also could you post the contents of your tool.php and i can take a look

 

could you post a link for the contrib and i will download to see what might be the problem

Link to comment
Share on other sites

i found the problem with column controller if your using this contrib http://www.oscommerce.com/community/contributions,169/page,3

 

its the database file this is to do with the database changes to the table configuration_group.

 

The value 15 for configuration_group_id is already in use by sessions.

 

I would try the following: (back up everything first)

 

hopefully you made a backup first if you did you can drop the database and upload the database again and use the code below to import

 

check the cofiguration_group in the database and see which is the last group number I change it to 18 since i have other mods installed

 

1) reverse out of your changes to the database (if you can't do this it might be easier to manually update as outlined below)

2) modify the first line of column_controller.sql in a text editor and change the number 14 to 18. (make sure you use a pure text editor - not MSword etc.)

3) modify the rest of the lines in column_controller.sql to change the 14 to 18 (it should be clear what to change - it is the fifth value in each line)

4) re-run database update

 

If not - you could just manually alter the appropriate values by editing the tables configuration and configuration_group using phpMyAdmin. you only need to change the configuration_group_id for column controller in the configuration_group table to 18 and then the configuration_group_id in the configuration table to 18 for those records associated with Column Controller. Reading column_controller.sql will show which records to change.

 

this is the correct database file log into your phpadmin and copy the following into sql box and and click go

 

INSERT INTO configuration_group (configuration_group_id,configuration_group_title,configuration_group_descrip
tion,sort_order,visible) VALUES ('18','Column Controller','Configure Column width which boxes will display and where.','18','0');
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Left Column Width','BOX_WIDTH_LEFT','125','How wide (in pixels) would you like the Left column boxes to be?','18','1','','','','');
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Right Column Width','BOX_WIDTH_RIGHT','125','How wide (in pixels) would you like the Right column boxes to be?','18','2','','','','');
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Left Column','COLUMN_LEFT_IS_ON','true','Would you like to display the Left Column?','18','3','','','','tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Right Column','COLUMN_RIGHT_IS_ON','true','Would you like to display the Right Column?','18','4','','','','tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Left Column in Right Column','COLUMN_LEFT_IS_ON_RIGHT','false','Would you like the Left Column to be displayed in the Right Column?','18','5','','','','tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Right Column in Left Column','COLUMN_RIGHT_IS_ON_LEFT','false','Would you like the Right Column to be displayed?','18','6','','','','tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Left Banner Box','BOX_BANNER_LEFT_IS_ON','false','Would you like to display a banner on the left?','18','7','','','','tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Left Banner Group','BANNER_LEFT_GROUP_IS','125x125','Which banner group would you like displayed?','18','8','','','','');
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Left Banner Box Column?','BOX_BANNER_LEFT_COLUMN','left','In which column would you like to display the Left Banner Box?','18','9','','','','tep_cfg_select_option(array(\'left\', \'right\', \'both\'),');
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Categories Box','BOX_CATAGORIES_IS_ON','true','Would you like to display the Categories Box?','18','10','','','','tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Categories Box Column?','BOX_CATAGORIES_COLUMN','left','In which column would you like to display the Categories Box?','18','11','','','','tep_cfg_select_option(array(\'left\', \'right\'),');
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Manufacturers Box','BOX_MANUFACTURERS_IS_ON','true','Would you like to display the Manufacturers Box?','18','12','','','','tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Manufacturers Box Column?','BOX_MANUFACTURERS_COLUMN','left','In which column would you like to display the Manufacturers Box?','18','13','','','','tep_cfg_select_option(array(\'left\', \'right\'),');
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Whats New Box','BOX_WHATS_NEW_IS_ON','true','Would you like to display the Whats New Box?','18','18','','','','tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Whats New Box Column?','BOX_WHATS_NEW_COLUMN','left','In which column would you like to display the Whats New Box?','18','15','','','','tep_cfg_select_option(array(\'left\', \'right\'),');
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Search Box','BOX_SEARCH_IS_ON','true','Would you like to display the Search Box?','18','18','','','','tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Search Box Column?','BOX_SEARCH_COLUMN','left','In which column would you like to display the Search Box?','18','17','','','','tep_cfg_select_option(array(\'left\', \'right\'),');
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Information Box','BOX_INFORMATION_IS_ON','true','Would you like to display the Information Box?','18','18','','','','tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Information Box Column?','BOX_INFORMATION_COLUMN','left','In which column would you like to display the Information Box?','18','19','','','','tep_cfg_select_option(array(\'left\', \'right\'),');
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Shopping Cart Box','BOX_SHOPPING_CART_IS_ON','true','Would you like to display the Shopping Cart Box?','18','20','','','','tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Shopping Cart Box Column?','BOX_SHOPPING_CART_COLUMN','right','In which column would you like to display the Shopping Cart Box?','18','21','','','','tep_cfg_select_option(array(\'left\', \'right\'),');
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Log In Box','BOX_LOGINBOX_IS_ON','true','Would you like to display the Log In Box?','18','22','','','','tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Log In Box Column?','BOX_LOGINBOX_COLUMN','right','In which column would you like to display the Log In Box?','18','23','','','','tep_cfg_select_option(array(\'left\', \'right\'),');
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Manufacturer Info Box','BOX_MANUFACTURER_INFO_IS_ON','true','Would you like to display the Manufacturer Info Box?','18','24','','','','tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Manufacturer Info Box Column?','BOX_MANUFACTURER_INFO_COLUMN','right','In which column would you like to display the Manufacturer Info Box?','18','25','','','','tep_cfg_select_option(array(\'left\', \'right\'),');
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Order History Box','BOX_ORDER_HISTORY_IS_ON','true','Would you like to display the Order History Box?','18','26','','','','tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Order History Box Column','BOX_ORDER_HISTORY_COLUMN','right','In which column would you like to display the Order History Box?','18','27','','','','tep_cfg_select_option(array(\'left\', \'right\'),');
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Best Sellers Box','BOX_BEST_SELLERS_IS_ON','true','Would you like to display the Best Sellers Box?','18','28','','','','tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Best Sellers Box Column?','BOX_BEST_SELLERS_COLUMN','right','In which column would you like to display the Best Sellers Box?','18','29','','','','tep_cfg_select_option(array(\'left\', \'right\'),');
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Product Notifications Box','BOX_PRODUCT_NOTIFICATIONS_IS_ON','true','Would you like to display the Product Notifications Box?','18','30','','','','tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Product Notifications Box Column?','BOX_PRODUCT_NOTIFICATIONS_COLUMN','right','In which column would you like to display the Product Notifications Box?','18','31','','','','tep_cfg_select_option(array(\'left\', \'right\'),');
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Specials Box','BOX_SPECIALS_IS_ON','true','Would you like to display the Specials Box?','18','32','','','','tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Specials Box Column?','BOX_SPECIALS_COLUMN','right','In which column would you like to display the Specials Box?','18','33','','','','tep_cfg_select_option(array(\'left\', \'right\'),');
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Reviews Box','BOX_REVIEWS_IS_ON','true','Would you like to display the Reviews Box?','18','34','','','','tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Reviews Box Column?','BOX_REVIEWS_COLUMN','right','In which column would ?you like to display the Reviews Box?','18','35','','','','tep_cfg_select_option(array(\'left\', \'right\'),');
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Tell a Friend Box','BOX_TELL_A_FRIEND_IS_ON','true','Would you like to display the Tell a Friend Box?','18','36','','','','tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Tell a Friend Box Column?','BOX_TELL_A_FRIEND_COLUMN','right','In which column would ?you like to display the Tell a Friend Box?','18','37','','','','tep_cfg_select_option(array(\'left\', \'right\'),');
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Languages Box','BOX_LANGUAGES_IS_ON','true','Would you like to display the Languages Box?','18','38','','','','tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Languages Box Column?','BOX_LANGUAGES_COLUMN','right','In which column would you like to display the Languages Box in the Left Column?','18','39','','','','tep_cfg_select_option(array(\'left\', \'right\'),');
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Currencies Box','BOX_CURRENCIES_IS_ON','true','Would you like to display the Currencies Box?','18','40','','','','tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Currencies Box Column?','BOX_CURRENCIES_COLUMN','right','In which column would you like to display the Currencies Box?','18','41','','','','tep_cfg_select_option(array(\'left\', \'right\'),');
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Right Banner Box','BOX_BANNER_RIGHT_IS_ON','false','Would you like to display the Currencies Box?','18','42','','','','tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Right Banner Group','BANNER_RIGHT_GROUP_IS','100X100','Which Banner Group would you like to display in the Right Banner Box?','18','43','','','','');
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Right Banner Box Column?','BOX_BANNER_RIGHT_COLUMN','right','In which column would you like to display the Right Banner Box?','18','44','','','','tep_cfg_select_option(array(\'left\', \'right\', \'both\'),');

Edited by asiabound
Link to comment
Share on other sites

  • 5 months later...

In admin/column_controller.php change:

 

gID=15 to gID= (your group ID number)

 

where configuration_group_id = 15 to where configuration_group_id = (your group ID number)

 

Now it will take you to Column Controller and not Sessions.

 

Hope this helps. ;)

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...