Whilst trying up upgrade to and from the afore mentioned versions, I've encountered the following error...
Invalid object name 'uCommerce_Role'.
This seems to be because the table called 'uCommerce_Role' is not a part of the version I'm trying to upgrade from however after trying to install the newer version of uCommerce onto a blank Umbraco site, the same error is present.
I've tried changing the user permissions for the database thinking it might not have access to create tables but so far with no avail.
I tried creating the tables manually but this just ends up with a null pointer exception during the install instead of the above.
Any help would be appreciated and thanks in advance, Luke
I'm running on MS SQL and the user has datareader, datawriter and ddladmin permissions set; there are also no errors int he database within umbracoLog.
You can enable "Acquire Payment" task in the ToCompleted pipeline to get it going automatically when the order moves from "New Order" to "Completed Order".
Upgrading uCommerce from 2.0.5.0 to 2.6.4.13067
Whilst trying up upgrade to and from the afore mentioned versions, I've encountered the following error...
Invalid object name 'uCommerce_Role'.
This seems to be because the table called 'uCommerce_Role' is not a part of the version I'm trying to upgrade from however after trying to install the newer version of uCommerce onto a blank Umbraco site, the same error is present.
I've tried changing the user permissions for the database thinking it might not have access to create tables but so far with no avail.
I tried creating the tables manually but this just ends up with a null pointer exception during the install instead of the above.
Any help would be appreciated and thanks in advance,
Luke
Like I said... Help would be appreciated. ;)
Does the user you have in your connection string have access to modify the database?
Are you running on SQL Server (not SQL CE, MySQL)?
Just noticed that you're doing an upgrade so please ignore my question about which database you're running on.
Any errors in umbracoLog?
I'm running on MS SQL and the user has datareader, datawriter and ddladmin permissions set; there are also no errors int he database within umbracoLog.
Were you able to get this going?
No, I ended up changing from sale to authorise in order to get a partial sale happening, I have to manually accept the payment from paypal.
You can enable "Acquire Payment" task in the ToCompleted pipeline to get it going automatically when the order moves from "New Order" to "Completed Order".
is working on a reply...