Fatal error encountered during command execution with a mySQL INSERT

Question

I am trying to execute a INSERT statement on a mySQL DB in C#:

MySqlConnection connection = new MySqlConnection("SERVER=" + _dbConnection + ";" +
   "DATABASE=" + _dbName + ";" +
   "PORT=" + _dbPort + ";" +
   "UID=" + _dbUsername + ";" +
   "PASSWORD=" + _dbPassword + ";");
MySqlDataAdapter adapter;
DataSet dataset = new DataSet();
command = new MySqlCommand();
command.Connection = connection;
command.CommandText = "INSERT INTO plugins (pluginName, enabled) VALUES (@plugin,@enabled)";
command.Parameters.AddWithValue("@name", "pluginName");
command.Parameters.AddWithValue("@enabled", false);
adapter = new MySqlDataAdapter(command);
adapter.Fill(dataset);

The plugin table consists of two columns: pluginName(varchar(50)) and enabled(boolean).

This fails with the error: mysql Fatal error encountered during command execution. Any ideas on why this would fail?

Chris · Accepted Answer · 2010-03-18 04:56:57Z

8

You seem to be using @plugin in the query but @name in the parameters, although I'd expect a better error message if that was the sole problem!

answered Mar 18, 2010 at 4:56

Chris

10.5k1 gold badge40 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

fableal Over a year ago

If you explore the Exception's InnerException (its exceptions all the way...) you eventually find the source of the problem; in my case, a non-defined parameter (typo).

AdamMc331 Over a year ago

I just had this same problem, the error message is not clear at all. But thank you for helping me fix it!

Pranav Premarajan · Accepted Answer · 2019-04-15 06:38:01Z

1

Missing Parameters could also be a reason. eg:

cmd.CommandText = "INSERT INTO login VALUES(@uname,@pwd);"
cmd.Parameters.AddWithValue("@uname",TxtUsername.Text.ToString())
'forgot to place "@pwd"

cmd.ExecuteNonQuery()

You get fatal error which can be solved by adding

cmd.Parameters.AddWithValue("@pwd",TxtPassword.Text.ToString())

answered Apr 15, 2019 at 6:38

Pranav Premarajan

11 bronze badge

Comments

DanM7 · Accepted Answer · 2012-10-18 17:59:31Z

0

The error "Fatal error encountered during command execution" seems to be for general syntax errors in the CommandText line.

For example, the following just tripped me up for a while:

...@date,@email@first,@last...

Watch out for those commas! There should be one after @email:

...@date,@email,@first,@last...

edited Oct 18, 2012 at 17:59

answered Jul 12, 2012 at 21:03

DanM7

2,2423 gold badges29 silver badges47 bronze badges

Comments

Md Samrat Akbor · Accepted Answer · 2022-08-08 12:32:57Z

0

`(from user in _context.GetDataTable("call sp_get_user_subscribe_info(@param1, @param2)", _context.AddParameter(new dynamic[] { id }))`

My procedure has two parameters but I have passed only one parameter that's why this error message occurred, But this error message is so confusing.

edited Aug 8, 2022 at 12:32

answered Jun 3, 2022 at 6:50

Md Samrat Akbor

754 bronze badges

Collectives™ on Stack Overflow

Fatal error encountered during command execution with a mySQL INSERT

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related