DB Coonection - unidentified error after upgrading from php 4 to 5.0.3

Report · Nov 22, 2006

I am beginning to hate this!!!!!

I have had a sucessful connection with php 4.3.1 but it didn't support sessions so our IT guru has upgraded to php 5.0.3

When going back into the database connection, there were no tables so I checked the DB connection and I keep getting "unidentified error" when looking for a database.

is this a recognised compatibility issue or is it more likely to be a permissions problem?

We are running on apache 2.0.53 and MySQL 4.1.10a

Report · Nov 22, 2006

RichardOMarketing wrote:
> I have had a sucessful connection with php 4 but it didn't support sessions so
> our IT guru has upgraded to php 5.0.3

Strange decision to upgrade to a version that's two years old, but I
suppose that may be because of dependencies on an old version of Linux.
Did your IT guru enable MySQL when compiling PHP 5? It's not enabled by
default.

If you're running MySQL 4.1 or higher, did he also enable MySQLi? The
authentication protocol in MySQL 4.1 changed, and requires MySQLi to be
enabled as well. MySQL 4.1 and higher also requires mbstring to be
enabled in PHP.

> When going back into the database connection, there were no tables so I
> checked the DB connection and I keep getting "unidentified error" when looking
> for a database.
>
> is this a recognised compatibility issue or is it more likely to be a
> permissions problem?

The code generated by Dreamweaver is fine, but your server needs to be
configured correctly to process it.

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

Report · Nov 22, 2006

Thanks David

Temporarily, without an earlier answer, we have downgraded back to php 4.1.10a!!!!

I understand from another source that php 5.0.3 is not compatible with a MySQL version anything less than 4.1.3, which would explain a lot.

I have spoken to our IT guru who says that everything was enabled, including the MySQLi.

Trying to get us upgraded to a MySQL version higher than 4.1.3 is the next step and that is dependant on the Linux version we currently run on. - I guess thats severly out of date too!

Report · Nov 22, 2006

RichardOMarketing wrote:
> I understand from another source that php 5.0.3 is not compatible with a MySQL
> version anything less than 4.1.3, which would explain a lot.

I doubt it. My remote server is running PHP 5.0.0 and MySQL 4.0.22.

> Trying to get us upgraded to a MySQL version higher than 4.1.3 is the next
> step - I guess thats severly out of date too!

Installing MySQL 4.1.3 would be highly inadvisable, as it was a beta
version. The first production version of the 4.1 series was 4.1.7,
released in October 2004. The current MySQL series is 5.0, which was
first released in October 2005.

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

Report · Nov 22, 2006

quote:

Originally posted by: Newsgroup User

I doubt it. My remote server is running PHP 5.0.0 and MySQL 4.0.22.

http://foundationphp.com/

Ah - I guess our IT chap needs to do some more thinking!! - thanks David

Report · Nov 22, 2006

RichardOMarketing wrote:
> Ah - I guess our IT chap needs to do some more thinking!! - thanks David

Oh dear. I see your IT guru has been downgraded to an IT chap. ;)

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

Report · Nov 22, 2006

.oO(RichardOMarketing)

> I understand from another source that php 5.0.3 is not compatible with a MySQL
>version anything less than 4.1.3, which would explain a lot.

The standard MySQL extension in PHP should work with all older versions
(even a 3.x), while the extended interface MySQLi and PDO require a more
recent version (4.1 and higher) to make use of all the new features.

What's the version of the MySQL client library (check the output of
phpinfo())? It could be the source of problems too if it doesn't match
the server version. Did your "IT guru" build the PHP installation from
scratch or did he just install a precompiled binary?

Micha

Report · Nov 23, 2006

This is ridiculous....

We have now upgraded the Linux box and upgraded MySQL to V 5.0.18 and php to 5.1.2. - running on Apache 2.2.0

Because the Linux upgrade in not backwards compatible, I can't go back to a version that works!

Guess what - no connection - another unidentified error has ocurred. - It's not even trying!!!

Just looking at the configure command in phpinfo, mysql and mysqli doesn't seem to be enabled (as per Davids query):

