error in your SQL syntax at line 1

Question

0.00/5 (No votes)

See more:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[liteusers]' 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 MySQL server version for the right syntax to use near '[liteusers]' at line 1

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[MySqlException (0x80004005): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[liteusers]' at line 1]
MySql.Data.MySqlClient.MySqlStream.ReadPacket() +276
MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId) +68
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() +783
MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) +1743
MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +4
System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +10
System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +140
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +316
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +86
System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1482
System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +21
System.Web.UI.WebControls.DataBoundControl.PerformSelect() +138
System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +30
System.Web.UI.WebControls.GridView.DataBind() +4
System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +105
System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +75
System.Web.UI.Control.EnsureChildControls() +83
System.Web.UI.Control.PreRenderRecursiveInternal() +42
System.Web.UI.Control.PreRenderRecursiveInternal() +168
System.Web.UI.Control.PreRenderRecursiveInternal() +168
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +974

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

ASP.NET

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default2.aspx.cs" Inherits="Default2" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    
    </div>
    <asp:GridView ID="GridView1" runat="server" AllowPaging="True" 
        AllowSorting="True" DataSourceID="SqlDataSource1">
        <Columns>
            <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" 
                ShowSelectButton="True" />
        </Columns>
    </asp:GridView>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:nnscomm_appConnectionString %>" 
        DeleteCommand="DELETE FROM [liteusers] WHERE [id] = ?" 
        InsertCommand="INSERT INTO [liteusers] ([id], [number], [name], [emailid], [status], [days_left], [commodities], [start_date], [IMEI], [passcode], [verificationcode]) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)" 
        ProviderName="<%$ ConnectionStrings:nnscomm_appConnectionString.ProviderName %>" 
        SelectCommand="SELECT * FROM [liteusers]" 
        UpdateCommand="UPDATE [liteusers] SET [number] = ?, [name] = ?, [emailid] = ?, [status] = ?, [days_left] = ?, [commodities] = ?, [start_date] = ?, [IMEI] = ?, [passcode] = ?, [verificationcode] = ? WHERE [id] = ?">
        <DeleteParameters>
            <asp:Parameter Name="id" Type="Int32" />
        </DeleteParameters>
        <InsertParameters>
            <asp:Parameter Name="id" Type="Int32" />
            <asp:Parameter Name="number" Type="String" />
            <asp:Parameter Name="name" Type="String" />
            <asp:Parameter Name="emailid" Type="String" />
            <asp:Parameter Name="status" Type="String" />
            <asp:Parameter Name="days_left" Type="Int32" />
            <asp:Parameter Name="commodities" Type="String" />
            <asp:Parameter Name="start_date" Type="DateTime" />
            <asp:Parameter Name="IMEI" Type="String" />
            <asp:Parameter Name="passcode" Type="String" />
            <asp:Parameter Name="verificationcode" Type="String" />
        </InsertParameters>
        <UpdateParameters>
            <asp:Parameter Name="number" Type="String" />
            <asp:Parameter Name="name" Type="String" />
            <asp:Parameter Name="emailid" Type="String" />
            <asp:Parameter Name="status" Type="String" />
            <asp:Parameter Name="days_left" Type="Int32" />
            <asp:Parameter Name="commodities" Type="String" />
            <asp:Parameter Name="start_date" Type="DateTime" />
            <asp:Parameter Name="IMEI" Type="String" />
            <asp:Parameter Name="passcode" Type="String" />
            <asp:Parameter Name="verificationcode" Type="String" />
            <asp:Parameter Name="id" Type="Int32" />
        </UpdateParameters>
    </asp:SqlDataSource>
    </form>
</body>
</html>

Posted 25-Dec-15 21:34pm

Anurag Gupta

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mehdi Gholam · Accepted Answer · 2015-12-25T22:22:00

Solution 1

When using MYSQL the delimiter character for table/column names is not [ ] but ` i.e:

SQL

INSERT INTO `liteusers` ...

Posted 25-Dec-15 22:22pm

Mehdi Gholam

Updated 25-Dec-15 22:23pm

v2

Comments

[no name] 26-Dec-15 7:21am

Sorry for asking here: Is
INSERT INTO liteusers ....
wrong in MYSQL? Thank you in advance and 5.

Mehdi Gholam 26-Dec-15 8:49am

No you can omit the ` character if the names don't have spaces etc.