Copied to clipboard

Flag this post as spam?

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


  • Petr Snobelt 923 posts 1535 karma points
    Jan 16, 2011 @ 16:23
    Petr Snobelt
    0

    Bug on 4.6 and SQLCE

    Hello, I try to use FileManager in new umbraco with SQL CE and when I click on user, this error occured.

    Keyword not supported: 'datalayer'.

    It looks like its designed to works with default mssql only, will be great if you can update it to support datalayer

    Thanks 

    Petr

     

    Stack Trace:

    [ArgumentException: Keyword not supported: 'datalayer'.]
       System.Data.Common.DbConnectionOptions.ParseInternal(Hashtable parsetable, String connectionString, Boolean buildChain, Hashtable synonyms, Boolean firstKey) +6337982
       System.Data.Common.DbConnectionOptions..ctor(String connectionString, Hashtable synonyms, Boolean useOdbcRules) +134
       System.Data.SqlClient.SqlConnectionString..ctor(String connectionString) +103
       System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous) +35
       System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(String connectionString, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions) +253
       System.Data.SqlClient.SqlConnection.ConnectionString_Set(String value) +60
       Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) +68
       umbraco.DataLayer.SqlHelper`1.ExecuteScalar(String commandText, IParameter[] parameters) +152
    
    [SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteScalar]
       umbraco.DataLayer.SqlHelper`1.ExecuteScalar(String commandText, IParameter[] parameters) +360
       umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerTableUtility.GetTable(String name) +154
       umbraco.DataLayer.Utility.Table.DefaultTableUtility`1.ContainsTable(String name) +15
       Dascoba.Umb.FileManager.Support.DataHelper.AssureTableExists() +319
       Dascoba.Umb.FileManager.EditUserPageHandler.UmbracoPageInit(Object sender, EventArgs e) +438
       System.Web.UI.Control.InitRecursive(Control namingContainer) +133
       System.Web.UI.Control.InitRecursive(Control namingContainer) +421
       System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1954
  • Daniel Bardi 927 posts 2562 karma points
    Jan 16, 2011 @ 18:58
    Daniel Bardi
    0

    Current version does not work with 4.5 or 4.6.

    It's listed as working in 4.0 only!

  • Petr Snobelt 923 posts 1535 karma points
    Jan 16, 2011 @ 19:55
    Petr Snobelt
    0

     

    Yes but I hope you are working on new version which support v4.6.

    So I add this here to inform you that you should update it to support datalayer too, and not only new xml schema.

     

  • Daniel Bardi 927 posts 2562 karma points
    Jan 16, 2011 @ 20:31
    Daniel Bardi
    2

    I a m currently working on the next version ... should be released within a week.

    I'll check into the datalayer issue.

  • Petr Snobelt 923 posts 1535 karma points
    Jan 16, 2011 @ 20:33
    Petr Snobelt
    0

    Great news, thank you.

  • Daniel Bardi 927 posts 2562 karma points
    Jan 16, 2011 @ 20:35
    Daniel Bardi
    0

    I'm having an issue with the tree in 4.6.... I've posted a question but have not recieved an answer yet.

    Could you assist?  http://our.umbraco.org/forum/developers/extending-umbraco/16308-Custom-tree-is-not-rendering-in-461

  • Petr Snobelt 923 posts 1535 karma points
    Jan 16, 2011 @ 22:08
    Petr Snobelt
    0

    Sorry, I have not experience with tree in 4.6. I'm sure, you already read this http://our.umbraco.org/wiki/reference/backoffice-apis/tree-api-to-create-custom-treesapplications 

    Petr

  • Daniel Bardi 927 posts 2562 karma points
    Jan 19, 2011 @ 11:36
    Daniel Bardi
    1

    Tree issues are all resolved and working with 4.6.

    I'm ironing out a few javascript fixes (breaking changes from previous) and nailing down some additional features (i.e. archive extracting, etc...)

  • Petr Snobelt 923 posts 1535 karma points
    Jan 27, 2011 @ 13:21
    Petr Snobelt
    0

    Hi Daniel,

    Have you any new version, which I can test on SQLCE and umbreaco 4.6.1 ?

     

    Thank you

    Petr

  • Daniel Bardi 927 posts 2562 karma points
    Jan 27, 2011 @ 19:41
    Daniel Bardi
    0

    Here's a beta release... still have some javascript issues in places...  let me know if it installs.

    http://www.dascoba.com/media/created-packages/FileManager_2.0_beta.zip

     

  • Petr Snobelt 923 posts 1535 karma points
    Jan 30, 2011 @ 22:08
    Petr Snobelt
    0

    Hi Daniel 

    I install your package and update lang file in config directory, but FileManager's tree is empty :-(

    I try to look at config file and it looks like as admin I should see something, should I?

    I try Chrome and IE8 and it looks like there are no js error.

    Is there anything what I can check?

    Thanks

  • Daniel Bardi 927 posts 2562 karma points
    Jan 30, 2011 @ 22:33
    Daniel Bardi
    0

    Have you enabled the app for admin in the user section?

    Works fine in testing.

  • Daniel Bardi 927 posts 2562 karma points
    Jan 30, 2011 @ 22:44
    Daniel Bardi
    0

    Here are the package actions.. Can you see anything wrong?

    <Action runat="install" alias="addApplication" appName="FileManager" appAlias="fileman" appIcon="filemanager.png" />

    <Action runat="install" alias="addApplicationTree" silent="false" initialize="true" sortOrder="0" applicationAlias="fileman" treeAlias="fileman" treeTitle="File Manager" iconOpened="folder_o.gif" iconClosed="folder.gif" assemblyName="Dascoba.Umb.FileManager" treeHandlerType="loadFileManager" />

    <Action runat="install" alias="addApplicationTree" silent="false" initialize="true" sortOrder="1" applicationAlias="fileman" treeAlias="filemanRecycleBin" treeTitle="Recycle Bin" iconOpened="folder_o.gif" iconClosed="folder.gif" assemblyName="Dascoba.Umb.FileManager" treeHandlerType="loadRecycleBin" />

    Here's the database records:

    App Table

    AppTree table

  • Daniel Bardi 927 posts 2562 karma points
    Jan 30, 2011 @ 23:08
    Daniel Bardi
    1

    I discovered the problem.. I forgot to include the assembly in the zip... :(  It was late when I did it.

    Uninstall and download the latest beta again here:

    http://www.dascoba.com/media/created-packages/FileManager_2.0_beta.zip

  • Petr Snobelt 923 posts 1535 karma points
    Jan 31, 2011 @ 20:16
    Petr Snobelt
    0

    Still without luck :-( 

    I uninstall and install new file, then I want go to user's section to allow fileManager and error (about datalayer) occured. I post stack trace, because it has filemanager in it. 

    [ArgumentException: Keyword not supported: 'datalayer'.]
       System.Data.Common.DbConnectionOptions.ParseInternal(Hashtable parsetable, String connectionString, Boolean buildChain, Hashtable synonyms, Boolean firstKey) +6337982
       System.Data.Common.DbConnectionOptions..ctor(String connectionString, Hashtable synonyms, Boolean useOdbcRules) +134
       System.Data.SqlClient.SqlConnectionString..ctor(String connectionString) +103
       System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous) +35
       System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(String connectionString, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions) +253
       System.Data.SqlClient.SqlConnection.ConnectionString_Set(String value) +60
       Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) +68
       umbraco.DataLayer.SqlHelper`1.ExecuteScalar(String commandText, IParameter[] parameters) +152
    
    [SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteScalar]
       umbraco.DataLayer.SqlHelper`1.ExecuteScalar(String commandText, IParameter[] parameters) +360
       umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerTableUtility.GetTable(String name) +154
       umbraco.DataLayer.Utility.Table.DefaultTableUtility`1.ContainsTable(String name) +15
       Dascoba.Umb.FileManager.Support.DataHelper.AssureTableExists() in \\psf\Home\Documents\Visual Studio 2010\Projects\Dascoba.Umbraco\Dascoba.Umb.FileManager.45\Support\DataHelper.cs:71
       Dascoba.Umb.FileManager.EditUserPageHandler.UmbracoPageInit(Object sender, EventArgs e) in \\psf\Home\Documents\Visual Studio 2010\Projects\Dascoba.Umbraco\Dascoba.Umb.FileManager.45\EditUserPageHandler.cs:62
       System.Web.UI.Control.InitRecursive(Control namingContainer) +133
       System.Web.UI.Control.InitRecursive(Control namingContainer) +421
       System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1954

     

    It may be similar to this error, meybe it helps you http://our.umbraco.org/projects/starter-kits/standard-website/bugs/15234-Keyword-not-supported-'datalayer' 

    Petr

     

  • Daniel Bardi 927 posts 2562 karma points
    Jan 31, 2011 @ 21:50
    Daniel Bardi
    0

    Yeah.. I suspect SQLCE has a problem (the same issues that I used to have with VistaDB).

    I would recommend adding the app and appTree records manually.

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies