Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Oscommerce 'products_extra charge' Database Query Problem


jcbbuller

Recommended Posts

Hello,

 

I am trying to help a local company who uses Oscommerce as their E-Commerce platform. Their online store is currently having problems when connecting to the database and shows the following error.

 

1054 - Unknown column 'products_extra_charge' in 'field list'

 

select products_id, products_price, products_extra_charge, products_tax_class_id, products_weight from products where products_id='133

 

Does anyone know how I can go by fixing this problem? Unfortunately I do not have access to their Oscommerce administration panel but I do have access to their webadmin and the databases associated with their website. If it comes down to it I can always reinstall Oscommerce but I'd rather not have to.

 

Thanks!

Jake

Link to comment
Share on other sites

@@jcbbuller

 

 

It means either the database table has not been defined in the /includes/filenames.php OR, the table is missing from the database OR the query on the associated file is not correct.

 

EDIT: Just so you know, the 'Products_extra_charge' field is NOT a standard database table, so it was added using a contribution or custom coded.

 

 

Chris

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...