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.
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
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.
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.
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.
is working on a reply...