Dreamweaver CS3 - Doesn't display MySQL tables

Hi folks

Research has indicated that there was a Dreamweaver bug (and update fix) in
version 8 whereby the listing of MySQL tables was empty if the database name
contained a non alphnumeric character.

I seem to be faced with this problem in CS3 (v9).

Can someone confirm or deny that this bug exists in this version ?

Can someone provide a solution ?

Thanks in anticipation.

--
Ronnie MacGregor
Scotland

Ronnie at
dBASEdeveloper
dot co dot uk

www.dBASEdeveloper.co.uk

On Sun, 22 Jun 2008 12:01:39 +0100
Ronnie MacGregor said :

Research has indicated that there was a Dreamweaver bug (and update fix) in
version 8 whereby the listing of MySQL tables was empty if the database name
contained a non alphnumeric character.

I seem to be faced with this problem in CS3 (v9).

Can someone confirm or deny that this bug exists in this version ?

The answer is that this bug does not exist in CS3 (v9).

The illusion of this bug is created when you don't have the database name
correct in the "Testing Server" parameters! .... And I would of course like to
blame my ISP for adding a prefix to the database name I used on creation and
generating the confusion in the first place !!! <g>

--
Ronnie MacGregor
Scotland

Ronnie at
dBASEdeveloper
dot co dot uk

www.dBASEdeveloper.co.uk

OK, we accept that blame. You're exonerated. 8)

--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
==================


"Ronnie MacGregor" <NoSp@m.thanks> wrote

On Sun, 22 Jun 2008 12:01:39 +0100
Ronnie MacGregor said :

Research has indicated that there was a Dreamweaver bug (and update fix)
in
version 8 whereby the listing of MySQL tables was empty if the database
name
contained a non alphnumeric character.

I seem to be faced with this problem in CS3 (v9).

Can someone confirm or deny that this bug exists in this version ?

The answer is that this bug does not exist in CS3 (v9).

The illusion of this bug is created when you don't have the database name
correct in the "Testing Server" parameters! .... And I would of course
like to
blame my ISP for adding a prefix to the database name I used on creation
and
generating the confusion in the first place !!! <g

--
Ronnie MacGregor
Scotland

Ronnie at
dBASEdeveloper
dot co dot uk

www.dBASEdeveloper.co.uk

On Sun, 22 Jun 2008 17:45:19 -0400
Murray *ACE* said :

OK, we accept that blame. You're exonerated. 8)

Its good to have someone to blame <g>.

I've documented what I've discovered in the course of doing this. Since you
seem to have a rather large presence here <g>, maybe you could cast your expert
eye over the result and let me know if there are any glaring errors/ommissions.

Cheers.

http://www.dbasedeveloper.co.uk/DWtoMySQL/DWtoMySQL.htm

--
Ronnie MacGregor
Scotland

Ronnie at
dBASEdeveloper
dot co dot uk

www.dBASEdeveloper.co.uk

Ewww - frames! 8)

* I would fill in the default images folder
* I would just put 'http://www.example.com' in the HTTP address field. Or
even leave it blank. (I would always use 'example.com' since that's exactly
the purpose it was created for)
* the FTP host may not be 'ftp.xxxx.xxx', it might also be 'www.xxxx.xxx',
depending on the host
* the FTP login is not always 'MySiteName.com' - it might be 'monkeybutt',
too. This would depend on the host.
* I never use the FTP connection option for my Testing server. My testing
server is a local *nix box. But, given the constraints mentioned above,
your information looks accurate.
* you cast the blame on DW for appending the /public_html/ folder to the URL
prefix, when actually that is your problem. That folder should not be
included in the HTTP address field at all, which is a field that you fill
out.

The rest seems OK. And with these modifications, you have a workable
tutorial....

--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
==================


"Ronnie MacGregor" <NoSp@m.thanks> wrote

On Sun, 22 Jun 2008 17:45:19 -0400
Murray *ACE* said :

OK, we accept that blame. You're exonerated. 8)

Its good to have someone to blame <g>.

I've documented what I've discovered in the course of doing this. Since
you
seem to have a rather large presence here <g>, maybe you could cast your
expert
eye over the result and let me know if there are any glaring
errors/ommissions.

