Topic on Project:Support desk

Hi

We've moved a Wiki farm to a new server (copy-pasting the db content) and upgraded to 1.33.1. One thing we are struggling with are the images, they are not showing.

I checked the following things

- The database entries for the images exist - there are entries in the images, pages (and probably some more tables)

- The files exist on the fs

- Special:MediaStatistics shows a probable distribution of media files

- $wgShellLocale = "C.UTF-8"; (according to the troubleshooting page)

On the other side

- The page does not make a GET request to retrieve the image, in contrast to the previous installation

- Special:ListFiles does not show any files

- checkImages.php returns Good images: 0/0

Thanks for your help!

If you upgraded at the same time - sometimes this can happen if the actors upgrade didn't work properly.

Can you try running cleanupUsersWithNoId.php followed by migrateActors.php and see if that helps?

Hi Bawolff

Thanks for your help!

In the meantime I compared a new insert with the existing entries in the images table. All the old entries have 0 as value in the img_description_id, i.e. they don't link to an existing comment. When I try adjust the img_description_id to another comment, I can see the image in the Special:ListFiles page - thus I would assume that is the problem.

Will the cleanupUsersWithNoId.php and migrateActors.php handle that as well? Is there another script doing this?

Sorry, I'm pretty new to MediaWiki - in case cleanupUsersWithNoId.php helps: What would be a reasonable choice for the --prefix parameter?

Thanks!

i think prefix can be pretty much anything. "Import>" i think is a common choice.

That will mostly fix if the img_actor field is messed up. If img_description_id is messed up, i guess retry running update.php. you can also try running migrateComments.php maybe with --force option

Hi Bawolff

migrateComments.php did not help, but I think I should be able to restore the comment table with the old data in the imagestable.

Thanks so much for your help.