Page MenuHomePhabricator

wikiloves updates fail with "Unknown column 'cl_to' in 'SELECT'"
Closed, ResolvedPublic

Description

Traceback:

pymysql.err.OperationalError: (1054, "Unknown column 'cl_to' in 'SELECT'")

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/data/project/wikiloves/./wikiloves/database.py", line 191, in <module>
    db = update_event_data(event_name, event_configuration, db)
  File "/data/project/wikiloves/./wikiloves/database.py", line 146, in update_event_data
    event_data = getData(event_slug, event_configuration)
  File "/data/project/wikiloves/./wikiloves/database.py", line 53, in getData
    country_data = get_country_data(cat, start_time, end_time)
  File "/data/project/wikiloves/./wikiloves/database.py", line 67, in get_country_data
    dbData = get_data_for_category(category)
  File "/data/project/wikiloves/./wikiloves/database.py", line 127, in get_data_for_category
    query_data = commonsdb.query(dbquery, (category_name,))
  File "/data/project/wikiloves/wikiloves/commons_database.py", line 51, in query
    return self._query(*sql)
  File "/data/project/wikiloves/wikiloves/commons_database.py", line 33, in _query
    cursor.execute(*sql)
  File "/data/project/wikiloves/www/python/venv/lib/python3.9/site-packages/pymysql/cursors.py", line 158, in execute
    result = self._query(query)
  File "/data/project/wikiloves/www/python/venv/lib/python3.9/site-packages/pymysql/cursors.py", line 325, in _query
    conn.query(q)
  File "/data/project/wikiloves/www/python/venv/lib/python3.9/site-packages/pymysql/connections.py", line 549, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  File "/data/project/wikiloves/www/python/venv/lib/python3.9/site-packages/pymysql/connections.py", line 779, in _read_query_result
    result.read()
  File "/data/project/wikiloves/www/python/venv/lib/python3.9/site-packages/pymysql/connections.py", line 1157, in read
    first_packet = self.connection._read_packet()
  File "/data/project/wikiloves/www/python/venv/lib/python3.9/site-packages/pymysql/connections.py", line 729, in _read_packet
    packet.raise_for_error()
  File "/data/project/wikiloves/www/python/venv/lib/python3.9/site-packages/pymysql/protocol.py", line 221, in raise_for_error
    err.raise_mysql_exception(self._data)
  File "/data/project/wikiloves/www/python/venv/lib/python3.9/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
    raise errorclass(errno, errval)
pymysql.err.OperationalError: (1054, "Unknown column 'cl_to' in 'SELECT'")

Related Objects

Event Timeline

This tool seems to still be broken and hasn't updated in several days. Is this just for the current Wiki Loves contest (i.e. Folklore) or for all WL contests?

Mentioned in SAL (#wikimedia-cloud) [2026-04-11T18:26:42Z] <wmbot~jeanfred@tools-bastion-15> Deploy 1f12fc8 (Update database query following categorylinks normalization) for T420408

Mentioned in SAL (#wikimedia-cloud) [2026-04-11T19:52:32Z] <wmbot~jeanfred@tools-bastion-15> Deploy 3f3c90198 (Fix query performance by using subquery instead of JOIN for linktarget) for T420408

JeanFred claimed this task.