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.

Please Sign in or register to post replies

Write your reply to:

Draft