Repository navigation
problem migration #13 #240
Description
08:08:28 [EROR] (plugin:CS2-SimpleAdmin (RELEASE)) Error applying migration "013_AddNameColumnToSaPlayerIpsTable".
code = Error (1), message = System.Data.SQLite.SQLiteException (0x87AF001F): SQL logic error
near "TRUNCATE": syntax error
at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, SQLiteCommand command, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
at System.Data.SQLite.SQLiteDataReader.NextResult()
at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteNonQueryAsync(CancellationToken cancellationToken)
--- End of stack trace from previous location ---
at CS2_SimpleAdmin.Database.Migration.ExecuteMigrationsAsync()
at CS2_SimpleAdmin.Database.Migration.ExecuteMigrationsAsync()
I don't understand why it's not working. I even tried to modify the table manually.
Still the same error. :-(
Activity
Weapon8 commentedon Oct 26, 2025
CS2-SimpleAdmin/Database/Migrations/Sqlite/013_AddNameColumnToSaPlayerIpsTable.sql
TRUNCATE TABLE
sa_players_ips;ALTER TABLE
sa_players_ipsADDnameVARCHAR(64) NULL DEFAULT NULL;CREATE INDEX IF NOT EXISTS
idx_sa_players_ips_used_atONsa_players_ips(used_atDESC);TRUNCATE TABLE no exist on sqlite DELETE FROM it's real script it's possible you change it pls?
NJOOSHY commentedon Mar 26, 2026
yeah i have encountered this as creating sa_bans , did you solve it ?