SemanticMediaWiki / SemanticExtraSpecialProperties

Provides extra special properties to Semantic MediaWiki.
https://www.mediawiki.org/wiki/Extension:Semantic_Extra_Special_Properties
Other
26 stars 28 forks source link

_USEREDITCNTNS not compatible with MW 1.39 #233

Closed robinwiel closed 1 month ago

robinwiel commented 1 month ago

Setup and configuration

Issue

The special property _USEREDITCNTNS has not been made compatible with MediaWiki 1.39. From this version, the table "revision_actor_temp" is merged back into "revision".

Produces a stack trace and outputs:

Wikimedia\Rdbms\DBQueryError from line 1618 of /var/platform/cores/1.39/20240814-1556/includes/libs/rdbms/database/Database.php: Error 1146: Table 'sandbox139.revision_actor_temp' doesn't exist
Function: SESP\PropertyAnnotators\UserEditCountPerNsPropertyAnnotator::getEditsPerNs
Query: SELECT  page.page_namespace AS `ns`,COUNT(revision.rev_id) AS `edits`  FROM `revision` JOIN `revision_actor_temp` ON ((revision_actor_temp.revactor_rev=revision.rev_id)) JOIN `actor` ON ((actor.actor_id=revision_actor_temp.revactor_actor)) JOIN `page` ON ((page.page_id=revision.rev_page))   WHERE actor.actor_user = 4  GROUP BY page.page_namespace

Steps to reproduce the observation (recommendation is to use the sandbox): Enable the special property _USEREDITCNTNS and run the maintenance script rebuildData.php on the User-namespace.