[Auto Exception] OperationalError: (sqlite3.OperationalError) no such column: players.technique_rating [SQL: SELECT players.id AS players_id, players.team_

[Manishrdy]

Automated issue created from exception logger.

• Type: OperationalError
• Message: (sqlite3.OperationalError) no such column: players.technique_rating [SQL: SELECT players.id AS players_id, players.team_id AS players_team_id, players.profile_id AS players_profile_id, players.name AS players_name, players.role AS players_role, players.batting_rating AS players_batting_rating, players.bowling_rating AS players_bowling_rating, players.fielding_rating AS players_fielding_rating, players.batting_hand AS players_batting_hand, players.bowling_type AS players_bowling_type, players.bow
• Severity: error
• Source: sqlite
• User: anonymous
• Request ID: n/a
• Timestamp (UTC): 2026-09-12 00:31:27.917484

Context

{
  "migration": "extend_fc_statistics_cache",
  "apply": true
}

Traceback

Traceback (most recent call last):
  File "/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1967, in _exec_single_context
    self.dialect.do_execute(
  File "/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 952, in do_execute
    cursor.execute(statement, parameters)
sqlite3.OperationalError: no such column: players.technique_rating

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/home/ubuntu/SimCricketX/migrations/extend_fc_statistics_cache.py", line 174, in run_migration
    rebuilt_tournaments, rebuilt_rows = _rebuild_caches(db)
  File "/home/ubuntu/SimCricketX/migrations/extend_fc_statistics_cache.py", line 137, in _rebuild_caches
    engine.rebuild_player_stats_cache(tournament_id, player_ids)
  File "/home/ubuntu/SimCricketX/engine/tournament_engine.py", line 1649, in rebuild_player_stats_cache
    for p in db.session.query(Player)
  File "/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/orm/query.py", line 2704, in all
    return self._iter().all()  # type: ignore
  File "/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/orm/query.py", line 2857, in _iter
    result: Union[ScalarResult[_T], Result[_T]] = self.session.execute(
  File "/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 2351, in execute
    return self._execute_internal(
  File "/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/orm/session.py", line 2249, in _execute_internal
    result: Result[Any] = compile_state_cls.orm_execute_statement(
  File "/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/orm/context.py", line 306, in orm_execute_statement
    result = conn.execute(
  File "/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1419, in execute
    return meth(
  File "/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/sql/elements.py", line 527, in _execute_on_connection
    return connection._execute_clauseelement(
  File "/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1641, in _execute_clauseelement
    ret = self._execute_context(
  File "/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1846, in _execute_context
    return self._exec_single_context(
  File "/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1986, in _exec_single_context
    self._handle_dbapi_exception(
  File "/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 2363, in _handle_dbapi_exception
    raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
  File "/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1967, in _exec_single_context
    self.dialect.do_execute(
  File "/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 952, in do_execute
    cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such column: players.technique_rating
[SQL: SELECT players.id AS players_id, players.team_id AS players_team_id, players.profile_id AS players_profile_id, players.name AS players_name, players.role AS players_role, players.batting_rating AS players_batting_rating, players.bowling_rating AS players_bowling_rating, players.fielding_rating AS players_fielding_rating, players.batting_hand AS players_batting_hand, players.bowling_type AS players_bowling_type, players.bowling_hand AS players_bowling_hand, players.batting_style AS players_batting_style, players.bowling_style AS players_bowling_style, players.technique_rating AS players_technique_rating, players.temperament_rating AS players_temperament_rating, players.stamina_rating AS players_stamina_rating, players.is_captain AS players_is_captain, players.is_wicketkeeper AS players_is_wicketkeeper, players.matches_played AS players_matches_played, players.total_runs AS players_total_runs, players.total_balls_faced AS players_total_balls_faced, players.total_fours AS players_total_fours, players.total_sixes AS players_total_sixes, players.total_fifties AS players_total_fifties, players.total_centuries AS players_total_centuries, players.highest_score AS players_highest_score, players.not_outs AS players_not_outs, players.total_balls_bowled AS players_total_balls_bowled, players.total_runs_conceded AS players_total_runs_conceded, players.total_wickets AS players_total_wickets, players.total_maidens AS players_total_maidens, players.five_wicket_hauls AS players_five_wicket_hauls, players.best_bowling_wickets AS players_best_bowling_wickets, players.best_bowling_runs AS players_best_bowling_runs, players.master_player_id AS players_master_player_id, players.user_player_id AS players_user_player_id 
FROM players 
WHERE players.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]
[parameters: (1