Topic on Project:Support desk

If it helps any other newbie. After experimentation I found Bawolff's reply to more precisely mean:

SELECT img_name from image where img_metadata like '%GPSL%';

Where "image" should be the name of your mediawiki dataset. For me, it was named mw_image

Using the SiteGround SQL tools I have, my particular MediaWiki files were located in a \MediaWiki directory off my public site root directory. They had a somewhat arbitrary name assigned when first made (like [domain_name]_mw[number]\mw_image

Hope this helps.

Thanks again, Bawolff! Now I see other pictures with geocoords.

If anyone can ever make a utility to block geocoords? That sure is a lot simpler than never messing up, or having to delete the entire page and start over, if you do.

Hi everyone,

I uploaded a bunch of pictures to my personal mediawiki site, then realized I forgot to wipe geocoords from them (which can be clearly seen on their metadata pages). I'm just an amateur site builder, but this presents multiple problems:

1) Even if I edit the image and upload a new version with geo info wiped, doesn't the old version remain, with its geo info?

2) How can I be sure I haven't goofed and left a geocoord across the many pictures I've uploaded? Maybe dozens or hundreds; not sure how many were screen captures, and how many from my phone.

In short, I think I am looking for a tool that will wipe and/or block any and all geocoords on any of my pictures, passively and forever more.

Does anyone know of such a thing? Thanks so much if you can help!

P.S. I am using 1.27.1 of MediaWiki, from Sept. 2016 or so.

You need to upload a new version, and delete the old version (If you have revision deletion, you can just set the old version of the image content to be deleted and keep the rest of the history).

You can try to get a list of such photos by doing a query on the database like SELECT img_name from image where img_metadata like '%GPSL%';

p.s. Edit - As RedKnight7 noted above, if you're using $wgDBPrefix, then you need to add that to the image name.

For blocking uploads that contain geocoords you can implement a UploadVerifyFile hook to check metadata of the file and reject it (apparently it should be accessible from UploadBase::getImageInfo()).