DW CS5 viewing cached MySQL data, not respecting changes made

[ImmortalArashi]

Hello,

First the specs - Dreamweaver CS5, MySQL 5.1.50, Apache 2.2.15, PHP 5.3.2, Windows 7 Ultimate 64-bit.

I'm running into an odd issue with Dreamweaver CS5 apparently relying upon a cache when connecting to a locally hosted MySQL server; this is using the built-in Dreamweaver CS5 Server Behaviors.  I've been tasked with updating a web application, this has included making numerous updates to several tables.  These changes were made using MySQL Administrator; I've ensured that these changes have been properly applied by logging into the MySQL server via command line, MySQL Administrator, and phpMyAdmin.

However, when I connect to this same MySQL database server with Dreamweaver CS5's Server Behaviors - none of the updates appear, instead I see a much older version of all the tables in question.  I've attempted uninstalling Creative Suite 5 Web Premium, afterwards deleting the Adobe folder in C:\ProgramData\, and even using the following Clean Uninstall tool from Adobe: http://www.adobe.com/support/contact/cs5clean.html.  Upon rebooting and re-installation of CS5 I am still presented with an older, apparently cached version of the MySQL tables.

I'm guessing I need to delete a cache, or cache-like, setting for Dreamweaver CS5 - how/where would I do this?  I've also noticed that Dreamweaver CS5 will not connect with newly added users, only with pre-existing users.  These issues were only noticed after the Adobe Updater installed the 11.0.3 update.  Any thoughts on what I can do at this point?  Has this issue been found elsewhere?

Thanks in advance for any suggestions.

[Lawrence_Cramer]

The Dreamweaver Cache only cares about the files themselves, not any data. To update the data view in the Database, Binding, or Server Behavior tabs just click the little blue refresh arrow on each tab. If your doing a lot of updating or development to the database it's good to get into the habit of clicking this every time you access the tab for a page.

--
Lawrence Cramer - *Adobe Community Professional*
http://www.Cartweaver.com
Shopping Cart for Adobe Dreamweaver
available in PHP, ColdFusion, and ASP

Stay updated - http://blog.cartweaver.com

[ImmortalArashi]

Hmm, I don't see a refresh arrow on the Server Behaviors tab.  I do have one on both Bindings and Databases though - however pressing each of these does nothing to update Dreamweaver's view of my MySQL database.

I only mentioned a cache problem as the possible culprit as I have done a complete uninstall + running the Clean CS5 tool several times now (at least 5 since this problem appeared last week) - each time I reinstall CS5 Web Premium I'm presented with my old list of Site definitions.  I also discovered that if I attempt to create a new MySQL connection for a newly added user to the database, Dreamweaver returns a 1045 error which I discovered was a MySQL timeout error.  This leads me to believe that Dreamweaver is no longer actually communicating with my database, but rather looking at an older snapshot version.

I would rather not have to go through the hassle of a complete system restore at this point as I'm on several deadlines.  During my last uninstall attempt I discovered a cache file here: C:\Users\<userName>\AppData\Roaming\Adobe\Dreamweaver CS5\en_US\Configuration\WinFileCache-530B2A19.dat  After uninstalling I had manually deleted this entire folder hoping that after running the Clean CS5 tool, rebooting, and once again re-installing CS5 I would at the very least wipe out Site definitions.  Unfortunately, this has not yet worked.

Any other ideas?

[bregent]

Are you using the same database login in DW as you are in the admin tool? Is it possible you have 2 different sets of tables under different user accounts? I'm not sure if MySQL allows this, but most other DBMS's do.

[ImmortalArashi]

No, it's the same user/password combo.  What I've done is modify some column names within a few tables, then add some extra tables into the same database.  I've followed the same process I have for years; the problem here is that Dreamweaver is not picking up on the fact that any changes have been made.  For example, to conform to a new naming convention columns which previously began with 'sc' now begin with 'mc' - I can see the new 'mc' naming convention when logging into the database via command line, MySQL Administrator, and phpMyAdmin.  Unfortunately, Dreamweaver is still showing the older 'sc' naming convention.

As I've mentioned, what leads me to believe that Dreamweaver is using a cached copy of the database rather than communicating to the current database is that when I add new users Dreamweaver's MySQL Connection returns a timeout error.  Yet I can log into the database using this new user/password combo via command line, MySQL Administrator, phpMyAdmin, etc.  I've even gone as far as backing up all my databases, doing  clean uninstall of MySQL, rebooting, then installing an updated version of MySQL hoping it was a problem with the database server.  Now I can see the problem was originally, and remains with Dreamweaver.

This is a fairly new problem I'm encountering here.  I've done my share of Googling and have yet to find a similar occurance.  Is there no other location Dreamweaver would be store site preferences or references to Server Behaviors that might prevent it from currently connecting to the MySQL server?

Thanks.

[charelvand]

Hi,

I have exactly the same issue. Did you find a solution yet?

Best regards

[David_Powers]

ImmortalArashi wrote:

As I've mentioned, what leads me to believe that Dreamweaver is using a cached copy of the database rather than communicating to the current database is that when I add new users Dreamweaver's MySQL Connection returns a timeout error.

As Lawrence says, Dreamweaver doesn't cache database results. It always connects to the live server and gets the data afresh. The fact that you're getting a timeout error suggests the problem lies in the testing server setup.

The way that Dreamweaver communicates with MySQL is through a couple of files in a hidden folder called _mmServerScripts, which should be in your site root. You can't normally see it in the Dreamweaver Files panel, but you should be able to see it in Windows Explorer or Mac Finder. Dreamweaver passes the login details in the site's Connections folder to these files to query the database. If it can't connect to the database, you get an error, not cached data. The fact that you're getting an error with new user accounts means that you're connecting to an old version of the database.

Start by checking the contents of the Connections folder. Make sure that the login details in the connection file are correct.

Next, select Site > Advanced > Remove Connection Scripts.

Finally, open the Site Setup dialog box for the current site, and check the settings for Testing server. If you're connecting to the testing server on a local network, Server Folder should point to the site root folder in your testing server's document root. Web URL should be the URL you would use to get to the same folder through a browser. For example, if you're testing in a subfolder of the document root, it will be something like http://localhost/mysite/. If you're using a virtual host, it will be simply http://mysite/.