Server Error in '/' Application.

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

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: MySql.Data.Types.MySqlConversionException: Unable to convert MySQL date/time value to System.DateTime

Source Error:


Line 3:  Dim db = Database.Open("qcms")
Line 4:  Dim Articles=db.querysingle("select articles.*,i.image,c.Name as CountryName from articles LEFT JOIN countries c ON articles.CountryCode=c.Code LEFT JOIN images i on articles.ArticleID=i.ArticleID where articles.ArticleID=@0 and articles.language=@1 and articles.isactive ORDER BY i.IsMain DESC, WhenPosted DESC LIMIT 6;",PageData("QPage_RecordID"),PageData("QPage_Language"))
Line 5:  Dim Images=db.query("select images.* from images where images.ArticleID=@0 /*and articles.language=@1*/ and images.isactive and not images.ismain ORDER BY SortingOrder,ImageID;",PageData("QPage_RecordID"),PageData("QPage_Language"))
Line 6:  Dim myImage, myThumb, myAuthor, myPlace, myImageG, myThumbG as string
Line 7:  myImage=Articles.Image & ""

Source File: C:\inetpub\wwwroot\madredelbuonconsiglio.it\baseroot\Quantium\QCMS\Templates\divinity\Include\_content_articles_content_page_form.vbhtml    Line: 5

Stack Trace:


