close ad
WARNING: Do Not Install the DREAMWEAVER CC 2017 or 2018 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

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

Thread began 2/08/2016 7:12 am by Mark | Last modified 2/10/2016 2:41 pm by Ray Borduin | 1181 views | 19 replies |

Mark

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.

Sign in to reply to this post

Ray BorduinWebAssist

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.

Sign in to reply to this post

Mark

Site STE File Attached

The STE file has been attached.

Sign in to reply to this post

Ray BorduinWebAssist

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

Sign in to reply to this post

Mark

New STE Attached

New STE attached

Sign in to reply to this post

Mark

More Info

More info included in private message

Sign in to reply to this post

Ray BorduinWebAssist

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.

Sign in to reply to this post

Mark

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>

Sign in to reply to this post

Mark

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

Sign in to reply to this post

Mark

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

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...