Invalid column name 'PricesIsSpecifiedWithVat'. after update
Earlier today i updated Tea Commerce to version 2.3.0 from 2.2.3 and now i'm getting YSOD's everywhere.
Invalid column name 'PricesIsSpecifiedWithVat'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Invalid column name 'PricesIsSpecifiedWithVat'.
Seems like it's a DB problem. Where do i need to add this Column?
I also have this issue when upgrading from v. 2.2.3 to v. 2.3.0
Shouldn't the Tea Commerce installer update the database table with this additional column, when upgrading Tea Commerce?
It's a bit critical when it isn't added cause it breaks existing razor script e.g. minicart. The revision history http://documentation.teacommerce.net/revision-history/ tells it's a new feature: NEW: Prices can be entered with VAT into Umbraco
but isn't it more breaking change, when it change the database (add a new column)? or at least highlight or write a note about this :)
Invalid column name 'PricesIsSpecifiedWithVat'. after update
Earlier today i updated Tea Commerce to version 2.3.0 from 2.2.3 and now i'm getting YSOD's everywhere.
Seems like it's a DB problem. Where do i need to add this Column?
I fixed it by adding PricesIsSpecifiedWithVat column in TeaCommerce_Store
It's a bit with 0 as default value and not null - in case anyone runs into the same problem.
I also have this issue when upgrading from v. 2.2.3 to v. 2.3.0
Shouldn't the Tea Commerce installer update the database table with this additional column, when upgrading Tea Commerce?
It's a bit critical when it isn't added cause it breaks existing razor script e.g. minicart.
The revision history http://documentation.teacommerce.net/revision-history/ tells it's a new feature:
NEW: Prices can be entered with VAT into Umbraco
but isn't it more breaking change, when it change the database (add a new column)? or at least highlight or write a note about this :)
/Bjarne
There was a bug in the install script - it has been fixed and the fresh and working version of 2.3.0 is now available at http://our.umbraco.org/projects/website-utilities/tea-commerce/
Thanks for reporting this!
Kind regards
Anders
Thanks, it works great now! :)
/Bjarne
is working on a reply...