Copied to clipboard

Flag this post as spam?

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


  • Jamie Attwood 147 posts 363 karma points
    Sep 12, 2013 @ 15:50
    Jamie Attwood
    0

    Error after successful install on Umbraco 4.11.9 with Contour 3.0.15

    Please help - I am getting an error after installation with Contour 3.0.15:

     

    Method not found: 'umbraco.DataLayer.ISqlHelper umbraco.DataLayer.DataLayerHelper.CreateSqlHelper(System.String, Boolean)'.

     

    The documentation suggests that this should be fine for 4.11.9.

    Thanks,

  • Tim Geyssens 6562 posts 15373 karma points MVP 2x c-trib
    Sep 12, 2013 @ 21:36
    Tim Geyssens
    0

    Downgrade to 3.0.14 for the moment, will look into the error next week

  • Jamie Attwood 147 posts 363 karma points
    Sep 12, 2013 @ 21:41
    Jamie Attwood
    0

    How, exactly do I downgrade? 

  • Andreas Kristensen 20 posts 79 karma points
    Sep 16, 2013 @ 14:18
    Andreas Kristensen
    0

    I have the same problem with the same version of umbraco, and the problem presists after doing the downgrade.

    I assume that to downgrade i simply download version 3.0.14 and extract its files to the root level of my site, overwriting the existing contour files.

    stack trace:

    [MissingMethodException: Method not found: 'umbraco.DataLayer.ISqlHelper umbraco.DataLayer.DataLayerHelper.CreateSqlHelper(System.String, Boolean)'.]
       Umbraco.Forms.Data.Helper.Connect(String connection) +0
       Umbraco.Forms.Data.Storage.FormStorage..ctor() +50
       Umbraco.Forms.UI.Dashboard.FormsDashboard.Page_Load(Object sender, EventArgs e) +1435
       System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +25
       System.Web.UI.Control.LoadRecursive() +71
       System.Web.UI.Control.LoadRecursive() +190
       System.Web.UI.Control.LoadRecursive() +190
       System.Web.UI.Control.LoadRecursive() +190
       System.Web.UI.Control.LoadRecursive() +190
       System.Web.UI.Control.LoadRecursive() +190
       System.Web.UI.Control.LoadRecursive() +190
       System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3064
    
  • Tim Geyssens 6562 posts 15373 karma points MVP 2x c-trib
    Sep 16, 2013 @ 14:19
    Tim Geyssens
    0

    Yeah just follow the same steps as you would on upgrade http://our.umbraco.org/projects/umbraco-pro/contour/documentation/Installation/Upgrade

  • Andreas Kristensen 20 posts 79 karma points
    Sep 16, 2013 @ 14:28
    Andreas Kristensen
    0

    Thanks for you reply Tim,

    I have followed the steps in the upgrade guide but the page at [My site]/umbraco/plugins/umbracocontour/upgrade.aspx
    Gives me the following error:

    [MissingMethodException: Method not found: 'umbraco.DataLayer.ISqlHelper umbraco.DataLayer.DataLayerHelper.CreateSqlHelper(System.String, Boolean)'.]
       Umbraco.Forms.Data.Helper.Connect(String connection) +0
       Umbraco.Forms.Data.Storage.FieldConditionStorage..ctor() +26
       Umbraco.Forms.UI.Pages.Upgrade.Page_Load(Object sender, EventArgs e) +122
       System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +25
       System.Web.UI.Control.LoadRecursive() +71 

    System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3064 

    3.0.15 game me the same error on the update page, and i therefore had the server guy run the manual SQL update script on the database, so that should also be in order unless there are database differences between .15 and .14

  • Jamie Attwood 147 posts 363 karma points
    Sep 16, 2013 @ 14:28
    Jamie Attwood
    0

    I was able to make 3.0.14 work finally by uninstalling .15 and re-installing 3.0.14. The install does not really completely install, so 1) run the install, (this will crash your entire website however with a YSOD) so you then need to manually remove the DLL's that dont' get removed by the uninstall (Umbraco.Forms.*****), then clean your webconfig by stripping out the assembly references that also don't get removed from the uninstall. Then install 3.0.14...

  • Andreas Kristensen 20 posts 79 karma points
    Sep 17, 2013 @ 11:55
    Andreas Kristensen
    0

    I tried doing as Jamie suggested but now i have no contour icon on the dashboard and the content page referances a missing  '/usercontrols/dashboards/ContactForm_logs.ascx'. 

    Not even sure where this came from since i do not have the file anywhere, neither in my backup of the old site or in any of the new manual installs.

    Installation guide tells me to insert them though, and i followed it step for step...

  • Andreas Kristensen 20 posts 79 karma points
    Sep 17, 2013 @ 12:08
    Andreas Kristensen
    0

    visiting the upgrade link now gives me this error:

    [SqlException (0x80131904): Foreign key 'FK_UFFieldConditions_UFFields' references invalid table 'UFFields'.
    Could not create constraint. See previous errors.]
       System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +404
       System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +412
       System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1363
       System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) +2899708
       System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +504
       System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +327
       Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) +167
       umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters) +171
    
    [SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteNonQuery]
       umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters) +371
       Umbraco.Forms.UI.Pages.Upgrade.Page_Load(Object sender, EventArgs e) +1498
       System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +25
       System.Web.UI.Control.LoadRecursive() +71
       System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3064
  • Jarred Reynolds 3 posts 23 karma points
    Sep 23, 2013 @ 12:58
    Jarred Reynolds
    0

    I encountered the same error when trying to upgrade from Contour v1.x to Contour v3.0.15 on an Umbraco v4.7.0 installation...

    Method not found: 'umbraco.DataLayer.ISqlHelper umbraco.DataLayer.DataLayerHelper.CreateSqlHelper(System.String, Boolean)'.

     

    I then uninstalled the Contour v1.x package through the Umbraco Repository and performed a fresh install of Contour, again through the Umbraco Respository (v3.0.15?), and received the same error.

    The good news is that extracting UmbracoContour_3.0.14_update.zip per Tim's instructions above seems to have corrected the issue.

  • 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