'../configure' '--prefix=/usr' '--datadir=/usr/share/php5' '--mandir=/usr/share/man' '--bindir=/usr/bin' '--with-libdir=lib' '--includedir=/usr/include' '--sysconfdir=/etc/php5/apache2' '--with-config-file-path=/etc/php5/apache2' '--with-config-file-scan-dir=/etc/php5/conf.d' '--with-exec-dir=/usr/lib/php5/bin' '--enable-magic-quotes' '--enable-libxml' '--enable-session' '--with-mm' '--with-pcre-regex' '--enable-xml' '--enable-simplexml' '--enable-spl' '--enable-safe-mode' '--disable-debug' '--enable-memory-limit' '--enable-inline-optimization' '--enable-zend-multibyte' '--disable-rpath' '--with-apxs2=/usr/sbin/apxs2' '--disable-all' '--disable-cli'

Or am I looking at the wrong place???

When opening the original .php files, none of the scripts seem to be working now which suggestes that even some of the basic functionality is no longer working!

Do I need to get our IT body to do some better basic configuration?

I attach the text from the phpinfo.php results page for reference.

Report · Nov 23, 2006

RichardOMarketing wrote:
> Guess what - no connection - another unidentified error has ocurred. - It's
> not even trying!!!

Dreamweaver's trying all right, but it can't do anything if the
PHP/MySQL configuration is wrong.

> Just looking at the configure command in phpinfo, mysql and mysqli doesn't
> seem to be enabled (as per Davids query):

That's right. They're not enabled. Tell your IT department to read the
following pages in the PHP documentation:

http://www.php.net/manual/en/ref.mysql.php
http://www.php.net/manual/en/ref.mysqli.php
http://www.php.net/manual/en/ref.mbstring.php
http://www.php.net/manual/en/ref.xsl.php

You need the first three. The fourth is optional, but it's required if
you ever want to use the Dreamweaver XSL Transformation server behavior,
so it's worth enabling at the same time.

Since you're running MySQL 5.0, you don't strictly need the PHP MySQL
extension, since MySQLI is better. However, Dreamweaver doesn't support
MySQLI. Why install both if you can use only one? Two reasons:
Dreamweaver may one day support MySQLI, so it's good to be ready. More
importantly, there seem to be problems logging in to MySQL 4.1 or higher
if MySQLI isn't also enabled.

I see that your configuration uses zend-multibyte. I don't know if there
are any conflicts using it in conjunction with mbstring, but in my
experience, mbstring is necessary for working with MySQL 4.1 and higher.

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

Report · Nov 23, 2006

quote:

Originally posted by: Newsgroup User
That's right. They're not enabled. Tell your IT department to read the
following pages in the PHP documentation:
http://foundationphp.com/

I suspected as much. I have now passed your comments their way and they are now looking at the URL links you suggested.

Many many thanks for staying with me on this.... I'll let you know what happens when we get further!

Report · Nov 23, 2006

""

Report · Nov 24, 2006

I'm having a similar problem with one DW8 site. Other sites on the same server still work in DW - or at least I can select a database in the connection setup and tables are listed under the database connection. I haven't saved any changes 'cause I'm afraid of breaking those sites too!

This site WAS working well. I spent tons of time using the application objects. I've deleted and re-upload the Connections and _mmServerScripts folders on the server but no change. All the scripts on the server seem to be working fine with a browser. I've been using them for a week but now that I want to make a change using DW I can't connect to the DB.

This happend a few weeks ago but I think all I did was reboot the workstation and it was fine. No such luck this time!

OSX 10.4.8, DW 8.0.2, PHP 4.3.10.-2.4, MySQL 4.1.15

Report · Nov 27, 2006

David... we've now upgraded Linux, php and MySQL and enabled all the points that you referred to.

It works like a dream!!!!

Session variables work great.

User login is now sooo easy!

Thanks for all your help.

(ps - yes I have changed my username due to a login user error.... can't mark this topic as solved now - sorry guys!)

Report · Nov 27, 2006

RichardODreamweaver wrote:
> David... we've now upgraded Linux, php and MySQL and enabled all the points
> that you referred to.
>
> It works like a dream!!!!

Great.

> Thanks for all your help.

My pleasure. At least we got there in the end. :)

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