Jump to content
Search In
  • More options...
Find results that contain...
Find results in...
wethecom

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

About Us

Codefling is a forward-thinking platform for developers to share and monetize their work from plugins to game assets and everything in-between.

2065 files sold to 246 customers and $26874.99 of payments processed this year!

×
×
  • 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.