search

pmachapman / mysqltuner

MySQL Tuner for Windows
GNU General Public License v3.0
101 stars 16 forks source link

Support early mysql 4.0.18 issue Again #17

Closed ayuen99 closed 6 years ago

ayuen99 commented 6 years ago

Hi,

I found an error during testing another mysql server.

System.Data.SqlTypes.SqlNullValueException: Data is Null. This method or property cannot be called on Null values. at MySql.Data.MySqlClient.MySqlDataReader.GetFieldValue(Int32 index, Boolean checkNull) at MySql.Data.MySqlClient.MySqlDataReader.GetString(Int32 i) at MySqlTuner.MySqlServer.Load() in C:\Users\Peter.Chapman\Source\Repos\mysqltuner\MySQLTuner\MySqlServer.cs:line 586 at MySqlTuner.TuningCalculator.Calculate(MySqlServer server) in C:\Users\Peter.Chapman\Source\Repos\mysqltuner\MySQLTuner\TuningCalculator.cs:line 138

pmachapman commented 6 years ago

Hmm, looks like an odd one. Are there many databases on the server? It looks like it is crashing on the output of the SHOW TABLE STATUS FROM _your_databasename query.

Are you able to run SHOW TABLE STATUS FROM _your_databasename for each database on your server, including the mysql database, and send me the output as a text file or CSV file?

Also, are you connecting as the root user?

pmachapman commented 6 years ago

I've written a fix for the crash that you have been having: https://github.com/pmachapman/mysqltuner/releases/download/0.8.3/MySQLTuner-0.8.3-net20-connector-517.zip. Please let me know if this fixes the issue for you.