12 Replies Latest reply: Nov 11, 2014 11:55 PM by mdemetri2

Dreamweaver CS5.5 - *** No Table Found

mdemetri2 Nov 11, 2014 2:49 AM

Ok, so I recently got upgraded to windows 7.....it may or may not be related, but from the searches I have done, I don't think it is.

So, my site is configured and connects ok, I can view both remote and local files as well as put and get as necessary.

Connection details have not changed.

When I am trying to create a recordset I get an "unidentified error has occurred" message. When I try to view tables there aren't any, and when doing an update recordset is shows no table found error.

What do I need to do to get things working again?

Thanks

1. Re: Dreamweaver CS5.5 - *** No Table Found

Ben Pleysier Nov 11, 2014 3:00 AM (in response to mdemetri2)

Try this http://www.dmxzone.com/go/16740/clearing-dreamweaver-s-cache/ first.

If that does not work, close Dreamweaver and rename the configuration folder to configuration-backup or similar.
Like Show 0 Likes (0)

Actions
2. Re: Dreamweaver CS5.5 - *** No Table Found

mdemetri2 Nov 11, 2014 3:12 AM (in response to Ben Pleysier)

Hi, thanks Ben, unfortunately clearing the cache or renaming the configuration folder has made no difference................ :-(
Like Show 0 Likes (0)

Actions
3. Re: Dreamweaver CS5.5 - *** No Table Found

Ben Pleysier Nov 11, 2014 3:24 AM (in response to mdemetri2)

I am assuming that you are running an Apache server and the your site is within the correct root folder as in www or httpdocs or similar.

If that is the case, please check to make sure that the Server Model has been properly set in the Site Setup under the Advanced tab. For example, mine is set to PHP MySQL.
Like Show 0 Likes (0)

Actions
4. Re: Dreamweaver CS5.5 - *** No Table Found

mdemetri2 Nov 11, 2014 3:28 AM (in response to Ben Pleysier)

Correct yes. Also, the Server Model is already set to PHP MySQL, this has been working in the past so not sure what the cause is.
Like Show 0 Likes (0)

Actions
5. Re: Dreamweaver CS5.5 - *** No Table Found

Ben Pleysier Nov 11, 2014 3:42 AM (in response to mdemetri2)

Does PHPMyAdmin connect to the database?

The reason I ask is because Windows 7 uses IPV6. This could be the cause of the problem.
Like Show 0 Likes (0)

Actions
6. Re: Dreamweaver CS5.5 - *** No Table Found

mdemetri2 Nov 11, 2014 3:46 AM (in response to Ben Pleysier)

I use MySQL Query Browser to connect to my database from the W7 machine, no issues doing it that way.

Should I download PHPMyAdmin and try connecting that what?
Like Show 0 Likes (0)

Actions
7. Re: Dreamweaver CS5.5 - *** No Table Found

Ben Pleysier Nov 11, 2014 3:53 AM (in response to mdemetri2)

No need to install PHPMyAdmin, the Query Browser has already confirmed that you can connect.

I am stuck and will sleep on the problem. If no one has given you the right answer, I'll revisit this in the morning, it is nearly midnight here.
Like Show 0 Likes (0)

Actions
8. Re: Dreamweaver CS5.5 - *** No Table Found

mdemetri2 Nov 11, 2014 4:50 AM (in response to Ben Pleysier)

Ok, thanks very much Ben, appreciated!
Like Show 0 Likes (0)

Actions
9. Re: Dreamweaver CS5.5 - *** No Table Found

Nancy O. Nov 11, 2014 10:35 AM (in response to mdemetri2)

Connection details have not changed.
Which version of PHP do you have on local and remote servers? Add this line to a PHP file and view it.
?php phpinfo() ?>

I only mention this because PHP 5.5, will not support old school MySql server connections.You'll need to switch to MySqli (improved) or PDO connections.

Nancy O.
Like Show 0 Likes (0)

Actions
10. Re: Dreamweaver CS5.5 - *** No Table Found

Ben Pleysier Nov 11, 2014 1:09 PM (in response to Nancy O.)

Ok, I slept on it and if Nancy's idea does not help or is not of relevance, please try turning off your firewall temporarily. If that solves the problem (or produces a different error message), adjust your firewall settings to allow Dreamweaver, the web server, and MySQL to talk to each other.

You could also try Site->Advanced->Remove Connection Scripts as in
I'll keep my fingers crossed for you. In the meantime, I feel like going back to bed for a real night's sleep.
Like Show 0 Likes (0)

Actions
11. Re: Dreamweaver CS5.5 - *** No Table Found

mdemetri2 Nov 11, 2014 11:49 PM (in response to Nancy O.)

Hi Nancy O.....doing as you suggest says we are running PHP Version 5.1.6....
Like Show 0 Likes (0)

Actions
12. Re: Dreamweaver CS5.5 - *** No Table Found

mdemetri2 Nov 11, 2014 11:55 PM (in response to Ben Pleysier)

Hi Ben, wow really appreciate your persistence on this. When I clicked Remove Connection Scripts, I got Failed to remove connection scripts.

Now, today I am working from home - so work laptop and my broadband.........guess what, I can connect to the site and when I create a recordset etc I get to see the tables!

This suggests that there has been a change at my work place which is for whatever reason blocking the MySQL connection through Dreamweaver,....... the only thing that I can think of recently was a proxy change....in Dreamweaver do you know where I can specify any addition connection settings? Clutching at straws somewhat, but at least from home I know I am able to connect OK .

Many many thanks for your input - I owe you a beer for the effort :-)
Like Show 0 Likes (0)

Actions