Jump to:

23355 Posts in 17873 Topics by 2862 members

General Questions

SilverStripe Forums » General Questions » Page versions issue

General questions about getting started with SilverStripe that don't fit in any of the categories above.

Moderators: martimiz, Sean, biapar, Willr, Ingo, swaiba, simon_w

Page: 1
Go to End
Author Topic: 245 Views
  • Tony Air
    Avatar
    Community Member
    13 Posts

    Page versions issue Link to this post

    Hi I have an issue with page versions when SiteConfig extenders are used.

    Here's my extension:
    class SiteConfigMod extends DataExtension {
    public static $many_many = array(
          'TopMenu' => 'SiteTree',
       );
    }

    Here's an error:
    URL: http://localhost/page-2/?archiveDate=2013-01-29+15%3A02%3A14

    Couldn't run query: SELECT DISTINCT "SiteTree_versions"."ClassName", "SiteTree_versions"."Created", "SiteTree_versions"."LastEdited", "SiteTree_versions"."URLSegment", "SiteTree_versions"."Title", "SiteTree_versions"."MenuTitle", "SiteTree_versions"."Content", "SiteTree_versions"."MetaDescription", "SiteTree_versions"."ExtraMeta", "SiteTree_versions"."ShowInMenus", "SiteTree_versions"."ShowInSearch", "SiteTree_versions"."Sort", "SiteTree_versions"."HasBrokenFile", "SiteTree_versions"."HasBrokenLink", "SiteTree_versions"."ReportClass", "SiteTree_versions"."CanViewType", "SiteTree_versions"."CanEditType", "SiteTree_versions"."Priority", "SiteTree_versions"."MetaTitle", "SiteTree_versions"."CustomCSS", "SiteTree_versions"."CSSVersion", "SiteTree_versions"."Version", "SiteTree_versions"."ParentID", "SiteTree_versions"."RecordID" AS "ID", CASE WHEN "SiteTree_versions"."ClassName" IS NOT NULL THEN "SiteTree_versions"."ClassName" ELSE 'SiteTree' END AS "RecordClassName", "SiteTree_versions"."RecordID", "SiteTree_versions"."WasPublished", "SiteTree_versions"."AuthorID", "SiteTree_versions"."PublisherID" FROM "SiteTree_versions" INNER JOIN "SiteConfig_TopMenu_versions" ON "SiteConfig_TopMenu_versions"."SiteTreeID" = "SiteTree_versions"."RecordID" WHERE ("SiteConfig_TopMenu_versions"."SiteConfigID" = '1') AND ("SiteConfig_TopMenu_versions"."Version" = "SiteTree_versions"."Version") AND ("SiteTree_versions"."Version" IN SELECT LatestVersion FROM SELECT "SiteTree_versions"."RecordID", MAX("SiteTree_versions"."Version") AS LatestVersion FROM "SiteTree_versions" WHERE "SiteTree_versions"."LastEdited" <= '2013-01-29 15:02:14' GROUP BY "SiteTree_versions"."RecordID" ) AS "SiteTree_versions_latest" WHERE "SiteTree_versions_latest"."RecordID" = "SiteTree_versions"."RecordID" )) ORDER BY "SiteTree_versions"."Sort" ASC Table 'silverstripe.SiteConfig_TopMenu_versions' doesn't exist

    245 Views
Page: 1
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.