Topic on Extension talk:CheckUser

I've installed CheckUser extension on my wiki and imported the file <code>cu_changes.sql</code> and <code>cu_log.sql</code>.

When I run the CheckUser special page, after filling in everything I get only a query error of type <code>[a4d205656bdaeb2ad048ee23] 2019-08-26 17:00:06: Errore irreversibile di tipo "Wikimedia\Rdbms\DBQueryError"</code>. However, it does not affect the CheckUserLog special page, which is displayed as expected.

My MediaWiki version is 1.33.0, with PHP 7.1.26 (cgi-fcgi), MySQL 5.6.33-log, ICU 50.1.2. Can somebody help?

Set $wgShowExceptionDetails to true in LocalSettings.php to see a more meaningful error message.

Now the [fb42dddde2e2823b929178c4] /w/index.php?title=Speciale:CU Wikimedia\Rdbms\DBQueryError from line 1587 of /membri/kaymoskva/w/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 cuc_ip,cuc_ip_hex,COUNT(*) AS count,MIN(cuc_timestamp) AS first,MAX(cuc_timestamp) AS last FROM `kwiki_cu_changes` FORCE INDEX (cuc_user_ip_time) WHERE cuc_user = '8' AND (1 = 1) GROUP BY cuc_ip,cuc_ip_hex ORDER BY last DESC LIMIT 5001 Function: SpecialCheckUser::doUserIPsDBRequest Error: 1176 Key 'cuc_user_ip_time' doesn't exist in table 'kwiki_cu_changes' (localhost) Backtrace:

1. 0 /membri/kaymoskva/w/includes/libs/rdbms/database/Database.php(1556): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)
2. 1 /membri/kaymoskva/w/includes/libs/rdbms/database/Database.php(1274): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)
3. 2 /membri/kaymoskva/w/includes/libs/rdbms/database/Database.php(1784): Wikimedia\Rdbms\Database->query(string, string)
4. 3 /membri/kaymoskva/w/extensions/CheckUser/includes/specials/SpecialCheckUser.php(529): Wikimedia\Rdbms\Database->select(string, array, array, string, array)
5. 4 /membri/kaymoskva/w/extensions/CheckUser/includes/specials/SpecialCheckUser.php(497): SpecialCheckUser->doUserIPsDBRequest(integer, integer)
6. 5 /membri/kaymoskva/w/extensions/CheckUser/includes/specials/SpecialCheckUser.php(105): SpecialCheckUser->doUserIPsRequest(string, integer)
7. 6 /membri/kaymoskva/w/includes/specialpage/SpecialPage.php(569): SpecialCheckUser->execute(NULL)
8. 7 /membri/kaymoskva/w/includes/specialpage/SpecialPageFactory.php(558): SpecialPage->run(NULL)
9. 8 /membri/kaymoskva/w/includes/MediaWiki.php(288): MediaWiki\Special\SpecialPageFactory->executePath(Title, RequestContext)
10. 9 /membri/kaymoskva/w/includes/MediaWiki.php(865): MediaWiki->performRequest()
11. 10 /membri/kaymoskva/w/includes/MediaWiki.php(515): MediaWiki->main()
12. 11 /membri/kaymoskva/w/index.php(42): MediaWiki->run()
13. 12 {main}

What does the cuc_user_ip_time index mean?

Did you run update.php after installing the extension? If not, please run it and try again.

Otherwise, there may be a bug on the extension that failed to run one of the scripts. Apparelty you'll need to run manually, replacing /*$wgDBprefix*/ with kwiki_