Page 1 of 2
Switch from ADOD to MySQL
Posted: 2012-08-15 19:03
by 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
Re: Switch from ADOD to MySQL
Posted: 2012-08-22 17:24
by 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.
Re: Switch from ADOD to MySQL
Posted: 2012-09-06 15:17
by 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
Re: Switch from ADOD to MySQL
Posted: 2012-09-06 15:44
by xdaniel
Public pages seems to run when I line them out, but I can no longer use the admin forms...
Re: Switch from ADOD to MySQL
Posted: 2012-09-06 16:25
by 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
Re: Switch from ADOD to MySQL
Posted: 2012-09-06 18:09
by 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
Re: Switch from ADOD to MySQL
Posted: 2012-09-06 20:13
by Fred
Did you run on a different version the last time?
You should use "php mysql" server model
Re: Switch from ADOD to MySQL
Posted: 2012-09-06 20:43
by 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.
Re: Switch from ADOD to MySQL
Posted: 2012-09-07 10:39
by 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.
Re: Switch from ADOD to MySQL
Posted: 2012-12-26 09:18
by 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
