search

ClassiCube / MCGalaxy

A Minecraft Classic / ClassiCube server software
GNU General Public License v3.0
171 stars 80 forks source link

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

Open jpenguin opened 4 months ago

jpenguin commented 4 months ago

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?