Topic on Extension talk:AbuseFilter

Problem fixed

When I go to Special:AbuseFilter after installing AbuseFilter and run update.php, it shows following database error:

[bfb1bf7c329d630ebc5d6e00] 2018-06-25 15:18:44: Fatal exception of type "Wikimedia\Rdbms\DBQueryError"

It would be helpful if you could provide stack traceback. See Manual:How to debug.

Database error on Special:AbuseFilter:

[7584d3a6d8cb66b963a8b9a0] /plavormindtest/index.php?title=Special:AbuseFilter Wikimedia\Rdbms\DBQueryError from line 1443 of C:\NGINX\html\plavormindtest\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 af_id,af_enabled,af_deleted,af_pattern,af_global,af_public_comments,af_hidden,af_hit_count,af_timestamp,af_user_text,af_user,af_actions,af_group,af_throttled FROM abuse_filter WHERE af_deleted = '0' ORDER BY af_id LIMIT 51

Function: IndexPager::buildQueryInfo (AbuseFilterPager)

Error: 1 no such table: abuse_filter

Backtrace:

1. 0 C:\NGINX\html\plavormindtest\includes\libs\rdbms\database\Database.php(1413): Wikimedia\Rdbms\Database->makeQueryException(string, integer, string, string)

1. 1 C:\NGINX\html\plavormindtest\includes\libs\rdbms\database\Database.php(1186): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)

1. 2 C:\NGINX\html\plavormindtest\includes\libs\rdbms\database\Database.php(1640): Wikimedia\Rdbms\Database->query(string, string)

1. 3 C:\NGINX\html\plavormindtest\includes\pager\IndexPager.php(368): Wikimedia\Rdbms\Database->select(array, array, array, string, array, array)

1. 4 C:\NGINX\html\plavormindtest\includes\pager\IndexPager.php(224): IndexPager->reallyDoQuery(string, integer, boolean)

1. 5 C:\NGINX\html\plavormindtest\includes\pager\IndexPager.php(608): IndexPager->doQuery()

1. 6 C:\NGINX\html\plavormindtest\includes\pager\TablePager.php(292): IndexPager->isNavigationBarShown()

1. 7 C:\NGINX\html\plavormindtest\extensions\AbuseFilter\includes\Views\AbuseFilterViewList.php(284): TablePager->getNavigationBar()

1. 8 C:\NGINX\html\plavormindtest\extensions\AbuseFilter\includes\Views\AbuseFilterViewList.php(134): AbuseFilterViewList->showList(array, array)

1. 9 C:\NGINX\html\plavormindtest\extensions\AbuseFilter\includes\special\SpecialAbuseFilter.php(122): AbuseFilterViewList->show()

1. 10 C:\NGINX\html\plavormindtest\includes\specialpage\SpecialPage.php(565): SpecialAbuseFilter->execute(NULL)

1. 11 C:\NGINX\html\plavormindtest\includes\specialpage\SpecialPageFactory.php(569): SpecialPage->run(NULL)

1. 12 C:\NGINX\html\plavormindtest\includes\MediaWiki.php(288): SpecialPageFactory::executePath(Title, RequestContext)

1. 13 C:\NGINX\html\plavormindtest\includes\MediaWiki.php(867): MediaWiki->performRequest()

1. 14 C:\NGINX\html\plavormindtest\includes\MediaWiki.php(524): MediaWiki->main()

1. 15 C:\NGINX\html\plavormindtest\index.php(42): MediaWiki->run()

1. 16 {main}

Also update.php shows following error:

Creating abuse_filter table ...[b894800c426189ba94cbe1ab] [no req] Wikimedia\Rdbms\DBQueryError from line 1443 of C:\NGINX\html\plavormindtest\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: CREATE TABLE abuse_filter (

af_id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
af_pattern BLOB NOT NULL,
af_user INTEGER  NOT NULL,
af_user_text BLOB NOT NULL,
af_timestamp BLOB NOT NULL,
af_enabled INTEGER not null default 1,
af_comments BLOB,
af_public_comments BLOB,
af_hidden INTEGER not null default 0,
af_hit_count INTEGER not null default 0,
af_throttled INTEGER NOT NULL default 0,
af_deleted INTEGER NOT NULL DEFAULT 0,
af_actions BLOB NOT NULL DEFAULT ,
af_global INTEGER NOT NULL DEFAULT 0
af_group BLOB  NOT NULL DEFAULT 'default'
)

Function: Wikimedia\Rdbms\Database::sourceFile( C:\NGINX\html\plavormindtest\extensions\AbuseFilter/abusefilter.tables.sqlite.sql ) Error: 1 near "af_group": syntax error

Backtrace:

1. 0 C:\NGINX\html\plavormindtest\includes\libs\rdbms\database\Database.php(1413): Wikimedia\Rdbms\Database->makeQueryException(string, integer, string, string)
2. 1 C:\NGINX\html\plavormindtest\includes\libs\rdbms\database\Database.php(1186): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)
3. 2 C:\NGINX\html\plavormindtest\includes\libs\rdbms\database\Database.php(4260): Wikimedia\Rdbms\Database->query(string, string)
4. 3 C:\NGINX\html\plavormindtest\includes\libs\rdbms\database\Database.php(4195): Wikimedia\Rdbms\Database->sourceStream(resource (closed), NULL, NULL, string, NULL)
5. 4 C:\NGINX\html\plavormindtest\includes\installer\DatabaseUpdater.php(683): Wikimedia\Rdbms\Database->sourceFile(string)
6. 5 C:\NGINX\html\plavormindtest\includes\installer\DatabaseUpdater.php(726): DatabaseUpdater->applyPatch(string, boolean, string)
7. 6 C:\NGINX\html\plavormindtest\includes\installer\DatabaseUpdater.php(482): DatabaseUpdater->addTable(string, string, boolean)
8. 7 C:\NGINX\html\plavormindtest\includes\installer\DatabaseUpdater.php(450): DatabaseUpdater->runUpdates(array, boolean)
9. 8 C:\NGINX\html\plavormindtest\maintenance\update.php(200): DatabaseUpdater->doUpdates(array)
10. 9 C:\NGINX\html\plavormindtest\maintenance\doMaintenance.php(94): UpdateMediaWiki->execute()
11. 10 C:\NGINX\html\plavormindtest\maintenance\update.php(245): require_once(string)
12. 11 {main}

Try downloading the newest version now. It seems Daimona Eaytoy fixed some syntax errors related to sqlite after your report.

Yeah, I noticed it independently. BTW, @PlavorSeol, I suggest you to report these bugs on phabricator, so that they won't probably get unnoticed.

@Daimona Eaytoy Thanks, it works now. At first, I thought I configured my wiki incorrectly so that it had a problem.