17488 Posts in 4473 Topics by 1978 members
|
Page:
1
|
Go to End | |
| Author | Topic: | 2009 Views |
-
HELP! What happened to my admin pages!

7 June 2007 at 10:25am
Yesterday morning I went to check out my admin pages and I got this:
ERROR:
ErrorThe 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
-
Re: HELP! What happened to my admin pages!

7 June 2007 at 1:46pm Last edited: 7 June 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 -
Re: HELP! What happened to my admin pages!

7 June 2007 at 4:04pm Last edited: 8 June 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.phpThere is some ID missing for some reason.....
any hints?
The problem must be in the database I guess....
Cheers
Nicolaas
-
Re: HELP! What happened to my admin pages!

9 June 2007 at 2:03pm
Looks like your NextPage / PrevPage controls are the cuplrit?
| 2009 Views | ||
|
Page:
1
|
Go to Top |


