PHP MySQL Error Code 500

Fastest way to fix this error is to remove the connection scripts:

_mmServerScripts

     MMHTTPDB.php

     mysql.php

In the pulldown on the site files tab, under "Sites" is "Remove Connection Scripts" at the bottom. Do that and try to connect again. DW will generate new ones and that usually does the trick.

Hello,

I have also had the same error - namely that whilst I could connect via ftp, upload/download files, and view database tables, any attempt to view of modify recordsets resulted in error 500.

Having checked other potential causes (e.g. selection/non-selection use of passive FTP setting, enabling of php, etc.), on the back of posts here I contacted my host and asked if if could relate to mod security, as further investigation revealed that the issue only occurred on sites where mod security had not been disabled (I don't like to disable mod security for obvious reasons - and I'm told you can't do that site by site with apache2 anyway).

After a few false starts, the problem was resolved - with the following response from my host: "The false positives were being generated by "/_mmServerScripts/MMHTTPDB.php" and that is what we've worked around in the rules. As such, any domain on [servername] using that script in the same way shouldn't generate a false-positive moving forward."

So it seems the answer (assuming your on an apache server of course) may be to modify the rules to allow full access for MMHTTPDB.php.

I hope that is of help to some.