Jump to content

MySql handle raised an exception

Pending 1.5.17

xxxproms

Posted

Hello UltimateLeaderboard Support Team (Developer Mevent),

And I’m using your plugin UltimateLeaderboard on my Rust server.
The plugin worked perfectly on version 1.5.14, but after updating to version 1.5.17 I’m encountering a database error:

[21:11:54] > MySql handle raised an exception (MySqlException: Table 'base_clan_st.PlayerStats' doesn't exist)
  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 <021a1dba6a754e42a6cc7771fdfee190>:0 

It seems like the update to 1.5.17 introduced some change in the database schema, or the plugin is now referencing a table that no longer exists.

MeventSupport

Posted

Hi! You’d better remove the period (.) from the leaderboard table prefix.
 

Periods (the dot character, ".") are effectively reserved in MySQL because they serve as the qualifier separator for multipart identifiers (database.table.column). That design decision leads to both syntactic and practical restrictions

xxxproms

Posted

I’ve double-checked my database settings, and I don’t have a dot (.) in either the database name or the table prefix. Here are the relevant MySQL settings (password redacted):

Host: blabla.beget.tech  
Port: 3306  
Database Name: blabla_clan_st  
Username: blabla_clan_st  
Table Prefix: clan  

In version 1.5.14 everything worked fine. After updating to 1.5.17 it started throwing the error:

Quote

MySqlException: Table 'xxxpro7r_clan_st.PlayerStats' doesn’t exist

Since I haven’t introduced any dot in the prefix or database name, it suggests the issue lies somewhere in the plugin’s logic—perhaps how it constructs or expects table names in this new version.

Could you please check if version 1.5.17 introduced changes in table naming or expected schema? And if possible provide guidance or patch to restore compatibility with my existing tables.

Thank you in advance for your help.

  • Curator
Mevent

Posted

can u send me ur config?

2m

Downloads

Total number of downloads.

9.5k

Customers

Total customers served.

138.2k

Files Sold

Total number of files sold.

2.9m

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.