|
I just completed updating from 1.5.1.0 to 1.6.1.0. I did the usual precautions of turning off the cache, cleared the cache and sessions, and installed from the shell.
When I tried to open the site (and trigger the DB update) I started getting errors. Here is the first error.
Error in file: “path-to-root/app/code/core/Mage/Sales/sql/sales_setup/mysql4-upgrade-1.5.9.9-1.6.0.0.php” - Column “base_shipping_hidden_tax_amount” does not exists on table “sales_flat_invoice”
I changed the field base_shipping_hidden_tax_amount in table sales_flat_invoice back to base_shipping_hidden_tax_amount from base_shipping_hidden_tax_amnt and changed the code in app/code/core/Mage/Sales/sql/sales_setup/mysql4-upgrade-1.5.9.9-1.6.0.0.php so that it didn’t change the field name. I then proceeded to the get all the following errors and make the same change until the site finally loaded.
So far it seems to run fine (serious testing is next), but what I want to know is if I am messing up the site for future updates or modules?
There must have been a reason that the field names were changed, but it appeared that part of the update was not notified of these field name changes. I’ve been searching for hours for a solution to this and it concerns me that my I didn’t see this solution else ware. (I saw the problem a few times)
Column “base_shipping_hidden_tax_amount” does not exists on table “sales_flat_invoice”
Column “base_shipping_hidden_tax_amount” does not exists on table “sales_flat_creditmemo”
Column “base_shipping_hidden_tax_amount” does not exists on table “sales_flat_quote_address”
Column “forced_do_shipment_with_invoice” does not exists on table “sales_flat_order”
Column “payment_authorization_expiration” does not exists on table “sales_flat_order”
Column “number” does not exists on table “sales_flat_shipment_track”
Thanks!
|
