SQL Error On Product Rate
Question: We purchased the Product Rate Shipping Extension for Magento
and when we try and save edits to products we are getting this error
SQLSTATE[42S22]: Column not found: 1054 Unknown column
'e.shipping_addon' in 'field list'". Any advice on how I can fix this?
We are using Magento v18.104.22.168. Thanks!
Answer: If you see this error after installing the extension then rebuild the flat product catalog in cache management.
This is because new attributes have been added to the product by the extension. You may also see this problem with other attributes. You should also disable your cache while you are still configuring Magento.
Removing/Upgrading Product Rate
If you have previously installed ProductRate or wish to completely remove ProductRate, please follow the below steps:
- Remove everything under
- Go into phpMyAdmin
- Bring up SQL prompt
SELECT * FROM core_config_data WHERE path LIKE "carriers/productrate%";
- Ensure values returned look correct (if in doubt be careful!)
DELETE FROM core_config_data WHERE path LIKE "carriers/productrate%";
SELECT * FROM core_resource WHERE code LIKE "productrate%";
- Ensure values returned are similar to version 0.0.1 and data_version 0.0.1
DELETE FROM core_resource WHERE path LIKE "productrate%";