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

[Romain Beauxis]

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:
        /usr/share/doc/mediawiki/examples/AdminSettings.sample
   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..


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