SQLiteException: SQL logic error or missing database table ngpve_rulesets has 10 columns but 9 values were supplied

Hi, i finally tried to migrate my plugin to the latest version. here are the steps that i did.

1. i removed all nextgenpve config files

2. removed all nextgenpve data files

3. unloaded dynamicpvp and zonemanager

4. removed nextgenpve plugin file (cs) --- no loaded nextgenpve plugin!

5. uploaded new version and loaded

6. error is encountered (SQLiteException: SQL logic error or missing database table ngpve_rulesets has 10 columns but 9 values were supplied)

7. i tried to open /pverule and click add  only error in logs no menu for ruleset 

 

pls help! 

+1 
hi, i'm new with this plugin and i try to change to it from truepve, but if i try to change something in gui i have this error in console:

 

Failed to call hook 'CmdNextGenPVEGUI' on plugin 'NextGenPVE v1.0.74' (SQLiteException: SQL logic error or missing database
table ngpve_rulesets has 10 columns but 9 values were supplied)
  at System.Data.SQLite.SQLite3.Prepare (System.Data.SQLite.SQLiteConnection cnn, System.String strSql, System.Data.SQLite.SQLiteStatement previous, System.UInt32 timeoutMS, System.String& strRemain) [0x0035e] in <c628cacddc184ceeb28a412d54694bf2>:0 
  at System.Data.SQLite.SQLiteCommand.BuildNextCommand () [0x000f6] in <c628cacddc184ceeb28a412d54694bf2>:0 
  at System.Data.SQLite.SQLiteCommand.GetStatement (System.Int32 index) [0x00008] in <c628cacddc184ceeb28a412d54694bf2>:0 
  at (wrapper remoting-invoke-with-check) System.Data.SQLite.SQLiteCommand.GetStatement(int)
  at System.Data.SQLite.SQLiteDataReader.NextResult () [0x00127] in <c628cacddc184ceeb28a412d54694bf2>:0 
  at System.Data.SQLite.SQLiteDataReader..ctor (System.Data.SQLite.SQLiteCommand cmd, System.Data.CommandBehavior behave) [0x00090] in <c628cacddc184ceeb28a412d54694bf2>:0 
  at (wrapper remoting-invoke-with-check) System.Data.SQLite.SQLiteDataReader..ctor(System.Data.SQLite.SQLiteCommand,System.Data.CommandBehavior)
  at System.Data.SQLite.SQLiteCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x0000c] in <c628cacddc184ceeb28a412d54694bf2>:0 
  at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery (System.Data.CommandBehavior behavior) [0x00006] in <c628cacddc184ceeb28a412d54694bf2>:0 
  at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery () [0x00006] in <c628cacddc184ceeb28a412d54694bf2>:0 
  at Oxide.Plugins.NextGenPVE.CmdNextGenPVEGUI (Oxide.Core.Libraries.Covalence.IPlayer iplayer, System.String command, System.String[] args) [0x01e57] in <b62a4a641ba444349c13ecab08135c70>:0 
  at Oxide.Plugins.NextGenPVE.DirectCallHook (System.String name, System.Object& ret, System.Object[] args) [0x0156f] in <b62a4a641ba444349c13ecab08135c70>:0 
  at Oxide.Plugins.CSharpPlugin.InvokeMethod (Oxide.Core.Plugins.HookMethod method, System.Object[] args) [0x00079] in <3606d2af539c45e4b5c61658e6a8b307>:0 
  at Oxide.Core.Plugins.CSPlugin.OnCallHook (System.String name, System.Object[] args) [0x000d8] in <c2afd8354b8b4f3ca451cf5a1aa111c3>:0 
  at Oxide.Core.Plugins.Plugin.CallHook (System.String hook, System.Object[] args) [0x00060] in <c2afd8354b8b4f3ca451cf5a1aa111c3>:0 

 

Having the same issue. I have Turrets to target Players but want them to do damage as they aren't right now. 

1.0.75 is the latest version.  1.0.74 definitely has an issue.

I have the latest version and still get this error

If that's the case then you will probably need to remove the db file and start over.  Or you can send it to me and I can try to fix it.

I removed the db file and tried typing in /pverule and I was getting an error. Reloaded the plugin and I could open the GUI but when clicking on default or Add I get the error

I tried earlier but also removed the entire data/NextGenPVE dir as well as the config file.  That worked although it was excessive.

I just removed the Data folder and Config file, reloaded the plugin and still can't add a Ruleset. I keep getting the error as stated in the first comment

That doesn't make sense.  Can you send me that db file?

That file is empty or showing empty when I click on the edit button

Disregard, it's showing something now but has that alien text

 

To make sure there isn't something funny going in with the file system, unload the plugin, delete the files, then load (instead of delete and reload).

That's normal.  It's not a text file.

So I unloaded/removed the data file, config file, and the plugin. I loaded the plugin back onto the server and it showed fine on the console. Brough up the GUI and clicked on Add under Rulesets and still getting this without touching anything else 

Changed Status from Pending to Closed

Changed Fixed In to 1.0.76

That seemed to have fixed it. I can add a Ruleset now, thanks so much

Clicking on default gives me this now though...

Another fix for that in 1.0.77.