SilverStripe Forum

• Overview
• User help
• Tutorials
• Documentation
• Forums
• IRC
• Mailing Lists
• Showcase
• Bugs
• How to Contribute
• Donate
• Roadmap
• Search (new!)

• vcmusic42
  
  Community Member
  22 posts
  

  Login doesn't load CMS

  25 December 2007 at 4:02am

  I don't know what's going on, but as of the past few days, my login page fails to redirect me to the CMS admin. When I go to:

  http://domain.com/Security/login

  it prompts me for the login/password, then says "Welcome back," but then nothing happens. I was concerned I wouldn't be able to get into the admin at all, but I did, by going to domain.com/admin directly. However, I was rather fond of the redirect and want it back!

  The only changes I've made have been to the page templates, because I've been testing a new layout. Other than that everything's the same. Any ideas on what could have caused this?

• Tim
  
  Core Development Team
  200 posts
  

  Re: Login doesn't load CMS

  25 December 2007 at 12:05pm

  To login to the CMS go to domain.com/admin/ this will then redirect you to the security login page, then back to the CMS admin interface after you have logged in.

• vcmusic42
  
  Community Member
  22 posts
  

  Re: Login doesn't load CMS

  25 December 2007 at 12:20pm

  The latest development as of 5 mins ago is that now, even when I enter the correct login details, going straight to http://domain.com/admin gets me this:

  ERROR:
  Error

  The website server has not been able to respond to your request.

  No 500, 404, or other indications of where this is coming from.

  This is ODD. All I've been doing this past hour is the Data-object Relationships tutorial, and I see my new pages/objects correctly in the flush - which proves it's not that the website is down. I get the login pages and the flush just fine, but have NO ACCESS to the admin now. ?? HELP!!

• vcmusic42
  
  Community Member
  22 posts
  

  Re: Login doesn't load CMS

  25 December 2007 at 12:28pm

  Ok, when in doubt, retrace your steps, right? I deleted the 3 changed files I'd been working with in the tutorial - Project.php, Student.php, and ProjectHolder.php. Ran a flush and deleted the cache, and the admin reappeared. Something in one of those files must have been causing an error, although I have no idea what it could have been...

  looking for typos now...

• gamelodge
  
  Community Member
  6 posts
  

  Re: Login doesn't load CMS

  5 January 2008 at 4:23am

  I have the same problem with same error:

  
  ERROR:
  Error

  The website server has not been able to respond to your request.
  

  This is new installation, no modifications.
  I downloaded the software
  downloaded modules gallery/ecommerce/forum/blog
  uploaded all
  did install

  All works and i can login and manage all sections except CMS everytime i try and manage CMS it gives me that error

  Last edited: 5 January 2008 at 4:24am

• gamelodge
  
  Community Member
  6 posts
  

  Re: Login doesn't load CMS

  5 January 2008 at 2:50pm

  Here is the error i get when switching on dev mode-
  
  FATAL ERROR: DATABASE ERROR: Couldn't run query: SELECT `Post`.*, `Post`.ID, if(`Post`.ClassName,`Post`.ClassName,'Post') AS RecordClassName FROM `Post` INNER JOIN `Post` AS PostList ON PostList.TopicID = `Post`.TopicID WHERE (`Post`.ForumID = 14 and `Post`.ParentID = 0 and `Post`.Status = 'Moderated') GROUP BY `Post`.ID ORDER BY max(PostList.Created) DESC LIMIT 30 | Invalid use of group function
  At line 397 in /home/silver/public_html/sapphire/core/model/Database.php
  

  looks like a forum issue?

  Unistalled Forum All works fine now
  installed form again - broken again
  so must be a forum issue, anyone else having this problem?

  Last edited: 5 January 2008 at 2:55pm

• prachait
  
  Community Member
  1 post
  

  Re: Login doesn't load CMS - SOLUTION IS HERE

  9 January 2008 at 5:18pm

  Hi

  I too have the same issues
  I just installed the new version, and every thing works ok
  As soon as I install the FORUM, it become broked
  /admin gives
  ERROR:
  Error

  The website server has not been able to respond to your request.

  Solution::

  1. Open forum\code\forum.php
  2. go to line 265
  

  
  return DataObject::get("Post", "`Post`.ForumID = $this->ID and `Post`.ParentID = 0 and $statusFilter", "max(PostList.Created) DESC",
           "INNER JOIN `Post` AS PostList ON PostList.TopicID = `Post`.TopicID", $limit
        );
  

  remove the max() from max(PostList.Created) to PostList.Created

  New code will be

  
        return DataObject::get("Post", "`Post`.ForumID = $this->ID and `Post`.ParentID = 0 and $statusFilter", "PostList.Created DESC",
           "INNER JOIN `Post` AS PostList ON PostList.TopicID = `Post`.TopicID", $limit
        );
  

  and it will work fine.

  Kindly let me know your feedbacks on info at prachait dot com

  Thanks
  Prachait Saxena

  Last edited: 9 January 2008 at 5:43pm

• gamelodge
  
  Community Member
  6 posts
  

  Re: Login doesn't load CMS

  9 January 2008 at 5:27pm

  has someone reported this as a Bug yet?