Cheers.

http://www.dbasedeveloper.co.uk/DWtoMySQL/DWtoMySQL.htm

--
Ronnie MacGregor
Scotland

Ronnie at
dBASEdeveloper
dot co dot uk

www.dBASEdeveloper.co.uk

On Mon, 23 Jun 2008 09:34:17 -0400
Murray *ACE* said :

Ewww - frames! 8)

<LOL>

C'mon .... that site design is long long outdated, and even at the time was
thrown together very quickly.

Go criticise www.AlpsChalets.com <g>

.......(that invitation might prove to be a mistake! <g>)

* I would fill in the default images folder

OK ... personally I don't use a default but .... done!

* I would just put 'http://www.example.com' in the HTTP address field. Or
even leave it blank. (I would always use 'example.com' since that's exactly
the purpose it was created for)

Hmmm.... personal preference .... Yes it is an example but the word example
gives to the novice no indication of what should be substituted. .... not done
<g>

* the FTP host may not be 'ftp.xxxx.xxx', it might also be 'www.xxxx.xxx',
depending on the host
* the FTP login is not always 'MySiteName.com' - it might be 'monkeybutt',
too. This would depend on the host.

Point taken. This document is destined to be used by a major "Reseller's ISP"
here in the UK, and so was designed to match their setup. I have added wording
to draw attention to these points.

* I never use the FTP connection option for my Testing server. My testing
server is a local *nix box.

Probably the wise thing to do, .... but not the purpose of this document.

But, given the constraints mentioned above,
your information looks accurate.

Thanks, that is reassuring.

* you cast the blame on DW for appending the /public_html/ folder to the URL
prefix, when actually that is your problem. That folder should not be
included in the HTTP address field at all, which is a field that you fill
out.

Ooops.... that was a mixture of a typo and then a consequent mistake in trying
to establish where Dreamweaver was getting its info from. Now corrected.

I still blame Dreamweaver for this append, and there is a further bug in this
default value where the FTP login starts "ftp" and not "www". If you are in a
position to feed things back up the line, I would consider this as the one
single issue which would prevent DW users making a connection of this type. See
amended document for details.

http://www.dbasedeveloper.co.uk/DWtoMySQL/DWtoMySQL.htm

The rest seems OK. And with these modifications, you have a workable
tutorial....

Thanks for the feedback.

--
Ronnie MacGregor
Scotland

Ronnie at
dBASEdeveloper
dot co dot uk

www.dBASEdeveloper.co.uk

Hmmm.... personal preference .... Yes it is an example but the word
example
gives to the novice no indication of what should be substituted. .... not
done
g

Not really. www.example.com was created expressly for this purpose. It
belongs to nobody, and there is no site there. Anything else you might use
could well already be in use.


--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
==================


"Ronnie MacGregor" <NoSp@m.thanks> wrote

On Mon, 23 Jun 2008 09:34:17 -0400
Murray *ACE* said :

Ewww - frames! 8)

LOL

C'mon .... that site design is long long outdated, and even at the time
was
thrown together very quickly.

Go criticise www.AlpsChalets.com <g

......(that invitation might prove to be a mistake! <g>)


* I would fill in the default images folder

OK ... personally I don't use a default but .... done!


* I would just put 'http://www.example.com' in the HTTP address field.
Or
even leave it blank. (I would always use 'example.com' since that's
exactly
the purpose it was created for)

Hmmm.... personal preference .... Yes it is an example but the word
example
gives to the novice no indication of what should be substituted. .... not
done
g


* the FTP host may not be 'ftp.xxxx.xxx', it might also be
'www.xxxx.xxx',
depending on the host
* the FTP login is not always 'MySiteName.com' - it might be
'monkeybutt',
too. This would depend on the host.

Point taken. This document is destined to be used by a major "Reseller's
ISP"
here in the UK, and so was designed to match their setup. I have added
wording
to draw attention to these points.


* I never use the FTP connection option for my Testing server. My
testing
server is a local *nix box.

Probably the wise thing to do, .... but not the purpose of this document.


