unidentified error - DB Connection MYSQL

[thewomb]

Hey guys, firstly i'm very sorry to post another of these "unidentified error" related posts but i have spent the past 4 days trying to resolve it and simply have hit a brick wall. I have tried and cried over this.

Apache
PHP Version 5.2.2
MySQL 5.0.41
Dreamweaver CS3 and Dreamweaver 8
OSX10.4

I have existing sites set up in DW8 which connect to MYSQL perfectly and preview the live data server fine all DB functionality and connections are smooth.

I then recently exported the sites and imported them into DWCS3, now i get an "unidentified error occurred" when trying to preview live data, connect to any database, anything to do with MYSQL basically

here's the dialogue window i get when previewing LiveData
LiveData Preview Error

when i go into the database selection menu and try to select a database i get an "unidentified error occurred" then this 404 error
Select Database Error

here's the connection dialogue setup
Database Setup Window

I can connect to MYSQL via PHP fine when i code it manually DW8 connects fine but CS3 with the exact same settings fails with this "unidentified error occurred" then a 404 error i simply can't understand why CS3 would fail when DW8 works perfectly obviously MYSQL and PHP are working fine or it would fail in DW8 also, no?.

the only thing i can think of is that there may be an issue with the DWCS3 connection scripts? stab in the dark.

[Newsgroup_User]

thewomb wrote:
> the only thing i can think of is that there may be an issue with the DWCS3
> connection scripts? stab in the dark.

The problem almost certainly lies with your Testing Server settings in
the Site definition. If you are using a local testing environment,
"Testing server folder" and "URL prefix" should both point to the same
location. "Testing server folder" should be the physical path to the
site root folder, and "URL prefix" should be the URL that you use to get
to the same place.

For example:

Testing server folder: Macintosh HD:Users:davidpowers:Sites:mysite:
URL prefix: http://localhost/~davidpowers/mysite/

If you are using a remote testing server, "Testing server folder" is
replaced by "Host directory".

--
David Powers, Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/

[thewomb]

Hey david, thanx for the info. I have tried multiple configs on this and none work.
Im sure they are mapped to the same directory.

root of the Site is.
Mackintosh HD:Library:WebServer:Documents:freelove.net.au

apache root dir is Mackintosh HD:Library:WebServer:Documents

url Prefix is http://127.0.0.1/freelove.net.au which maps to
Mackintosh HD:Library:WebServer:Documents:freelove.net.au

one other note, when i execute the MMHTTPDB.php file in the _mmServerScripts folder

i get this error "The files from the _mmServerScripts folder are for the server model PHP-MySQL. You try to connect to a database using a different server model . Please remove this folder outside the Dreamweaver environment on both local and testing machines and try again.\n"

thanx in advance

also how can it work fine in DW8 and not in DW9?

[thewomb]

David i thought it may be because the http is hosted in the lib folder so i tried it here

Macintosh HD:Users:thewomb:Sites:freelove.net.au
http://127.0.0.1/~thewomb/freelove.net.au/

no joy when i enter the url prefix as above i'm old by CS3 that
CS3 Prefix error

which is not correct they do map to the same location as you can see.

any ideas?

[Newsgroup_User]

thewomb wrote:
> no joy when i enter the url prefix as above i'm old by CS3 that
> http://thewomb.info/mysqlerrors/0000.jpg
>
> which is not correct they do map to the same location as you can see.

That error message refers to the HTTP Address field in the Local Info
category of the site definition, so you can ignore it.

--
David Powers, Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/

[Newsgroup_User]

thewomb wrote:
> also how can it work fine in DW8 and not in DW9?

I don't know. I have just created the same setup on a PowerBook running
OS X 10.4.9 and DW CS3. I used the same freelove.net.au folder, and
everything worked perfectly.

--
David Powers, Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/

[thewomb]

Hi David!. i just uninstalled Phakt 3.7.1 from DW8 and now i get this error on trying to test or establish a connection to mysql DB. im very confused indeed.

MySQL Error # 2013

Lost Connection to MySQL Server during query

[Günter_Schenk]

>>
Hi David!. i just uninstalled Phakt 3.7.1 from DW8 and now i get this error
>>

oh, your DW8 site was built with Phakt then ? You´re regretfully getting in trouble, because Phakt´s server model "PHP_ADODB" isn´t supported on Dreamweaver CS3, means a DW8 site built with Phakt isn´t compatible with DW CS3´s server model PHP MYSQL

[thewomb]

NO, no... this site is not yet built. it's just an index page nothing more.. it's a test environment to see if DWCS3 will connect to MYSQL, Answer is still a very big NO!

i understand that the ADODB is now dead. that's not the issue here.

thanx for the input and apologies for the confusion, i just mentioned Phakt because it must have been allowing a connection to MYSQL where as now DW8 no longer connects.

any news from your end David?

[Günter_Schenk]

just wondering -- what server model is currently declared for the site that has been imported to CS3 ?

as to your issue with DW 8 :: it seems you must have declared the server model PHP_ADODB there -- now that you deleted the Phakt extension, did you change it to PHP MYSQL now ?

[thewomb]

the imported site is set to PHP_MYSQL, i have removed that site now from the equasion now, it will just further complicate issues.

i am using a site that was set up in CS3 as a control, still no MYSQL connection and still no live data preview without the 404 error i am thinking tomorrow i may reinstall osx from scratch and see if it works on a fresh install.

quote:

---

as to your issue with DW 8 :: it seems you must have declared the server model PHP_ADODB there -- now that you deleted the Phakt extension, did you change it to PHP MYSQL now ?

---

yeah the model was PHP_ADODB but i tried to set up a new test site with PHP_MYSQL and it worked fine also in DW8 but once i removed Phakt it no longer worked. I'm not looking forward to the reinstall but if that's what it takes i have no other alternative.

even thought the url prefix and the testing server folder map to the same dir DWCS3 refuses to acknowledge that they do, its frustrating to say the least when i can see that its set up right but be told otherwise by the software.

thanx!

[Günter_Schenk]

>>
yeah the model was PHP_ADODB but i tried to set up a new test site with PHP_MYSQL and it worked fine also in DW8 but once i removed Phakt it no longer worked
>>

BTW, one of the things which can come in your way when switching between server models, are the connection files, because the code in there is usually somewhat "proprietary" and related to the server model they´ve been created for -- means trying to use a connection file created with PHP_ADOBE under PHP_MYSQL (and vice versa) won´t work. Is that the case, or did you create a new connection file for the PHP_MYSQL server model ?

[thewomb]

yeah created the site from scratch in CS3 so connection scripts are PHP_MYSQL

[thewomb]

ok i was under the impression that there may have been an issue with my laptop config somewhere and was ready to reinstall OSX, but before i did that i wanted to test another machine. i have OSX server her in the studio running mysql and php for months flawlessly. I installed DWCS3 on this box and tried to map the URL prefix and testing folders and still get the same error. i have been building sites for years and understand the mapping structure, i have also set up DW on many PC's with no problems using PHP. MYSQL etc.

this is killing me. please someone help.