Jump to:

17452 Posts in 4473 Topics by 1971 members

Archive

SilverStripe Forums » Archive » HELP! What happened to my admin pages!

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

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

Page: 1
Go to End
Author Topic: 2106 Views
  • Nicolaas
    Avatar
    Forum Moderator
    213 Posts

    HELP! What happened to my admin pages! Link to this post

    Yesterday morning I went to check out my admin pages and I got this:

    ERROR:
    Error

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

    I reinstalled the sapphire and cms folders using FTP, but nothing changed. What can I do? This is NO fun!

    I tried ?debug=1 , ?flush=1

    still nothing.

    The only thing I did just before I got this problem was that I logged out.

    This is not fun! What can I do????

    Thanks for any help on this self-destruction mode.

    Nicolaas

  • Sean
    Avatar
    Forum Moderator
    921 Posts

    Re: HELP! What happened to my admin pages! Link to this post

    inside your _config.php file, add this line:

    Director::set_environment_type('dev');

    This should then show you the error, rather than give you a page without any debugging information.

    If you don't know what the error means, then please reply back.

    Cheers,
    Sean

  • Nicolaas
    Avatar
    Forum Moderator
    213 Posts

    Re: HELP! What happened to my admin pages! Link to this post

    Thanks Sean!

    That gives me a lot more information:

    FATAL ERROR: DATABASE ERROR: Couldn't run query: SELECT `SiteTree_Live`.*, `UserDefinedForm_Live`.*, `SubscribeForm_Live`.*, `ErrorPage_Live`.*, `GhostPage_Live`.*, `RedirectorPage_Live`.*, `VirtualPage_Live`.*, `SiteTree_Live`.ID, if(`SiteTree_Live`.ClassName,`SiteTree_Live`.ClassName,'SiteTree') AS RecordClassName FROM `SiteTree_Live` LEFT JOIN `UserDefinedForm_Live` ON `UserDefinedForm_Live`.ID = `SiteTree_Live`.ID LEFT JOIN `SubscribeForm_Live` ON `SubscribeForm_Live`.ID = `SiteTree_Live`.ID LEFT JOIN `ErrorPage_Live` ON `ErrorPage_Live`.ID = `SiteTree_Live`.ID LEFT JOIN `GhostPage_Live` ON `GhostPage_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 WHERE (ParentID = AND Sort < ) ORDER BY Sort DESC LIMIT 1 | You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND Sort < ) ORDER BY Sort DESC LIMIT 1' at line 1
    At line 186 in /home/fly-fishing-conz/www/sapphire/core/model/Database.php

    There is some ID missing for some reason.....

    any hints?

    The problem must be in the database I guess....

    Cheers

    Nicolaas

  • mandrew
    Avatar
    Core Development Team
    32 Posts

    Re: HELP! What happened to my admin pages! Link to this post

    Looks like your NextPage / PrevPage controls are the cuplrit?

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