Jump to content
Search In
  • More options...
Find results that contain...
Find results in...
saintmichel13

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

Closed 1.0.74 1.0.76

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! 

nextgenpve2.PNG

Share this comment


Link to comment

+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 

 

Share this comment


Link to comment

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.

Share this comment


Link to comment

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

Share this comment


Link to comment

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

Share this comment


Link to comment

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

Share this comment


Link to comment

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).

Share this comment


Link to comment

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 

image.thumb.png.5c90c5a1ca72a64988543d540c72a080.png

Share this comment


Link to comment

About Us

Codefling is a forward-thinking platform for developers to share and monetize their work from plugins to game assets and everything in-between.

2,585 files sold to 298 customers and $35,723 of payments processed this year!

×
×
  • 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.