Unspecified Error when creating connection

Hello!

New customer here.

Just now installed MySQLi Server Behaviors and am trying to use it to create a connection.
I have been following the online step-by-step on your website. But, not getting very far...

I have tried several variations of server name, including the port... not including the port, even trying localhost and he full domain name.

The user name and password are no problem I know those are correct.


When I put the database name in and click TEST... I always get "An Unidentified Error has Occurred". I don't know where to go from here. I can connect from manually coded MySQLi and PDO connection. So, that too is not the issue.

Mac OS 10.12.6 using Dreamweaver CS6

Please assist

This is an issue with the Dreamweaver Site Definition, specifically the Testing Server settings, and most likely the Website URL value you have entered. I'd have to see your testing server settings in Dreamweaver to debug, but you can look there and may be able to spot the problem yourself.

This issue seems to have been resolved.
It seems that hacks like me, are no longer going to get away without setting up an actual testing server anymore. Never used one from CS3-->CS6 despite the nag screens.
Per Ray's advice, I set up a testing server using one of my unused/email-only domains. Once the first sync was complete, it lit up and now the learning begins.
there is a niggling issue with field focus on the WASB forms. You have to click back and forth a couple of times between fields to get them to accept keyboard input. Hopefully, this will get fixed soon.

You can just define the live remote server as the testing server. It doesn't actually have to be a testing server, you just have to tell Dreamweaver to use your live server as the testing server and that will work too. You can literally use the duplicate button to duplicate your remote server settings and use it as your testing server.

Good to know. Thanks

Hey Ray, I'm having the exact same thing happen. I remember it from a couple years back and it's all coming back to haunt me again.

Just like Orian, my DW (High Sierra/CS6) connects fine to server and separate PHP/mysql connection works. But I'm trying to update one section of a site to mysqli and the Database connection just can't be made because of that "unidentified error".

I know it's often some strange thing in the site definition but I wonder if you can see what it is cause I just can't see it even after a couple days trying various things.

This is usually a server redirect causing the site URL from your testing server in dreamweaver to not properly reflect the final URL.

So if you have your URL in your Dreamweaver testing server set to http://www.yoursite.com and if you put that in the browser it goes to https://yoursite.com then it wouldn't work because of the redirect. Try to copy/paste the url in your Dreamweaver testing server into a browser and then copy/paste it back to your Dreamweaver site definition to make sure that it is set to the final destination url. That will usually do the trick.

Hey Ray.. thanks for getting back to me. This is a strange issue because you're correct, when the site is entered in a browser, it DOES go to https:// version.

How can I work around this is that's the case? How can I keep it all consistent (SSL) using the Webassist MYSQLI package?

Just update the testing server settings in Dreamweaver to specify the https:// location and it should work.

If you mean putting https in the last field of the site setup (Web URL), then I had done that and no luck.