Jump to:

17488 Posts in 4473 Topics by 1978 members

Archive

SilverStripe Forums » Archive » Blog Won't Work...

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: 1678 Views
  • morethanfire
    Avatar
    Community Member
    13 Posts

    Blog Won't Work... Link to this post

    25 June 2008 at 8:13am

    I am trying to get my blog to work, but currently if you go the url it shows a blank page (no source or anything). The blog is the most recent module version and i am using 2.2.2. My host is MediaTemple (gs). Everything else is working correctly, I think at least. I have reinstalled the blog module, but that did not work. I am getting some errors through email, they are down below. Is there anything I can do to fix this?

    Warning: Cannot modify header information - headers already sent by (output started at /nfs/c02/h05/mnt/41947/domains/domainname.com/html/blog/_config.php:10)
    At line 95 in /nfs/c02/h05/mnt/41947/domains/domainname.com/html/sapphire/misc/GoogleSitemap.php

    header(Content-type: application/xml; charset="utf-8")
    line 95 of GoogleSitemap.php

    GoogleSitemap->index(Array)
    line 261 of Controller.php

    Controller->run(Array)
    line 104 of Director.php

    Director::direct(/sitemap.xml)
    line 158 of main.php

    and

    Error: DATABASE ERROR: Couldn't run query: SELECT `SiteTree_Live`.*, `BlogEntry_Live`.*, `BlogHolder_Live`.*, `UserDefinedForm_Live`.*, `GalleryPage_Live`.*, `ArticlePage_Live`.*, `ErrorPage_Live`.*, `RedirectorPage_Live`.*, `VirtualPage_Live`.*, `SubscribeForm_Live`.*, `SiteTree_Live`.ID, if(`SiteTree_Live`.ClassName,`SiteTree_Live`.ClassName,'SiteTree') AS RecordClassName FROM `SiteTree_Live` LEFT JOIN `BlogEntry_Live` ON `BlogEntry_Live`.ID = `SiteTree_Live`.ID LEFT JOIN `BlogHolder_Live` ON `BlogHolder_Live`.ID = `SiteTree_Live`.ID LEFT JOIN `UserDefinedForm_Live` ON `UserDefinedForm_Live`.ID = `SiteTree_Live`.ID LEFT JOIN `GalleryPage_Live` ON `GalleryPage_Live`.ID = `SiteTree_Live`.ID LEFT JOIN `ArticlePage_Live` ON `ArticlePage_Live`.ID = `SiteTree_Live`.ID LEFT JOIN `ErrorPage_Live` ON `ErrorPage_Live`.ID = `SiteTree_Live`.ID LEFT JOIN `RedirectorPage_Live` ON `RedirectorPage_Live`.ID = `SiteTree_Live`.ID LEFT JOIN `VirtualPage_Live` ON `VirtualPage_Live`.ID = `SiteTree_Live`.ID LEFT JOIN `SubscribeForm_Live` ON `SubscribeForm_Live`.ID = `SiteTree_Live`.ID WHERE (`ParentID` = 25 AND ShowInMenus = 1 AND Date BETWEEN 'blog-1-1' AND 'blog-12-31') AND (`SiteTree_Live`.ClassName IN ('Page','BlogEntry','BlogHolder','UserDefinedForm','GalleryPage','ArticleHolder','ArticlePage','HomePage','ErrorPage','RedirectorPage','VirtualPage','SubscribeForm')) ORDER BY `BlogEntry_Live`.Date DESC LIMIT 0, 10 | Column 'Date' in where clause is ambiguous
    At line 431 in /nfs/c02/h05/mnt/41947/domains/domainname.com/html/sapphire/core/model/Database.php

    user_error(DATABASE ERROR: Couldn't run query: SELECT `SiteTree_Live`.*, `BlogEntry_Live`.*, `BlogHolder_Live`.*, `UserDefinedForm_Live`.*, `GalleryPage_Live`.*, `ArticlePage_Live`.*, `ErrorPage_Live`.*, `RedirectorPage_Live`.*, `VirtualPage_Live`.*, `SubscribeForm_Live`.*, `SiteTree_Live`.ID, if(`SiteTree_Live`.ClassName,`SiteTree_Live`.ClassName,'SiteTree') AS RecordClassName FROM `SiteTree_Live` LEFT JOIN `BlogEntry_Live` ON `BlogEntry_Live`.ID = `SiteTree_Live`.ID LEFT JOIN `BlogHolder_Live` ON `BlogHolder_Live`.ID = `SiteTree_Live`.ID LEFT JOIN `UserDefinedForm_Live` ON `UserDefinedForm_Live`.ID = `SiteTree_Live`.ID LEFT JOIN `GalleryPage_Live` ON `GalleryPage_Live`.ID = `SiteTree_Live`.ID LEFT JOIN `ArticlePage_Live` ON `ArticlePage_Live`.ID = `SiteTree_Live`.ID LEFT JOIN `ErrorPage_Live` ON `ErrorPage_Live`.ID = `SiteTree_Live`.ID LEFT JOIN `RedirectorPage_Live` ON `RedirectorPage_Live`.ID = `SiteTree_Live`.ID LEFT JOIN `VirtualPage_Live` ON `VirtualPage_Live`.ID = `SiteTree_Live`.ID LEFT JOIN `SubscribeForm_Live` ON `SubscribeForm_Live`.ID = `SiteTree_Live`.ID WHERE (`ParentID` = 25 AND ShowInMenus = 1 AND Date BETWEEN 'blog-1-1' AND 'blog-12-31') AND (`SiteTree_Live`.ClassName IN ('Page','BlogEntry','BlogHolder','UserDefinedForm','GalleryPage','ArticleHolder','ArticlePage','HomePage','ErrorPage','RedirectorPage','VirtualPage','SubscribeForm')) ORDER BY `BlogEntry_Live`.Date DESC LIMIT 0, 10 | Column 'Date' in where clause is ambiguous,256)
    line 431 of Database.php

    Database->databaseError(Couldn't run query: SELECT `SiteTree_Live`.*, `BlogEntry_Live`.*, `BlogHolder_Live`.*, `UserDefinedForm_Live`.*, `GalleryPage_Live`.*, `ArticlePage_Live`.*, `ErrorPage_Live`.*, `RedirectorPage_Live`.*, `VirtualPage_Live`.*, `SubscribeForm_Live`.*, `SiteTree_Live`.ID, if(`SiteTree_Live`.ClassName,`SiteTree_Live`.ClassName,'SiteTree') AS RecordClassName FROM `SiteTree_Live` LEFT JOIN `BlogEntry_Live` ON `BlogEntry_Live`.ID = `SiteTree_Live`.ID LEFT JOIN `BlogHolder_Live` ON `BlogHolder_Live`.ID = `SiteTree_Live`.ID LEFT JOIN `UserDefinedForm_Live` ON `UserDefinedForm_Live`.ID = `SiteTree_Live`.ID LEFT JOIN `GalleryPage_Live` ON `GalleryPage_Live`.ID = `SiteTree_Live`.ID LEFT JOIN `ArticlePage_Live` ON `ArticlePage_Live`.ID = `SiteTree_Live`.ID LEFT JOIN `ErrorPage_Live` ON `ErrorPage_Live`.ID = `SiteTree_Live`.ID LEFT JOIN `RedirectorPage_Live` ON `RedirectorPage_Live`.ID = `SiteTree_Live`.ID LEFT JOIN `VirtualPage_Live` ON `VirtualPage_Live`.ID = `SiteTree_Live`.ID LEFT JOIN `SubscribeForm_Live` ON `SubscribeForm_Live`.ID = `SiteTree_Live`.ID WHERE (`ParentID` = 25 AND ShowInMenus = 1 AND Date BETWEEN 'blog-1-1' AND 'blog-12-31') AND (`SiteTree_Live`.ClassName IN ('Page','BlogEntry','BlogHolder','UserDefinedForm','GalleryPage','ArticleHolder','ArticlePage','HomePage','ErrorPage','RedirectorPage','VirtualPage','SubscribeForm')) ORDER BY `BlogEntry_Live`.Date DESC LIMIT 0, 10 | Column 'Date' in where clause is ambiguous,256)
    line 108 of MySQLDatabase.php

    MySQLDatabase->query(SELECT `SiteTree_Live`.*, `BlogEntry_Live`.*, `BlogHolder_Live`.*, `UserDefinedForm_Live`.*, `GalleryPage_Live`.*, `ArticlePage_Live`.*, `ErrorPage_Live`.*, `RedirectorPage_Live`.*, `VirtualPage_Live`.*, `SubscribeForm_Live`.*, `SiteTree_Live`.ID, if(`SiteTree_Live`.ClassName,`SiteTree_Live`.ClassName,'SiteTree') AS RecordClassName FROM `SiteTree_Live` LEFT JOIN `BlogEntry_Live` ON `BlogEntry_Live`.ID = `SiteTree_Live`.ID LEFT JOIN `BlogHolder_Live` ON `BlogHolder_Live`.ID = `SiteTree_Live`.ID LEFT JOIN `UserDefinedForm_Live` ON `UserDefinedForm_Live`.ID = `SiteTree_Live`.ID LEFT JOIN `GalleryPage_Live` ON `GalleryPage_Live`.ID = `SiteTree_Live`.ID LEFT JOIN `ArticlePage_Live` ON `ArticlePage_Live`.ID = `SiteTree_Live`.ID LEFT JOIN `ErrorPage_Live` ON `ErrorPage_Live`.ID = `SiteTree_Live`.ID LEFT JOIN `RedirectorPage_Live` ON `RedirectorPage_Live`.ID = `SiteTree_Live`.ID LEFT JOIN `VirtualPage_Live` ON `VirtualPage_Live`.ID = `SiteTree_Live`.ID LEFT JOIN `SubscribeForm_Live` ON `SubscribeForm_Live`.ID = `SiteTree_Live`.ID WHERE (`ParentID` = 25 AND ShowInMenus = 1 AND Date BETWEEN 'blog-1-1' AND 'blog-12-31') AND (`SiteTree_Live`.ClassName IN ('Page','BlogEntry','BlogHolder','UserDefinedForm','GalleryPage','ArticleHolder','ArticlePage','HomePage','ErrorPage','RedirectorPage','VirtualPage','SubscribeForm')) ORDER BY `BlogEntry_Live`.Date DESC LIMIT 0, 10,256)
    line 81 of DB.php

    DB::query(SELECT `SiteTree_Live`.*, `BlogEntry_Live`.*, `BlogHolder_Live`.*, `UserDefinedForm_Live`.*, `GalleryPage_Live`.*, `ArticlePage_Live`.*, `ErrorPage_Live`.*, `RedirectorPage_Live`.*, `VirtualPage_Live`.*, `SubscribeForm_Live`.*, `SiteTree_Live`.ID, if(`SiteTree_Live`.ClassName,`SiteTree_Live`.ClassName,'SiteTree') AS RecordClassName FROM `SiteTree_Live` LEFT JOIN `BlogEntry_Live` ON `BlogEntry_Live`.ID = `SiteTree_Live`.ID LEFT JOIN `BlogHolder_Live` ON `BlogHolder_Live`.ID = `SiteTree_Live`.ID LEFT JOIN `UserDefinedForm_Live` ON `UserDefinedForm_Live`.ID = `SiteTree_Live`.ID LEFT JOIN `GalleryPage_Live` ON `GalleryPage_Live`.ID = `SiteTree_Live`.ID LEFT JOIN `ArticlePage_Live` ON `ArticlePage_Live`.ID = `SiteTree_Live`.ID LEFT JOIN `ErrorPage_Live` ON `ErrorPage_Live`.ID = `SiteTree_Live`.ID LEFT JOIN `RedirectorPage_Live` ON `RedirectorPage_Live`.ID = `SiteTree_Live`.ID LEFT JOIN `VirtualPage_Live` ON `VirtualPage_Live`.ID = `SiteTree_Live`.ID LEFT JOIN `SubscribeForm_Live` ON `SubscribeForm_Live`.ID = `SiteTree_Live`.ID WHERE (`ParentID` = 25 AND ShowInMenus = 1 AND Date BETWEEN 'blog-1-1' AND 'blog-12-31') AND (`SiteTree_Live`.ClassName IN ('Page','BlogEntry','BlogHolder','UserDefinedForm','GalleryPage','ArticleHolder','ArticlePage','HomePage','ErrorPage','RedirectorPage','VirtualPage','SubscribeForm')) ORDER BY `BlogEntry_Live`.Date DESC LIMIT 0, 10)
    line 157 of SQLQuery.php

    SQLQuery->execute()
    line 1519 of DataObject.php

    DataObject->instance_get(`ParentID` = 25 AND ShowInMenus = 1 AND Date BETWEEN 'blog-1-1' AND 'blog-12-31',`BlogEntry`.Date DESC,,0, 10,DataObjectSet)
    line 1502 of DataObject.php

    DataObject::get(Page,`ParentID` = 25 AND ShowInMenus = 1 AND Date BETWEEN 'blog-1-1' AND 'blog-12-31',`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 38 of .cache.nfs.c02.h05.mnt.41947.domains.domainname.com.html.blog.templates.Layout.BlogHolder.ss

    include(/nfs/c02/h05/mnt/41947/domains/domainname.com/html/silverstripe-cache/.cache.nfs.c02.h05.mnt.41947.domains.domainname.com.html.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(blog,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/blog)
    line 158 of main.php

  • Willr
    Avatar
    Forum Moderator
    5163 Posts

    Re: Blog Won't Work... Link to this post

    26 June 2008 at 2:02pm

    Column 'Date' in where clause is ambiguous


    Blog module has a field called date you probably have another column called Date as well, this is conflicting. Make sure any of your SQL code has the correct table in the filter rather then just filtering by "Date DESC" you need to do "`BlogEntry`.`Date` DESC" and check your code does `YourPageType`.`Date` instead of Date in any DataObject gets or SQL

  • morethanfire
    Avatar
    Community Member
    13 Posts

    Re: Blog Won't Work... Link to this post

    30 June 2008 at 2:05pm

    I am not exactly sure what that all means, ha. I have found "Date DESC" in the BlogHolder.php file. But really don't know what to do with it. Here's the line below.

    return DataObject::get("Page","`ParentID` = $this->ID AND ShowInMenus = 1 $tagCheck $dateCheck","`BlogEntry`.Date DESC",'',"$start, $limit");

  • Willr
    Avatar
    Forum Moderator
    5163 Posts

    Re: Blog Won't Work... Link to this post

    30 June 2008 at 2:18pm

    Looking through your error query I see you had - ArticlePage_Live so you followed the tutorial correct?

    Well the tutorial uses a field called 'Date' on the ArticlePage.php file - open it and check. If it does then what you might have to do is - if you followed the whole tutorial you would have written a method called LatestNews() in HomePage.php

    In the tutorial it looks something like

    function LatestNews($num=5) {
    $news = DataObject::get_one("ArticleHolder");
    return ($news) ? DataObject::get("ArticlePage", "ParentID = $news->ID", "Date DESC", "", $num) : false;
    }

    Now you can see that 3rd parameter is "Date DESC" this might be conflicting - as theres 2 Date fields now - on your ArticlePage.php and your BlogEntry.php file. How you can fix this is by changing that method to sort in the format `ArticlePage`.Date which says what table as well as what field you want to sort by rather then just "Date". So you would change the LatestNews() method to

    function LatestNews($num=5) {
    $news = DataObject::get_one("ArticleHolder");
    return ($news) ? DataObject::get("ArticlePage", "ParentID = $news->ID", "`ArticlePage`.Date DESC", "", $num) : false;
    }

  • morethanfire
    Avatar
    Community Member
    13 Posts

    Re: Blog Won't Work... Link to this post

    30 June 2008 at 6:42pm

    Sweet! I got that, thanks for that I would have never been able to pin-point that down.

    Still the blog is showing up blank. I am not sure what this is. I have switch the blog entry under the hold to a regular page and the blog works, but I rather not have to do this. Is there anything that I may do?

    Cameron

  • Willr
    Avatar
    Forum Moderator
    5163 Posts

    Re: Blog Won't Work... Link to this post

    30 June 2008 at 8:22pm

    hmm yes the blank blog page has come up before - namely http://silverstripe.com/site-builders-forum/flat/105499 I have no idea what it could be. What version of the blog are you trying to use

  • morethanfire
    Avatar
    Community Member
    13 Posts

    Re: Blog Won't Work... Link to this post

    1 July 2008 at 4:33am

    I am using v0.1. I've tried reinstalling it a couple times looking through couple pages of code (not great at code, unless I really know what I am looking at). I also took a look at my server logs and there aren't any errors in there, accept for one not being able to find a script (fixed that). I am on MediaTemple's grid, could there be some issue with what server you are set up on, etc? I have noticed a horrible lag, takes a half minute to load the site sometimes.

    The only error I am getting through email now is this over and over again.

    Warning: Cannot modify header information - headers already sent by (output started at /nfs/c02/h05/mnt/41947/domains/regimentdesign.com/html/blog/_config.php:10)
    At line 95 in /nfs/c02/h05/mnt/41947/domains/regimentdesign.com/html/sapphire/misc/GoogleSitemap.php

    header(Content-type: application/xml; charset="utf-8")
    line 95 of GoogleSitemap.php

    GoogleSitemap->index(Array)
    line 261 of Controller.php

    Controller->run(Array)
    line 104 of Director.php

    Director::direct(/sitemap.xml)
    line 158 of main.php

    1678 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.