But, given the constraints mentioned above,
your information looks accurate.

Thanks, that is reassuring.


* you cast the blame on DW for appending the /public_html/ folder to the
URL
prefix, when actually that is your problem. That folder should not be
included in the HTTP address field at all, which is a field that you fill
out.

Ooops.... that was a mixture of a typo and then a consequent mistake in
trying
to establish where Dreamweaver was getting its info from. Now corrected.

I still blame Dreamweaver for this append, and there is a further bug in
this
default value where the FTP login starts "ftp" and not "www". If you are
in a
position to feed things back up the line, I would consider this as the one
single issue which would prevent DW users making a connection of this
type. See
amended document for details.

http://www.dbasedeveloper.co.uk/DWtoMySQL/DWtoMySQL.htm


The rest seems OK. And with these modifications, you have a workable
tutorial....

Thanks for the feedback.

--
Ronnie MacGregor
Scotland

Ronnie at
dBASEdeveloper
dot co dot uk

www.dBASEdeveloper.co.uk

Oops - premature post.

I still blame Dreamweaver for this append, and there is a further bug in
this
default value where the FTP login starts "ftp" and not "www". If you are
in a

Sorry - don't know what you are saying here.

--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
==================


"Ronnie MacGregor" <NoSp@m.thanks> wrote

On Mon, 23 Jun 2008 09:34:17 -0400
Murray *ACE* said :

Ewww - frames! 8)

LOL

C'mon .... that site design is long long outdated, and even at the time
was
thrown together very quickly.

Go criticise www.AlpsChalets.com <g

......(that invitation might prove to be a mistake! <g>)


* I would fill in the default images folder

OK ... personally I don't use a default but .... done!


* I would just put 'http://www.example.com' in the HTTP address field.
Or
even leave it blank. (I would always use 'example.com' since that's
exactly
the purpose it was created for)

Hmmm.... personal preference .... Yes it is an example but the word
example
gives to the novice no indication of what should be substituted. .... not
done
g


* the FTP host may not be 'ftp.xxxx.xxx', it might also be
'www.xxxx.xxx',
depending on the host
* the FTP login is not always 'MySiteName.com' - it might be
'monkeybutt',
too. This would depend on the host.

Point taken. This document is destined to be used by a major "Reseller's
ISP"
here in the UK, and so was designed to match their setup. I have added
wording
to draw attention to these points.


* I never use the FTP connection option for my Testing server. My
testing
server is a local *nix box.

Probably the wise thing to do, .... but not the purpose of this document.


But, given the constraints mentioned above,
your information looks accurate.

Thanks, that is reassuring.


* you cast the blame on DW for appending the /public_html/ folder to the
URL
prefix, when actually that is your problem. That folder should not be
included in the HTTP address field at all, which is a field that you fill
out.

Ooops.... that was a mixture of a typo and then a consequent mistake in
trying
to establish where Dreamweaver was getting its info from. Now corrected.

I still blame Dreamweaver for this append, and there is a further bug in
this
default value where the FTP login starts "ftp" and not "www". If you are
in a
position to feed things back up the line, I would consider this as the one
single issue which would prevent DW users making a connection of this
type. See
amended document for details.

http://www.dbasedeveloper.co.uk/DWtoMySQL/DWtoMySQL.htm


The rest seems OK. And with these modifications, you have a workable
tutorial....

Thanks for the feedback.

--
Ronnie MacGregor
Scotland

Ronnie at
dBASEdeveloper
dot co dot uk

www.dBASEdeveloper.co.uk

On 23 Jun 2008 in macromedia.dreamweaver, Murray *ACE* wrote:

www.example.com was created expressly for this purpose.

True. See item 3 at:

http://www.rfc-editor.org/rfc/rfc2606.txt

It belongs to nobody, and there is no site there.

Not true. Try plugging http://example.com/ into your browser...

Belongs to:

[joe@linuxserver3 ~]$ whois example.com
[Querying whois.internic.net]
[Redirected to whois.iana.org]
[Querying whois.iana.org]
[whois.iana.org]

IANA Whois Service
Domain: example.com
Name: IANA_RESERVED

