How to fix error when getting data from sql, unity

-2
I can not understand what the error
encodings are right everywhere
recording works
but on line rdr = cmd.ExecuteReader (); an error pops up
Google did not help ((



  error: 

MySql.Data.MySqlClient.MySqlException (0x80004005): Fatal error encountered attempting to read the resultset. ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Expected end of data packet at MySql.Data.MySqlClient.NativeDriver.CheckEOF () [0x00017] in <326e9aab93854e739606c3572c385a34>:0 at MySql.Data.MySqlClient.NativeDriver.ReadEOF () [0x00011] in <326e9aab93854e739606c3572c385a34>:0 at MySql.Data.MySqlClient.NativeDriver.GetColumnsData (MySql.Data.MySqlClient.MySqlField[] columns) [0x00017] in <326e9aab93854e739606c3572c385a34>:0 at MySql.Data.MySqlClient.Driver.GetColumns (System.Int32 count) [0x0001c] in <326e9aab93854e739606c3572c385a34>:0 at MySql.Data.MySqlClient.ResultSet.LoadColumns (System.Int32 numCols) [0x00000] in <326e9aab93854e739606c3572c385a34>:0 at MySql.Data.MySqlClient.ResultSet..ctor (MySql.Data.MySqlClient.Driver d, System.Int32 statementId, System.Int32 numCols) [0x00029] in <326e9aab93854e739606c3572c385a34>:0 at MySql.Data.MySqlClient.Driver.NextResult (System.Int32 statementId) [0x00035] in <326e9aab93854e739606c3572c385a34>:0 at MySql.Data.MySqlClient.MySqlDataReader.NextResult () [0x00053] in <326e9aab93854e739606c3572c385a34>:0 at MySql.Data.MySqlClient.MySqlDataReader.NextResult () [0x00116] in <326e9aab93854e739606c3572c385a34>:0 at MySql.Data.MySqlClient.MySqlDataReader.Close () [0x00052] in <326e9aab93854e739606c3572c385a34>:0 at MySql.Data.MySqlClient.MySqlCommand.ResetReader () [0x00020] in <326e9aab93854e739606c3572c385a34>:0 at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x002d1] in <326e9aab93854e739606c3572c385a34>:0 at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader () [0x00000] in <326e9aab93854e739606c3572c385a34>:0 at (wrapper remoting-invoke-with-check) MySql.Data.MySqlClient.MySqlCommand.ExecuteReader() at Join.loadData () [0x0005d] in C:\Users\tim\Documents\UnityProject\EasyChild\Assets\script\sqlLoginJoin\Join.cs:77

UnityEngine.Debug:Log(Object)
Join:loadData() (at Assets/script/sqlLoginJoin/Join.cs:90)

using System.Collections; using System.Collections.Generic; using UnityEngine; using System.IO; using MySql.Data.MySqlClient; using MySql.Data; using System.Runtime; using System; using System.Data; public class tst : MonoBehaviour { string constr = "Server=localhost;Database=testunity8;User ID=root;Password=root;CharSet=utf8;port=3306"; MySqlConnection con = null; // command object "Server=localhost;Database=easychild;User ID=root;Password=root;Pooling=true" MySqlCommand cmd = null; // reader object MySqlDataReader rdr = null; // Start is called before the first frame update void Awake() { con = new MySqlConnection(constr); con.Open(); Debug.Log("Connection State: " + con.State);

    }
    void OnApplicationQuit()
    {
        if (con != null)
        {

            if (con.State.ToString() != "Closed")
                con.Close();
            con.Dispose();
        }
        Debug.Log("killing con");

    }
    public void loadData()
    {
        string query = "SELECT * FROM test;";
        try
        {
            if (con.State.ToString() != "Open")
                con.Open();

            using (cmd = new MySqlCommand(query, con))
            {
                rdr = cmd.ExecuteReader();
                if (rdr.HasRows)
                    while (rdr.Read())
                    {
                        Debug.Log(rdr[1]);
                    }
                rdr.Dispose();
            }
        }
        catch (Exception ex)
        {
            Debug.Log(ex.ToString());
        }
    }
}
c++
mysql
sql
runtime-error
unityscript
asked on Stack Overflow Apr 20, 2019 by Tim Gorin • edited Apr 20, 2019 by Paul Ogilvie

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0