Page versions issue

[Tony Air]

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 

[Howard Grigg]

Hi Tony,

This dev list is for discussing the core development of the framework and CMS (new UIs, APIs etc...). The issue you're having is best asked on the forum.

Cheers,

Howard

--
You received this message because you are subscribed to the Google Groups "SilverStripe Core Development" group.
To unsubscribe from this group and stop receiving emails from it, send an email to silverstripe-d...@googlegroups.com.
To post to this group, send email to silverst...@googlegroups.com.
Visit this group at http://groups.google.com/group/silverstripe-dev?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

[Tony Air]

Hi Howard,

forum is keeping silence and it's core issue

[Pigeon Friend]

This looks like a bug that needs to go into the bug tracker.

Dan

[Sam Minnée]

Damian Mooyman has done a bunch of work on the ORM recently, including the versioned decorator, and might know what's happening here.  In fact, it's possible that it's already been fixed on a pre-release version.

Does it happen in the latest 3.0 branch from GitHub? What about 3.1?

Is your project set up with Composer?  If so, it's easier to switch between versions of SilverStripe and to make use of development versions.  See http://doc.silverstripe.org/framework/en/installation/composer

Thanks,

Sam

[Tony Air]

Hi Same,

it's 3.1 fetched from github

Best regards, Tony Air
CEO, The Web Development Agency (New Castle LLC)

E-mail: to...@thewebdevelopmentagency.ru
Skype: a2nt.fd
Mob. +7 (923) 136-60-13 (OVB)
Mob. +7 (967) 004-08-17 (DME,SVO,VKO)
http://TheWebDevelopmentAgency.ru/