Jump to content

Error and plugin not working

Not a Bug 1.0.17

CaptainNebulous

Posted (edited)

Just bought and installed this. I get the following message in console 

 

[Oxide] 15:51 [Error] MySql handle raised an exception in 'BetterStatistics v1.0.17' plugin (MySqlException: PROCEDURE christopher7_betterstatistics.createTable does not exist)
  at MySql.Data.MySqlClient.MySqlCommand.EndExecuteReader (System.IAsyncResult result) [0x00022] in <8d7380b3d3cf4bd8be324c584f371b44>:0 
  at (wrapper remoting-invoke-with-check) MySql.Data.MySqlClient.MySqlCommand.EndExecuteReader(System.IAsyncResult)
  at Oxide.Core.MySql.Libraries.MySql+MySqlQuery.Handle () [0x0010e] in <021a1dba6a754e42a6cc7771fdfee190>:0  
[Oxide] 15:51 [Error] MySql handle raised an exception in 'BetterStatistics v1.0.17' plugin (MySqlException: PROCEDURE christopher7_betterstatistics.createTable does not exist)
  at MySql.Data.MySqlClient.MySqlCommand.EndExecuteReader (System.IAsyncResult result) [0x00022] in <8d7380b3d3cf4bd8be324c584f371b44>:0 
  at (wrapper remoting-invoke-with-check) MySql.Data.MySqlClient.MySqlCommand.EndExecuteReader(System.IAsyncResult)
  at Oxide.Core.MySql.Libraries.MySql+MySqlQuery.Handle () [0x0010e] in <021a1dba6a754e42a6cc7771fdfee190>:0  
[Oxide] 15:51 [Error] MySql handle raised an exception (MySqlException: Table 'christopher7_betterstatistics.main_stats_wipe' doesn't exist)
  at MySql.Data.MySqlClient.MySqlCommand.EndExecuteReader (System.IAsyncResult result) [0x00022] in <8d7380b3d3cf4bd8be324c584f371b44>:0 
  at (wrapper remoting-invoke-with-check) MySql.Data.MySqlClient.MySqlCommand.EndExecuteReader(System.IAsyncResult)
  at Oxide.Core.MySql.Libraries.MySql+MySqlQuery.Handle () [0x0010e] in <021a1dba6a754e42a6cc7771fdfee190>:0  
[Oxide] 15:51 [Error] MySql command callback raised an exception (NullReferenceException: Object reference not set to an instance of an object)
  at Oxide.Plugins.BetterStatistics+<Startup>c__Iterator0.<>m__0 (System.Collections.Generic.List`1[T] list) [0x00010] in <73a3a7c7e5e042b485e5a9a0040649e2>:0 
  at Oxide.Core.MySql.Libraries.MySql+MySqlQuery+<>c__DisplayClass24_0.<Handle>b__0 () [0x0005d] in <021a1dba6a754e42a6cc7771fdfee190>:0  

 

Edited by CaptainNebulous
CaptainNebulous

Posted

After much testing and hours spent I still am having this issue. So far I haven't been able to use the plugin. Note that for now I was only going to use the MySQL/In-Game UI part of it not the web site

Billy Joe

Posted

This is to you not executing the SQL file provided on your database, please execute the .sql file on your database.

Billy Joe

Posted

Changed Status from Pending to Not a Bug

CaptainNebulous

Posted (edited)

I guess I just don't know how to use this then 😞  I don't know how to execute the file on my database.   My apologies

I think the problem is this " 
"DROP DATABASE" statements are disabled."

But I don't know how to enable them

Edited by CaptainNebulous
CaptainNebulous

Posted

So I finally got this working. Turned out I had to rename the file in the SQL to get it to work with my host's chosen file name. But after wipe I am now getting this in the logs

 

[Oxide] 11:47 [Error] MySql handle raised an exception in 'BetterStatistics v1.0.17' plugin (MySqlException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'overall.nailgun = overall.nailgun + wipe.nailgun

WHERE

overall.stea...' at line 58)

at MySql.Data.MySqlClient.MySqlCommand.EndExecuteReader (System.IAsyncResult result) [0x00022] in <8d7380b3d3cf4bd8be324c584f371b44>:0

at (wrapper remoting-invoke-with-check) MySql.Data.MySqlClient.MySqlCommand.EndExecuteReader(System.IAsyncResult)

at Oxide.Core.MySql.Libraries.MySql+MySqlQuery.Handle () [0x0010e] in <021a1dba6a754e42a6cc7771fdfee190>:0

 

CaptainNebulous

Posted

So it looks like it didn't save the wipe stats when I wiped, also whenever I try to look at another player's stats it says it can't find their stats. 

McGee007

Posted

check that i put code in my comment for procedures

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.