Jump to:

1136 Posts in 1984 Topics by 403 members

Upgrading SilverStripe

SilverStripe Forums » Upgrading SilverStripe » admin/EditForm Fatal Error

Ask questions about upgrading SilverStripe to the latest version.

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

Page: 1
Go to End
Author Topic: 1023 Views
  • pcbender
    Avatar
    Community Member
    20 Posts

    admin/EditForm Fatal Error Link to this post

    On a latest trunk svn up, I am unable to save and publish a previously published page. The short error is:

    Unknown table 'BlogEntry_Live' IN POST /admin/EditForm

    The table is in the database, but it is not in the FROM or JOIN sections of the SQL statement.

    The full error is:

    500//ERROR [User Error]: Couldn't run query: SELECT `SiteTree_Live`.*, `BlogEntry_Live`.*, `BlogTree_Live`.*, `ContactPage_Live`.*, `CheckoutPage_Live`.*, `Product_Live`.*, `ProductGroup_Live`.*, `Calendar_Live`.*, `CalendarEvent_Live`.*, `Forum_Live`.*, `ForumHolder_Live`.*, `GalleryPage_Live`.*, `Donation_Live`.*, `ErrorPage_Live`.*, `RedirectorPage_Live`.*, `VirtualPage_Live`.*, `SSPAlbum_Live`.*, `SSPGallery_Live`.*, `BlogHolder_Live`.*, `SiteTree_Live`.ID, if(`SiteTree_Live`.ClassName,`SiteTree_Live`.ClassName,'SiteTree') AS RecordClassName, `SiteTree_Live_versions`.AuthorID, `SiteTree_Live_versions`.Version, `SiteTree_Live_versions`.RecordID FROM `SiteTree_Live` LEFT JOIN `BlogEntry_versions` ON `BlogEntry_versions`.RecordID = `SiteTree_Live_versions`.RecordID AND `BlogEntry_versions`.Version = `SiteTree_Live_versions`.Version LEFT JOIN `BlogTree_versions` ON `BlogTree_versions`.RecordID = `SiteTree_Live_versions`.RecordID AND `BlogTree_versions`.Version = `SiteTree_Live_versions`.Version LEFT JOIN `ContactPage_versions` ON `ContactPage_versions`.RecordID = `SiteTree_Live_versions`.RecordID AND `ContactPage_versions`.Version = `SiteTree_Live_versions`.Version LEFT JOIN `CheckoutPage_versions` ON `CheckoutPage_versions`.RecordID = `SiteTree_Live_versions`.RecordID AND `CheckoutPage_versions`.Version = `SiteTree_Live_versions`.Version LEFT JOIN `Product_versions` ON `Product_versions`.RecordID = `SiteTree_Live_versions`.RecordID AND `Product_versions`.Version = `SiteTree_Live_versions`.Version LEFT JOIN `ProductGroup_versions` ON `ProductGroup_versions`.RecordID = `SiteTree_Live_versions`.RecordID AND `ProductGroup_versions`.Version = `SiteTree_Live_versions`.Version LEFT JOIN `Calendar_versions` ON `Calendar_versions`.RecordID = `SiteTree_Live_versions`.RecordID AND `Calendar_versions`.Version = `SiteTree_Live_versions`.Version LEFT JOIN `CalendarEvent_versions` ON `CalendarEvent_versions`.RecordID = `SiteTree_Live_versions`.RecordID AND `CalendarEvent_versions`.Version = `SiteTree_Live_versions`.Version LEFT JOIN `Forum_versions` ON `Forum_versions`.RecordID = `SiteTree_Live_versions`.RecordID AND `Forum_versions`.Version = `SiteTree_Live_versions`.Version LEFT JOIN `ForumHolder_versions` ON `ForumHolder_versions`.RecordID = `SiteTree_Live_versions`.RecordID AND `ForumHolder_versions`.Version = `SiteTree_Live_versions`.Version LEFT JOIN `GalleryPage_versions` ON `GalleryPage_versions`.RecordID = `SiteTree_Live_versions`.RecordID AND `GalleryPage_versions`.Version = `SiteTree_Live_versions`.Version LEFT JOIN `Donation_versions` ON `Donation_versions`.RecordID = `SiteTree_Live_versions`.RecordID AND `Donation_versions`.Version = `SiteTree_Live_versions`.Version LEFT JOIN `ErrorPage_versions` ON `ErrorPage_versions`.RecordID = `SiteTree_Live_versions`.RecordID AND `ErrorPage_versions`.Version = `SiteTree_Live_versions`.Version LEFT JOIN `RedirectorPage_versions` ON `RedirectorPage_versions`.RecordID = `SiteTree_Live_versions`.RecordID AND `RedirectorPage_versions`.Version = `SiteTree_Live_versions`.Version LEFT JOIN `VirtualPage_versions` ON `VirtualPage_versions`.RecordID = `SiteTree_Live_versions`.RecordID AND `VirtualPage_versions`.Version = `SiteTree_Live_versions`.Version LEFT JOIN `SSPAlbum_versions` ON `SSPAlbum_versions`.RecordID = `SiteTree_Live_versions`.RecordID AND `SSPAlbum_versions`.Version = `SiteTree_Live_versions`.Version LEFT JOIN `SSPGallery_versions` ON `SSPGallery_versions`.RecordID = `SiteTree_Live_versions`.RecordID AND `SSPGallery_versions`.Version = `SiteTree_Live_versions`.Version LEFT JOIN `BlogHolder_versions` ON `BlogHolder_versions`.RecordID = `SiteTree_Live_versions`.RecordID AND `BlogHolder_versions`.Version = `SiteTree_Live_versions`.Version WHERE (`SiteTree_Live`.WasPublished = true) AND (`SiteTree_Live`.ClassName IN ('Page','BlogEntry','BlogTree','ContactPage','AccountPage','CheckoutPage','Product','ProductGroup','Calendar','CalendarEvent','Forum','ForumHolder','GalleryPage','Donation','SiteMap','ErrorPage','RedirectorPage','VirtualPage','SSPAlbum','SSPGallery','BlogHolder')) AND (`SiteTree_Live_versions`.RecordID = '1') ORDER BY `SiteTree_Live_versions`.LastEdited DESC, `SiteTree_Live_versions`.Version DESC Unknown table 'BlogEntry_Live' IN POST /admin/EditForm Line 400 in /home/pcbender/geo-kidz.com/sapphire/core/model/MySQLDatabase.php

  • pcbender
    Avatar
    Community Member
    20 Posts

    Re: admin/EditForm Fatal Error Link to this post

    After much digging, this turns out to be an issue with the embargoexpiry module. Once I removed it, everything works.

    1023 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.