mysql error on save

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"
  }

and it worked

look into database wrapper for nuget..