marianama Posted January 10, 2010 Posted January 10, 2010 (edited) Hi there, I met several problems since trying the installation of this useful add-on (Column controller. http://addons.oscommerce.com/info/1009 ). I tried it on a fresh v2.2rc2a for a few times and the following problem keep showing up: 1. Sql error: SQL query: INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` ) VALUES ( 182, 'Currencies Box', 'BOX_CURRENCIES_IS_ON', 'true', 'Would you like to display the Currencies Box?', 400, 40, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'tep_cfg_select_option(array(''true'', ''false''),' ) MySQL said: #1062 - Duplicate entry '182' for key 1 2. Modules disappeared: All payment/shipping/order total modules just disappeared in the admin cpanel as well as the frotend. In admin cpanel modules showed a line of text: TEXT_MODULE_DIRECTORY /home/www/mydomain.com/includes/modules/payment/ As you might notice, it showed "TEXT_MODULE_DIRECTORY" instead of like "payment modules". 3. Text error: Similar as above mentioned, ALL the text table headings in admin lead to an error. e.g. on the product admin page, the heading of the table was "TABLE_HEADING_CATEGORIES_PRODUCTS, TABLE_HEADING_STATUS, TABLE_HEADING_ACTION". In the admin-configuration list, the first item showed a long weird "BOX_CONFIGURATION_ADMINISTRATORS". For the No.1 problem, I tried to remove all the numbers (182,183,184,185,...) from the sql file so that it does not lead to an error. But I really don't know if it was the solution actually I don't know anything about coding and sql. And the No.2 and 3 problems are still not fixed. Would any one advise? Thank you. Mariana Edited January 10, 2010 by marianama Quote
Recommended Posts
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.