Server Error in '/' Application.

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '* from ip Where ip='54.144.'' at line 1

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: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '* from ip Where ip='54.144.'' at line 1

Source Error:


Line 113:	myCommand.Parameters.AddWithValue("ip", IP_deel1)		
Line 114:	'myCommand.Parameters.AddWithValue("ip", "100.200.")
Line 115:	myCommand.ExecuteNonQuery()		
Line 116:
Line 117:	SQLstmt = "Insert into ip (ip,naam,reversedns,banned) values (@ip,@naam,@reversedns,@banned)"		

Source File: D:\www\esims.nl\www\App_Code\PageView.vb    Line: 115

Stack Trace:


[MySqlException (0x80004005): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '* from ip Where ip='54.144.'' at line 1]
   MySql.Data.MySqlClient.MySqlStream.ReadPacket() +309
   MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId) +67
   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() +845
   MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) +1619
   MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery() +121
   PageViewClass.autoban() in D:\www\esims.nl\www\App_Code\PageView.vb:115
   PageViewClass.PageView2_db(Int32 pagina, String paginanaam) in D:\www\esims.nl\www\App_Code\PageView.vb:25
   PageViewClass.PageView_db(Int32 pagina) in D:\www\esims.nl\www\App_Code\PageView.vb:12
   ASP.r2_forum_reactie_aspx.Page_Load(Object Src, EventArgs E) in D:\www\esims.nl\www\r2\forum\reactie.aspx:19
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +52
   System.Web.UI.Control.OnLoad(EventArgs e) +97
   System.Web.UI.Control.LoadRecursive() +61
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +693


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