MySql handle raised an exception (MySqlException: Unknown column 'UserID' in 'field list')
at MySql.Data.MySqlClient.MySqlCommand.EndExecuteNonQuery (System.IAsyncResult asyncResult) [0x00022] in <8d7380b3d3cf4bd8be324c584f371b44>:0
at (wrapper remoting-invoke-with-check) MySql.Data.MySqlClient.MySqlCommand.EndExecuteNonQuery(System.IAsyncResult)ut
at Oxide.Core.MySql.Libraries.MySql+MySqlQuery.Handle () [0x000f2] in <7a75fa05cbc04391919cf072f240bf30>:0
i also allowed admin to have stats
there are no other player other than admin this is a test server
ive verified the login and database with mysql workbench and wordpress and php scripts
i added the tables manualy they asked for columns so i put in dummy ones .. i tried not putting in tables and allowing them to be created by the script that didnt work either
"MySQL": {
"useMySQL": true,
"autoWipe": false,
"sql_port": 3306,
"sql_host": "localhost",
"sql_db": "crustybattlefield1",
"sql_user": "root",
"sql_pass": "",
"tablename": "playerranksdb1",
"LBtableName": "playerranksLeaderdb1"
}