[Pkg-mediawiki-devel] Bug#472831: Bug#472831: mediawiki: Cannot create a new page

Romain Beauxis toots at rastageeks.org
Wed Mar 26 19:02:50 UTC 2008

Le Wednesday 26 March 2008 19:21:49 autoconf, vous avez écrit :
> Package: mediawiki
> Version: 1:1.12.0-1
> Severity: important
> Whenever I try to create a new page, I get the following error:
> Database 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 "Database::select". MySQL returned error "1146: Table
> 'wikidb.protected_titles' doesn't exist (localhost)".
> The URL leading to this was
> http://localhost/mediawiki/index.php?title=Fubar&action=edit
> This used to work. I installed mediawiki very recently, and it initially
> used to work. I had successfully created a page. Now, for no apparent
> reason, it does not work any more, and I cannot create any page no matter
> what it's named.

Did you recently upgraded to 1.12.0 from 1.11.x ?

If this is the case, then you should need to update the database.

A rapid sketch is the following:
  1) Dump your database to a text file.
     mysqldump --add-drop-table -u <user> -p <my-database> > /path/to/file.sql
  2)   You will need an AdminSettings.php file.
   If you don't have any, a sample is available at:
   You may fill in this file and copy it in /etc/mediawiki.
    If you use the mysql root account, you may delete it afterward.
  3)  Then run this command:
          php /var/lib/mediawiki/maintenance/update.php
   This shall need a proper php5 binary, as provided in php5-cli

This is documented but not in this precise case. I'll add some more 
documentation to the package..

If you are the big tree,
We are the small axe,
Ready to cut you down,
Sharpen to cut you down...

More information about the Pkg-mediawiki-devel mailing list