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

Capture.png

Share this comment


Link to comment

Hi,

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

Edited by Steenamaroo

Share this comment


Link to comment
1.1m

Downloads

Total number of downloads.

5.4k

Customers

Total customers served.

77.7k

Files Sold

Total number of files sold.

1.5m

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.