500 Internal Server Error

One site in particular is suddenly throwing me this when I try to create a new recordset. It's never done this before and I can't find a cause. Help! Any other site is just fine with these behaviors!

I deleted the DW scripts directory on the host server and that seems to have fixed the initial problem in creating a recordset. Now I see the recordset, but it won't retrieve any table data (column names) or anything that. I get the 500 error IN the Bindings panel. Image attached...

This is usually a problem with the server or the site settings pointing to the server. Are you able to get to the web site using the url defined in the testing server settings in dreamweaver? It uses the testing server url to get the database information.

Yes, I can FTP files to/from the server, and I can get to the database using Navicat. Also, the pages all pull database details on the live server just fine. I built these recordsets before yesterday using your mySQLi behaviors, and it's always been fine. I haven't changed anything on the DW configuration at all - the 500 error just started happening. I can't open previously built recordsets (that still pull data fine on the live site), nor can I create new ones - but ONLY on this one site. All of my other sites I built using this behavior extension work fine. I can't see any issues with the configuration itself. I'm totally flummoxed!

If you attache an export of your site definition (with passwords) I can import it and see what is wrong.

PM

What is the page you are working on?

I was able to reproduce the issue using your connection. I've updated MySQLi server behaviors to correct this issue. Please reinstall the latest version and then clear your connection scripts to get the updated files. Let me know if you still have issues after that.

Not sure what you did, but that seemed to fix it!