Database error

Jump to navigation Jump to search

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

[be08a4b2e71667a7f74607e8] /wiki/index.php?title=Special:Log&offset=2011-01-28+18%253A41%253A07%252B00&limit=20&amp%253Boffset=&amp%253Blimit=100&amp%253Bamp%253Bdir=prev&amp%253Bamp%253Btype=&amp%253Bamp%253Buser=&amp%253Btype=&amp%253Buser=&type=&user=&hide_tag_log=0 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: "2011-01-28 18%3A41%3A07%2B00"
LINE 1: ... AND (log_type != 'patrol') AND (((log_timestamp>='2011-01-2...
^

Function: IndexPager::buildQueryInfo (LogPager)
Query: SELECT log_id,log_type,log_action,log_timestamp,log_namespace,log_title,log_params,log_deleted,user_id,user_name,log_actor,logging_actor.actor_user AS "log_user",logging_actor.actor_name AS "log_user_text",comment_log_comment.comment_text AS "log_comment_text",comment_log_comment.comment_data AS "log_comment_data",comment_log_comment.comment_id AS "log_comment_cid",(SELECT array_to_string(array_agg(ctd_name),',') FROM "change_tag" JOIN "change_tag_def" ON ((ct_tag_id=ctd_id)) WHERE ct_log_id=log_id ) AS "ts_tags" FROM "logging" JOIN "actor" "logging_actor" ON ((actor_id=log_actor)) LEFT JOIN "user" ON ((user_id=logging_actor.actor_user)) JOIN "comment" "comment_log_comment" ON ((comment_log_comment.comment_id = log_comment_id)) WHERE (log_type != 'suppress') AND (log_type != 'patrol') AND (((log_timestamp>='2011-01-28 18%3A41%3A07%2B00'))) ORDER BY log_timestamp LIMIT 1

Backtrace:

from /usr/local/apache2/htdocs/wiki/includes/libs/rdbms/database/Database.php(1618)
#0 /usr/local/apache2/htdocs/wiki/includes/libs/rdbms/database/Database.php(1602): Wikimedia\Rdbms\Database->getQueryException(string, string, string, string)
#1 /usr/local/apache2/htdocs/wiki/includes/libs/rdbms/database/Database.php(1576): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, string, string, string)
#2 /usr/local/apache2/htdocs/wiki/includes/libs/rdbms/database/Database.php(952): Wikimedia\Rdbms\Database->reportQueryError(string, string, string, string, boolean)
#3 /usr/local/apache2/htdocs/wiki/includes/libs/rdbms/database/Database.php(1708): Wikimedia\Rdbms\Database->query(string, string, integer)
#4 /usr/local/apache2/htdocs/wiki/includes/libs/rdbms/database/DBConnRef.php(103): Wikimedia\Rdbms\Database->select(array, array, array, string, array, array)
#5 /usr/local/apache2/htdocs/wiki/includes/libs/rdbms/database/DBConnRef.php(325): Wikimedia\Rdbms\DBConnRef->__call(string, array)
#6 /usr/local/apache2/htdocs/wiki/includes/pager/IndexPager.php(460): Wikimedia\Rdbms\DBConnRef->select(array, array, array, string, array, array)
#7 /usr/local/apache2/htdocs/wiki/includes/pager/IndexPager.php(277): IndexPager->reallyDoQuery(string, integer, boolean)
#8 /usr/local/apache2/htdocs/wiki/includes/logging/LogPager.php(503): IndexPager->doQuery()
#9 /usr/local/apache2/htdocs/wiki/includes/pager/IndexPager.php(612): LogPager->doQuery()
#10 /usr/local/apache2/htdocs/wiki/includes/specials/SpecialLog.php(294): IndexPager->getBody()
#11 /usr/local/apache2/htdocs/wiki/includes/specials/SpecialLog.php(176): SpecialLog->show(FormOptions, array)
#12 /usr/local/apache2/htdocs/wiki/includes/specialpage/SpecialPage.php(701): SpecialLog->execute(NULL)
#13 /usr/local/apache2/htdocs/wiki/includes/specialpage/SpecialPageFactory.php(1428): SpecialPage->run(NULL)
#14 /usr/local/apache2/htdocs/wiki/includes/MediaWiki.php(316): MediaWiki\SpecialPage\SpecialPageFactory->executePath(string, RequestContext)
#15 /usr/local/apache2/htdocs/wiki/includes/MediaWiki.php(904): MediaWiki->performRequest()
#16 /usr/local/apache2/htdocs/wiki/includes/MediaWiki.php(562): MediaWiki->main()
#17 /usr/local/apache2/htdocs/wiki/index.php(50): MediaWiki->run()
#18 /usr/local/apache2/htdocs/wiki/index.php(46): wfIndexMain()
#19 {main}