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.

Archive /

Our old forums are still available as a read-only archive.

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

blog won't install correctly


Reply


818 Views

Avatar
grayCeworks

Community Member, 2 Posts

6 November 2008 at 4:37pm

Edited: 06/11/2008 5:29pm

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