SqliteException, server not startingFixed

I noticed that after update my RAM usage went from 6GB to 10GB

ianh80

i found the issue. I removed player database plugin and all boots up fine now.

I do not have such a plugin, but there is an error ((((

That was the issue for me just thought it might help others.

did not help me :(
SqliteException: Failed to prepare query: no such table: pragma_table_info (1)
at Facepunch.Sqlite.Database.Prepare (System.String query) [0x00057] in <abe1a5bbf2094e03ad739fa3aa1cb207>:0
at Facepunch.Sqlite.Database.QueryInt[T1,T2] (System.String query, T1 arg1, T2 arg2) [0x00000] in <abe1a5bbf2094e03ad739fa3aa1cb207>:0
at Facepunch.Sqlite.Database.ColumnExists (System.String tableName, System.String columnName) [0x00000] in <abe1a5bbf2094e03ad739fa3aa1cb207>:0
at UserPersistance..ctor (System.String strFolder) [0x0017b] in <e434e630114c4960a2bee590ab9ef94c>:0
at ServerMgr.Initialize (System.Boolean loadSave, System.String saveFile, System.Boolean allowOutOfDateSaves, System.Boolean skipInitialSpawn) [0x00011] in <e434e630114c4960a2bee590ab9ef94c>:0
at Bootstrap+<StartServer>d__19.MoveNext () [0x002fb] in <e434e630114c4960a2bee590ab9ef94c>:0
at UnityEngine.SetupCoroutine.InvokeMoveNext (System.Collections.IEnumerator enumerator, System.IntPtr returnValueAddress) [0x00026] in <0b31faaf1c50461d95c83ac166a20393>:0

(Filename: <abe1a5bbf2094e03ad739fa3aa1cb207> Line: 0)

@RustBot I disabled plugin NextGenPve and everything worked, the server is loading!
my server without plugins also fails 🀬

Got the same message with "SqliteException: Failed to prepare query: no such table: pragma_table_info (1)"

Running Linux
removed all player*.db from the rustserver directory
removed all plugins temporary from the plugins folder
validated all files with steam
reinstalled umod

still same issue

Confirmed if you have the same error as i did and @ianh80 on the beginning of this post get rid of Player Database my server works now!

FastCD
@RustBot I disabled plugin NextGenPve and everything worked, the server is loading!

I am using TruePve - but I want to keep a PVE server lol

Gidys

Confirmed if you have the same error as i did and @ianh80 on the beginning of this post get rid of Player Database my server works now!

Not using that mod, but how did you remove it? Just the plugin or did you remove the data, etc?

I would assume removing the plugin should be good enough, but after removing all plugins it's still running into that problem for me.

@qwertyAT I removed the plugin PlayerDatabase.cs and oxide/data/playerdatabase.db it seems that some people have a bit diffrent kind of this issue but for me and ianh80 (we had the exact same error) it worked to just remove it
RustBot

I am using TruePve - but I want to keep a PVE server lol

After loading the server, I turned the plugin back on! Everything is working! But for now, you can't reload )))))))

@Gidys thanks. :)

Yea, I'm looking for similarities, that's why I also was curious what files you did delete.

But nothing in my data folder but json and some oxide.*.data files

1. If you have these plugins installed is for a reason removing them is not a sollution.

2. My x2 server (proc gen map) launched fine but my Training Grounds server (custom map) fails to launch and I though it's custom map issue... Any ideas? if plugins with SQLite cause the issuesΒ  then what's the fix instead of just get rid of the plugins? Still can't get what the hell is going on. I updated both of my servers as usual. They were fine before the update. Only stopped, updated and RIP. Weird...

@Flammable I am worried that indeed the issue is in SQLite for now the only thing i could do to make the server work for now is to delete the plugin and i will propably just wait for someone with a fix (try to load the plugin back in once the server loads apparently it should work that way)
Locked automatically