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   2183 Views

Avatar
Nicolaas

Forum Moderator, 213 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, 213 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

Core Development Team, 36 Posts

9 June 2007 at 2:03pm

Looks like your NextPage / PrevPage controls are the cuplrit?