Error 500

Getting in error 500 message when trying to view site shortly after changing document hierarchy.

Am I doomed? Or is there a way (barring a restore) to bring it back to life?

Many thanks

Please read http://modxcms.com/forums/index.php/topic,489.0.html and provide some more information about what you did...

OK here’s the info that I know how to gather - I put a question mark if I don’t know how to get it. None of the pages are working.

Web Server:
• PHP version and how it’s running (suexec, mod_php, CGI, etc.) 5.2.1 CGI
• Apache or IIS version - Apache Vers?
• Operating System and version ?


Database:
• MySQL version 5.0.18
• List of any tables over 1MB in size modx_event_log (18mb)


MODx:
• Version 0.9.5
• Any changes you’ve made -
• Any snippets you’re running on the page that is not working properly Wayfinder1, Ditto 1.0.2
• Any plugins you’re running - FCKeditor TinyMCE


Browser/Client:
• Browser name and version FF 1.5.0.11
• Operating System and version Mac 10.4.8

Many thanks

A bit more info as Firefox gives me:

« MODx Parse Error »
MODx encountered the following error while attempting to parse the requested resource:
« Execution of a query to the database failed - 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 ’48 AND sc.published=1 AND sc.deleted=0 AND (sc.privateweb=0) AND sc.hidemenu = 0’ at line 1 »
SQL: SELECT DISTINCT sc.id,sc.menutitle,sc.pagetitle,sc.introtext,sc.menuindex,sc.published,sc.hidemenu,sc.parent,sc.isfolder,sc.description,sc.alias,sc.longtitle,sc.type,if(sc.type=’reference’,sc.content,’’) as content, sc.template,sc.link_attributes FROM `db#########`.modx_site_content sc LEFT JOIN `db########`.modx_document_groups dg on dg.document = sc.id WHERE sc.parent = 1,48 AND sc.published=1 AND sc.deleted=0 AND (sc.privateweb=0) AND sc.hidemenu = 0 GROUP BY sc.id ORDER BY sc.menuindex ASC;
[Copy SQL to ClipBoard]

Parser timing
MySQL: 0.0066 s (4 Requests)
PHP: 0.0391 s
Total: 0.0457 s



Please not that I replaced the db figure with hashes

Problem solved!

I had a Wayfinder call of &startId=`1,47` - that’s what caused the problem.

I’m a fool.

I’m going for a pint.

No I’m going to the toilet then I’m going for a pint.