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   1094 Views

Avatar
pcbender

Community Member, 20 Posts

9 June 2009 at 10:50am

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

Community Member, 20 Posts

10 June 2009 at 4:20am

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