Internal Server Error 500
We've been wrestling with this error for several months.
At first, we thought it had to do with the length of documents or reserved words or special characters. All of that may still be true, but what I find after exploring the Web a little is that it has to do with script failure. Apache thinks something is screwy in the PHP being fed to it.
Most recently, I tried to get the sql module to work. I set up the DSN per the instructions on doc.tw.o then created a test page. I inserted one line SQL(db=>memberlist) SE LECT count(*) FROM members SQL
then hit Preview and got the Error 500 message.
We have previously gotten the Error 500 message when words like 'up load' and 'se lect' were in the text of the page. When those words are removed or altered, the page works.
It tends to happen more often when pages are long (that may be psychological. You remember the BIG failures.) which, of course, just means the odds are greater that a reserved word is used, if that's the case.
One on-line source suggests that the path to php.exe may not be correct. I assume that, if it isn't correct, it doesn't work at all.
Surely, others are having this same issue.
Funny. I just got the message from THIS message! I'll alter the suspect words and try again.
That didn't do it. I'll alter the sql statement taking out the curly braces.
Nope. I missed a suspect word in the sql statement.