Database error

Jump to navigation Jump to search

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

[3ac9ee96a3f492a75dc44757] /echinowiki/index.php?title=Special:ListFiles&offset=2020-03-27+20%253A19%253A04%252B00 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-03-27 20%3A19%3A04%2B00"
LINE 1: ... = img_description_id)) WHERE (img_timestamp >= '2020-03-2...
^

Function: IndexPager::buildQueryInfo (ImageListPager)
Query: SELECT img_timestamp,img_name,img_size,'yes' AS "top",comment_img_description.comment_text AS "img_description_text",comment_img_description.comment_data AS "img_description_data",comment_img_description.comment_id AS "img_description_cid",'img_description' AS "description_field",actor_user,actor_name,(SELECT COUNT(oi_archive_name) FROM "oldimage" WHERE oi_name = img_name ) AS "count" FROM "image" JOIN "actor" ON ((actor_id=img_actor)) JOIN "comment" "comment_img_description" ON ((comment_img_description.comment_id = img_description_id)) WHERE (img_timestamp >= '2020-03-27 20%3A19%3A04%2B00') ORDER BY img_timestamp,img_name LIMIT 1

Backtrace:

from /var/www/html/echino-mediawiki-1.40.1/includes/libs/rdbms/database/Database.php(1524)
#0 /var/www/html/echino-mediawiki-1.40.1/includes/libs/rdbms/database/Database.php(1508): Wikimedia\Rdbms\Database->getQueryException()
#1 /var/www/html/echino-mediawiki-1.40.1/includes/libs/rdbms/database/Database.php(1482): Wikimedia\Rdbms\Database->getQueryExceptionAndLog()
#2 /var/www/html/echino-mediawiki-1.40.1/includes/libs/rdbms/database/Database.php(855): Wikimedia\Rdbms\Database->reportQueryError()
#3 /var/www/html/echino-mediawiki-1.40.1/includes/libs/rdbms/database/Database.php(1629): Wikimedia\Rdbms\Database->query()
#4 /var/www/html/echino-mediawiki-1.40.1/includes/libs/rdbms/database/DBConnRef.php(119): Wikimedia\Rdbms\Database->select()
#5 /var/www/html/echino-mediawiki-1.40.1/includes/libs/rdbms/database/DBConnRef.php(344): Wikimedia\Rdbms\DBConnRef->__call()
#6 /var/www/html/echino-mediawiki-1.40.1/includes/specials/pagers/ImageListPager.php(337): Wikimedia\Rdbms\DBConnRef->select()
#7 /var/www/html/echino-mediawiki-1.40.1/includes/pager/IndexPager.php(278): ImageListPager->reallyDoQuery()
#8 /var/www/html/echino-mediawiki-1.40.1/includes/pager/IndexPager.php(847): IndexPager->doQuery()
#9 /var/www/html/echino-mediawiki-1.40.1/includes/pager/TablePager.php(300): IndexPager->isNavigationBarShown()
#10 /var/www/html/echino-mediawiki-1.40.1/includes/pager/TablePager.php(109): TablePager->getNavigationBar()
#11 /var/www/html/echino-mediawiki-1.40.1/includes/specials/SpecialListFiles.php(134): TablePager->getFullOutput()
#12 /var/www/html/echino-mediawiki-1.40.1/includes/specialpage/SpecialPage.php(701): SpecialListFiles->execute()
#13 /var/www/html/echino-mediawiki-1.40.1/includes/specialpage/SpecialPageFactory.php(1475): SpecialPage->run()
#14 /var/www/html/echino-mediawiki-1.40.1/includes/MediaWiki.php(327): MediaWiki\SpecialPage\SpecialPageFactory->executePath()
#15 /var/www/html/echino-mediawiki-1.40.1/includes/MediaWiki.php(923): MediaWiki->performRequest()
#16 /var/www/html/echino-mediawiki-1.40.1/includes/MediaWiki.php(576): MediaWiki->main()
#17 /var/www/html/echino-mediawiki-1.40.1/index.php(50): MediaWiki->run()
#18 /var/www/html/echino-mediawiki-1.40.1/index.php(46): wfIndexMain()
#19 {main}