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.

Archive

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

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

HELP! What happened to my admin pages!


Reply

4 Posts   2126 Views

Avatar
Nicolaas

7 June 2007 at 10:25am Forum Moderator, 213 Posts

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

7 June 2007 at 1:46pm (Last edited: 7 June 2007 1:46pm), Forum Moderator, 921 Posts

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

7 June 2007 at 4:04pm (Last edited: 8 June 2007 1:15pm), Forum Moderator, 213 Posts

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

9 June 2007 at 2:03pm Core Development Team, 33 Posts

Looks like your NextPage / PrevPage controls are the cuplrit?