Copied to clipboard

Flag this post as spam?

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


  • Craig100 1006 posts 2204 karma points c-trib
    Feb 25, 2015 @ 11:11
    Craig100
    0

    Many errors after upgrade to U7.2.2

    Having just completed an site upgrade from 7.2.1 to 7.2.2 I'm getting a few issues with Media uploads and Archetype data types. When I look in the trace logs I see a load of SEOChecker errors:-

    As a "for instance", the details of the error at the top of the list is:-

    SEOChecker: Error checking orphan nodes

    umbraco.DataLayer.SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteNonQuery ---> System.Data.SqlClient.SqlException: Invalid object name 'SEOChecker_Robots'.

       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

       at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)

       at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)

       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)

       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)

       at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)

       at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

       at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters)

       at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)

       at umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteNonQuery(String commandText, SqlParameter[] parameters)

       at umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters)

       --- End of inner exception stack trace ---

       at umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters)

       at SEOChecker.Core.Repository.Umbraco.UmbracoDocumentRepository.DeleteReferences(Int32 rootId, Boolean permanentDelete)

       at SEOChecker.Core.Repository.OrphanNodes.OrphanNodeRepository.RemoveOrphanNodes()

    Is it safe to remove and reinstall SEOChecker if it's already being used in pages? Or should I try reinstalling it over the existing installation? Or is there something obvious I have overlooked in the upgrade. I put back any SEOChecker related sections in /config/*.config files so hopefully I haven't missed anything.
    Any advice appreciated as this has happened shortly before going live. Had to upgrade as 7.2.1 also had media upload issues which were fixed in 7.2.2. Just need to get it going ;)
    Cheers,
    Craig
  • Richard Soeteman 3722 posts 11521 karma points MVP
    Feb 25, 2015 @ 11:17
    Richard Soeteman
    0

    Ah please add the SEOChecker-Robots database table manually then those errors should be gone

    Best,

    Richard

  • Craig100 1006 posts 2204 karma points c-trib
    Feb 25, 2015 @ 15:02
    Craig100
    0

    Oh, that table was removed to enable exporting the database to SQL Azure (https://our.umbraco.org/projects/website-utilities/seo-checker/bugs/61509-SQL-Azure-compatibility)  What should the table structure be, as I don't have it anymore? :(

    Will I have to remove and replace it each time I want to restore the Live DB? The issue was there was no clustered index.

    Regards,

    Craig

  • Craig100 1006 posts 2204 karma points c-trib
    Feb 25, 2015 @ 19:07
    Craig100
    0

    Ok, I trashed another site installing then uninstalling SEOChecker so I could script the Robots table and add it to the site I'm working on.  SEOChecker still appears to be preventing media uploads. The media does not upload and I get a red "not found: not found" indication on the left hand pane. 

    In the trace log I get the following error from SEOChecker.

    SEOChecker: Error in PageNotFound Module

    System.UriFormatException: Invalid URI: The hostname could not be parsed.

       at System.Uri.CreateThis(String uri, Boolean dontEscape, UriKind uriKind)

       at System.Uri..ctor(String uriString)

       at System.UriBuilder.get_Uri()

       at SEOChecker.Core.Extensions.UrlBuilderExtensions.ToUri(UrlBuilder builder)

       at SEOChecker.Core.Extensions.HttpContextExtensions.RawUri(HttpContext context)

       at SEOChecker.HttpModules.UrlModule.(Object , EventArgs )

    Is there a way out of this? Anything else I can check is there/not there, configuration, etc.?

    Thanks,

    Craig

  • Richard Soeteman 3722 posts 11521 karma points MVP
    Feb 26, 2015 @ 06:15
    Richard Soeteman
    0

    Hi Craig,

    You don't need to re-install SEO Checker. In the manual http://soetemansoftware.nl/seo-checker/downloads you find the install scripts.

    But what's more weird is the last error since it should parse your local url. If you use Fiddler or similar what files goes into error during upload?

    Best,

    Richard

  • Craig100 1006 posts 2204 karma points c-trib
    Feb 26, 2015 @ 10:04
    Craig100
    0

    Not used Fiddler (will look into) but the console in Chrome gives:-

     POST http://localhost:49168/umbraco/backoffice/UmbracoApi/Media/PostAddFile?origin=blueimp 404 (Not Found)jquery.min.js:6

    x.ajaxTransport.x.support.cors.e.crossDomain.sendjquery.min.js:6
    x.extend.ajaxjquery.fileupload.js:877
    $.widget._onSend.sendjquery.fileupload.js:939
    $.widget._onSendjquery-ui.min.js:5
    (anonymous function)jquery.fileupload.js:645
    $.widget._addConvenienceMethods.data.submitjquery.fileupload-angular.js:111
    (anonymous function)jquery.min.js:4
    (anonymous function)jquery.min.js:4
    x.Callbacks.ljquery.min.js:4
    x.Callbacks.c.fireWithjquery.min.js:4
    x.extend.Deferred.x.each.i.(anonymous function)jquery.min.js:4
    x.Callbacks.ljquery.min.js:4
    x.Callbacks.c.fireWithjquery.min.js:4
    x.extend.Deferred.x.each.i.(anonymous function)jquery.min.js:4
    x.Callbacks.ljquery.min.js:4
    x.Callbacks.c.fireWithjquery.min.js:4
    (anonymous function)jquery.min.js:4
    x.Callbacks.ljquery.min.js:4
    x.Callbacks.c.fireWithjquery.min.js:4
    x.extend.Deferred.x.each.i.(anonymous function)jquery.min.js:4
    x.Callbacks.ljquery.min.js:4
    x.Callbacks.c.fireWithjquery.fileupload-image.js:190
    $.widget.processActions.resizeImage.resolveload-image.all.min.js:1 g.onload

    Craig

  • Richard Soeteman 3722 posts 11521 karma points MVP
    Feb 26, 2015 @ 10:19
    Richard Soeteman
    0

    Hi Craig,

    That url should be ignored by default. What I think is that there will be some requests to appplugins etc that will be redirected, maybe add appplugins to the Umbraco ignored paths then SEO Checker should ignore that url.

    Best,

    Richard

  • Craig100 1006 posts 2204 karma points c-trib
    Feb 26, 2015 @ 12:59
    Craig100
    0

    I thought that these errors started after I'd upgraded from 7.2.1 to 7.2.2 but looking back several days in the trace logs I see they've been there for the last 3 weeks (from the 6th Feb to be exact). Build started on 4th Feb. SEOChecker enterprise licence added on the 10th Feb. List of installed packages is:-

    1. Archetype

    2. Config Tree

    3. Diplo Trace Log Viewer

    4. ezSearch

    5. nuPickers

    6. SEO Checker (licenced)

    7. Slimsy

    8. Umbraco Core Property Value Converters

    9. Umbraco Forms (licenced)

    Have now installed Fiddler and the only error shown is the  /umbraco/backoffice/UmbracoApi/Media/PostAddFile?origin=blueimp HTTP/1.1 with no response.  I don't  see the umbraco/backoffice/ directory in the solution so guess it's a routing controller.
    Added App_Plugins to ignored paths as suggested: <add key="umbracoReservedPaths" value="~/umbraco,~/install/,~/App_Plugins" /> but made no difference.
    Craig
  • Richard Soeteman 3722 posts 11521 karma points MVP
    Feb 26, 2015 @ 14:27
    Richard Soeteman
    0

    Really weird but great it's not the update. I assume you are using 1.8.1 of SEO Checker?

    I had one client reporting an issue in combination with ArcheType that i could not reproduce. maybe this is similar. Would it be possible maybe to share the environment so I can run it in debug mode? If that is possible please mail me direct richard@soetemansoftware.nl.

    Sorry for not having a solution directly.

    Best,

    Richard

  • Craig100 1006 posts 2204 karma points c-trib
    Feb 27, 2015 @ 00:18
    Craig100
    0

    Gave up with the upgrade after 2 days. Bit the bullet and totally rebuilt the site (thanks to uSync!).  Media issues fixed, but still getting loads of 

    SEOChecker: Error in HttpModule for url rewriting

     System.UriFormatException: Invalid URI: The hostname could not be parsed.

     at System.Uri.CreateThis(String uri, Boolean dontEscape, UriKind uriKin

    If it makes a difference I have set umbracoHideTopLevelNodeFromPath to True.

    The site will be multi-lingual.

    Craig

Please Sign in or register to post replies

Write your reply to:

Draft