Last modified: 2005-10-16 20:05:42 UTC
Hello, I am hunting for some Non Commercial pictures on the french wikipedia and found an interesting entry. http://fr.wikipedia.org/wiki/Image:Silvereye.jpg Show that it got uploaded on april 19 2005 ( 20050419 ) by user Svtiste. Looking at the database, the page_id is 241763 and the revision table show: +---------+----------+-------------+---------------+----------------+ | rev_id | rev_page | rev_text_id | rev_user_text | rev_timestamp | +---------+----------+-------------+---------------+----------------+ | 1854709 | 241763 | 1854709 | Svtiste | 20050419135904 | | 2535685 | 241763 | 2535685 | Tipiac | 20050423163239 | +---------+----------+-------------+---------------+----------------+ But the wikipage only show the Svtiste entry. I am now looking at Tipiac revision text: SELECT old_text FROM text WHERE old_id=2535685; +-------------------------------------------------------+ | O:18:"historyblobcurstub":1:{s:6:"mCurId";i:241763;} | +-------------------------------------------------------+ Looks like it points to something in the old 'cur' table: SELECT cur_id,cur_title,cur_user_text,cur_timestamp,cur_is_new,cur_touched FROM cur where cur_id=241763; +--------+---------------+---------------+----------------+------------+----------------+ | cur_id | cur_title | cur_user_text | cur_timestamp | cur_is_new | cur_touched | +--------+---------------+---------------+----------------+------------+----------------+ | 241763 | Silvereye.jpg | Tipiac | 20050423163239 | 0 | 20050629213607 | +--------+---------------+---------------+----------------+------------+----------------+ So it looks like Svtist is the uploader, but I dont understand why user Tipiac is showing in the revision table :( User did change the template though but at a different date: http://fr.wikipedia.org/w/index.php?title=Mod%C3%A8le:CC-BY-ND-NC&action=history
Looks normal to me: http://fr.wikipedia.org/w/index.php?title=Image:Silvereye.jpg&action=history Are you looking at the *file upload* history and confusing this with the *page edit* history?
