mysql problem with mediawiki

Hi all,

I just upgrade my oneclick mediawiki and I got now this error when I work on it:

"depuis la fonction « Database::select ». MySQL a renvoyé l’erreur « 1146 : Table 'ferriere2.wikiprotected_titles' doesn't exist (mysql.ferriere-le-vayer.info) »."

Could you help me to solve this?

Thanks a lot
Marc

Because of the complications that go along with upgrading a live database, the Dreamhost One-Click Installer doesn't normally modify the database if you perform a One-Click Upgrade. In this case, it looks like MediaWiki made some changes to their database schema, which is why you've got this problem now. Fortunately, the fix looks pretty easy.

According to the MediaWiki upgrade guide, all you need to do is log in through the shell and run the maintenance/upgrade.php script. Just keep in mind that on Dreamhost, the default PHP version in your path is PHP4, and MediaWiki needs PHP5, you'll need to type the full path to the PHP5 interpreter to run the script. As such, anywhere the guide tells you to type

php <something>

you should type

/usr/local/php5/bin/php <something>

instead.

You need to do some maintenance task, from the wiki

http://wiki.dreamhost.com/Mediawiki#Upgrading_to_1.12.0

And you're done. Your site must be usable now.

Thank You very much for your help.

Marc

Thank You very much
Marc