Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Deleting Error


austcoll

Recommended Posts

HI

I am using the 2.3.4 Edge version and when I try to delete and attribute I get this message!

1146 - Table 'aussieug_501.products_attributes_download' doesn't exist

delete from products_attributes_download where products_attributes_id = '1871'

[TEP STOP]

 

Any idea how I can remove or fix it?

Many thanks in advance

Mitchell

 

Link to comment
Share on other sites

That error is saying one of the database tables is missing. That table has been part of oscommerce for years so if it is missing from your installation, it must have been deleted at some point. You can run the following to create it but I would be concerned about what else has been altered.

CREATE TABLE products_attributes_download (
  products_attributes_id int NOT NULL,
  products_attributes_filename varchar(255) NOT NULL default '',
  products_attributes_maxdays int(2) default '0',
  products_attributes_maxcount int(2) default '0',
  PRIMARY KEY  (products_attributes_id)
) CHARACTER SET utf8 COLLATE utf8_unicode_ci;

 

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...