
Originally Posted by
neto737
How I fixed the button "ban user from room"?
And, how to fix this?
Error in query:
UPDATE user_pets SET room_id = 0, name = @103name, race = @103race, color = @103color, type = 15, expirience = 0, energy = 100, nutrition = 100, respect = 0, createstamp = '1362079211', x = 0, Y = 0, Z = 0 WHERE id = 103
MySql.Data.MySqlClient.MySqlException (0x80004005): Fatal error encountered during command execution. ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Parameter '@103name' must be defined.
em MySql.Data.MySqlClient.Statement.SerializeParameter(MySqlParameterCollection parameters, MySqlPacket packet, String parmName)
em MySql.Data.MySqlClient.Statement.InternalBindParameters(String sql, MySqlParameterCollection parameters, MySqlPacket packet)
em MySql.Data.MySqlClient.Statement.BindParameters()
em MySql.Data.MySqlClient.PreparableStatement.Execute()
em MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
em MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
em MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
em Database_Manager.Database.Session_Details.QueryAdapter.runQuery()