Database error

Jump to navigation Jump to search

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

[6b87e22626eae9c63abc6ce2] /algowiki/index.php?title=Chapter_10&action=history&offset=20201001181029 Wikimedia\Rdbms\DBQueryError from line 1603 of /var/www/websites/mediawiki_v3/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",user_name,(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)) LEFT JOIN "mwuser" ON ((actor_rev_user.actor_user != 0) AND (user_id = actor_rev_user.actor_user)) WHERE rev_page = '13' AND (rev_timestamp>='20201001181029') ORDER BY rev_timestamp LIMIT 1
Function: IndexPager::buildQueryInfo (history page unfiltered)
Error: 22007 ERROR: invalid input syntax for type timestamp with time zone: "20201001181029"
LINE 1: ...ser)) WHERE rev_page = '13' AND (rev_timestamp>='202010011...
^

Backtrace:

#0 /var/www/websites/mediawiki_v3/includes/libs/rdbms/database/Database.php(1574): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, string, string, string)
#1 /var/www/websites/mediawiki_v3/includes/libs/rdbms/database/Database.php(1152): Wikimedia\Rdbms\Database->reportQueryError(string, string, string, string, boolean)
#2 /var/www/websites/mediawiki_v3/includes/libs/rdbms/database/Database.php(1807): Wikimedia\Rdbms\Database->query(string, string)
#3 /var/www/websites/mediawiki_v3/includes/libs/rdbms/database/DBConnRef.php(68): Wikimedia\Rdbms\Database->select(array, array, array, string, array, array)
#4 /var/www/websites/mediawiki_v3/includes/libs/rdbms/database/DBConnRef.php(315): Wikimedia\Rdbms\DBConnRef->__call(string, array)
#5 /var/www/websites/mediawiki_v3/includes/pager/IndexPager.php(418): Wikimedia\Rdbms\DBConnRef->select(array, array, array, string, array, array)
#6 /var/www/websites/mediawiki_v3/includes/pager/IndexPager.php(256): IndexPager->reallyDoQuery(string, integer, boolean)
#7 /var/www/websites/mediawiki_v3/includes/pager/IndexPager.php(660): IndexPager->doQuery()
#8 /var/www/websites/mediawiki_v3/includes/pager/ReverseChronologicalPager.php(39): IndexPager->isNavigationBarShown()
#9 /var/www/websites/mediawiki_v3/includes/actions/HistoryAction.php(308): ReverseChronologicalPager->getNavigationBar()
#10 /var/www/websites/mediawiki_v3/includes/actions/FormlessAction.php(43): HistoryAction->onView()
#11 /var/www/websites/mediawiki_v3/includes/MediaWiki.php(511): FormlessAction->show()
#12 /var/www/websites/mediawiki_v3/includes/MediaWiki.php(302): MediaWiki->performAction(Article, Title)
#13 /var/www/websites/mediawiki_v3/includes/MediaWiki.php(900): MediaWiki->performRequest()
#14 /var/www/websites/mediawiki_v3/includes/MediaWiki.php(527): MediaWiki->main()
#15 /var/www/websites/mediawiki_v3/index.php(44): MediaWiki->run()
#16 {main}