Jump to content

Error with SQL

Pending 2.2.1
The Friendly Chap

By The Friendly Chap,

The Friendly Chap

The Friendly Chap 228

Posted 

(22:33:00) | [PlayerRanks] PlayerRanks local database was saved.
(22:33:02) | [PlayerRanks] Please do not reload, or unload, PlayerRanks until save-completion message.
(22:33:04) | MySql handle raised an exception (MySqlException: Unknown column 'MLRSFired' 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
(22:33:04) | [PlayerRanks] SQL saving is complete.
(22:33:04) | MySql handle raised an exception (MySqlException: Column count doesn't match value count 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
(22:33:04) | [PlayerRanks] SQL saving is complete.

Seems to error when trying to save the SQL database.
 

  • Administrator
Steenamaroo

Steenamaroo 1,167

Posted

  • Administrator

Hi,
In the update notes...

SQL users will need to drop their tables.
PlayerRanks will create a new table with columns for the new categories.

That'll get you back up and running.

Vnuk

Vnuk 1

Posted

Me too!!!!

Even after deleting the SQL table and a full reload, I get an error... 

16:55 [Error] MySql handle raised an exception (MySqlException: Column count doesn't match value count 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

 

  • Administrator
Steenamaroo

Steenamaroo 1,167

Posted

  • Administrator

I found a minor issue relating to snapshot leaderboards.
If you're seeing that error when manually saving a leaderboard, I've found the problem and will update soon.
Thanks for reporting it!

Vnuk

Vnuk 1

Posted

Yes, it crashes when manually saving. Thank you for your creativity!

1.4m

Downloads

Total number of downloads.

6.9k

Customers

Total customers served.

102.2k

Files Sold

Total number of files sold.

2m

Payments Processed

Total payments processed.

Customers

Providers

Resources

About Us

Codefling is the largest marketplace to buy and sell plugins, maps, tools, and more! Our modern platform makes it easy to find exciting new content while providing a feature-rich environment for creators to monetize their work!

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