Jump to content

Error with SQL

Pending 2.2.1
The Friendly Chap

By The Friendly Chap,

The Friendly Chap

The Friendly Chap 238

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,422

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 2

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,422

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 2

Posted

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

Customers

Everything customers need to manage purchases, support, and discover services.

Providers

Quick access to the tools creators use to manage files, support, and earnings.

Resources

Docs, support resources, and tools to help users and creators move faster.

About Us

Codefling is the largest marketplace for plugins, maps, tools, and more, making it easy for customers to discover new content and for creators to monetize their work.

Downloads
2.5m
Total downloads
Customers
11.1k
Customers served
Files Sold
159.6k
Total sales
Payments
3.4m
Processed total
Customer Reviews 147 verified reviews 4.0
×
×
  • 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.