Copied to clipboard

Flag this post as spam?

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


  • Jonathan 1 post 71 karma points
    Jun 12, 2016 @ 03:23
    Jonathan
    0

    Broken Database Guid exception

    Hi,

    I tried to change the name of a Document Type and seem to have broken my site.

    Now whenever I try to click on a Document Type, I get an error "Server error: Contact administrator, see log for full details. Failed to retrieve content type"I tried to change the name of a Document Type and seem to have broken my site.

    If I try to click on a node in Content, I get the following error: "Server error: Contact administrator, see log for full details. Failed to retrieve data for content id 1078"

    Rendering the home page I get an exception: "System.FormatException: Unrecognized Guid format." and Stack Trace:

    [FormatException: Unrecognized Guid format.] System.GuidResult.SetFailure(ParseFailureKind failure, String failureMessageID, Object failureMessageFormatArgument, String failureArgumentName, Exception innerException) +3799640 System.Guid.TryParseGuid(String g, GuidStyles flags, GuidResult& result) +525 System.Guid..ctor(String g) +137

    etc etc.

    In AppdDataLogs I get:

    System.FormatException: Unrecognized Guid format. at System.Guid.GuidResult.SetFailure(ParseFailureKind failure, String failureMessageID, Object failureMessageFormatArgument, String failureArgumentName, Exception innerException) at System.Guid.TryParseGuid(String g, GuidStyles flags, GuidResult& result) at System.Guid..ctor(String g) at MySql.Data.Types.MySqlGuid.MySql.Data.Types.IMySqlValue.ReadValue(MySqlPacket packet, Int64 length, Boolean nullVal) at MySql.Data.MySqlClient.ResultSet.ReadColumnData(Boolean outputParms) at MySql.Data.MySqlClient.ResultSet.NextRow(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlDataReader.Read() at Umbraco.Core.Persistence.Database.

    And this is from the log file just before / while I was breaking it:

    2016-06-12 10:58:17,333 [P10300/D4/T529] INFO Umbraco.Core.Publishing.PublishingStrategy - Content 'Maritime Communications Field Engineer' with Id '1790' has been unpublished. 2016-06-12 10:58:18,608 [P10300/D4/T529] INFO umbraco.content - Loading content from database... 2016-06-12 10:58:18,709 [P10300/D4/T529] ERROR Umbraco.Core.Persistence.UmbracoDatabase - Database exception occurred System.FormatException: Unrecognized Guid format. at System.Guid.GuidResult.SetFailure(ParseFailureKind failure, String failureMessageID, Object failureMessageFormatArgument, String failureArgumentName, Exception innerException) at System.Guid.TryParseGuid(String g, GuidStyles flags, GuidResult& result) at System.Guid..ctor(String g) at MySql.Data.Types.MySqlGuid.MySql.Data.Types.IMySqlValue.ReadValue(MySqlPacket packet, Int64 length, Boolean nullVal) at MySql.Data.MySqlClient.ResultSet.ReadColumnData(Boolean outputParms) at MySql.Data.MySqlClient.ResultSet.NextRow(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlDataReader.Read() at Umbraco.Core.Persistence.Database.

    I've tried looking for bad records in the database (MySQL) but don't really know what to look for. Can anyone point me in the right direction please? Thanks in advance.

Please Sign in or register to post replies

Write your reply to:

Draft