Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Stefan Bohlin 46 posts 168 karma points
    Apr 11, 2014 @ 16:13
    Stefan Bohlin
    0

    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?

  • Stefan Bohlin 46 posts 168 karma points
    Apr 11, 2014 @ 16:53
    Stefan Bohlin
    100

    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.

  • Bjarne Fyrstenborg 1282 posts 3994 karma points MVP 8x c-trib
    Apr 12, 2014 @ 20:39
    Bjarne Fyrstenborg
    0

    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

  • Anders Burla 2560 posts 8256 karma points
    Apr 13, 2014 @ 09:46
    Anders Burla
    1

    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

  • Bjarne Fyrstenborg 1282 posts 3994 karma points MVP 8x c-trib
    Apr 13, 2014 @ 13:07
    Bjarne Fyrstenborg
    0

    Thanks, it works great now! :)

    /Bjarne

Please Sign in or register to post replies

Write your reply to:

Draft