Last modified: 2014-06-07 06:03:08 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T68309, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 66309 - Create views for global_block_whitelist table
Create views for global_block_whitelist table
Status: RESOLVED INVALID
Product: Wikimedia Labs
Classification: Unclassified
tools (Other open bugs)
unspecified
All All
: Unprioritized normal
: ---
Assigned To: Marc A. Pelletier
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2014-06-07 05:54 UTC by Liangent
Modified: 2014-06-07 06:03 UTC (History)
2 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Liangent 2014-06-07 05:54:54 UTC
This table only contains publicly available data (on [[Special:GlobalBlockList]]), ex: 2014-06-06T15:41:43: Tegel (meta.wikimedia.org) globally blocked 209.164.72.72 (expires on 2015-06-06 at 15:41:43, **locally disabled by Liangent: test**) (Open proxy) (local status)

> $a=GlobalBlocking::checkIPsForBlock(array('171.33.223.207'),true);
Caught exception DBQueryError: A database error has occurred. Did you forget to run maintenance/update.php after upgrading?  See: https://www.mediawiki.org/wiki/Manual:Upgrading#Run_the_update_script
Query: SELECT  gbw_by,gbw_reason  FROM `global_block_whitelist`   WHERE gbw_id = '37375'  LIMIT 1  
Function: GlobalBlocking::getWhitelistInfo
Error: 1146 Table 'p50380g50497__wikidb_zhwiki.global_block_whitelist' doesn't exist (zhwiki.labsdb)

#0 /data/project/liangent-php/mw/includes/db/Database.php(1131): DatabaseBase->reportQueryError('Table 'p50380g5...', 1146, 'SELECT  gbw_by,...', 'GlobalBlocking:...', false)
#1 /data/project/liangent-php/mw/includes/db/Database.php(1598): DatabaseBase->query('SELECT  gbw_by,...', 'GlobalBlocking:...')
#2 /data/project/liangent-php/mw/includes/db/Database.php(1687): DatabaseBase->select('global_block_wh...', Array, Array, 'GlobalBlocking:...', Array, Array)
#3 /data/project/liangent-php/mw/extensions/GlobalBlocking/GlobalBlocking.class.php(286): DatabaseBase->selectRow('global_block_wh...', Array, Array, 'GlobalBlocking:...')
#4 /data/project/liangent-php/mw/extensions/GlobalBlocking/GlobalBlocking.class.php(191): GlobalBlocking::getWhitelistInfo('37375')
#5 /data/project/liangent-php/mw/maintenance/eval.php(81) : eval()'d code(1): GlobalBlocking::checkIpsForBlock(Array, true)
#6 /data/project/liangent-php/mw/maintenance/eval.php(81): eval()
#7 {main}
Comment 1 Liangent 2014-06-07 06:03:08 UTC
My fault. Didn't add it to my own table list in tools.

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links