Problem Statement

Unable to create template from existing pages in Confluence 4.0, since pages are stored in XHTML instead of Wiki Markup, and Global Templates can only be created using Wiki Markup.

Temporary Workaround:

Run this query in Confluence's Database:

SELECT * FROM BODYCONTENT WHERE CONTENTID IN (SELECT CONTENTID FROM `content` WHERE contentID IN (SELECT CONTENTID FROM bodycontent WHERE bodytypeid = '0') AND PREVVER = (SELECT contentid from content WHERE title = '<Replace with the page's title here>' AND PREVVER IS NULL));

This query will only return results if there are any older versions of the page, and if the older version exists prior to the upgrade.

The query essentially returns Wiki Markup of older versions of the page, which can be used to create the template.