https://bugzilla.wikimedia.org/show_bug.cgi?id=38606
--- Comment #3 from Platonides <platoni...@gmail.com> 2012-08-17 23:34:51 UTC --- RobLa not having the page_id there makes some queries that should be simple, quite convoluted. For instance, here's what I ended up coding for determining the (original) uploader and date of an image: 1. Query recent changes for that title and action=upload 2. Else query upload log for that title 3. Else look check the page history for a rename entry, verify it against log table and go to 1. Still, I remember it being fooled by files uploaded with a filename equal to others deleted. You cannot just rely on the upload filename given in the Log table, since the file may have been renamed. The last upload may not be what you want (eg. FlickrReviewer uploading a bigger size). I don't remember right now the reason for not diving into oldimage table. Having the log_page would allow a simple JOIN from the upload log entry to get the associated page (if not deleted). And in Wiki Loves Monuments there will be many scrutiny of images and logs. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
