Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Recommended Posts

Posted (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".

5233528720100110173717043.jpg

 

 

In the admin-configuration list, the first item showed a long weird "BOX_CONFIGURATION_ADMINISTRATORS".

 

5233528720100110173657036.jpg

 

 

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 by marianama

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...