An Unidentified Error Has Occurred with PHP/MySQL/Dreamweaver MX
Written by Rob on September 10, 2004 – 11:03 am -This particular error has taken up most of the last day and a half of work for me. Was frustrating as all get out, as I tried just about everything under the sun to no avail. But I think it is finally fixed, and want to document it here, both for myself and anyone who may find this page through Google.
Setting up a new Apache 2.0.50 server with PHP 5.0.1 and MySQL 4.0.20 support on Windows Server 2003. After setup, cannot create a PHP/MySQL test connection for a web page in Dreamweaver MX 6.1. Dreamweaver was installed on the same machine as Apache/MySQL/PHP. Clicking the “Test” button brings up the error “An Unidentified Error has occurred”.
What finally fixed it for me was turning on logging to a file in my php.ini and inspecting that log file manually after each page request. One error came up “Undefined Variable HTTP_SERVER_VARS”. This web page on Chris Karakas Online describes how to fix that error by turning on register_long_arrays in php.ini.
register_long_arrays = on
by default it is set to off. Once that was changed, you can restart the apache services and retry the connection. For the first time in two days, I got a very welcome “Connection was made successfully” message.
Posted in Uncategorized |
October 20th, 2004 at 1:37 pm
dear Rob,
I’ve the very same experience as you, it took me days frustrating etc.
I’m using macosx and installed everything (mysql and php) in the right order.
After consulting macromedia by telephone today, they are still figuring out, and visiting many other forums, etc I find this page with a clear explanation to solve the problem.
My next step is to get the permissions to edt the php.ini file.
I’m not there but close,
thank you
greetings from rotterdam holland
gerard helder
November 11th, 2004 at 6:11 pm
I had the same issue but running on XP Pro with IIS. I searched all of Macromedia’s site and found nothing that helped. Then I turned to Yahoo! and found your site. I blew 6 hours screwing around with this simple issue that Macromedia should have documented. I just wanted to say thank you for taking the time to document it.
Bob
December 14th, 2004 at 1:03 pm
Hello,
I have the same error but I?m using PHP 5.0.2 & MySQL 4.1.x. I?ve found in others forums that Dreamweaver MX use the OLD password system and version 4.1.x use a new hashing method. I?m reading the MySQL notes to fix that problem. Nothing yet..
Any suggestion, please, send me an email to raciel@mzo.grm.desoft.cu
April 5th, 2005 at 8:00 pm
Thanks for the page. Getting the same error. Unfortunately, I don’t have PHP 5 installed, the “register_long_arrays” wasn’t implemented in v4.
Argh.
January 5th, 2006 at 2:29 pm
Oh my god! Thank you!!
March 22nd, 2006 at 1:18 pm
Macromedia should pay you for doing all of their engineers’ job. Send them a bill for $10,000! You probably saved them thousands of man-hours, and $$$s, with this. They must reward you!
May 3rd, 2006 at 10:33 am
i installed php triad and had same problem.
with php 4.x your fix doesn’t work.
then i download php 4.3.2 ,deleted folder c:\apache\php then installed php for apache in folder c:\apache\php.
it works now
May 3rd, 2006 at 10:34 am
oops , it was php 4.4.2 that fixed the problem.
May 30th, 2006 at 11:58 am
Save me sleepless nights. I will pass on this valuable information.
You should start a school for macromedia programers to visit.
June 7th, 2007 at 10:50 am
Just to echo the thanks for taking the time to document this issue…
Many hours saved!
February 4th, 2008 at 11:48 am
Thank you Rob !!
I spend hours on this problem !!
March 5th, 2008 at 3:20 pm
Great, sweet Jebus!
Years, brother, years.
More than one trip to the Macromedia site, and their “explanations”.
I’ve close to the same set-up as you, and all it took was “register_long_arrays = on”.
It worked the very first time.
Thank you more than I can say.
If I had money, I’d throw it at you.
Kit
March 7th, 2008 at 9:57 am
You have just ended a week of craziness.
March 7th, 2008 at 12:26 pm
You’re all very welcome! Glad this helped, I sure remember the headaches it caused me.
March 11th, 2008 at 9:31 pm
Most commonly the issue is that you have specified the HTTP Address and URL Prefix incorrectly in Dreamweaver. ONLY specify the root folder path, not the entire site address. Should be Example: http://localhost/mysite
NOT: http://localhost/mysite/index.php