Jump to content

Error with SQL

Pending 2.2.1
The Friendly Chap

By The Friendly Chap,

  • Report this file
    • The Friendly Chap 
    (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.
     

    Share this comment

    Link to comment
    Steenamaroo

    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.

    Share this comment

    Link to comment
    Vnuk

    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

     

    Share this comment

    Link to comment
    Steenamaroo

    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!

    Share this comment

    Link to comment
    1.1m

    Downloads

    Total number of downloads.

    5.7k

    Customers

    Total customers served.

    82.3k

    Files Sold

    Total number of files sold.

    1.6m

    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.