Forum posts to 'Archive'

Re: Login doesn't load CMS

aymentouhent — Sat, 23 Feb 2008 11:17:20 +1300

Thank u PRACHAIT, ur solution work by moving the max()

Posted to: Login doesn't load CMS Show Thread | Post Reply

Re: Login doesn't load CMS

Tim — Wed, 09 Jan 2008 19:17:38 +1300

Thanks for your fix Prachait, I've reported this bug and your patch here;

http://open.silverstripe.com/ticket/2111

Posted to: Login doesn't load CMS Show Thread | Post Reply

Re: Login doesn't load CMS

gamelodge — Wed, 09 Jan 2008 17:27:32 +1300

has someone reported this as a Bug yet?

Posted to: Login doesn't load CMS Show Thread | Post Reply

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

prachait — Wed, 09 Jan 2008 17:18:44 +1300

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

Posted to: Login doesn't load CMS Show Thread | Post Reply

Re: Login doesn't load CMS

gamelodge — Sat, 05 Jan 2008 14:50:49 +1300

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?

Posted to: Login doesn't load CMS Show Thread | Post Reply

Re: Login doesn't load CMS

gamelodge — Sat, 05 Jan 2008 04:23:13 +1300

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

Posted to: Login doesn't load CMS Show Thread | Post Reply

Re: Login doesn't load CMS

vcmusic42 — Tue, 25 Dec 2007 12:28:25 +1300

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

Posted to: Login doesn't load CMS Show Thread | Post Reply

Re: Login doesn't load CMS

vcmusic42 — Tue, 25 Dec 2007 12:20:51 +1300

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!!

Posted to: Login doesn't load CMS Show Thread | Post Reply

Re: Login doesn't load CMS

Tim — Tue, 25 Dec 2007 12:05:01 +1300

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.

Posted to: Login doesn't load CMS Show Thread | Post Reply

Login doesn't load CMS

vcmusic42 — Tue, 25 Dec 2007 04:02:23 +1300

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?

Posted to: Login doesn't load CMS Show Thread | Post Reply