Unity Android MySQL connection function failing: Index was outside the bounds of the array

-1

I have a class to handle all of the database interactions between the client and database (MySQL) (I know and understand that I shouldn't allow direct access to a database)

public T getDatabaseValue<T>(string value, string query)

{

    try

    {

        connection = new MySqlConnection(connectionString);

        connection.Open();

        command = new MySqlCommand(query, connection);

        MySqlDataReader reader = command.ExecuteReader();

        if (reader.Read())

        {

            return (T)reader[value];

        }

        else

            return default(T);

    }

    catch (MySqlException SQLex)

    {

        Debug.Log("Database get failed (SQL Exception), query: " + query);

        Debug.Log("Exception Message: " + SQLex.Message);   

        return default(T);

    }

    catch (System.Exception ex)

    {

        Debug.Log("Database get failed (System Exception), query: " + query);

        Debug.Log("Exception Message: " + ex.Message);

        return default(T);

    }

}

This works flawlessly in the editor. When building and running on Android I get this error message via Monitor:

01-01 15:21:14.141: I/Unity(23761): (Filename: ./Runtime/Export/Debug.bindings.h Line: 43)

01-01 15:21:14.829: I/Unity(23761): Database get failed (System Exception), query: SELECT MAX(DT_Stamp) FROM tbl_Store;

01-01 15:21:14.829: I/Unity(23761):  

01-01 15:21:14.829: I/Unity(23761): (Filename: ./Runtime/Export/Debug.bindings.h Line: 43)

01-01 15:21:14.829: I/Unity(23761): Exception Message: Index was outside the bounds of the array.

I'm not using an array to store the contents of the reader, here is the line that calls this example (it happens for all database interactions, not just this one, and not just this database querying function):

    DateTime DB_Date = getDatabaseValue<DateTime>("MAX(DT_Stamp)", "SELECT MAX(DT_Stamp) FROM tbl_Store;");

Here's the contents of tbl_Store:

(Item_ID (int)), (Item_Name (varchar)), (Item_Price (float)), (In_Use (bit)), (DT_Stamp (datetime))

4 Hero Upgrade #1 100 1 2018-12-11 09:53:14 

5 Hero Upgrade #2 300 1 2018-12-11 09:53:14 

6 Hero Upgrade #3 700 1 2018-12-11 09:53:14

I also tried it in a much more basic project to get the core error message returned by Android:

01-01 17:23:48.307: E/Unity(10476): IndexOutOfRangeException: Index was outside the bounds of the array. 

01-01 17:23:48.307: E/Unity(10476): at System.Diagnostics.TraceInternal.get_AppName () [0x0000e] in <ac210d81537245bc838518cc8e845861>:0 

01-01 17:23:48.307: E/Unity(10476): at System.Diagnostics.TraceInternal.TraceEvent (System.Diagnostics.TraceEventType eventType, System.Int32 id, System.String format, System.Object args) [0x0003d] in <ac210d81537245bc838518cc8e845861>:0 

01-01 17:23:48.307: E/Unity(10476): at System.Diagnostics.Trace.TraceError (System.String message) [0x00000] in <ac210d81537245bc838518cc8e845861>:0 

01-01 17:23:48.307: E/Unity(10476): at MySql.Data.MySqlClient.MySqlTrace.LogError (System.Int32 id, System.String msg) [0x00028] in <326e9aab93854e739606c3572c385a34>:0 

01-01 17:23:48.307: E/Unity(10476): at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver () [0x00031] in <326e9aab93854e739606c3572c385a34>:0 

01-01 17:23:48.307: E/Unity(10476): at MySql.Data.MySqlClient.MySqlPool.GetConnection () [0x0001c] in <326e9aab93854e739606c3572c385a34>:0 

01-01 17:23:48.307: E/Unity(10476): at MySql.Data.MySqlClient.MySqlConnection.Open () [0x000f3] in <326e9aab93854e739606c3572c385a34>:0 

01-01 17:23:48.307: E/Unity(10476): at texttest1.Start () [0x00011] in <dd75ac8e3f854a97ac132dae6ec658fd>:0

I'm probably missing something really simple here but any help would be greatly appreciated!

asked Jan 1 at 19:02

James Coyle

172

Does getDatabaseValue<DateTime>("dt_stamp", "SELECT MAX(DT_Stamp) dt_stamp FROM tbl_Store;") fail too?

– sticky bit
Jan 1 at 19:12

Hey, yeah so the code that I used for the "Simpler" version is as follows: ` void Start () { connection = new MySqlConnection(connectionString); connection.Open(); command = new MySqlCommand("SELECT Item_Name FROM tbl_Store;", connection); MySqlDataReader reader = command.ExecuteReader(); text = GameObject.Find("Text").GetComponent<Text>(); reader.Read(); text.text = reader["Item_Name"].ToString(); }`

– James Coyle
Jan 1 at 19:18

Which doesn't actually use the same query, and it still produces the same result in Monitor.bat

– James Coyle
Jan 1 at 19:20

add a comment |

-1

I have a class to handle all of the database interactions between the client and database (MySQL) (I know and understand that I shouldn't allow direct access to a database)

public T getDatabaseValue<T>(string value, string query)

{

    try

    {

        connection = new MySqlConnection(connectionString);

        connection.Open();

        command = new MySqlCommand(query, connection);

        MySqlDataReader reader = command.ExecuteReader();

        if (reader.Read())

        {

            return (T)reader[value];

        }

        else

            return default(T);

    }

    catch (MySqlException SQLex)

    {

        Debug.Log("Database get failed (SQL Exception), query: " + query);

        Debug.Log("Exception Message: " + SQLex.Message);   

        return default(T);

    }

    catch (System.Exception ex)

    {

        Debug.Log("Database get failed (System Exception), query: " + query);

        Debug.Log("Exception Message: " + ex.Message);

        return default(T);

    }

}

This works flawlessly in the editor. When building and running on Android I get this error message via Monitor:

01-01 15:21:14.141: I/Unity(23761): (Filename: ./Runtime/Export/Debug.bindings.h Line: 43)

01-01 15:21:14.829: I/Unity(23761): Database get failed (System Exception), query: SELECT MAX(DT_Stamp) FROM tbl_Store;

01-01 15:21:14.829: I/Unity(23761):  

01-01 15:21:14.829: I/Unity(23761): (Filename: ./Runtime/Export/Debug.bindings.h Line: 43)

01-01 15:21:14.829: I/Unity(23761): Exception Message: Index was outside the bounds of the array.

    DateTime DB_Date = getDatabaseValue<DateTime>("MAX(DT_Stamp)", "SELECT MAX(DT_Stamp) FROM tbl_Store;");

Here's the contents of tbl_Store:

(Item_ID (int)), (Item_Name (varchar)), (Item_Price (float)), (In_Use (bit)), (DT_Stamp (datetime))

4 Hero Upgrade #1 100 1 2018-12-11 09:53:14 

5 Hero Upgrade #2 300 1 2018-12-11 09:53:14 

6 Hero Upgrade #3 700 1 2018-12-11 09:53:14

I also tried it in a much more basic project to get the core error message returned by Android:

01-01 17:23:48.307: E/Unity(10476): IndexOutOfRangeException: Index was outside the bounds of the array. 

01-01 17:23:48.307: E/Unity(10476): at System.Diagnostics.TraceInternal.get_AppName () [0x0000e] in <ac210d81537245bc838518cc8e845861>:0 

01-01 17:23:48.307: E/Unity(10476): at System.Diagnostics.TraceInternal.TraceEvent (System.Diagnostics.TraceEventType eventType, System.Int32 id, System.String format, System.Object args) [0x0003d] in <ac210d81537245bc838518cc8e845861>:0 

01-01 17:23:48.307: E/Unity(10476): at System.Diagnostics.Trace.TraceError (System.String message) [0x00000] in <ac210d81537245bc838518cc8e845861>:0 

01-01 17:23:48.307: E/Unity(10476): at MySql.Data.MySqlClient.MySqlTrace.LogError (System.Int32 id, System.String msg) [0x00028] in <326e9aab93854e739606c3572c385a34>:0 

01-01 17:23:48.307: E/Unity(10476): at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver () [0x00031] in <326e9aab93854e739606c3572c385a34>:0 

01-01 17:23:48.307: E/Unity(10476): at MySql.Data.MySqlClient.MySqlPool.GetConnection () [0x0001c] in <326e9aab93854e739606c3572c385a34>:0 

01-01 17:23:48.307: E/Unity(10476): at MySql.Data.MySqlClient.MySqlConnection.Open () [0x000f3] in <326e9aab93854e739606c3572c385a34>:0 

01-01 17:23:48.307: E/Unity(10476): at texttest1.Start () [0x00011] in <dd75ac8e3f854a97ac132dae6ec658fd>:0

I'm probably missing something really simple here but any help would be greatly appreciated!

asked Jan 1 at 19:02

James Coyle

172

Does getDatabaseValue<DateTime>("dt_stamp", "SELECT MAX(DT_Stamp) dt_stamp FROM tbl_Store;") fail too?

– sticky bit
Jan 1 at 19:12

Hey, yeah so the code that I used for the "Simpler" version is as follows: ` void Start () { connection = new MySqlConnection(connectionString); connection.Open(); command = new MySqlCommand("SELECT Item_Name FROM tbl_Store;", connection); MySqlDataReader reader = command.ExecuteReader(); text = GameObject.Find("Text").GetComponent<Text>(); reader.Read(); text.text = reader["Item_Name"].ToString(); }`

– James Coyle
Jan 1 at 19:18

Which doesn't actually use the same query, and it still produces the same result in Monitor.bat

– James Coyle
Jan 1 at 19:20

add a comment |

-1

I have a class to handle all of the database interactions between the client and database (MySQL) (I know and understand that I shouldn't allow direct access to a database)

public T getDatabaseValue<T>(string value, string query)

{

    try

    {

        connection = new MySqlConnection(connectionString);

        connection.Open();

        command = new MySqlCommand(query, connection);

        MySqlDataReader reader = command.ExecuteReader();

        if (reader.Read())

        {

            return (T)reader[value];

        }

        else

            return default(T);

    }

    catch (MySqlException SQLex)

    {

        Debug.Log("Database get failed (SQL Exception), query: " + query);

        Debug.Log("Exception Message: " + SQLex.Message);   

        return default(T);

    }

    catch (System.Exception ex)

    {

        Debug.Log("Database get failed (System Exception), query: " + query);

        Debug.Log("Exception Message: " + ex.Message);

        return default(T);

    }

}

This works flawlessly in the editor. When building and running on Android I get this error message via Monitor:

01-01 15:21:14.141: I/Unity(23761): (Filename: ./Runtime/Export/Debug.bindings.h Line: 43)

01-01 15:21:14.829: I/Unity(23761): Database get failed (System Exception), query: SELECT MAX(DT_Stamp) FROM tbl_Store;

01-01 15:21:14.829: I/Unity(23761):  

01-01 15:21:14.829: I/Unity(23761): (Filename: ./Runtime/Export/Debug.bindings.h Line: 43)

01-01 15:21:14.829: I/Unity(23761): Exception Message: Index was outside the bounds of the array.

    DateTime DB_Date = getDatabaseValue<DateTime>("MAX(DT_Stamp)", "SELECT MAX(DT_Stamp) FROM tbl_Store;");

Here's the contents of tbl_Store:

(Item_ID (int)), (Item_Name (varchar)), (Item_Price (float)), (In_Use (bit)), (DT_Stamp (datetime))

4 Hero Upgrade #1 100 1 2018-12-11 09:53:14 

5 Hero Upgrade #2 300 1 2018-12-11 09:53:14 

6 Hero Upgrade #3 700 1 2018-12-11 09:53:14

I also tried it in a much more basic project to get the core error message returned by Android:

01-01 17:23:48.307: E/Unity(10476): IndexOutOfRangeException: Index was outside the bounds of the array. 

01-01 17:23:48.307: E/Unity(10476): at System.Diagnostics.TraceInternal.get_AppName () [0x0000e] in <ac210d81537245bc838518cc8e845861>:0 

01-01 17:23:48.307: E/Unity(10476): at System.Diagnostics.TraceInternal.TraceEvent (System.Diagnostics.TraceEventType eventType, System.Int32 id, System.String format, System.Object args) [0x0003d] in <ac210d81537245bc838518cc8e845861>:0 

01-01 17:23:48.307: E/Unity(10476): at System.Diagnostics.Trace.TraceError (System.String message) [0x00000] in <ac210d81537245bc838518cc8e845861>:0 

01-01 17:23:48.307: E/Unity(10476): at MySql.Data.MySqlClient.MySqlTrace.LogError (System.Int32 id, System.String msg) [0x00028] in <326e9aab93854e739606c3572c385a34>:0 

01-01 17:23:48.307: E/Unity(10476): at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver () [0x00031] in <326e9aab93854e739606c3572c385a34>:0 

01-01 17:23:48.307: E/Unity(10476): at MySql.Data.MySqlClient.MySqlPool.GetConnection () [0x0001c] in <326e9aab93854e739606c3572c385a34>:0 

01-01 17:23:48.307: E/Unity(10476): at MySql.Data.MySqlClient.MySqlConnection.Open () [0x000f3] in <326e9aab93854e739606c3572c385a34>:0 

01-01 17:23:48.307: E/Unity(10476): at texttest1.Start () [0x00011] in <dd75ac8e3f854a97ac132dae6ec658fd>:0

I'm probably missing something really simple here but any help would be greatly appreciated!

asked Jan 1 at 19:02

James Coyle

172

I have a class to handle all of the database interactions between the client and database (MySQL) (I know and understand that I shouldn't allow direct access to a database)

public T getDatabaseValue<T>(string value, string query)

{

    try

    {

        connection = new MySqlConnection(connectionString);

        connection.Open();

        command = new MySqlCommand(query, connection);

        MySqlDataReader reader = command.ExecuteReader();

        if (reader.Read())

        {

            return (T)reader[value];

        }

        else

            return default(T);

    }

    catch (MySqlException SQLex)

    {

        Debug.Log("Database get failed (SQL Exception), query: " + query);

        Debug.Log("Exception Message: " + SQLex.Message);   

        return default(T);

    }

    catch (System.Exception ex)

    {

        Debug.Log("Database get failed (System Exception), query: " + query);

        Debug.Log("Exception Message: " + ex.Message);

        return default(T);

    }

}

This works flawlessly in the editor. When building and running on Android I get this error message via Monitor:

01-01 15:21:14.141: I/Unity(23761): (Filename: ./Runtime/Export/Debug.bindings.h Line: 43)

01-01 15:21:14.829: I/Unity(23761): Database get failed (System Exception), query: SELECT MAX(DT_Stamp) FROM tbl_Store;

01-01 15:21:14.829: I/Unity(23761):  

01-01 15:21:14.829: I/Unity(23761): (Filename: ./Runtime/Export/Debug.bindings.h Line: 43)

01-01 15:21:14.829: I/Unity(23761): Exception Message: Index was outside the bounds of the array.

    DateTime DB_Date = getDatabaseValue<DateTime>("MAX(DT_Stamp)", "SELECT MAX(DT_Stamp) FROM tbl_Store;");

Here's the contents of tbl_Store:

(Item_ID (int)), (Item_Name (varchar)), (Item_Price (float)), (In_Use (bit)), (DT_Stamp (datetime))

4 Hero Upgrade #1 100 1 2018-12-11 09:53:14 

5 Hero Upgrade #2 300 1 2018-12-11 09:53:14 

6 Hero Upgrade #3 700 1 2018-12-11 09:53:14

I also tried it in a much more basic project to get the core error message returned by Android:

01-01 17:23:48.307: E/Unity(10476): IndexOutOfRangeException: Index was outside the bounds of the array. 

01-01 17:23:48.307: E/Unity(10476): at System.Diagnostics.TraceInternal.get_AppName () [0x0000e] in <ac210d81537245bc838518cc8e845861>:0 

01-01 17:23:48.307: E/Unity(10476): at System.Diagnostics.TraceInternal.TraceEvent (System.Diagnostics.TraceEventType eventType, System.Int32 id, System.String format, System.Object args) [0x0003d] in <ac210d81537245bc838518cc8e845861>:0 

01-01 17:23:48.307: E/Unity(10476): at System.Diagnostics.Trace.TraceError (System.String message) [0x00000] in <ac210d81537245bc838518cc8e845861>:0 

01-01 17:23:48.307: E/Unity(10476): at MySql.Data.MySqlClient.MySqlTrace.LogError (System.Int32 id, System.String msg) [0x00028] in <326e9aab93854e739606c3572c385a34>:0 

01-01 17:23:48.307: E/Unity(10476): at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver () [0x00031] in <326e9aab93854e739606c3572c385a34>:0 

01-01 17:23:48.307: E/Unity(10476): at MySql.Data.MySqlClient.MySqlPool.GetConnection () [0x0001c] in <326e9aab93854e739606c3572c385a34>:0 

01-01 17:23:48.307: E/Unity(10476): at MySql.Data.MySqlClient.MySqlConnection.Open () [0x000f3] in <326e9aab93854e739606c3572c385a34>:0 

01-01 17:23:48.307: E/Unity(10476): at texttest1.Start () [0x00011] in <dd75ac8e3f854a97ac132dae6ec658fd>:0

I'm probably missing something really simple here but any help would be greatly appreciated!

c# mysql .net visual-studio unity3d

asked Jan 1 at 19:02

James Coyle

172

asked Jan 1 at 19:02

James Coyle

172

asked Jan 1 at 19:02

James Coyle

172

asked Jan 1 at 19:02

James Coyle

172

asked Jan 1 at 19:02

James Coyle

172

Does getDatabaseValue<DateTime>("dt_stamp", "SELECT MAX(DT_Stamp) dt_stamp FROM tbl_Store;") fail too?

– sticky bit
Jan 1 at 19:12

Hey, yeah so the code that I used for the "Simpler" version is as follows: ` void Start () { connection = new MySqlConnection(connectionString); connection.Open(); command = new MySqlCommand("SELECT Item_Name FROM tbl_Store;", connection); MySqlDataReader reader = command.ExecuteReader(); text = GameObject.Find("Text").GetComponent<Text>(); reader.Read(); text.text = reader["Item_Name"].ToString(); }`

– James Coyle
Jan 1 at 19:18

Which doesn't actually use the same query, and it still produces the same result in Monitor.bat

– James Coyle
Jan 1 at 19:20

add a comment |

Does getDatabaseValue<DateTime>("dt_stamp", "SELECT MAX(DT_Stamp) dt_stamp FROM tbl_Store;") fail too?

– sticky bit
Jan 1 at 19:12

Hey, yeah so the code that I used for the "Simpler" version is as follows: ` void Start () { connection = new MySqlConnection(connectionString); connection.Open(); command = new MySqlCommand("SELECT Item_Name FROM tbl_Store;", connection); MySqlDataReader reader = command.ExecuteReader(); text = GameObject.Find("Text").GetComponent<Text>(); reader.Read(); text.text = reader["Item_Name"].ToString(); }`

– James Coyle
Jan 1 at 19:18

Which doesn't actually use the same query, and it still produces the same result in Monitor.bat

– James Coyle
Jan 1 at 19:20

Does getDatabaseValue<DateTime>("dt_stamp", "SELECT MAX(DT_Stamp) dt_stamp FROM tbl_Store;") fail too?

– sticky bit
Jan 1 at 19:12

Hey, yeah so the code that I used for the "Simpler" version is as follows: ` void Start () { connection = new MySqlConnection(connectionString); connection.Open(); command = new MySqlCommand("SELECT Item_Name FROM tbl_Store;", connection); MySqlDataReader reader = command.ExecuteReader(); text = GameObject.Find("Text").GetComponent<Text>(); reader.Read(); text.text = reader["Item_Name"].ToString(); }`

– James Coyle
Jan 1 at 19:18

Which doesn't actually use the same query, and it still produces the same result in Monitor.bat

– James Coyle
Jan 1 at 19:20

add a comment |

2 Answers
2

active

oldest

votes

I found the answer:

In order to get Android device to communicate externally you need to add I18N.dll and I18N.West.dll to your assets, this was the difference between it working in the Unity Editor and the Android APK.

answered Jan 1 at 20:09

James Coyle

172

add a comment |

There's nothing named that way (MAX(DT_Stamp)) in the result set. I would use AS name in your projection clause and reference it that way.

answered Jan 1 at 19:05

Daniel A. White

150k37296376

Hey, thanks for the quick reply! I see what you mean, however the return value of the SQL statement returns a value with the name property of "MAX(DT_Stamp)" via the MySQL database.

– James Coyle
Jan 1 at 19:07

Like I say it works in the unity client absolutely fine, it just fails on Android

– James Coyle
Jan 1 at 19:07

@JamesCoyle it might just be an issue w/ the particular mysql ado.net provider.

– Daniel A. White
Jan 1 at 19:08

That's true, but surely if that was the case it wouldn't work in the Unity editor at all?

– James Coyle
Jan 1 at 19:10

@JamesCoyle who knows. many of those could be different since theres unmanaged code that drive some of those.

– Daniel A. White
Jan 1 at 19:10

|
show 2 more comments

Your Answer

StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53998144%2funity-android-mysql-connection-function-failing-index-was-outside-the-bounds-of%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

2 Answers
2

active

oldest

votes

2 Answers
2

active

oldest

votes

I found the answer:

In order to get Android device to communicate externally you need to add I18N.dll and I18N.West.dll to your assets, this was the difference between it working in the Unity Editor and the Android APK.

answered Jan 1 at 20:09

James Coyle

172

add a comment |

I found the answer:

In order to get Android device to communicate externally you need to add I18N.dll and I18N.West.dll to your assets, this was the difference between it working in the Unity Editor and the Android APK.

answered Jan 1 at 20:09

James Coyle

172

add a comment |

I found the answer:

In order to get Android device to communicate externally you need to add I18N.dll and I18N.West.dll to your assets, this was the difference between it working in the Unity Editor and the Android APK.

answered Jan 1 at 20:09

James Coyle

172

I found the answer:

In order to get Android device to communicate externally you need to add I18N.dll and I18N.West.dll to your assets, this was the difference between it working in the Unity Editor and the Android APK.

answered Jan 1 at 20:09

James Coyle

172

answered Jan 1 at 20:09

James Coyle

172

answered Jan 1 at 20:09

James Coyle

172

answered Jan 1 at 20:09

James Coyle

172

add a comment |

There's nothing named that way (MAX(DT_Stamp)) in the result set. I would use AS name in your projection clause and reference it that way.

answered Jan 1 at 19:05

Daniel A. White

150k37296376

Hey, thanks for the quick reply! I see what you mean, however the return value of the SQL statement returns a value with the name property of "MAX(DT_Stamp)" via the MySQL database.

– James Coyle
Jan 1 at 19:07

Like I say it works in the unity client absolutely fine, it just fails on Android

– James Coyle
Jan 1 at 19:07

@JamesCoyle it might just be an issue w/ the particular mysql ado.net provider.

– Daniel A. White
Jan 1 at 19:08

That's true, but surely if that was the case it wouldn't work in the Unity editor at all?

– James Coyle
Jan 1 at 19:10

@JamesCoyle who knows. many of those could be different since theres unmanaged code that drive some of those.

– Daniel A. White
Jan 1 at 19:10

|
show 2 more comments

There's nothing named that way (MAX(DT_Stamp)) in the result set. I would use AS name in your projection clause and reference it that way.

answered Jan 1 at 19:05

Daniel A. White

150k37296376

Hey, thanks for the quick reply! I see what you mean, however the return value of the SQL statement returns a value with the name property of "MAX(DT_Stamp)" via the MySQL database.

– James Coyle
Jan 1 at 19:07

Like I say it works in the unity client absolutely fine, it just fails on Android

– James Coyle
Jan 1 at 19:07

@JamesCoyle it might just be an issue w/ the particular mysql ado.net provider.

– Daniel A. White
Jan 1 at 19:08

That's true, but surely if that was the case it wouldn't work in the Unity editor at all?

– James Coyle
Jan 1 at 19:10

@JamesCoyle who knows. many of those could be different since theres unmanaged code that drive some of those.

– Daniel A. White
Jan 1 at 19:10

|
show 2 more comments

There's nothing named that way (MAX(DT_Stamp)) in the result set. I would use AS name in your projection clause and reference it that way.

answered Jan 1 at 19:05

Daniel A. White

150k37296376

There's nothing named that way (MAX(DT_Stamp)) in the result set. I would use AS name in your projection clause and reference it that way.

answered Jan 1 at 19:05

Daniel A. White

150k37296376

answered Jan 1 at 19:05

Daniel A. White

150k37296376

answered Jan 1 at 19:05

Daniel A. White

150k37296376

answered Jan 1 at 19:05

Daniel A. White

150k37296376

Hey, thanks for the quick reply! I see what you mean, however the return value of the SQL statement returns a value with the name property of "MAX(DT_Stamp)" via the MySQL database.

– James Coyle
Jan 1 at 19:07

Like I say it works in the unity client absolutely fine, it just fails on Android

– James Coyle
Jan 1 at 19:07

@JamesCoyle it might just be an issue w/ the particular mysql ado.net provider.

– Daniel A. White
Jan 1 at 19:08

That's true, but surely if that was the case it wouldn't work in the Unity editor at all?

– James Coyle
Jan 1 at 19:10

@JamesCoyle who knows. many of those could be different since theres unmanaged code that drive some of those.

– Daniel A. White
Jan 1 at 19:10

|
show 2 more comments

Hey, thanks for the quick reply! I see what you mean, however the return value of the SQL statement returns a value with the name property of "MAX(DT_Stamp)" via the MySQL database.

– James Coyle
Jan 1 at 19:07

Like I say it works in the unity client absolutely fine, it just fails on Android

– James Coyle
Jan 1 at 19:07

@JamesCoyle it might just be an issue w/ the particular mysql ado.net provider.

– Daniel A. White
Jan 1 at 19:08

That's true, but surely if that was the case it wouldn't work in the Unity editor at all?

– James Coyle
Jan 1 at 19:10

@JamesCoyle who knows. many of those could be different since theres unmanaged code that drive some of those.

– Daniel A. White
Jan 1 at 19:10

Hey, thanks for the quick reply! I see what you mean, however the return value of the SQL statement returns a value with the name property of "MAX(DT_Stamp)" via the MySQL database.

– James Coyle
Jan 1 at 19:07

Like I say it works in the unity client absolutely fine, it just fails on Android

– James Coyle
Jan 1 at 19:07

@JamesCoyle it might just be an issue w/ the particular mysql ado.net provider.

– Daniel A. White
Jan 1 at 19:08

That's true, but surely if that was the case it wouldn't work in the Unity editor at all?

– James Coyle
Jan 1 at 19:10

@JamesCoyle who knows. many of those could be different since theres unmanaged code that drive some of those.

– Daniel A. White
Jan 1 at 19:10

|
show 2 more comments

draft saved

draft discarded

Thanks for contributing an answer to Stack Overflow!

Please be sure to answer the question. Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

Search This Blog

Ufyukyu