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