caffeine_fubar
12-02-04, 10:06 PM
Dreamweaver Problem...
Setting up a connection, keep getting "An unidentified error has occurred" ... when trying to connect to MySQL database...
Many solutions, but i am running off GLOBAT.com hosting. What the hell do i do?
Is there a simple way to fix this, or do i really have to ask them to edit their php.ini??? lol
Stryder
12-02-04, 10:20 PM
It's difficult to suggest how to fix the problem.
It could be possible that you access to the database is incorrect (i.e. Username, password, domain name, port, Database name, Table name etc)
Then again you could be attempting to access it wrongly with your script, perhaps the script is the wrong permission level etc.
Some PHP variables can be fixed with a .htaccess file on Apache servers, however thats something else you would have to find out.
You are going to have to debug it on your own for now, unless you are able to get someone to give you a hand (Just make sure they are someone you can trust otherwise it would be like handing your car keys to a total stranger and expecting them to park your car for you.)
caffeine_fubar
12-03-04, 12:23 AM
Well.. globat is my Valet... its just that i dont wanna spend the time to call them and all...
Are you trying to access the remote server from your local machine? If so, have you set the local address as an access host in the mysql server?
newbie1
02-04-05, 08:33 PM
SUMMARIZING 4 TROUBLESHOOTING POINTS FOR MYSQL CONNECTION
1) In Dreamweaver, go to Sites/Manage Sites/Advanced, in “Testing Server,” be sure to configure URL prefix: http://localhost/ .... See Check the URL Prefix in the Site Definition at Macromedia.com. (Note that the URL prefix does not always need to point to http://localhost/. Right now, we are just using localhost as the troubleshooting web site. The important thing is for “URL prefix” to point to the document root address of whichever testing web site you are connecting to.)
2) Make sure that the MySql extension is activated in php.ini. Take the ; off the left side of the line in order to activate: extension=php_mysql.dll
3) Make sure that extension_dir = “c:\php\ext” is activated in php.ini, and that it points to the correct directory where php_mysql.dll is located.
For PHP5: extension_dir = “c:\php\ext”
For PHP4: extension_dir = “c:\php" Use this if you followed PHP4 installation instructions and copied all the extensions from c:\php\extensions to c:\php.
4) Make sure that PHP is working in Apache server. Does browsing to your http://localhost/phpinfo.php page display PHP graphics and data?
BLANK PAGES AND ERROR CODES IN DREAMWEAVER
The Dreamweaver Tutorial has you create PHP code on two pages: comments-view.php and comments-add.php. The problem is that after you complete the tutorial instructions, both pages display as blank pages in your Internet browser.
If you’re working on those pages in Dreamweaver, when you click on “Live Data View” you get the following error code:
The testing server did not execute any of the scripts in your document. Possible explanations include:
1) The testing server is not running.
2) The testing server ignores files with the ".php" file extension.
3) Your document does not contain any scripts.
This is caused by a parsing problem in PHP, i.e the PHP code hangs up and your Apache server gives you a blank page. The solution is to make a change in the php.ini file. Change short_open_tag = on to make it read: short_open_tag = off
Good luck. I hope this helps.
REFERENCE:
http://www.thriftyplaces.com/html/dreamweaver__mysql__php___apac.html