Jump to content

mysql error on save

Pending 2.1.4


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"


Link to comment
  • Administrator


Completely remove the tables then reload, or save, PlayerRanks.
The tables will then be created automatically.

Edited by Steenamaroo
Link to comment


Total number of downloads.



Total customers served.


Files Sold

Total number of files sold.


Payments Processed

Total payments processed.

  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.