Switch from ADOD to MySQL

[xdaniel]

Hi,

I'm not sure it is the right place here. Is there a way to switch a site from ADODB (PHP4, which is longer available in my DW) to MySQL (which is available)?

Best wishes

Daniel

[Fred]

Give me an example of some database statement. Lets say a select statement.
I have always used MySQL so dont know if there is a diffeence and if it is only a matter of updating the database or even just the connection string.

[xdaniel]

Hi Fred,

I have some sites using servermodel ADODB and now the provider switched to PHP 5.3. I copied the 5.3 compatibility pack. But it doesn't work:

Deprecated: Assigning the return value of new by reference is deprecated in /is/htdocs/www/adodb/adodb.inc.php on line 894

Deprecated: Assigning the return value of new by reference is deprecated in /is/htdocs/www/adodb/adodb.inc.php on line 1865

Warning: Cannot modify header information - headers already sent by (output started at /is/htdocs/www/adodb/adodb.inc.php:894) in /is/htdocs/www/includes/common/KT_functions.inc.php on line 425

Another site on the same Server uses MySQL and works fine. Any idea?

Best wishes

Daniel

[xdaniel]

Public pages seems to run when I line them out, but I can no longer use the admin forms...

[Fred]

Did a quick google search on the adodb.inc.php file

I would imagine this file needs updating adodb.inc.php

ADOdb is a database abstraction library for PHP
Look here for more info.
http://phplens.com/adodb/index.html

The error you get from KT_functions.inc.php is because of the outdated adodb.inc.php file

[xdaniel]

Hi Fred,

this was the missing link. Thank you very much!!!

I downloaded the latest version, renamed the old one (backup), copied the new and renamed it again and everthing worked!

Do you have any idea why I can't choose PHP4 as a servermodell anymore on my dreamweaver? I installed it new.

Best wishes from Germany

Daniel

[Fred]

Did you run on a different version the last time?

You should use "php mysql" server model

[xdaniel]

no, it is the same version, DW 8.0.2. But I can't edit the pages I started some time ago anymore. Now it's on WIN 7 and before it was on WIN XP.

[Fred]

You not using a different version of the extensions?

I honestly cant remember when php4 disappeared from the options. I only have phpmysql.

I am also running on win7 but in compatibility mode. Has some issues in native mode. Cant remember what they were.

[xdaniel]

Addendum: When using the newer adodb-classes you have to copy also the original subdirectory "Iakt" and add the two include lines in the of the adodb.inc.php to the new ones.

The other problem, that I couldn't use adodb as servermodell was, that I hadn't installed Phakt