Switch from ADOD to MySQL

xdaniel
Posts: 22
Joined: 2012-07-10 21:21

Switch from ADOD to MySQL

Post by xdaniel » 2012-08-15 19:03

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

User avatar
Fred
Site Admin
Posts: 491
Joined: 2010-02-15 12:10
Location: Armagh, Northern Ireland
Contact:

Re: Switch from ADOD to MySQL

Post by Fred » 2012-08-22 17:24

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
Posts: 22
Joined: 2012-07-10 21:21

Re: Switch from ADOD to MySQL

Post by xdaniel » 2012-09-06 15:17

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
Posts: 22
Joined: 2012-07-10 21:21

Re: Switch from ADOD to MySQL

Post by xdaniel » 2012-09-06 15:44

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

User avatar
Fred
Site Admin
Posts: 491
Joined: 2010-02-15 12:10
Location: Armagh, Northern Ireland
Contact:

Re: Switch from ADOD to MySQL

Post by Fred » 2012-09-06 16:25

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
Posts: 22
Joined: 2012-07-10 21:21

Re: Switch from ADOD to MySQL

Post by xdaniel » 2012-09-06 18:09

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

User avatar
Fred
Site Admin
Posts: 491
Joined: 2010-02-15 12:10
Location: Armagh, Northern Ireland
Contact:

Re: Switch from ADOD to MySQL

Post by Fred » 2012-09-06 20:13

Did you run on a different version the last time?

You should use "php mysql" server model

xdaniel
Posts: 22
Joined: 2012-07-10 21:21

Re: Switch from ADOD to MySQL

Post by xdaniel » 2012-09-06 20:43

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.

User avatar
Fred
Site Admin
Posts: 491
Joined: 2010-02-15 12:10
Location: Armagh, Northern Ireland
Contact:

Re: Switch from ADOD to MySQL

Post by Fred » 2012-09-07 10:39

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
Posts: 22
Joined: 2012-07-10 21:21

Re: Switch from ADOD to MySQL

Post by xdaniel » 2012-12-26 09:18

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 :|

Post Reply