Originally Posted by chris32882 Alright, I backed up my database and tried inputing the above in a query and this is what I get returned #1146 - Table 'tms_zc1-back-1226445866.products' doesn't exist Do your tables have a prefix? If so, try adding your prefix to the front of the table name like this: update sometableprefix_products set products_tax_class_id = 1
Originally Posted by edadk Do your tables have a prefix? If so, try adding your prefix to the front of the table name like this: update sometableprefix_products set products_tax_class_id = 1 have no idea man , don't really mess with sql much, hrmmm
Originally Posted by chris32882 have no idea man , don't really mess with sql much, hrmmm In that case it might be better to stick with using admin to change each product individually. Ed
Originally Posted by edadk In that case it might be better to stick with using admin to change each product individually. Ed its like any other installation of Zen-Cart the prefix should be the same Im assuming?
Just want you to know the prefix was zen I added: Code: update zen_products set products_tax_class_id = 1 now should it of been update products set products_tax_class_id = 1 normally
update zen_products set products_tax_class_id = 1
Forum Rules