Registrant:
Name: Internet Assigned Numbers Authority (IANA)
Organization: Internet Assigned Numbers Authority (IANA)
Address1: 4676 Admiralty Way, Suite 330
Address2:
Address3:
City: Marina del Rey
State/Province: CA
Country: US
Postal Code: 90292
Phone: 310-823-9358
Fax: 310-823-8649
Email: res-dom (AT) iana (DOT) org
Registration Date: 11/01/2001
Last Updated Date: 11/01/2001

Administrative Contact:
Name: Internet Assigned Numbers Authority (IANA)
Organization: Internet Assigned Numbers Authority (IANA)
Address1: 4676 Admiralty Way, Suite 330
Address2:
Address3:
City: Marina del Rey
State/Province: CA
Country: US
Postal Code: 90292
Phone: 310-823-9358
Fax: 310-823-8649
Email: res-dom (AT) iana (DOT) org
Registration Date: 11/01/2001
Last Updated Date: 11/01/2001

Technical Contact:
Name: Internet Assigned Numbers Authority (IANA)
Organization: Internet Assigned Numbers Authority (IANA)
Address1: 4676 Admiralty Way, Suite 330
Address2:
Address3:
City: Marina del Rey
State/Province: CA
Country: US
Postal Code: 90292
Phone: 310-823-9358
Fax: 310-823-8649
Email: res-dom (AT) iana (DOT) org
Registration Date: 11/01/2001
Last Updated Date: 11/01/2001

Nameserver Information:
Nameserver: a.iana-servers.net.
IP Address: 192.0.34.43
Nameserver: b.iana-servers.net.
IP Address: 193.0.0.236
Nameserver: c.iana-servers.net.
IP Address: 139.91.1.10

Located at:

[joe@linuxserver3 ~]$ dig example.com

; <<>> DiG 9.3.1 <<>> example.com
;; global options: printcmd
;; Got answer:
;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 14029
;; flags: qr rd ra; QUERY: 1, ANSWER: 1, AUTHORITY: 2, ADDITIONAL: 2

;; QUESTION SECTION:
;example.com. IN A

;; ANSWER SECTION:
example.com. 172800 IN A 208.77.188.166

;; AUTHORITY SECTION:
example.com. 172703 IN NS a.iana-servers.net.
example.com. 172703 IN NS b.iana-servers.net.

;; ADDITIONAL SECTION:
a.iana-servers.net. 50089 IN A 192.0.34.43
b.iana-servers.net. 172703 IN A 193.0.0.236

;; Query time: 155 msec
;; SERVER: 127.0.0.1#53(127.0.0.1)
;; WHEN: Mon Jun 23 17:17:18 2008
;; MSG SIZE rcvd: 125

--
Joe Makowiec
http://makowiec.net/
Email: http://makowiec.net/contact.php

On Mon, 23 Jun 2008 12:32:09 -0400
Murray *ACE* said :

I still blame Dreamweaver for this append, and there is a further bug in
this
default value where the FTP login starts "ftp" and not "www". If you are
in a

Sorry - don't know what you are saying here.

What I am saying is that I think there are a couple of bugs in the way
Dreamweaver comes up with the default value for the URL Prefix. I believe that
these bugs will prevent the avarage user making a database connection.

The worst thing about a non-working default value, is that the novice user will
assume that Dreamweaver knows better than they do in terms of what should be
entered in this field. A blank field would actually be better in this case,
forcing the user to figure it out without being misled.

Try it for yourself .....

Define a new site on your development machine.

Set up the "Local info" section and the "Remote info" section along the lines
defined in the first two screengrabs shown here :

http://www.dbasedeveloper.co.uk/DWtoMySQL/DWtoMySQL.htm

Now move on to the "Testing Server" section,
Select "PHP MySQL"
Select "FTP"

Now what do you see in the "URL prefix" field ?

Hopefully you see the same as I do ... shown in the fourth (small) screengrab.


Two problems with this default string?

Would you agree that this will never connect?

Bug?

--
Ronnie MacGregor
Scotland

Ronnie at
dBASEdeveloper
dot co dot uk

www.dBASEdeveloper.co.uk