I shouldn't have used the mediawiki package from ubuntu's repository. My initial thought was that since I wasn't that eager to taste all the newest features of mediawiki, I'd better use the package management system of the OS and avoid all the hassles of manual upgrading.
However... after I upgarded from ubuntu 8.04 (hardy) to 8.10 (intrepid), there were still errors like the following shown.
1146: Table 'wikidb.mw_protected_titles' doesn't exist (localhost)Apparently the database wasn't updated with the system upgrade, it turns out that the ubuntu package didn't provide me the AdminSettings.php (not even an AdminSettings.sample) file for updating database. So I had to add it by myself and provided it with database admin password and then run
php update.phpunder {mediawiki_root}/maintainence manually.
Hope this helps.