Update from 1.19 to 1.23 fails: Error: 1054 Unknown column 'page_content_model' in 'field list'.
Closed, DuplicatePublic
Actions

Assigned To

Authored By

	MarkAHershberger
	Dec 15 2014, 9:53 PM

Description

From Support Desk:

Hi. I am having problems upgrading my mediawiki instance. SO far I have: replaced all files with 1.23.7 files,
added back a couple of custom lines for auth, upgraded all extensions to 1.23 and removed unsupported ones
and then tried to run php update.php. The script connects and then fails shorty afterward on
Error: 1054 Unknown column 'page_content_model' in 'field list'. Does anyone know where this table gets created?

And this reply:

Sorry, I don't know. But you at least are not the first and only person, who has this problem. I found a number of hits
for this problem on Google. Maybe they bring you to the right idea?

Link from reply: https://www.google.de/search?q=%22Error:+1054+Unknown+column+%27page_content_model%27+in+%27field+list%27.%22

Related Objects

Mentioned In: T88263: Clean #Wiki-Release-Team project
T78236: Phabricator silently overwrites changes (no mid-air collision/conflict detection)
Mentioned Here: rEDPLd9cd11826ef3: Don't check for Template:Extension_DPL during update
T59335: Issue running update.php on fresh install when both AbuseFilter and Echo are being installed
T62492: ExtDynamicPageList::commonSetup() uses Title::exists() and causes problems in update.php

Event Timeline

MarkAHershberger created this task.Dec 15 2014, 9:53 PM

MarkAHershberger claimed this task.

MarkAHershberger raised the priority of this task from to Needs Triage.

MarkAHershberger updated the task description. (Show Details)

MarkAHershberger changed Security from none to None.

MarkAHershberger added a project: Wiki-Release-Team.

MarkAHershberger added a subscriber: Mglaser.

MarkAHershberger subscribed.

Ciencia_Al_Poder subscribed.Dec 15 2014, 9:56 PM

Krinkle updated the task description. (Show Details)Dec 15 2014, 9:56 PM

Krinkle removed a subscriber: Ciencia_Al_Poder.

Krinkle added a subscriber: Ciencia_Al_Poder.

Malyacko subscribed.Dec 15 2014, 10:00 PM

Aklapper mentioned this in T78236: Phabricator silently overwrites changes (no mid-air collision/conflict detection).Dec 16 2014, 5:10 PM

Palexis moved this task from Backlog to Need Discussion on the Wiki-Release-Team board.Jan 1 2015, 11:40 PM

greg edited projects, added MW-1.23-release; removed Wiki-Release-Team.Feb 5 2015, 11:08 PM

greg mentioned this in T88263: Clean #Wiki-Release-Team project.Feb 5 2015, 11:34 PM

Aklapper renamed this task from Update to latest LTS fails to Update to latest LTS fails: Error: 1054 Unknown column 'page_content_model' in 'field list'..Feb 6 2015, 12:14 PM

Aklapper renamed this task from Update to latest LTS fails: Error: 1054 Unknown column 'page_content_model' in 'field list'. to Update from 1.19 to 1.23 fails: Error: 1054 Unknown column 'page_content_model' in 'field list'..

Aklapper triaged this task as Low priority.

Did anyone ask the original reporter for installed extensions?

Found T62492 (but DPL seems to be not involved here). T59335 mentions some other extensions.
Also see http://stackoverflow.com/questions/26831047/mediawiki-database-recovery

Error: 1054 Unknown column page_content_model in 'field list'

This is a MySQL error number and the task reported upgrading from MediaWiki 1.19 to 1.23.

The page_content_model field however is part of the updater.

MysqlUpdater.php

	// 1.21
	// ..
	[ 'addField', 'page', 'page_content_model', 'patch-page-page_content_model.sql' ],

Looking for other reports via Google:

https://www.mediawiki.org/wiki/Topic:Raukamfvlfdvadoh "[RESOLVED] upgrade from 1.16.1 to 1.21.1 failing"
- Running update.php from command-line failed. Uninstalling DPL solved the issue. Using the web updater also worked (with DPL installed).
https://www.mediawiki.org/wiki/Topic:Rlqs29fxd74rxtpo "[RESOLVED] Database error in upgrading from 1.18 to 1.22"
- The error comes from WikiPage or LinkCache. This suggests something is trying to create a page using the current MediaWiki source code before the updater runs. Core's own logic for that (e.g. createSysop, createMainpage etc.) always run after the schema updates for this reason. Perhaps the DPL extension tries to do it before hand and fails because WikiPage assumes the schema to be up to date.

Looking at the DynamicPageList extension source code, I found the culprit. commonSetup() tried to create Template:Extension DPL during the initialisation of the source code. This was fixed by @MarkAHershberger in rEDPLd9cd11826ef3: Don't check for Template:Extension_DPL during update - landed in master for 1.24 and backported to REL1_22 and REL1_23.

Closing as resolved.

Krinkle merged a task: T62492: ExtDynamicPageList::commonSetup() uses Title::exists() and causes problems in update.php.Apr 18 2017, 10:05 PM

Krinkle closed this task as a duplicate of T62492: ExtDynamicPageList::commonSetup() uses Title::exists() and causes problems in update.php.

Krinkle added subscribers: Bawolff, • wikibugs-l-list, Calygos.

Update from 1.19 to 1.23 fails: Error: 1054 Unknown column 'page_content_model' in 'field list'.Closed, DuplicatePublicActions

Description

Related Objects

Event Timeline

Update from 1.19 to 1.23 fails: Error: 1054 Unknown column 'page_content_model' in 'field list'.
Closed, DuplicatePublic
Actions