Server Error in '/' Application.

Unknown column 'IMG_8630.PNG' in 'where clause'

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.MySqlClient.MySqlException: Unknown column 'IMG_8630.PNG' in 'where clause'

Source Error:


Line 8:      Dim sql = "SELECT * FROM tbl_event INNER JOIN tbl_venue ON eventVenue = venueId INNER JOIN tbl_organisation ON eventOrganisation = organisationId WHERE eventId = " + eventId + " AND eventPublishYN = 1 ORDER BY eventDate"
Line 9:  
Line 10:     Dim rs = conn.Query(sql)
Line 11: 
Line 12:     Dim eventDate As Date

Source File: D:\HostingSpaces\kettlecup\topgame.network\wwwroot\event.vbhtml    Line: 10

Stack Trace:


[MySqlException (0x80004005): Unknown column 'IMG_8630.PNG' in 'where clause']
   MySql.Data.MySqlClient.MySqlStream.ReadPacket() +352
   MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId) +119
   MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId) +17
   MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force) +110
   MySql.Data.MySqlClient.MySqlDataReader.NextResult() +961
   MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) +1690
   MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +4
   System.Data.Common.DbCommand.ExecuteReader() +14
   WebMatrix.Data.<QueryInternal>d__0.MoveNext() +151
   System.Collections.Generic.List`1..ctor(IEnumerable`1 collection) +186
   System.Linq.Enumerable.ToList(IEnumerable`1 source) +61
   WebMatrix.Data.Database.Query(String commandText, Object[] parameters) +100
   ASP._Page_event_vbhtml.Execute() in D:\HostingSpaces\kettlecup\topgame.network\wwwroot\event.vbhtml:10
   System.Web.WebPages.WebPageBase.ExecutePageHierarchy() +198
   System.Web.WebPages.WebPage.ExecutePageHierarchy(IEnumerable`1 executors) +69
   System.Web.WebPages.WebPage.ExecutePageHierarchy() +131
   System.Web.WebPages.WebPageBase.ExecutePageHierarchy(WebPageContext pageContext, TextWriter writer, WebPageRenderingBase startPage) +78
   System.Web.WebPages.WebPageHttpHandler.ProcessRequestInternal(HttpContextBase httpContext) +116


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