Last modified: 2007-12-22 19:33:09 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T14314, the corresponding Phabricator task for complete and up-to-date bug report information.

Bug 12314 - Bug in includes/Title.php


Summary:	Bug in includes/Title.php

Status:	CLOSED FIXED

Product:	MediaWiki
Classification:	Unclassified
Component:	Database (Other open bugs)
Version:	1.12.x
Hardware:	All All

Importance:	High major (vote)
Target Milestone:	---
Assigned To:	Nobody - You can work on this!

URL:
Whiteboard:
Keywords:	patch, patch-need-review

Depends on:
Blocks:
	Show dependency tree / graph

Reported:	2007-12-15 11:58 UTC by Bertrand GRONDIN
Modified:	2007-12-22 19:33 UTC (History)
CC List:	1 user (show)

See Also:
Web browser:	---
Mobile Platform:	---
Assignee Huggle Beta Tester:	---

Attachments
Correcting bug in MySql database (1.01 KB, patch) 2007-12-15 12:04 UTC, Bertrand GRONDIN	Details
Add an attachment (proposed patch, testcase, etc.)

Description Bertrand GRONDIN 2007-12-15 11:58:15 UTC

Comment 1 Bertrand GRONDIN 2007-12-15 12:03:02 UTC

When you protect a Title (new functionnality) which is not created, we read the following error message

depuis la fonction « Title::updateTitleProtection ». MySQL a renvoyé l’erreur « 1054 : Unknown column 'pt_user' in 'field list' (sql:3306) ».

The problem is due to a bug in Title.php lines 1209 and 1298. The `protected_titles` TABLE in MySql database has no column intituled `tp_user` but has `pt_by` column

I join a patch file correcting this mistake.

Comment 2 Bertrand GRONDIN 2007-12-15 12:04:44 UTC

Created attachment 4440 [details]
Correcting bug in MySql database

This is the patch file which corrects the problem.

Comment 3 Bertrand GRONDIN 2007-12-15 12:05:29 UTC

This problem is severe

Comment 4 Bertrand GRONDIN 2007-12-16 16:03:32 UTC

The problem is due from the revision #28417 which modify `pt_by` to `pt_user` without changing the name of the column to the `protected_titles` TABLE.

The revision must be reverted or the column 'pt_by' `protected_titles` TABLE to be modified in 'pt_user'. 

I thing that a simple reverted will be better.

Comment 5 Aryeh Gregor (not reading bugmail, please e-mail directly) 2007-12-16 21:28:47 UTC

Changed tables.sql in r28570 for MySQL.  I expect Greg will fix pgsql shortly.

Wikimedia Bugzilla is closed!

Search

Personal tools

Navigation

Links