Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

We're retiring the forums!

The SilverStripe forums have passed their heyday. They'll stick around, but will be read only. We'd encourage you to get involved in the community via the following channels instead:

Archive /

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

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

HELP! What happened to my admin pages!


Go to End


4 Posts   2364 Views

Avatar
Nicolaas

Forum Moderator, 224 Posts

7 June 2007 at 10:25am

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

Avatar
Sean

Forum Moderator, 922 Posts

7 June 2007 at 1:46pm

Edited: 07/06/2007 1:46pm

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

Avatar
Nicolaas

Forum Moderator, 224 Posts

7 June 2007 at 4:04pm

Edited: 08/06/2007 1:15pm

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

Avatar
mandrew

Community Member, 37 Posts

9 June 2007 at 2:03pm

Looks like your NextPage / PrevPage controls are the cuplrit?