[Mediawiki-l] Help with images lost in database upgrade

[Brion Vibber]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Sean Forman wrote:
> http://www.bbref.com/bullpen/
> 
> Fairly large wiki, with 12,000 images and 46,000 pages.  This morning we
> upgraded our database server to a newer machine.  All of the content, etc
> works fine and nothing was lost, but now images no longer appear and are
> replaced with their names.   Clicking on the name says image not found.
> 
> The images are still there on the server in the images dir.  For example.
> 
> http://www.baseball-reference.com/bullpen/Image:100px-Floridamarlins.gif
> can be found here
> http://www.baseball-reference.com/bpv/images/5/51/100px-Floridamarlins.gif
> 
> I've tried rebuildImages.php from the command line and that doesn't do the
> trick.  Any thoughts?  Re-import them?
> 
> I'm guessing that updating the db somehow messed up mediawiki knowing the
> exact path to the image, but I'm not sure about that.

The paths seem just fine, see the 'file' links at
http://www.baseball-reference.com/bullpen/Special:Imagelist

I'm not really sure what's going on... You seem to have database entries
(they show up on Special:imagelist and Special:newimages) and files (the
links from imagelist are fine), but they're not matching up in usage.

It's possible something's gone weird in your 'image' table such that the
data's there but doesn't get matched properly when doing queries; maybe
a broken collection or null-padding or something funky. Do some checks
on the database and see what the data and the structure look like...

- -- brion
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.8 (Darwin)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEARECAAYFAkibVd4ACgkQwRnhpk1wk47BOgCg0X1+9ptAVok00PEdZtfk7k1I
GU0Anib/+cg17djfJm3C1lABkijiM4U4
=Nnw+
-----END PGP SIGNATURE-----