edit: I have figured out the problem with help of simon_w in the irc... apparently not all my files uploaded correctly, so they were there, but they didn't register the blog entry tables in the database... all is working now... thanks simon!
I have a brand new installation of silverstripe, haven't made any changes yet. I copied the contents of the blog folder to the blog directory on my server, and then ran the /db/build?flush=1 and it at first seemed to hang on creating a table in the database, but I tried again, and it went through.
Now I show a blog holder in my silverstripe admin. However it doesn't give me any options of putting blog pages or anything under it. trying to view it on the site just gives a ton of mysql query fatal errors. my site now has a blog link in the navigation that does nothing.
Help! please?
FATAL ERROR: DATABASE ERROR: Couldn't run query: SELECT `SiteTree`.*, `BlogHolder`.*, `UserDefinedForm`.*, `ErrorPage`.*, `RedirectorPage`.*, `VirtualPage`.*, `SubscribeForm`.*, `SiteTree`.ID, if(`SiteTree`.ClassName,`SiteTree`.ClassName,'SiteTree') AS RecordClassName FROM `SiteTree` LEFT JOIN `BlogHolder` ON `BlogHolder`.ID = `SiteTree`.ID LEFT JOIN `UserDefinedForm` ON `UserDefinedForm`.ID = `SiteTree`.ID LEFT JOIN `ErrorPage` ON `ErrorPage`.ID = `SiteTree`.ID LEFT JOIN `RedirectorPage` ON `RedirectorPage`.ID = `SiteTree`.ID LEFT JOIN `VirtualPage` ON `VirtualPage`.ID = `SiteTree`.ID LEFT JOIN `SubscribeForm` ON `SubscribeForm`.ID = `SiteTree`.ID WHERE (`ParentID` = 5 AND ShowInMenus = 1 ) AND (`SiteTree`.ClassName IN ('Page','BlogHolder','UserDefinedForm','ErrorPage','RedirectorPage','VirtualPage','SubscribeForm')) ORDER BY `BlogEntry`.Date DESC LIMIT 0, 10 | Unknown column 'BlogEntry.Date' in 'order clause'
At line 431 in /home/content/a/d/m/adminwebtest/html/yawac/sapphire/core/model/Database.php
user_error(DATABASE ERROR: Couldn't run query: SELECT `SiteTree`.*, `BlogHolder`.*, `UserDefinedForm`.*, `ErrorPage`.*, `RedirectorPage`.*, `VirtualPage`.*, `SubscribeForm`.*, `SiteTree`.ID, if(`SiteTree`.ClassName,`SiteTree`.ClassName,'SiteTree') AS RecordClassName FROM `SiteTree` LEFT JOIN `BlogHolder` ON `BlogHolder`.ID = `SiteTree`.ID LEFT JOIN `UserDefinedForm` ON `UserDefinedForm`.ID = `SiteTree`.ID LEFT JOIN `ErrorPage` ON `ErrorPage`.ID = `SiteTree`.ID LEFT JOIN `RedirectorPage` ON `RedirectorPage`.ID = `SiteTree`.ID LEFT JOIN `VirtualPage` ON `VirtualPage`.ID = `SiteTree`.ID LEFT JOIN `SubscribeForm` ON `SubscribeForm`.ID = `SiteTree`.ID WHERE (`ParentID` = 5 AND ShowInMenus = 1 ) AND (`SiteTree`.ClassName IN ('Page','BlogHolder','UserDefinedForm','ErrorPage','RedirectorPage','VirtualPage','SubscribeForm')) ORDER BY `BlogEntry`.Date DESC LIMIT 0, 10 | Unknown column 'BlogEntry.Date' in 'order clause',256)
line 431 of Database.php
Database->databaseError(Couldn't run query: SELECT `SiteTree`.*, `BlogHolder`.*, `UserDefinedForm`.*, `ErrorPage`.*, `RedirectorPage`.*, `VirtualPage`.*, `SubscribeForm`.*, `SiteTree`.ID, if(`SiteTree`.ClassName,`SiteTree`.ClassName,'SiteTree') AS RecordClassName FROM `SiteTree` LEFT JOIN `BlogHolder` ON `BlogHolder`.ID = `SiteTree`.ID LEFT JOIN `UserDefinedForm` ON `UserDefinedForm`.ID = `SiteTree`.ID LEFT JOIN `ErrorPage` ON `ErrorPage`.ID = `SiteTree`.ID LEFT JOIN `RedirectorPage` ON `RedirectorPage`.ID = `SiteTree`.ID LEFT JOIN `VirtualPage` ON `VirtualPage`.ID = `SiteTree`.ID LEFT JOIN `SubscribeForm` ON `SubscribeForm`.ID = `SiteTree`.ID WHERE (`ParentID` = 5 AND ShowInMenus = 1 ) AND (`SiteTree`.ClassName IN ('Page','BlogHolder','UserDefinedForm','ErrorPage','RedirectorPage','VirtualPage','SubscribeForm')) ORDER BY `BlogEntry`.Date DESC LIMIT 0, 10 | Unknown column 'BlogEntry.Date' in 'order clause',256)
line 108 of MySQLDatabase.php
MySQLDatabase->query(SELECT `SiteTree`.*, `BlogHolder`.*, `UserDefinedForm`.*, `ErrorPage`.*, `RedirectorPage`.*, `VirtualPage`.*, `SubscribeForm`.*, `SiteTree`.ID, if(`SiteTree`.ClassName,`SiteTree`.ClassName,'SiteTree') AS RecordClassName FROM `SiteTree` LEFT JOIN `BlogHolder` ON `BlogHolder`.ID = `SiteTree`.ID LEFT JOIN `UserDefinedForm` ON `UserDefinedForm`.ID = `SiteTree`.ID LEFT JOIN `ErrorPage` ON `ErrorPage`.ID = `SiteTree`.ID LEFT JOIN `RedirectorPage` ON `RedirectorPage`.ID = `SiteTree`.ID LEFT JOIN `VirtualPage` ON `VirtualPage`.ID = `SiteTree`.ID LEFT JOIN `SubscribeForm` ON `SubscribeForm`.ID = `SiteTree`.ID WHERE (`ParentID` = 5 AND ShowInMenus = 1 ) AND (`SiteTree`.ClassName IN ('Page','BlogHolder','UserDefinedForm','ErrorPage','RedirectorPage','VirtualPage','SubscribeForm')) ORDER BY `BlogEntry`.Date DESC LIMIT 0, 10,256)
line 81 of DB.php
DB::query(SELECT `SiteTree`.*, `BlogHolder`.*, `UserDefinedForm`.*, `ErrorPage`.*, `RedirectorPage`.*, `VirtualPage`.*, `SubscribeForm`.*, `SiteTree`.ID, if(`SiteTree`.ClassName,`SiteTree`.ClassName,'SiteTree') AS RecordClassName FROM `SiteTree` LEFT JOIN `BlogHolder` ON `BlogHolder`.ID = `SiteTree`.ID LEFT JOIN `UserDefinedForm` ON `UserDefinedForm`.ID = `SiteTree`.ID LEFT JOIN `ErrorPage` ON `ErrorPage`.ID = `SiteTree`.ID LEFT JOIN `RedirectorPage` ON `RedirectorPage`.ID = `SiteTree`.ID LEFT JOIN `VirtualPage` ON `VirtualPage`.ID = `SiteTree`.ID LEFT JOIN `SubscribeForm` ON `SubscribeForm`.ID = `SiteTree`.ID WHERE (`ParentID` = 5 AND ShowInMenus = 1 ) AND (`SiteTree`.ClassName IN ('Page','BlogHolder','UserDefinedForm','ErrorPage','RedirectorPage','VirtualPage','SubscribeForm')) ORDER BY `BlogEntry`.Date DESC LIMIT 0, 10)
line 157 of SQLQuery.php
SQLQuery->execute()
line 1519 of DataObject.php
DataObject->instance_get(`ParentID` = 5 AND ShowInMenus = 1 ,`BlogEntry`.Date DESC,,0, 10,DataObjectSet)
line 1502 of DataObject.php
DataObject::get(Page,`ParentID` = 5 AND ShowInMenus = 1 ,`BlogEntry`.Date DESC,,0, 10)
line 51 of BlogHolder.php
BlogHolder->BlogEntries()
call_user_func_array(Array,Array)
line 177 of Object.php
Object->__call(BlogEntries,Array)
BlogHolder_Controller->BlogEntries()
call_user_func_array(Array,Array)
line 542 of ViewableData.php
ViewableData->cachedCall(BlogEntries,,)
line 583 of ViewableData.php
ViewableData->hasValue(BlogEntries)
line 54 of .cache.home.content.a.d.m.adminwebtest.html.yawac.blog.templates.Layout.BlogHolder.ss
include(/tmp/silverstripe-cache-home-content-a-d-m-adminwebtest-html-yawac/.cache.home.content.a.d.m.adminwebtest.html.yawac.blog.templates.Layout.BlogHolder.ss)
line 197 of SSViewer.php
SSViewer->process(BlogHolder_Controller)
line 189 of SSViewer.php
SSViewer->process(BlogHolder_Controller)
line 296 of Controller.php
Controller->defaultAction(index,Array)
line 267 of Controller.php
Controller->run(Array)
line 22 of ModelAsController.php
ModelAsController->run(Array)
line 104 of Director.php
Director::direct(blog/)
line 158 of main.php
Context
Debug (Debug::showError() in line 180 of Debug.php)
* msg =
Couldn't run query: SELECT `SiteTree`.*, `BlogHolder`.*, `UserDefinedForm`.*, `ErrorPage`.*, `RedirectorPage`.*, `VirtualPage`.*, `SubscribeForm`.*, `SiteTree`.ID, if(`SiteTree`.ClassName,`SiteTree`.ClassName,'SiteTree') AS RecordClassName FROM `SiteTree` LEFT JOIN `BlogHolder` ON `BlogHolder`.ID = `SiteTree`.ID LEFT JOIN `UserDefinedForm` ON `UserDefinedForm`.ID = `SiteTree`.ID LEFT JOIN `ErrorPage` ON `ErrorPage`.ID = `SiteTree`.ID LEFT JOIN `RedirectorPage` ON `RedirectorPage`.ID = `SiteTree`.ID LEFT JOIN `VirtualPage` ON `VirtualPage`.ID = `SiteTree`.ID LEFT JOIN `SubscribeForm` ON `SubscribeForm`.ID = `SiteTree`.ID WHERE (`ParentID` = 5 AND ShowInMenus = 1 ) AND (`SiteTree`.ClassName IN ('Page','BlogHolder','UserDefinedForm','ErrorPage','RedirectorPage','VirtualPage','SubscribeForm')) ORDER BY `BlogEntry`.Date DESC LIMIT 0, 10 | Unknown column 'BlogEntry.Date' in 'order clause'
* errorLevel =
256