Database error

From ECE Information Technology Services
Jump to navigationJump to search

A database query error has occurred. This may indicate a bug in the software.

[5b7e32baad4ba894f9d6d061] /mediawiki/index.php?title=Special:Contributions/Jazminl&offset=2009-05-15+22%253A48%253A04%252B00&limit=20&printable=yes&target=Jazminl Wikimedia\Rdbms\DBQueryError from line 1603 of /ubc/ece/home/vhosts/common/packages/mediawiki/mediawiki-1.34.2/includes/libs/rdbms/database/Database.php: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: SELECT rev_id,rev_page,rev_timestamp,rev_minor_edit,rev_deleted,rev_len,rev_parent_id,rev_sha1,comment_rev_comment.comment_text AS "rev_comment_text",comment_rev_comment.comment_data AS "rev_comment_data",comment_rev_comment.comment_id AS "rev_comment_cid",actor_rev_user.actor_user AS "rev_user",actor_rev_user.actor_name AS "rev_user_text",temp_rev_user.revactor_actor AS "rev_actor",page_namespace,page_title,page_id,page_latest,page_is_redirect,page_len,user_name,page_is_new,revactor_timestamp,(SELECT array_to_string(array_agg(ctd_name),',') FROM "change_tag","change_tag_def" WHERE ct_rev_id=rev_id ) AS "ts_tags" FROM "revision" JOIN "revision_comment_temp" "temp_rev_comment" ON ((temp_rev_comment.revcomment_rev = rev_id)) JOIN "comment" "comment_rev_comment" ON ((comment_rev_comment.comment_id = temp_rev_comment.revcomment_comment_id)) JOIN "revision_actor_temp" "temp_rev_user" ON ((temp_rev_user.revactor_rev = rev_id)) JOIN "actor" "actor_rev_user" ON ((actor_rev_user.actor_id = temp_rev_user.revactor_actor)) JOIN "page" ON ((page_id = rev_page)) LEFT JOIN "mwuser" ON ((actor_rev_user.actor_user != 0) AND (user_id = actor_rev_user.actor_user)) WHERE ((temp_rev_user.revactor_actor = '3')) AND ((rev_deleted & 4) = 0) AND (revactor_timestamp>='2009-05-15 22%3A48%3A04%2B00') ORDER BY revactor_timestamp,revactor_rev LIMIT 1
Function: IndexPager::buildQueryInfo (contributions page unfiltered)
Error: 22007 ERROR: invalid input syntax for type timestamp with time zone: "2009-05-15 22%3A48%3A04%2B00"
LINE 1: ... ((rev_deleted & 4) = 0) AND (revactor_timestamp>='2009-05-1...
^

Backtrace:

#0 /ubc/ece/home/vhosts/common/packages/mediawiki/mediawiki-1.34.2/includes/libs/rdbms/database/Database.php(1574): Wikimedia\Rdbms\Database->getQueryExceptionAndLog()
#1 /ubc/ece/home/vhosts/common/packages/mediawiki/mediawiki-1.34.2/includes/libs/rdbms/database/Database.php(1152): Wikimedia\Rdbms\Database->reportQueryError()
#2 /ubc/ece/home/vhosts/common/packages/mediawiki/mediawiki-1.34.2/includes/libs/rdbms/database/Database.php(1807): Wikimedia\Rdbms\Database->query()
#3 /ubc/ece/home/vhosts/common/packages/mediawiki/mediawiki-1.34.2/includes/libs/rdbms/database/DBConnRef.php(68): Wikimedia\Rdbms\Database->select()
#4 /ubc/ece/home/vhosts/common/packages/mediawiki/mediawiki-1.34.2/includes/libs/rdbms/database/DBConnRef.php(315): Wikimedia\Rdbms\DBConnRef->__call()
#5 /ubc/ece/home/vhosts/common/packages/mediawiki/mediawiki-1.34.2/includes/specials/pagers/ContribsPager.php(205): Wikimedia\Rdbms\DBConnRef->select()
#6 /ubc/ece/home/vhosts/common/packages/mediawiki/mediawiki-1.34.2/includes/pager/IndexPager.php(256): ContribsPager->reallyDoQuery()
#7 /ubc/ece/home/vhosts/common/packages/mediawiki/mediawiki-1.34.2/includes/pager/IndexPager.php(609): IndexPager->doQuery()
#8 /ubc/ece/home/vhosts/common/packages/mediawiki/mediawiki-1.34.2/includes/specials/SpecialContributions.php(239): IndexPager->getNumRows()
#9 /ubc/ece/home/vhosts/common/packages/mediawiki/mediawiki-1.34.2/includes/specialpage/SpecialPage.php(575): SpecialContributions->execute()
#10 /ubc/ece/home/vhosts/common/packages/mediawiki/mediawiki-1.34.2/includes/specialpage/SpecialPageFactory.php(611): SpecialPage->run()
#11 /ubc/ece/home/vhosts/common/packages/mediawiki/mediawiki-1.34.2/includes/MediaWiki.php(296): MediaWiki\Special\SpecialPageFactory->executePath()
#12 /ubc/ece/home/vhosts/common/packages/mediawiki/mediawiki-1.34.2/includes/MediaWiki.php(900): MediaWiki->performRequest()
#13 /ubc/ece/home/vhosts/common/packages/mediawiki/mediawiki-1.34.2/includes/MediaWiki.php(527): MediaWiki->main()
#14 /ubc/ece/home/vhosts/common/packages/mediawiki/mediawiki-1.34.2/index.php(44): MediaWiki->run()
#15 {main}