Copied to clipboard

Flag this post as spam?

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


  • Bo Damgaard Mortensen 719 posts 1207 karma points
    May 17, 2011 @ 13:40
    Bo Damgaard Mortensen
    0

    Unable to convert MySQL date/time value to System.DateTime

    Hi all,

    I don't know if this is the right category. If it is, just let me know and I will remove it :-)

    I'm running a Umbraco 4.5.2 site on a MySQL database and yesterday it all crashed on me. The news section shows up just fine on the frontend, but I get an 500 server error when trying to expand the News section tree - i.e. it's not loading the news childnodes.

    When I try to access a mobile-backend-site I made I get the following error:

    Unable to convert MySQL date/time value to System.DateTime

    I realized that my host (UnoEuro.com) have updated phpmyadmin/MySQL to version 5.1.42 ( at least I think so since the phpmyadmin looks completely different now)

    Does this have something to do with the above error? Has anyone had these problems before?

    Any help is greatly appreciated!

    - Bo

  • Bo Damgaard Mortensen 719 posts 1207 karma points
    May 17, 2011 @ 15:03
    Bo Damgaard Mortensen
    0

    Solved it myself ;-)

    Turned out that the a DateTime cast from the mobile-backend site caused the document/node not to be created in the XMLDOCUMENT table in the database. After I deleted the nodes in the CMSDOCUMENT table it worked again!

  • Bo Damgaard Mortensen 719 posts 1207 karma points
    May 17, 2011 @ 15:46
    Bo Damgaard Mortensen
    0

    edit: doublepost..

  • nojaf 91 posts 300 karma points
    Nov 19, 2012 @ 15:42
    nojaf
    0

    I'm having the same error. I even delete all rows from those tables you mentioned but I still receive this error.

    Can anyone help me?

     

    Edit: If I put ConvertZeroDateTime=True; in my connectionstring, I don't get the error. However I typ something in my rich Text editor. It never saves it, it's always saying

     

    01/01/0001 00:00:00

     

    Please someone help me!!

  • 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