https://bugzilla.wikimedia.org/show_bug.cgi?id=17343
[email protected] changed: What |Removed |Added ---------------------------------------------------------------------------- URL|http://radioscanningtw.jidan| |ni.org/index.php?title=%E7%8| |9%B9%E6%AE%8A:RecentChanges&| |uselang=en | Severity|trivial |normal Component|Maintenance scripts |Deleting Priority|Normal |High Summary|'Delete page script' entries|LogEventsList.php's |in Recentchanges, but not |getQueryInfo() INNER JOIN |delete/log |neglects log_user=0, causing | |deleteBatch.php's 'Delete | |page script' entries to be | |skipped Version|1.13.3 |1.15-svn --- Comment #3 from [email protected] 2009-03-17 04:56:41 UTC --- Gentlemen, I have found the problem. Allow us to delete two pages, $ echo 讀書會|php deleteBatch.php $ echo 工作坊|php deleteBatch.php -u WikiSysop Now using index.php?title=Special:Log&type=delete why can we only see the latter, but not the former? Allow us to do some queries, SELECT * FROM wiki_logging ORDER BY log_timestamp DESC LIMIT 2; +----------+------------+----------------+----------+---------------+-------- | log_type | log_action | log_timestamp | log_user | log_namespace |log_title +----------+------------+----------------+----------+---------------+-------- | delete | delete | 20090316221847 | 1 | 0 | 工作坊 | delete | delete | 20090316214131 | 0 | 0 | 讀書會 +----------+------------+----------------+----------+---------------+-------- We note that the row that doesn't show up in Special:Log&type=delete is the row with log_user=0. OK, now let's take a look at LogEventsList.php's function getQueryInfo: ...'INNER JOIN', 'user_id=log_user'... OK, now let's do a query, SELECT user_id,user_name FROM wiki_user ORDER BY user_id LIMIT 2; +---------+--------------+ | user_id | user_name | +---------+--------------+ | 1 | WikiSysop | | 2 | Jidanni | +---------+--------------+ Do you see what I see? That's right. There is no user_id=0 present! In deleteBatch.php there is the line $user = 'Delete page script'; The problem is there is no such user_name in the user table! You might say "what's the big deal about that". Well, the big deal is that 'Delete page script's deletions show up in RecentChanges. But not in Special:Log&type=delete. What compounds the frustration is that RecentChanges even has links on every deletion entry, to Special:Log&type=delete. However, when one clicks them, one cannot see any entries by the 'Delete page script' user! Therefore, please fix things so that $ echo XYZ|php deleteBatch.php will make entries in Special:Log&type=delete ! Thank you. -- 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 [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
