Changing Database Collation leading to error

So I’ve recently switched from latin1 to utf8 since I needed to use a language for the labels (Hebrew)
After switching to the utf8 format, I ran the server and I get a massive error which I have no idea of how to deal with (sorry if that might sound “nooby”)

Error:

SCRIPT ERROR: @es_extended/server/main.lua:133: attempt to index a nil value (field '?')
> ref (@es_extended/server/main.lua:133)

> async void MySQLAsync.Operation<System.Collections.Generic.List<System.Collections.Generic.Dictionary<string, object>>>+<ExecuteAsync>d__7.MoveNext() (@mysql-async/MySQLAsync.net.dll:0)

> async Task<List<Dictionary<string, object>>> MySQLAsync.FetchAll.ReaderAsync(MySqlCommand command) (@mysql-async/MySQLAsync.net.dll:0)

> async Task<DbDataReader> MySqlConnector.Core.TextCommandExecutor.ExecuteReaderAsync(string commandText, MySqlParameterCollection parameterCollection, CommandBehavior behavior, IOBehavior ioBehavior, CancellationToken cancellationToken) (@mysql-async/MySqlConnector.dll:0)

> async Task<MySqlDataReader> MySql.Data.MySqlClient.MySqlDataReader.CreateAsync(MySqlCommand command, CommandBehavior behavior, IOBehavior ioBehavior) (@mysql-async/MySqlConnector.dll:0)

> async Task MySql.Data.MySqlClient.MySqlDataReader.ReadFirstResultSetAsync(IOBehavior ioBehavior) (@mysql-async/MySqlConnector.dll:0)

> async Task<ResultSet> MySqlConnector.Core.ResultSet.ReadResultSetHeaderAsync(IOBehavior ioBehavior) (@mysql-async/MySqlConnector.dll:0)
SCRIPT ERROR: @esx_skin/server/main.lua:47: attempt to index a nil value (local 'user')

> ref (@esx_skin/server/main.lua:47)

> async void MySQLAsync.Operation<System.Collections.Generic.List<System.Collections.Generic.Dictionary<string, object>>>+<ExecuteAsync>d__7.MoveNext() (@mysql-async/MySQLAsync.net.dll:0)

> async Task<List<Dictionary<string, object>>> MySQLAsync.FetchAll.ReaderAsync(MySqlCommand command) (@mysql-async/MySQLAsync.net.dll:0)

> async Task<DbDataReader> MySqlConnector.Core.TextCommandExecutor.ExecuteReaderAsync(string commandText, MySqlParameterCollection parameterCollection, CommandBehavior behavior, IOBehavior ioBehavior, CancellationToken cancellationToken) (@mysql-async/MySqlConnector.dll:0)

> async Task<MySqlDataReader> MySql.Data.MySqlClient.MySqlDataReader.CreateAsync(MySqlCommand command, CommandBehavior behavior, IOBehavior ioBehavior) (@mysql-async/MySqlConnector.dll:0)

> async Task MySql.Data.MySqlClient.MySqlDataReader.ReadFirstResultSetAsync(IOBehavior ioBehavior) (@mysql-async/MySqlConnector.dll:0)

> async Task<ResultSet> MySqlConnector.Core.ResultSet.ReadResultSetHeaderAsync(IOBehavior ioBehavior) (@mysql-async/MySqlConnector.dll:0)
SCRIPT ERROR: @esx_identity/server/main.lua:11: attempt to index a nil value (field '?')

> ref (@esx_identity/server/main.lua:11)

> async void 

MySQLAsync.Operation<System.Collections.Generic.List<System.Collections.Generic.Dictionary<string, object>>>+<ExecuteAsync>d__7.MoveNext() (@mysql-async/MySQLAsync.net.dll:0)

> async Task<List<Dictionary<string, object>>> MySQLAsync.FetchAll.ReaderAsync(MySqlCommand command) (@mysql-async/MySQLAsync.net.dll:0)

> async Task<DbDataReader> MySqlConnector.Core.TextCommandExecutor.ExecuteReaderAsync(string commandText, MySqlParameterCollection parameterCollection, CommandBehavior behavior, IOBehavior ioBehavior, CancellationToken cancellationToken) (@mysql-async/MySqlConnector.dll:0)

> async Task<MySqlDataReader> MySql.Data.MySqlClient.MySqlDataReader.CreateAsync(MySqlCommand command, CommandBehavior behavior, IOBehavior ioBehavior) (@mysql-async/MySqlConnector.dll:0)

> async Task MySql.Data.MySqlClient.MySqlDataReader.ReadFirstResultSetAsync(IOBehavior ioBehavior) (@mysql-async/MySqlConnector.dll:0)

> async Task<ResultSet> MySqlConnector.Core.ResultSet.ReadResultSetHeaderAsync(IOBehavior ioBehavior) (@mysql-async/MySqlConnector.dll:0)
SCRIPT ERROR: @esx_skin/server/main.lua:47: attempt to index a nil value (local 'user')

> ref (@esx_skin/server/main.lua:47)

> async void MySQLAsync.Operation<System.Collections.Generic.List<System.Collections.Generic.Dictionary<string, object>>>+<ExecuteAsync>d__7.MoveNext() (@mysql-async/MySQLAsync.net.dll:0)

> async Task<List<Dictionary<string, object>>> MySQLAsync.FetchAll.ReaderAsync(MySqlCommand command) (@mysql-async/MySQLAsync.net.dll:0)

> async Task<DbDataReader> 
MySqlConnector.Core.TextCommandExecutor.ExecuteReaderAsync(string commandText, MySqlParameterCollection parameterCollection, CommandBehavior behavior, IOBehavior ioBehavior, CancellationToken cancellationToken) (@mysql-async/MySqlConnector.dll:0)

> async Task<MySqlDataReader> MySql.Data.MySqlClient.MySqlDataReader.CreateAsync(MySqlCommand command, CommandBehavior behavior, IOBehavior ioBehavior) (@mysql-async/MySqlConnector.dll:0)

> async Task MySql.Data.MySqlClient.MySqlDataReader.ReadFirstResultSetAsync(IOBehavior ioBehavior) (@mysql-async/MySqlConnector.dll:0)

> async Task<ResultSet> MySqlConnector.Core.ResultSet.ReadResultSetHeaderAsync(IOBehavior ioBehavior) (@mysql-async/MySqlConnector.dll:0)

Any answers are appreciated :slight_smile:

@TheIndra thanks for redirecting :smiley:

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.