HTTP Error Code 500 Internal Server Error when trying to create Dynamic MySQLi connection

When I try to create a Dynamic MySQLi connection from Dreamweaver CS 5.5 to a remote MySQL database, the following error appears when I click the Select button in the Primary Connection tab...

HTTP Error Code 500 Internal Server Error

My website is setup to force https and the non www. version is used. This is reflected in Site Setup with the Web URL option being set to https://domainname.com. However, I have tried all combinations http/https/www./non www, along with turning off forcing https and non www.. No change works and all report error 500.

I was able to connect to the database without problem when using Dreamweaver's built in MySQL connector BEFORE I installed the Dynamic MySQLi extension. Now I can't even do that with it too throwing a 500 error. I CAN connect to the database remotely using Navicat though - using the same settings I have tried in Dreamweaver.

I have deleted the _mmServer Scripts folder, exited and re-launched Dreamweaver, recreated the cache. Nothing resolves the problem.

Hope someone can help please as I need to get this up and running.

If I can't get this working can someone send me the PHP code the extension creates for a login, checking a user name exists (for sign-up), a query, an insert, an update and a delete please. Just need get this working no matter the process.

This sounds like an issue with your site definition of some sort. Please export your site definition in Dreamweaver and attach it to a reply to this post. (make sure to mark it as private in the attachments window). I'll debug your attachment and let you know what is going on.

The STE file has been attached.

I'll need a site export including usernames and passwords in order to debug.

New STE attached

More info included in private message

It appears to have something to do with your server settings. I've tried to recreate what Dreamweaver does with the page: test.php and it can't submit to the page Dreamweaver uses to return database information.

How are you doing the https:// redirect? I don't see a .htaccess file which is how it is usually done. I have a feeling that is somehow connected to this problem.

Hi,

The https redirect is performed in the web.config file in the root of the website. I'm on a Windows server. Here's the code that does it...

<system.webServer>
<rewrite>
<rules>
<clear />
<rule name="Redirect to https" stopProcessing="true">
<match url="(.*)" />
<conditions>
<add input="{HTTPS}" pattern="off" ignoreCase="true" />
</conditions>
<action type="Redirect" url="https://{HTTP_HOST}{REQUEST_URI}" redirectType="Permanent" appendQueryString="false" />
</rule>
</rules>
</rewrite>
</system.webServer>

Incidently, I did remove this code from the web.config file during my tests but it didn't make any difference.

I'm happy to stop forcing https if it will get this working!