Last modified: 2010-05-15 15:52:04 UTC

Wikimedia Bugzilla is closed!

Wikimedia has migrated from Bugzilla to Phabricator. Bug reports should be created and updated in Wikimedia Phabricator instead. Please create an account in Phabricator and add your Bugzilla email address to it.
Wikimedia Bugzilla is read-only. If you try to edit or create any bug report in Bugzilla you will be shown an intentional error message.
In order to access the Phabricator task corresponding to a Bugzilla report, just remove "static-" from its URL.
You could still run searches in Bugzilla or access your list of votes but bug reports will obviously not be up-to-date in Bugzilla.
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