Thanks... That was enough to steer me in the right direction. I now remember that in Decemeber I tried the upgrade, but had some problems with my custom skin. So then I just stuck with my old version. This time when I did the upgrade, it saw the new tables were already there and just skipped them.
-----Original Message----- From: mediawiki-l-bounces@Wikimedia.org [mailto:mediawiki-l-bounces@Wikimedia.org] On Behalf Of Brion Vibber Sent: Wednesday, January 11, 2006 9:35 AM To: MediaWiki announcements and site admin list Subject: Re: [Mediawiki-l] Upgrade OK, but showing old data
Anderson, Patrick G wrote:
Everything looked OK at first glance. However, when I browsed some of the pages, I noticed they were several months old. I checked the "Recent Pages" and it showed that I made edits in the past week, but when I clicked on the diff link and looked at those, it displayed old data as well. Finally I used SQLyog to open the database directly and look at the tables. in the wiki_cur table I can see the latest edits and it has the correct data there.
Is there something obvious I am missing?
Don't look at the 'cur' table, it's obsolete and leftover from your upgrade. Look in 'page', 'revision', and 'text'.
Check also for duplicate cur entries if you started with an old version of the schema without the unique title index; this could perhaps cause the wrong duplicate being picked during the upgrade.
-- brion vibber (brion @ pobox.com)