[re-solved] Sudden death: « MODx Parse Error »

I went from things working well to death. I don’t even know where to look.

I was editing a page when it happened, but can’t fathom what I changed on a page to cause this:

« 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 ’’ at line 1 »
SQL: SELECT published FROM `bcclique_bcportal`.bcportal_site_content WHERE id=
[Copy SQL to ClipBoard]

Parser timing
MySQL: 0.0005 s (2 Requests)
PHP: 1165649454.3476 s
Total: 1165649454.3481 s

I don’t even know where to start!

Thanks for any help!

Clicking on the "copy to clipboard" does nothing, btw.

I deleted a portion of the template I was working on - that seemed to let the site become accessible again.

However - I still get the error shown in the attachment. This shows up in the Manager on the home page of the Manager.

Your php version? MySql version? ... list of snippets you are using on that page etc..

Quote from: guyanonymous at Dec 09, 2006, 01:33 AM

[b]« 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 ’’ at line 1 »
SQL: SELECT published FROM `bcclique_bcportal`.bcportal_site_content WHERE id=
[Copy SQL to ClipBoard]

Well, the document id is missing from this SQL query, so that’s why you’re getting an error.

Does clicking on any document in the manager give you this? Or just one of them in particular? Have you tried just refreshing the document tree (or refreshing the manager page altogether)?

To me it just looks as if the links that are being created in the document tree are broken for some reason, and given that the ids seem to be showing in parenthesis next to each document in the image that you posted I assume that they are there in the database (it’s not corrupted or anything like that), but the page just didn’t load properly for some reason.

This is what leaves me confused.

None of the individual pages give this error - it’s only in the Manager now when I end up on the "home" page of manager (e.g., after saving anything in configuration; after hitting Site/Home).

Operating system Linux
Kernel version 2.6.17-11_4.BHsmp
Apache version 1.3.37 (Unix)
PERL version 5.8.5
PHP version 4.4.4
MySQL version 4.1.21-standard-log

I recognize this must be from something I did - it’s just I have no idea what.

Try clearing your event log (I suspect it’s now huge): Reports > System Events > Clear Log button

Looks like the new check to make sure you have a valid start_page, error_page, and unauthorized_page is dying. In fact, it needs to first check if there is a valid id specified before it even executes that query. Add a valid error_page or unauthorized_page to your Tools --> Configuration and the problem should go away...

BINGO!

It was the error page. All is good now!


Thanks!

Now on to solve my other confusions