Last modified: 2010-05-15 15:52:04 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 T12007, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 10007 - Can't Block IP with Postgresql
Can't Block IP with Postgresql
Status: RESOLVED FIXED
Product: MediaWiki
Classification: Unclassified
Database (Other open bugs)
1.10.x
All Linux
: Normal major (vote)
: ---
Assigned To: Nobody - You can work on this!
:
Depends on:
Blocks: postgres
  Show dependency treegraph
 
Reported: 2007-05-22 17:07 UTC by Ian Harding
Modified: 2010-05-15 15:52 UTC (History)
1 user (show)

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


Attachments

Description Ian Harding 2007-05-22 17:07:46 UTC
Page Displays:

Warning: pg_query() [function.pg-query]: Query failed: ERROR: invalid input syntax for integer: "" in /usr/local/mediawiki-1.10.0/includes/DatabasePostgres.php on line 496

Warning: pg_affected_rows(): supplied argument is not a valid PostgreSQL result resource in /usr/local/mediawiki-1.10.0/includes/DatabasePostgres.php on line 561

Postgres Log Shows:

LOG:  statement: SELECT /* User::idFromName Iharding */  user_id  FROM mwuser  WHERE user_name = '203.121.71.169'  LIMIT 1  
LOG:  statement: SELECT /* LinkCache::addLinkObj Iharding */  page_id  FROM page  WHERE page_namespace = '3' AND page_title = '203.121.71.169'  LIMIT 1  
LOG:  statement: SELECT /* IndexPager::reallyDoQuery (ContribsPager) Iharding */  page_namespace,page_title,page_is_new,page_latest,rev_id,rev_page,rev_text_id,rev_timestamp,rev_comment,rev_minor_edit,rev_user,rev_user_text,rev_deleted  FROM page,revision  WHERE (page_id=rev_page) AND rev_user_text = '203.121.71.169'  ORDER BY rev_timestamp DESC LIMIT 51  
LOG:  statement: SELECT /* Job::pop Iharding */  *  FROM job  WHERE job_id >= 0  ORDER BY job_id LIMIT 1  
LOG:  statement: SELECT /* LinkBatch::doQuery Iharding */ page_id, page_namespace, page_title FROM page WHERE (page_namespace=2 AND page_title IN ('Iharding')) OR (page_namespace=3 AND page_title IN ('Iharding'))
LOG:  statement: SELECT /* User::checkNewtalk Iharding */  user_id  FROM user_newtalk  WHERE user_id = '1'  LIMIT 1  
LOG:  statement: SELECT /* Parser::replaceLinkHolders Iharding */ page_id, page_namespace, page_title FROM page WHERE (page_namespace=4 AND page_title IN('Policy'))
LOG:  statement: SELECT /* LinkCache::addLinkObj Iharding */  page_id  FROM page  WHERE page_namespace = '8' AND page_title = 'Ipbreason-dropdown'  LIMIT 1  
LOG:  statement: SELECT /* LogReader::getRows Iharding */ /*! STRAIGHT_JOIN */ log_type, log_action, log_timestamp,
                                log_user, user_name,
                                log_namespace, log_title, page_id,
                                log_comment, log_params FROM logging LEFT OUTER JOIN page ON log_namespace=page_namespace AND log_title=page_title INNER JOIN mwuser ON user_id=log_user WHERE log_type='block' AND log_namespace=2 AND log_title = '203.121.71.169' ORDER BY log_timestamp DESC  LIMIT 50  OFFSET 0 
LOG:  statement: SELECT /* Job::pop Iharding */  *  FROM job  WHERE job_id >= 0  ORDER BY job_id LIMIT 1  
LOG:  statement: SELECT /* LinkBatch::doQuery Iharding */ page_id, page_namespace, page_title FROM page WHERE (page_namespace=2 AND page_title IN ('Iharding')) OR (page_namespace=3 AND page_title IN ('Iharding'))
LOG:  statement: SELECT /* User::checkNewtalk Iharding */  user_id  FROM user_newtalk  WHERE user_id = '1'  LIMIT 1  
LOG:  statement: DELETE /* Block::purgeExpired Iharding */ FROM ipblocks WHERE (ipb_expiry < '2007-05-22 16:58:36 GMT')
LOG:  statement: SELECT /*  Iharding */ nextval('ipblocks_ipb_id_val')
LOG:  statement: INSERT /* Block::insert Iharding */  INTO ipblocks (ipb_id,ipb_address,ipb_user,ipb_by,ipb_reason,ipb_timestamp,ipb_auto,ipb_anon_only,ipb_create_account,ipb_enable_autoblock,ipb_expiry,ipb_range_start,ipb_range_end,ipb_deleted) VALUES ('3','203.121.71.169','0','1','Spamming links to external sites','2007-05-22 16:58:36 GMT','0','1','1','0','2007-11-22 17:58:36 GMT','CB7947A9','CB7947A9','')
ERROR:  invalid input syntax for integer: ""
LOG:  statement: COMMIT
WARNING:  there is no transaction in progress
Comment 1 Greg Sabino Mullane 2007-05-29 21:06:09 UTC
Should be fixed in r22544. MySQL does not have a real Boolean type, so things like this may pop up again.

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


Navigation
Links