More in this section

Forums / Bugs & Issues / Membership password error

Membership password error

2 posts, 0 answered
  1. Joshua
    Joshua avatar
    10 posts
    18 Mar 2010
    19 May 2010
    Link to this post
    Hello, I am having issues with my site. I have my membership profiles setup and working correctly. I went to change a users password and I received the following error:

    Server Error in '/' Application.

    Insert Error: Column name or number of supplied values does not match table definition.

    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: System.Data.SqlClient.SqlException: Insert Error: Column name or number of supplied values does not match table definition.

    Source Error:

    Line 248:			Cmd.Parameters.Add("@LastName", SqlDbType.VarChar).Value = txtLastName.Text;
    Line 249:			Cmd.Parameters.Add("@Email", SqlDbType.VarChar).Value = txtEmail.Text;
    Line 250:			Cmd.ExecuteNonQuery();
    Line 251:
    Line 252:			Trace.Warn("Save", SQL);

    Any help would be greatly appreciated.

    Thank you,
  2. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    12 Sep 2017
    21 May 2010
    Link to this post
    Hi Joshua,

    The error generally appears when when during an INSERT operation the number of supplied column names or the number of supplied values does not match the table definition. The statement can be parsed, but causes the error at runtime.. The error is caused when you have a computed column/subquery in Insert statement.
    To avoid this problem,  the values specified in your clause or in the SELECT subquery should  match the number of columns in the INSERT clause. 

    Best wishes,
    Ivan Dimitrov
    the Telerik team

    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
2 posts, 0 answered