Solution to error: Could not fetch MediaWiki: Unknown column 'r.rev_text_id' in 'on clause' #76

[ahbrims]

I was using a new version of mediawiki (1.37.6) that no longer used the revision.rev_text_id (see: Mediawiki Manual.

I rewrote the SQL in the MediaWiki2DokuWiki/Mediawiki/Converter.php file. Using the advice under 'Sample MySQL code' on the Mediawiki Manual page Manual:page table

Original SQL:

$sql = "SELECT p.page_title, p.page_namespace, t.old_text FROM {$this->dbPrefix}page p INNER JOIN {$this->dbPrefix}revision r ON p.page_latest = r.rev_id INNER JOIN {$this->dbPrefix}{$textTable} t ON r.rev_text_id = t.old_id ORDER BY p.page_title";

With new SQL: $sql = "SELECT p.page_title, p.page_namespace, t.old_text FROM {$this->dbPrefix}page p INNER JOIN {$this->dbPrefix}slots s ON p.page_latest = s.slot_revision_id INNER JOIN {$this->dbPrefix}slot_roles r ON s.slot_role_id = r.role_id and r.role_name = 'main' INNER JOIN {$this->dbPrefix}content c ON s.slot_content_id = c.content_id INNER JOIN {$this->dbPrefix}text t ON substring( c.content_address, 4 ) = t.old_id
ORDER BY p.page_title";

It has copied the pages across, but haven't had time to check everything yet.

Sorry if this is the wrong place for this information. Hope this helps someone.

[wrknpoa]

Thanks.