Last modified: 2012-07-16 19:54:12 UTC
11) SpecialPagesTest::testSpecialPage with data set #34 ('SemanticStatistics') DBQueryError: A database error has occurred. Did you forget to run maintenance/update.php after upgrading? See: https://www.mediawiki.org/wiki/Manual:Upgrading#Run_the_update_script Query: SELECT COUNT(s_id) AS count FROM `bw_smw_type` WHERE p_id = '1' Function: SMW::getStatistics Error: 1054 Unknown column 'p_id' in 'where clause' (localhost) /www/sandwiki/includes/db/Database.php:972 /www/sandwiki/includes/db/Database.php:939 /www/sandwiki/includes/db/Database.php:1412 /www/sandwiki/extensions/SemanticMediaWiki/includes/storage/SQLStore/SMW_SQLStore3_SpecialPageHandlers.php:232 /www/sandwiki/extensions/SemanticMediaWiki/includes/storage/SQLStore/SMW_SQLStore3.php:291 /www/sandwiki/extensions/SemanticMediaWiki/specials/Statistics/SMW_SpecialStatistics.php:25 /www/sandwiki/includes/SpecialPage.php:611 /www/sandwiki/extensions/Translate/tests/SpecialPagesTest.php:42 /www/sandwiki/tests/phpunit/MediaWikiTestCase.php:79 /www/sandwiki/tests/phpunit/MediaWikiPHPUnitCommand.php:45 /www/sandwiki/tests/phpunit/phpunit.php:103
Niklas, thanks for the report. You just installed some development code that is not quite ready for deployment yet. For going back to the previous SQL implementation, you can add $smwgDefaultStore = 'SMWSQLStore2'; to your LocalSettings (after including SMW). We will also fix this issue soon.
https://gerrit.wikimedia.org/r/#/c/15725/ should fix this. But make sure to run update after 1.8 is released :)
This is not the final fix. It just means that the old code is used without you making the setting I mentioned above. If you feel adventurous again, you can switch to the new code with $smwgDefaultStore = 'SMWSQLStore3'; This will become the default again before the next release. Reopening the bug as it will only be fixed when Special:Statistics works with SQLStore3.
Fixed for Store3 in https://gerrit.wikimedia.org/r/#/c/15735/ (In reply to comment #3) > This is not the final fix. It just means that the old code is used without you > making the setting I mentioned above. If you feel adventurous again, you can > switch to the new code with $smwgDefaultStore = 'SMWSQLStore3'; This will Yes, one can switch to Store3 in LocalSettings.php but has to make sure to run Setup tables
