The DLL in the above photo is working.

This whole situation was ridiculous.

Can we get a link to that Discord please so we can get that?

Beware of random DLL sources, although this one may be... ok?

Btw, Economics may be impacted as well if you use SQLite.  Not certain but disabled while I debug my two sqlite plugins.

I did already delete the player.*.db earlier and rust did recreate them.

So now I tried the sql query but it did result in:

sqlite> ALTER TABLE data ADD COLUMN locked BOOLEAN DEFAULT 0;
Error: duplicate column name: locked

sqlite> pragma table_info('data');
0|userid|INT|0||1
1|token|INT|0||0
2|locked|BOOLEAN|0|0|0

what do i do with the dll once ive got it downloaded

evanvolcano

what do i do with the dll once ive got it downloaded

upload to
/RustDedicated_Data/Managed/

This .dll file also worked for me. 

Ludek

upload to
/RustDedicated_Data/Managed/

now my server just does this

08.07 18:38:22[Server]INFO Success! App '258550' fully installed.
08.07 18:38:22[Server]INFO [Multicraft] Preinstall finished, exit code 0
08.07 18:38:22[Server]INFO [Multicraft] Spawning postinstall process
08.07 18:38:22[Server]INFO % Total % Received % Xferd Average Speed Time Time Time Current
08.07 18:38:22[Server]INFO Dload Upload Total Spent Left Speed
08.07 18:38:22[Server]INFO 0 0 0 0 0 0 0 0 --:--:-- --:--:-- --:--:-- 0
08.07 18:38:22[Server]INFO 100 14336 100 14336 0 0 102k 0 --:--:-- --:--:-- --:--:-- 102k
08.07 18:38:22[Server]INFO node:internal/errors:841
08.07 18:38:22[Server]INFO const err = new Error(message);
08.07 18:38:22[Server]INFO ^
08.07 18:38:22[Server]INFO Error: Command failed: sqlite3 /server/my_server_identity/player.tokens.db "ALTER TABLE data ADD COLUMN locked BOOLEAN DEFAULT 0;" 2> /dev/null
08.07 18:38:22[Server]INFO at checkExecSyncError (node:child_process:828:11)
08.07 18:38:22[Server]INFO at Object.execSync (node:child_process:899:15)
08.07 18:38:22[Server]INFO at /opt/wrapper/src/index.js:155:23
08.07 18:38:22[Server]INFO at new Promise (<anonymous>)
08.07 18:38:22[Server]INFO at /opt/wrapper/src/index.js:151:11
08.07 18:38:22[Server]INFO at processTicksAndRejections (node:internal/process/task_queues:96:5) {
08.07 18:38:22[Server]INFO status: 1,
08.07 18:38:22[Server]INFO signal: null,
08.07 18:38:22[Server]INFO output: [ null, null, null ],
08.07 18:38:22[Server]INFO pid: 58,
08.07 18:38:22[Server]INFO stdout: null,
08.07 18:38:22[Server]INFO stderr: null
08.07 18:38:22[Server]INFO }
08.07 18:38:23[Multicraft] Server shut down (starting)
08.07 18:38:23[Multicraft] Restarting crashed server in 10 seconds
08.07 18:38:23[Multicraft] Looks like a crash, check the server console. Return value: 1
08.07 18:38:23[Multicraft] Server stopped

you need remove  player.token.db

agresos

you need remove  player.token.db

got rid of it, keep getting the same issue

first apply update rust or file validation... then last oxide update... and finally apply the fix DLL

agresos

first apply update rust or file validation... then last oxide update... and finally apply the fix DLL

what do you mean by "apply update rust"

So, it appears that this whole thread consists of two parites having seperate issues caused by the new way rust servers on linux hook into sqlite. 

As of yesterdays wipe, a completely fresh vanilla build of Rust doesn't work on some linux platforms using a certain build of sqlite to save player and map information resulting in this same error. This problem has yet to be fixed:

SqliteException: Failed to prepare query: near "(": syntax error (1)
at Facepunch.Sqlite.Database.Prepare (System.String query) [0x00057] in <f537fb739ea24f7c9c05975bd1a8de6b>:0
at Facepunch.Sqlite.Database.QueryInt[T1,T2] (System.String query, T1 arg1, T2 arg2) [0x00000] in <f537fb739ea24f7c9c05975bd1a8de6b>:0
at Facepunch.Sqlite.Database.ColumnExists (System.String tableName, System.String columnName) [0x00000] in <f537fb739ea24f7c9c05975bd1a8de6b>:0
at UserPersistance..ctor (System.String strFolder) [0x0017b] in <fa5bc33ffcdf4090ada554e73762793f>:0
at ServerMgr.Initialize (System.Boolean loadSave, System.String saveFile, System.Boolean allowOutOfDateSaves, System.Boolean skipInitialSpawn) [0x00006] in <fa5bc33ffcdf4090ada554e73762793f>:0
at Bootstrap+<StartServer>d__19.MoveNext () [0x002fb] in <fa5bc33ffcdf4090ada554e73762793f>:0
at UnityEngine.SetupCoroutine.InvokeMoveNext (System.Collections.IEnumerator enumerator, System.IntPtr returnValueAddress) [0x00026] in <0b31faaf1c50461d95c83ac166a20393>:0

The other problem, which was hotfixed by the .DLL file above, only works regarding a server able to que vanilla save information but struggles to write to sqlite databases on OxideRust via plugins. Keep in mind Oxide is not a service itself but rather an extension of the vanilla server (duh). This won't resolve the sqlite issue with vanilla Rust resulting in the string query 0x00057 being printed.