Jump to:

17488 Posts in 4473 Topics by 1978 members

Archive

SilverStripe Forums » Archive » blog won't install correctly

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

Moderators: martimiz, Howard, Sean, Ryan M., biapar, Willr, Ingo, simon_w

Page: 1
Go to End
Author Topic: 618 Views
  • grayCeworks
    Avatar
    Community Member
    2 Posts

    blog won't install correctly Link to this post

    6 November 2008 at 4:37pm Last edited: 6 November 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

    618 Views
Page: 1
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.