Copied to clipboard

Flag this post as spam?

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


These support forums are now closed for new topics and comments.
Please head on over to http://eureka.ucommerce.net/ for support.

  • Wietze Strik 27 posts 131 karma points
    Nov 13, 2012 @ 16:10
    Wietze Strik
    0

    Upgrading from 1.5 to 3.0

    I'm having some problems upgrading an uCommerce site from 1.5 to 3.0 in umbraco 4.7.0, which will also be upgraded to 4.10.0.

    I had some problems with log4net, but fixed those, now I get the error:

    could not execute query [ select cast(count(*) as INT) as col_0_0_ from uCommerce_Role role0_ ]

    I guess I'm missing a table.

    Can anybody help me what the best prctice is for upgrading. I Search for some releases in between but couldn't find them.

    Thx in advance

  • Søren Spelling Lund 1797 posts 2786 karma points
    Nov 13, 2012 @ 16:32
    Søren Spelling Lund
    0

    Hi Wietze,

    First you need to make sure that the user you're running the website under (the app pool identity) has permissions to modify the database schema.

    If that's in place uCommerce will be able to migrate your data to the latest version.

    If you site is built using the XSLT API it should continue working, but .NET custom code will have to be upgraded to the newer APIs and recompiled. 

  • Wietze Strik 27 posts 131 karma points
    Nov 13, 2012 @ 16:46
    Wietze Strik
    0

    HI Søren,

    thanks for your fast response.

    The db user defined in the connectionstring of the site is db owner. So I don't think that is the problem, or do I really need to give the network service user permissions? Because in my opinion this is only nessarey when I use integrated authentication.

  • Søren Spelling Lund 1797 posts 2786 karma points
    Nov 19, 2012 @ 11:01
    Søren Spelling Lund
    0

    These are the perms required to do the database updated.

    You can alternatively run the migrations manually. The process is straightforward:

    1) Locate the current schema version in table uCommerce_SystemVersion, e.g. 30

    2) Locate migration files in /umbraco/ucommerce/install

    3) Run migrations with a higher number than the current schema version, e.g. 31 - 93

    4) Update uCommerce_SystemVersion to the number of the last migration you ran, e.g 93

    Hope this helps.

Please Sign in or register to post replies

Write your reply to:

Draft