Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

Upgrading SilverStripe

Ask questions about upgrading SilverStripe to the latest version.

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

admin/EditForm Fatal Error


Reply

2 Posts   1058 Views

Avatar
pcbender

9 June 2009 at 10:50am Community Member, 20 Posts

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

Avatar
pcbender

10 June 2009 at 4:20am Community Member, 20 Posts

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