I want to get the HTML source of an old version of an article from the version history without restoring it. I can only seem to get a rendered preview or a change list in HTML from the compare option.

Is this possible?

  • James, you now have the privilege to vote in our current moderator election. Please exercise your new democratic privilege. – mickmackusa May 6 at 3:58

Revisions are stored in the #__ucm_content table. The version number is the core_version field. If you want, for example, to get the body of the 2nd reversion of the article with ID 123, you issue the following query:

SELECT `core_body` FROM `#__ucm_content` WHERE `core_content_item_id` = '123' AND `core_version` = 2;
  • Thanks. So I take it that this has to be done with server access, not through the administrator web portal? – James Sep 14 '17 at 15:13
  • You can probably install a DB extension that lets you do it via the admin section. – TryHarder Sep 15 '17 at 2:29

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.