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?
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!
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
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
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!
edit: doublepost..
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!!
is working on a reply...