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 1182 posts 3441 karma points MVP 4x 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 Johansen 2560 posts 8256 karma points
    Apr 13, 2014 @ 09:46
    Anders Burla Johansen
    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 1182 posts 3441 karma points MVP 4x c-trib
    Apr 13, 2014 @ 13:07
    Bjarne Fyrstenborg
    0

    Thanks, it works great now! :)

    /Bjarne

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies