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.

  • Casper Andersen 126 posts 508 karma points
    Jan 20, 2015 @ 15:10
    Casper Andersen
    0

    Server error: Contact administrator, see log for full details. Failed to retrieve data for application tree uCommerce

    I use WebMatrix 3 to install Umbraco. Then the first thing i do is i go to the Developers section and add a local package which is Ucommerce for Umbraco 7 version 6.5, and after a bit it, installs fine, then i have to go to Users and click on my user and tick a checkbox to allow me to see the Ucommerce Icon, then i save it and reload the page. then the icon on the navigation tree on the left for ucommerce pops up and then i click on it,

    then i get this problem:

     

    Server error: Contact administrator, see log for full details.
    Failed to retrieve data for application tree uCommerce

    And nothing is shown.

    Any help here would be great

  • Casper Andersen 126 posts 508 karma points
    Jan 21, 2015 @ 12:27
    Casper Andersen
    0

    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
  • Martin 181 posts 740 karma points
    Jan 21, 2015 @ 18:48
    Martin
    0

    Hi Casper,

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

    Best regards Martin

  • Casper Andersen 126 posts 508 karma points
    Jan 21, 2015 @ 19:25
    Casper Andersen
    0

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

  • Jan Skovgaard 11280 posts 23678 karma points MVP 10x admin c-trib
    Jan 21, 2015 @ 19:38
    Jan Skovgaard
    1

    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

  • Casper Andersen 126 posts 508 karma points
    Jan 21, 2015 @ 19:42
    Casper Andersen
    0

    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 :)

  • Jan Skovgaard 11280 posts 23678 karma points MVP 10x admin c-trib
    Jan 21, 2015 @ 19:56
    Jan Skovgaard
    1

    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

  • Casper Andersen 126 posts 508 karma points
    Jan 21, 2015 @ 20:02
    Casper Andersen
    0

    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 ? :)

  • Jan Skovgaard 11280 posts 23678 karma points MVP 10x admin c-trib
    Jan 21, 2015 @ 20:13
    Jan Skovgaard
    101

    Hi Casper

    Yeah when you're seeing the Umbraco installation screen you need to click the "Customize" button next to the green "Installation" button. It can be hard to see sometimes, but it's there! :)

    Then you're asked about DB credentials and if you prefer installing a skin or not.

    But you don't necessarily need to make a new installation. You can use Webmatrix to migrate from CE SQL to another DB if you go to the lower left corner in Webmatrix and choose "Database" then click on the umbraco database. Then in the upper panel the "Migrate" button is activated so you can click it.

    Hope this makes sense.

    /Jan

  • Casper Andersen 126 posts 508 karma points
    Jan 21, 2015 @ 21:12
    Casper Andersen
    0

    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 :)

  • Jan Skovgaard 11280 posts 23678 karma points MVP 10x admin c-trib
    Jan 21, 2015 @ 21:23
    Jan Skovgaard
    0

    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

  • Casper Andersen 126 posts 508 karma points
    Jan 21, 2015 @ 22:21
    Casper Andersen
    0

    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 :)

  • Jan Skovgaard 11280 posts 23678 karma points MVP 10x admin c-trib
    Jan 22, 2015 @ 05:26
    Jan Skovgaard
    0

    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

  • Casper Andersen 126 posts 508 karma points
    Jan 22, 2015 @ 08:29
    Casper Andersen
    0

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

  • Jan Skovgaard 11280 posts 23678 karma points MVP 10x admin c-trib
    Jan 22, 2015 @ 08:34
    Jan Skovgaard
    0

    Hi Casper

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

    /Jan

Please Sign in or register to post replies

Write your reply to:

Draft