MCGalaxy icon indicating copy to clipboard operation
MCGalaxy copied to clipboard

(Object reference not set to an instance of an object) - MariaDB

Open jpenguin opened this issue 9 months ago • 0 comments

Not related to my other issue, different server

Running MariaDB on Ubuntu, even premade the DB with latin1_swedish_ci

Type: MySqlException
Source: MySql.Data
Message: Fatal error encountered attempting to read the resultset.
Trace:   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x002da] in <2c8fc0407a5848dfa91f594842a803e7>:0 
  at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader () [0x00000] in <2c8fc0407a5848dfa91f594842a803e7>:0 
  at (wrapper remoting-invoke-with-check) MySql.Data.MySqlClient.MySqlCommand.ExecuteReader()
  at MCGalaxy.SQL.MySQLCommand.ExecuteReader () [0x00000] in <68bee6bf385a45f2b0e603e2988342b6>:0 
  at MCGalaxy.SQL.IDatabaseBackend.Iterate (System.String sql, System.Object[] parameters, MCGalaxy.SQL.ReaderCallback callback) [0x00036] in <68bee6bf385a45f2b0e603e2988342b6>:0 
  at MCGalaxy.SQL.Database.Do (System.String sql, System.Boolean createDB, MCGalaxy.SQL.ReaderCallback callback, System.Object[] args) [0x0000f] in <68bee6bf385a45f2b0e603e2988342b6>:0 
Type: MySqlException
Source: MySql.Data
Message: Fatal error encountered attempting to read the resultset.
Trace:   at MySql.Data.MySqlClient.MySqlDataReader.NextResult () [0x001f2] in <2c8fc0407a5848dfa91f594842a803e7>:0 
  at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x00250] in <2c8fc0407a5848dfa91f594842a803e7>:0 
Type: MySqlException
Source: MySql.Data
Message: Character set 'utf8mb3' is not supported by .Net Framework.
Trace:   at MySql.Data.MySqlClient.CharSetMap.GetCharacterSet (MySql.Data.Common.DBVersion version, System.String CharSetName) [0x00033] in <2c8fc0407a5848dfa91f594842a803e7>:0 
  at MySql.Data.MySqlClient.MySqlField.SetFieldEncoding () [0x00049] in <2c8fc0407a5848dfa91f594842a803e7>:0 
  at MySql.Data.MySqlClient.MySqlField.set_CharacterSetIndex (System.Int32 value) [0x00007] in <2c8fc0407a5848dfa91f594842a803e7>:0 
  at MySql.Data.MySqlClient.NativeDriver.GetColumnData (MySql.Data.MySqlClient.MySqlField field) [0x000ad] in <2c8fc0407a5848dfa91f594842a803e7>:0 
  at MySql.Data.MySqlClient.NativeDriver.GetColumnsData (MySql.Data.MySqlClient.MySqlField[] columns) [0x00004] in <2c8fc0407a5848dfa91f594842a803e7>:0 
  at MySql.Data.MySqlClient.Driver.GetColumns (System.Int32 count) [0x0001c] in <2c8fc0407a5848dfa91f594842a803e7>:0 
  at MySql.Data.MySqlClient.ResultSet.LoadColumns (System.Int32 numCols) [0x00000] in <2c8fc0407a5848dfa91f594842a803e7>:0 
  at MySql.Data.MySqlClient.ResultSet..ctor (MySql.Data.MySqlClient.Driver d, System.Int32 statementId, System.Int32 numCols) [0x0002a] in <2c8fc0407a5848dfa91f594842a803e7>:0 
  at MySql.Data.MySqlClient.Driver.NextResult (System.Int32 statementId, System.Boolean force) [0x00039] in <2c8fc0407a5848dfa91f594842a803e7>:0 
  at MySql.Data.MySqlClient.MySqlDataReader.NextResult () [0x000d2] in <2c8fc0407a5848dfa91f594842a803e7>:0 

Did a little searching, found https://mysqlconnector.net/tutorials/migrating-from-connector-net/ Better compatibility with non-MySQL databases ([MariaDB](https://bugs.mysql.com/bug.php?id=109331), Amazon Aurora, etc.) Is MySQL.Data just incompatible with MariaDB?

jpenguin avatar May 06 '24 18:05 jpenguin