austcoll Posted September 18, 2017 Share Posted September 18, 2017 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 More sharing options...
Jack_mcs Posted September 18, 2017 Share Posted September 18, 2017 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 More sharing options...
austcoll Posted September 18, 2017 Author Share Posted September 18, 2017 Thank you very much. It worked. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.