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.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 ;)
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.
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.?
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.
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:-
Archetype
Config Tree
Diplo Trace Log Viewer
ezSearch
nuPickers
SEO Checker (licenced)
Slimsy
Umbraco Core Property Value Converters
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.
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 [email protected].
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()
Ah please add the SEOChecker-Robots database table manually then those errors should be gone
Best,
Richard
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
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
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
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
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
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:-
Archetype
Config Tree
Diplo Trace Log Viewer
ezSearch
nuPickers
SEO Checker (licenced)
Slimsy
Umbraco Core Property Value Converters
Umbraco Forms (licenced)
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 [email protected].
Sorry for not having a solution directly.
Best,
Richard
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
is working on a reply...