Skip to content

Error with fresh install using SQLite #241

Open

Description

@EmpT420

The plugin does not start with a fresh install. No previous version file present.

16:53:00 [INFO] (cssharp:PluginContext) Loading plugin CS2-SimpleAdmin


| || | | || || || | | || _ || | | || || | | | | |
| || | | || _ || | | || || || _ || || | | || |
| |
| | | || || || | | |
_ | || | | || || | | |
|_____ || | | || || | | || || || || || | | _ |
_____| || | | ||
|| || | | || |
__ | _ || || |||| || | | | | |
|
||| || |||| |||||| |||| || |||| || |__|
>> Version: 1.7.8-beta-3
>> GitHub: https://github.com/daffyyyy/CS2-SimpleAdmin

16:53:00 [INFO] (cssharp:PluginContext) Finished loading plugin CS2-SimpleAdmin (RELEASE)
16:53:00 [INFO] (cssharp:PluginContext) Loading plugin MenuManagerCore
16:53:00 [INFO] (cssharp:PluginContext) Finished loading plugin MenuManager [Core]
16:53:00 [INFO] (plugin:CS2-SimpleAdmin (RELEASE)) Migration "001_CreateTables" successfully applied.
16:53:00 [INFO] (plugin:CS2-SimpleAdmin Fun Commands) Fun menus registered successfully!
[16:53:00.383] CSSharp: CounterStrikeSharp.API Loaded Successfully.
[16:53:00.383] CSSharp: Hooks added.
16:53:00 [INFO] (plugin:CS2-SimpleAdmin (RELEASE)) Migration "002_CreateFlagsTable" successfully applied.
16:53:00 [INFO] (plugin:CS2-SimpleAdmin (RELEASE)) Migration "003_ChangeColumnsPosition" successfully applied.
16:53:00 [INFO] (plugin:CS2-SimpleAdmin (RELEASE)) Migration "004_MoveOldFlagsToFlagsTable" successfully applied.
16:53:00 [INFO] (plugin:CS2-SimpleAdmin (RELEASE)) Migration "005_CreateUnbansTable" successfully applied.
16:53:00 [INFO] (plugin:CS2-SimpleAdmin (RELEASE)) Migration "006_ServerGroupsFeature" successfully applied.
16:53:00 [INFO] (plugin:CS2-SimpleAdmin (RELEASE)) Migration "007_ServerGroupsGlobal" successfully applied.
16:53:00 [INFO] (plugin:CS2-SimpleAdmin (RELEASE)) Plugin is up to date
16:53:00 [INFO] (plugin:CS2-SimpleAdmin (RELEASE)) Migration "008_OnlineTimeInPenalties" successfully applied.
16:53:00 [EROR] (plugin:CS2-SimpleAdmin (RELEASE)) Error applying migration "009_BanAllUsedIpAddress".
code = Error (1), message = System.Data.SQLite.SQLiteException (0x87AF001F): SQL logic error
near "used_at": 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()
[StatusBlocker] <<< Load() success!
[META] Loaded 2 plugins.
Event System loaded 94 events from file: vpk:/home/container/game/core/pak01.vpk:resource/core.gameevents.
Event System loaded 50 events from file: vpk:/home/container/game/csgo/pak01.vpk:resource/game.gameevents.
Event System loaded 145 events from file: vpk:/home/container/game/csgo/pak01.vpk:./resource/mod.gameevents.
CEntitySystem::BuildEntityNetworking (parallel build of server) took 28.380 msecs for 206 out of 286 classes
[STARTUP] {2.101} server module init ok

Activity

  1. EmpT420 commented on Oct 26, 2025

    @EmpT420
    Author

    Missing coma at the end of 'address' INTEGER NOT NULL

    Fixed:

    CREATE TABLE IF NOT EXISTS `sa_players_ips` (
                                                    `steamid` INTEGER NOT NULL,
                                                    `address` INTEGER NOT NULL,
                                                    `used_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
                                                    PRIMARY KEY (`steamid`, `address`)
    );
    
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions