Last modified: 2011-11-25 08:45:33 UTC
4 years ago an IP was blocked on German Wikipedia [1] indefinite. But there is no warning an the Special:Block page [2] and the API result does not know anything about the block [3]. [1] http://de.wikipedia.org/w/index.php?title=Spezial:Logbuch&type=block&page=Benutzer%3A137.226.39.166 [2] http://de.wikipedia.org/wiki/Special:Block/137.226.39.166 [3] http://de.wikipedia.org/w/api.php?action=query&list=blocks&bkusers=137.226.39.166&format=xml
There is no entry in the dewiki database. mysql> select * from ipblocks where ipb_address = '137.226.39.166'; Empty set (0.44 sec) It is in the logging table. mysql> select count(*) from logging where (log_id > 18288 and log_id < 23772 or log_id > 77698 and log_id < 99000 or log_id > 226000 and log_id < 290000) and log_namespace = 2 and log_type = 'block' and log_title = '137.226.39.166'; ==> 17 This looks like an isolated case. See http://de.wikipedia.org/w/api.php?action=query&list=blocks&bkusers=212.117.127.28&format=xml http://de.wikipedia.org/w/index.php?title=Spezial:Logbuch&type=block&page=Benutzer%3A212.117.127.28 http://de.wikipedia.org/w/api.php?action=query&list=blocks&bkusers=193.171.250.98&format=xml http://de.wikipedia.org/w/index.php?title=Spezial:Logbuch&type=block&page=Benutzer%3A193.171.250.98 And earlier on ENWP http://en.wikipedia.org/w/api.php?action=query&list=blocks&bkusers=212.211.136.33&format=xml https://secure.wikimedia.org/wikipedia/en/wiki/Special:Block/212.211.136.33 Have you tried to unblock it and reblock it? If you want to check that there are no other missing blocks, compare the logging table with the ipblocks table.
