Author: harding.ian

Description:
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

Version: 1.10.x
Severity: major
OS: Linux