I have been trying to find a solution to this problem now for almost a whole day. I checked the log files directly after i installed Ucommerce and it says:

Exception:
System.Data.SqlServerCe.SqlCeException (0x80004005): There was an error parsing the query. [ Token line number = 1,Token line offset = 24,Token in error = FROM ]
   at System.Data.SqlServerCe.SqlCeCommand.ProcessResults(Int32 hr)
   at System.Data.SqlServerCe.SqlCeCommand.CompileQueryPlan()
   at System.Data.SqlServerCe.SqlCeCommand.ExecuteCommand(CommandBehavior behavior, String method, ResultSetOptions options)
   at System.Data.SqlServerCe.SqlCeCommand.ExecuteNonQuery()
   at SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters)
   ved SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters)
   ved SqlCE4Umbraco.SqlCEHelper.ExecuteNonQuery(String commandText, SqlCeParameter[] parameters)
   ved umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters)
2015-01-21 12:24:21,016 [42] INFO  umbraco.BusinessLogic.Log - [Thread 52] Redirected log call (please use Umbraco.Core.Logging.LogHelper instead of umbraco.BusinessLogic.Log) | Type: Error | User: 0 | NodeId: -1 | Comment: Error in Grant User Permission for App action for package uCommerce 6.5.3.14350 error:umbraco.DataLayer.SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteNonQuery ---> SqlCE4Umbraco.SqlCeProviderException: Error running NonQuery: 
SQL Statement:
DELETE umbracoUser2app FROM umbracoUser2app JOIN umbracoUser ON umbracoUser2App.[user] = umbracoUser.id WHERE umbracoUser.userLogin = @UserLogin AND umbracoUser2App.app = @AppName

Hi Casper,

You can't use uCommerce with SQL Compact Edition. You atleast need SQL Server Express version.

Best regards Martin

I am not using CE i am using the express edition :)

Hi Casper

Sorry for interupting...but did you setup database credentials when you installed Umbraco or did you just run the installer using the default theme? If so then you're using CE SQL unless you migrated the database from CE SQL to MSSQL afterwards.

Sorry if I sound silly but I have seen quite a few posts where people have been convinced that they installed on MSSQL and it then turned out it was CE SQL, which is default when running the new Umbraco installer.

So just double checking and since the error message is complaining about something CE SQL related it could look like it :)

/Jan

It's fine i am very happy for any advice you can give me :) But i install it with WebMatrix 3 and as one of the first things i am prompted to install it with SQL CE which does not require a password, and then there is the SQLExpress option which requires a password for the user "sa" which i found and provided and then continued so should be correct :)

Hi Casper

Ok...but do you see the database when you login using the MSSQL client?...It's a bit tricky when installing using Webmatrix since it asks for DB credentials up front etc. But when you then run the Umbraco installer when running the website for the first time it's not remembering the DB you chose...if that makes english?...The point is...if you just clicked the green "Install" button then you're using CE SQL :) Confusing? Yes indeed!

/Jan

Ahh When i check my WebMatrix Databases i see 2 the one created when i wrote my credentials its called Umbraco82 but the number changes for each installation this database has no tables in it.

And then one called Umbraco.sdf which contains the whole of Umbraco, sounds like this could be the problem, any idea how to not make it create the standard SQL CE an use the SQLExpress created in the first place ? :)

AWESOME. I tried this but it would not let me migrate, there where some problems and i decided to reinstall it, i found the customize button, but i am not sure what to do from here with setting up the database, i am guessing i have to do it with Microsoft SQL Server Managment and then create a database through there but i am very new to this so not quite sure what to do. But so far thanks a lot for helping me this far :)

Hi Casper

Well it should not matter - You should be able to use the "MSSQL" one even though you're connecting to an express version.

But in order to migrate from Webmatrix make sure that you stop the website first otherwise it will probably lock the site and then you're not able to migrate because the site is using the DB or something like that.

Hope this makes sense.

/Jan

BOOYA! :-D Now it works perfectly, what i did not realise, was as soon as the configuration was done the Database name username and password where shown to me so took a picture of them and then entered them at the customization page and it now works with Ucommerce and everything.

I want to thank all of you for a massive help since this was a job at school AND at my job :)

Hi Casper

Happy to hear you got it solved - Please mark this topic as solved so others can easily go to the post that contains the solution if they come across the same issue. :)

Cheers, Jan

sure, just cant seem to find the button where i close this thread.

Hi Casper

Out for each post there is a "mark as solution" button around the avatar somewhere :)

/Jan

is working on a reply...