[Mediawiki-l] Upgrade OK, but showing old data

[Anderson, Patrick G]

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 at Wikimedia.org
[mailto:mediawiki-l-bounces at 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)