Database error

Jump to navigation Jump to search

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

[d98e518fd9472fa179851962] /algowiki/index.php?title=Special:Log/Algowikiadmin&offset=20140911181415&type=&user=Algowikiadmin 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 log_id,log_type,log_action,log_timestamp,log_namespace,log_title,log_params,log_deleted,user_id,user_name,user_editcount,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",actor_log_user.actor_user AS "log_user",actor_log_user.actor_name AS "log_user_text",log_actor,(SELECT array_to_string(array_agg(ctd_name),',') FROM "change_tag","change_tag_def" WHERE ct_log_id=log_id ) AS "ts_tags" FROM "logging" JOIN "comment" "comment_log_comment" ON ((comment_log_comment.comment_id = log_comment_id)) JOIN "actor" "actor_log_user" ON ((actor_log_user.actor_id = log_actor)) LEFT JOIN "mwuser" ON ((user_id=actor_log_user.actor_user)) WHERE (log_type NOT IN ('abusefilterprivatedetails','spamblacklist','titleblacklist','suppress')) AND (log_type != 'patrol') AND (log_type != 'tag') AND ((log_actor = '1')) AND ((log_deleted & 4) = 0) AND (log_timestamp>='20140911181415') ORDER BY log_timestamp LIMIT 1
Function: IndexPager::buildQueryInfo (LogPager)
Error: 22007 ERROR: invalid input syntax for type timestamp with time zone: "20140911181415"
LINE 1: ...) AND ((log_deleted & 4) = 0) AND (log_timestamp>='201409111...
^

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/logging/LogPager.php(474): IndexPager->doQuery()
#8 /var/www/websites/mediawiki_v3/includes/pager/IndexPager.php(474): LogPager->doQuery()
#9 /var/www/websites/mediawiki_v3/includes/specials/SpecialLog.php(244): IndexPager->getBody()
#10 /var/www/websites/mediawiki_v3/includes/specials/SpecialLog.php(134): SpecialLog->show(FormOptions, array)
#11 /var/www/websites/mediawiki_v3/includes/specialpage/SpecialPage.php(575): SpecialLog->execute(string)
#12 /var/www/websites/mediawiki_v3/includes/specialpage/SpecialPageFactory.php(611): SpecialPage->run(string)
#13 /var/www/websites/mediawiki_v3/includes/MediaWiki.php(296): MediaWiki\Special\SpecialPageFactory->executePath(Title, RequestContext)
#14 /var/www/websites/mediawiki_v3/includes/MediaWiki.php(900): MediaWiki->performRequest()
#15 /var/www/websites/mediawiki_v3/includes/MediaWiki.php(527): MediaWiki->main()
#16 /var/www/websites/mediawiki_v3/index.php(44): MediaWiki->run()
#17 {main}