Database error

Jump to navigation Jump to search

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

[7181f619c04e74543ec14e09] /index.php/Energy_Storage_101?offset=2021-05-03+20%253A27%253A56%252B00%257C753&limit=20&action=history 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: "2021-05-03 20%3A27%3A56%2B00%7C753"
LINE 1: ...ser)) WHERE rev_page = 10 AND (((rev_timestamp>='2021-05-0...
^

Function: IndexPager::buildQueryInfo (history 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",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 "user" ON ((actor_rev_user.actor_user != 0) AND (user_id = actor_rev_user.actor_user)) WHERE rev_page = 10 AND (((rev_timestamp>='2021-05-03 20%3A27%3A56%2B00%7C753'))) ORDER BY rev_timestamp,rev_id LIMIT 1

Backtrace:

from D:\inetpub\approot\storagewiki\includes\libs\rdbms\database\Database.php(1809)
#0 D:\inetpub\approot\storagewiki\includes\libs\rdbms\database\Database.php(1793): Wikimedia\Rdbms\Database->getQueryException(string, string, string, string)
#1 D:\inetpub\approot\storagewiki\includes\libs\rdbms\database\Database.php(1768): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, string, string, string)
#2 D:\inetpub\approot\storagewiki\includes\libs\rdbms\database\Database.php(1327): Wikimedia\Rdbms\Database->reportQueryError(string, string, string, string, boolean)
#3 D:\inetpub\approot\storagewiki\includes\libs\rdbms\database\Database.php(2012): Wikimedia\Rdbms\Database->query(string, string, integer)
#4 D:\inetpub\approot\storagewiki\includes\libs\rdbms\database\DBConnRef.php(68): Wikimedia\Rdbms\Database->select(array, array, array, string, array, array)
#5 D:\inetpub\approot\storagewiki\includes\libs\rdbms\database\DBConnRef.php(324): Wikimedia\Rdbms\DBConnRef->__call(string, array)
#6 D:\inetpub\approot\storagewiki\includes\pager\IndexPager.php(451): Wikimedia\Rdbms\DBConnRef->select(array, array, array, string, array, array)
#7 D:\inetpub\approot\storagewiki\includes\pager\IndexPager.php(275): IndexPager->reallyDoQuery(string, integer, boolean)
#8 D:\inetpub\approot\storagewiki\includes\pager\IndexPager.php(735): IndexPager->doQuery()
#9 D:\inetpub\approot\storagewiki\includes\actions\pagers\HistoryPager.php(682): IndexPager->getNumRows()
#10 D:\inetpub\approot\storagewiki\includes\pager\ReverseChronologicalPager.php(44): HistoryPager->isNavigationBarShown()
#11 D:\inetpub\approot\storagewiki\includes\actions\HistoryAction.php(318): ReverseChronologicalPager->getNavigationBar()
#12 D:\inetpub\approot\storagewiki\includes\actions\FormlessAction.php(48): HistoryAction->onView()
#13 D:\inetpub\approot\storagewiki\includes\MediaWiki.php(543): FormlessAction->show()
#14 D:\inetpub\approot\storagewiki\includes\MediaWiki.php(320): MediaWiki->performAction(Article, Title)
#15 D:\inetpub\approot\storagewiki\includes\MediaWiki.php(930): MediaWiki->performRequest()
#16 D:\inetpub\approot\storagewiki\includes\MediaWiki.php(564): MediaWiki->main()
#17 D:\inetpub\approot\storagewiki\index.php(53): MediaWiki->run()
#18 D:\inetpub\approot\storagewiki\index.php(46): wfIndexMain()
#19 {main}