837736 - Development wikimo: Database error on save.

Status: RESOLVED FIXED

(Infrastructure & Operations Graveyard :: WebOps: Other, task)

Description

[Justin Crawford [:hoosteeno] [:jcrawford]]

Dev environment only (https://wiki-dev.allizom.org):

Saving a page causes a database error.

Browser: FF 18.0.1
OS: OSX 10.8.2

Error:

A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:

    (SQL query hidden)

from within function "DatabaseBase::select". Database returned error "1054: Unknown column 'group_custom_texts' in 'field list' (dev-zeus-rw.db.phx1.mozilla.com)".

Comment 1

[Mark A. Hershberger (hexmode)]

You need to run the following command in the wiki directory:

  php maintenance/update.php

This is a normal part of upgrading.  I should have included directions for this.

Comment 2

[Mark A. Hershberger (hexmode)]

The problem here was a schema change that wasn't put in place properly.  Reverting the SemanticWatchlist submodule back to the REL1_19 branch fixed the problem.  The problem with them submodule is recorded here: https://bugzilla.wikimedia.org/show_bug.cgi?id=44648

Comment 3

[Jason Crowe [:jd]]

Thanks for the fix :)