[MySqlConversionException: Unable to convert MySQL date/time value to System.DateTime]
   MySql.Data.Types.MySqlDateTime.GetDateTime() +204
   MySql.Data.MySqlClient.MySqlDataReader.GetValue(Int32 i) +504
   MySql.Data.MySqlClient.MySqlDataReader.GetValues(Object[] values) +80
   System.Data.Common.DbEnumerator.MoveNext() +107
   WebMatrix.Data.<QueryInternal>d__0.MoveNext() +311
   System.Collections.Generic.List`1..ctor(IEnumerable`1 collection) +453
   System.Linq.Enumerable.ToList(IEnumerable`1 source) +73
   WebMatrix.Data.Database.Query(String commandText, Object[] parameters) +131
   ASP._Page_Quantium_QCMS_Templates_divinity_Include__content_articles_content_page_form_vbhtml.Execute() in C:\inetpub\wwwroot\madredelbuonconsiglio.it\baseroot\Quantium\QCMS\Templates\divinity\Include\_content_articles_content_page_form.vbhtml:5
   System.Web.WebPages.WebPageBase.ExecutePageHierarchy() +252
   System.Web.WebPages.WebPage.ExecutePageHierarchy(IEnumerable`1 executors) +99
   System.Web.WebPages.WebPage.ExecutePageHierarchy() +185
   System.Web.WebPages.WebPageBase.ExecutePageHierarchy(WebPageContext pageContext, TextWriter writer, WebPageRenderingBase startPage) +122
   System.Web.WebPages.<>c__DisplayClass3.<RenderPageCore>b__2(TextWriter writer) +309
   System.Web.WebPages.WebPageBase.Write(HelperResult result) +108
   ASP._Page_Quantium_QCMS_Templates_divinity_Include__content_articles_content_page_vbhtml.Execute() in C:\inetpub\wwwroot\madredelbuonconsiglio.it\baseroot\Quantium\QCMS\Templates\divinity\Include\_content_articles_content_page.vbhtml:6
   System.Web.WebPages.WebPageBase.ExecutePageHierarchy() +252
   System.Web.WebPages.WebPage.ExecutePageHierarchy(IEnumerable`1 executors) +99
   System.Web.WebPages.WebPage.ExecutePageHierarchy() +185
   System.Web.WebPages.WebPageBase.ExecutePageHierarchy(WebPageContext pageContext, TextWriter writer, WebPageRenderingBase startPage) +122
   System.Web.WebPages.<>c__DisplayClass3.<RenderPageCore>b__2(TextWriter writer) +309
   System.Web.WebPages.WebPageBase.Write(HelperResult result) +108
   ASP._Page_Quantium_QCMS_Templates_divinity_Include__content_articles_content_vbhtml.Execute() in C:\inetpub\wwwroot\madredelbuonconsiglio.it\baseroot\Quantium\QCMS\Templates\divinity\Include\_content_articles_content.vbhtml:11
   System.Web.WebPages.WebPageBase.ExecutePageHierarchy() +252
   System.Web.WebPages.WebPage.ExecutePageHierarchy(IEnumerable`1 executors) +99
   System.Web.WebPages.WebPage.ExecutePageHierarchy() +185
   System.Web.WebPages.WebPageBase.ExecutePageHierarchy(WebPageContext pageContext, TextWriter writer, WebPageRenderingBase startPage) +122
   System.Web.WebPages.<>c__DisplayClass3.<RenderPageCore>b__2(TextWriter writer) +309
   System.Web.WebPages.WebPageBase.Write(HelperResult result) +108
   ASP._Page_Quantium_QCMS_Templates_divinity_Include__content_articles_vbhtml.Execute() in C:\inetpub\wwwroot\madredelbuonconsiglio.it\baseroot\Quantium\QCMS\Templates\divinity\Include\_content_articles.vbhtml:9
   System.Web.WebPages.WebPageBase.ExecutePageHierarchy() +252
   System.Web.WebPages.WebPage.ExecutePageHierarchy(IEnumerable`1 executors) +99
   System.Web.WebPages.WebPage.ExecutePageHierarchy() +185
   System.Web.WebPages.WebPageBase.ExecutePageHierarchy(WebPageContext pageContext, TextWriter writer, WebPageRenderingBase startPage) +122
   System.Web.WebPages.<>c__DisplayClass3.<RenderPageCore>b__2(TextWriter writer) +309
   System.Web.WebPages.WebPageBase.Write(HelperResult result) +108
   ASP._Page_Quantium_QCMS_Templates_divinity_Include__body_articles_vbhtml.Execute() in C:\inetpub\wwwroot\madredelbuonconsiglio.it\baseroot\Quantium\QCMS\Templates\divinity\Include\_body_articles.vbhtml:17
   System.Web.WebPages.WebPageBase.ExecutePageHierarchy() +252
   System.Web.WebPages.WebPage.ExecutePageHierarchy(IEnumerable`1 executors) +99
   System.Web.WebPages.WebPage.ExecutePageHierarchy() +185
   System.Web.WebPages.WebPageBase.ExecutePageHierarchy(WebPageContext pageContext, TextWriter writer, WebPageRenderingBase startPage) +122
   System.Web.WebPages.<>c__DisplayClass3.<RenderPageCore>b__2(TextWriter writer) +309
   System.Web.WebPages.WebPageBase.Write(HelperResult result) +108
   ASP._Page_Quantium_QCMS_Templates_divinity_Layout__Articles_vbhtml.Execute() in C:\inetpub\wwwroot\madredelbuonconsiglio.it\baseroot\Quantium\QCMS\Templates\divinity\Layout\_Articles.vbhtml:6
   System.Web.WebPages.WebPageBase.ExecutePageHierarchy() +252
   System.Web.WebPages.WebPage.ExecutePageHierarchy(IEnumerable`1 executors) +99
   System.Web.WebPages.WebPage.ExecutePageHierarchy() +185
   System.Web.WebPages.WebPageBase.ExecutePageHierarchy(WebPageContext pageContext, TextWriter writer, WebPageRenderingBase startPage) +122
   System.Web.WebPages.<>c__DisplayClass3.<RenderPageCore>b__2(TextWriter writer) +309
   System.Web.WebPages.WebPageBase.Write(HelperResult result) +108
   System.Web.WebPages.WebPageBase.RenderSurrounding(String partialViewName, Action`1 body) +89
   System.Web.WebPages.WebPageBase.PopContext() +310
   System.Web.WebPages.WebPageHttpHandler.ProcessRequestInternal(HttpContextBase httpContext) +142


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.4690.0