Skip to content

Database schema out of sync - missing cl_collation column #20

Description

@magent-cryptograss

Problem

Category queries failing with:

Error 1054: Unknown column 'cl_collation' in 'SELECT'

This affects:

  • Category pages not listing their members
  • SMW queries that use categories
  • Likely the reason newly created venue pages aren't showing up in queries

Cause

MediaWiki was upgraded but maintenance/update.php wasn't run to update the database schema.

Fix

SSH to PickiPedia server and run:

cd /path/to/mediawiki
php maintenance/update.php

Context

Discovered while creating St. Petersburg scene + 13 venue pages. The pages exist but category/SMW queries return empty or error.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Fields

    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions