Jump to content

SQL error

Closed 1.0.10 1.0.11

iMonkey
iMonkey

Posted

stats.save
MySql handle raised an exception (MySqlException: Unknown column 'c4thrown' 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)
  at Oxide.Core.MySql.Libraries.MySql+MySqlQuery.Handle () [0x000f2] in <6e6f659265ef431ea12ea404a5e9a54c>:0 
MySql handle raised an exception (MySqlException: Unknown column 'c4thrown' 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)
  at Oxide.Core.MySql.Libraries.MySql+MySqlQuery.Handle () [0x000f2] in <6e6f659265ef431ea12ea404a5e9a54c>:0 

 

I'll vouch I dont see a c4thrown column in my table structure

iMonkey

Posted

after disconnecting and reconnecting, issuing /stats in chat returns:

Player not found in wipe stats table.

iMonkey

Posted

Any love? This issue basically makes the plugin unusable. The stats.sql file bundled with the plugin doesn't appear to have structuring to include c4 and satchels (at least). 

iMonkey

Posted (edited)

Updated to 1.0.11 but now getting this with every save (site stats still seem to successfully update on disconnect):

MySql handle raised an exception (MySqlException: Incorrect string value: '\xE5\x91\x86\xE5\x92\xAA...' for column 'json' at row 1)
  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)
  at Oxide.Core.MySql.Libraries.MySql+MySqlQuery.Handle () [0x000f2] in <6e6f659265ef431ea12ea404a5e9a54c>:0 

Edited by iMonkey
iMonkey

Posted

if it helps, the webstats are missing a 0 value for nailgun kills in my test run

Billy Joe

Posted

Nailgun was removed due to two many complaints, if you can try opening on a test server with new files and see if it errors.

iMonkey

Posted

Thanks, not sure what you're requesting tho, I have the current files running on production, the sql alerts have cleared when a save runs

Billy Joe

Posted

This issue should be fixed in the recent update, make sure you get rid of your old SQL structure and use new one.

Billy Joe

Posted

Changed Status from Pending to Closed

Changed Fixed In to 1.0.11

1.4m

Downloads

Total number of downloads.

6.9k

Customers

Total customers served.

102.3k

Files Sold

Total number of files sold.

2m

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.