5

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?

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

1 Answer 1

3

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;
2
  • Thanks. So I take it that this has to be done with server access, not through the administrator web portal?
    – James
    Sep 14, 2017 at 15:13
  • You can probably install a DB extension that lets you do it via the admin section.
    – TryHarder
    Sep 15, 2017 at 2:29

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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