Database error

Jump to navigation Jump to search

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

[419183e845ebf37e5e7a0ee5] /index.php?title=Special:Contributions/Bja519&offset=2020-11-03+16%253A56%253A48%252B00&limit=20&target=Bja519 Wikimedia\Rdbms\DBQueryError: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading or after adding a new extension?

Please see https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:Upgrading and https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:How_to_debug for more information.

Error 22007: ERROR: invalid input syntax for type timestamp with time zone: "2020-11-03 16%3A56%3A48%2B00"
LINE 1: ...AND ((rev_deleted & 4) = 0) AND (((rev_timestamp>='2020-11-0...
^

Function: IndexPager::buildQueryInfo (contributions page unfiltered)
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",rev_actor,page_namespace,page_title,page_id,page_latest,page_is_redirect,page_len,user_name,page_is_new,(SELECT array_to_string(array_agg(ctd_name),',') FROM "change_tag" JOIN "change_tag_def" ON ((ct_tag_id=ctd_id)) 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 "actor" "actor_rev_user" ON ((actor_rev_user.actor_id = rev_actor)) JOIN "page" ON ((page_id = rev_page)) LEFT JOIN "user" ON ((actor_rev_user.actor_user != 0) AND (user_id = actor_rev_user.actor_user)) WHERE ((rev_actor = 79)) AND ((rev_deleted & 4) = 0) AND (((rev_timestamp>='2020-11-03 16%3A56%3A48%2B00'))) ORDER BY rev_timestamp,rev_id LIMIT 1

Backtrace:

from /var/www/html/includes/libs/rdbms/database/Database.php(1618)
#0 /var/www/html/includes/libs/rdbms/database/Database.php(1602): Wikimedia\Rdbms\Database->getQueryException(string, string, string, string)
#1 /var/www/html/includes/libs/rdbms/database/Database.php(1576): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, string, string, string)
#2 /var/www/html/includes/libs/rdbms/database/Database.php(952): Wikimedia\Rdbms\Database->reportQueryError(string, string, string, string, boolean)
#3 /var/www/html/includes/libs/rdbms/database/Database.php(1711): Wikimedia\Rdbms\Database->query(string, string, integer)
#4 /var/www/html/includes/libs/rdbms/database/DBConnRef.php(103): Wikimedia\Rdbms\Database->select(array, array, array, string, array, array)
#5 /var/www/html/includes/libs/rdbms/database/DBConnRef.php(326): Wikimedia\Rdbms\DBConnRef->__call(string, array)
#6 /var/www/html/includes/specials/pagers/ContribsPager.php(293): Wikimedia\Rdbms\DBConnRef->select(array, array, array, string, array, array)
#7 /var/www/html/includes/pager/IndexPager.php(277): ContribsPager->reallyDoQuery(string, integer, boolean)
#8 /var/www/html/includes/pager/IndexPager.php(785): IndexPager->doQuery()
#9 /var/www/html/includes/specials/SpecialContributions.php(335): IndexPager->getNumRows()
#10 /var/www/html/includes/poolcounter/PoolCounterWorkViaCallback.php(74): SpecialContributions->{closure}()
#11 /var/www/html/includes/poolcounter/PoolCounterWork.php(162): PoolCounterWorkViaCallback->doWork()
#12 /var/www/html/includes/specials/SpecialContributions.php(364): PoolCounterWork->execute()
#13 /var/www/html/includes/specialpage/SpecialPage.php(701): SpecialContributions->execute(string)
#14 /var/www/html/includes/specialpage/SpecialPageFactory.php(1428): SpecialPage->run(string)
#15 /var/www/html/includes/MediaWiki.php(316): MediaWiki\SpecialPage\SpecialPageFactory->executePath(string, RequestContext)
#16 /var/www/html/includes/MediaWiki.php(904): MediaWiki->performRequest()
#17 /var/www/html/includes/MediaWiki.php(562): MediaWiki->main()
#18 /var/www/html/index.php(50): MediaWiki->run()
#19 /var/www/html/index.php(46): wfIndexMain()
#20 {main}