close ad
 
Important WebAssist Announcement
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

"An unidentified error has occurred" when attempting to connect db using Dynamic MySqli

Thread began 4/06/2024 12:50 pm by Michael | Last modified 4/11/2024 11:52 am by Patrice | 130 views | 10 replies |

Michael

"An unidentified error has occurred" when attempting to connect db using Dynamic MySqli

Dear Community, first of all, sincere condolances regarding Ray's passing...

I'm using this forum as a last resort having searched Google thoroughly and undertaken numerous tests and trials. I've tried this on two different laptops with two separate Dreamweaver & WebAssist installations but keep encountering the same issue. Previously, everything had been working well, with no changes to any settings. It started by not seeing any tables under my mysqli connection via WebAssist/Recordset, then under Database/Database Connections, WA Database panel for my sqli connection it shows "No Tables Found. Please check your connection and testing server settings." Simple enough, I thought, I tested my DW Site Settings (Main & Test Server) and all connected straight away, then I tested my Default Database Connection in the Dynamic MySqli Connection panel and each and every time all I see after clicking the test button is a DW Warning "An unidentified error has occurred". I've checked, double checked and triple checked my DB name, username, password and tried a few variants of MySQL server, IP addresses, 'localhost' etc etc, and I cannot get any further. As mentioned previously, the same is happening on two separate laptops each with their own Dreamweaver & WebAssist installations. I have uninstalled and reinstalled WebAssist ensuring the latest files are uploaded, again without success. Is this happening to any other users and is it just a case that WebAssist is slowly becoming obselete and it's time to move over to Wappler and ditch DW altogether? I've attached screenshots (if they can be seen!). Kindest Regards in advance, Mike.

Sign in to reply to this post

Mags

Do you have a .htaccess file in your site folder? If so, rename it with a .txt extension so that Dreamweaver doesn't treat it as a .htaccess file. I've found that if my connection can't see any tables in the database, that's usually why. Also are you connecting to a local or remote database? I see you have 127.0.0.1 in the connection info which is a local IP, so maybe if you change the server to localhost it might connect, or if it's a remote database then ensure you're using the remote IP.

Sign in to reply to this post

Michael

Hi Mags, thanks for taking the time to reply and help out! I have tried what you suggested, changed htaccess to a txt file, changed the connection info using localhost and my remote IP, however the same problem persists. Warmest Regards, Mike.

Sign in to reply to this post

PatriceWebAssist

Do the "rename" config file trick. That has worked for me in the past with this.
Here's a link with how to reinstall WA after you rename config file. Takes a bit to get it done but it should take care of the floaters.

https://www.projectseven.com/products/ex-man/info.htm#cc-issue

related thread
http://www.webassist.com/forums/posts.php?id=46924

Sign in to reply to this post

Michael

Thank you, Patrice, I really appreciate you taking time out to assist me, unfortunately after very carefully following your guidance, the same error is still occurring :( I'm still at a bit of a loss sadly.
Kindest Regards, Mike.

Sign in to reply to this post

PatriceWebAssist

Sorry to hear. The only other thing I can think of is to put your title in the search area. There are so many same named-questions here, perhaps you can find a solution. It is a reoccurring issue, evidently.

We are all struggling.

Sign in to reply to this post

Michael

Thanks Patrice, I've been continuing in my attempts to connect together with my host server, some pretty in depth tests! Still not having it. I was trying to locate any Dynamic MySqli error logs, looking through the site files and the local windows app data/roaming files but cannot find anything, would you know if, and where, any such WA error logs may be hiiding? Mike.

Sign in to reply to this post

PatriceWebAssist

When I am trying to solve php issues, I add this to the very top of a php page:

<?php
error_reporting(E_ALL);
ini_set('display_errors','on');
?>

It helps pin down what is causing a problem, although I am not sure if that will help you in this instance. But take care to remove it after problem solved.

Sign in to reply to this post

Michael

Thanks Patrice, I've actually been checking my PHP error logs via cPanel. I have made some progress, and it appears Cloudflare could be the issue, both Cloudflare linked sites display the unidentified error message, however I can connect WebAssist MySQLi successfully to a third domain which is not linked to Cloudflare, although all the forums on Cloudflare state it cannot be a Cloudflare issue (something to do with proxied DNS) - It appears too coincidental. I am awaiting one of the two domains to propogate back to the origin server before further testing, just pausing Cloudflare didn't appear to have any affect.

Sign in to reply to this post

Michael

OK, so in case anyone stumbles upon this thread with similar issues, I didn't necessarily find a solution, but I did successfully find the cause and a workaround!

In the DNS/Records section of Cloudflare, when the CNAME www record is set to proxied it prevented WebAssist MySQLi from connecting via the Dynamic MySQLi Connection wizard on Dreamweaver. By changing this setting to DNS only, after a few minutes and restarting DW, it connected fine! It is advisable to keep the setting to Proxied for the Caching/ CDN performance benefits of CF, but it's easy enough to toggle this setting from Proxied to DNS only when needed for WebAssist during development stages.

Alternatively, simply activate Development Mode in CF! Note: Pausing Cloudflare doesn't work.

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...