Switch from ADOD to MySQL

johnhson
Posts: 5
Joined: 2014-05-14 20:21

Re: Switch from ADOD to MySQL

Post by johnhson » 2014-05-14 20:42

Fred wrote: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
I went to http://phplens.com/adodb/index.html and totally bewildered - is it possible to post a link to the driver that needs to be downloaded?

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 » 2014-05-14 21:55

johnhson wrote:
I went to http://phplens.com/adodb/index.html and totally bewildered - is it possible to post a link to the driver that needs to be downloaded?
John the link it at the very top of the page :P
Here you go anyway. Includes code samples.

http://adodb.sourceforge.net/#download

johnhson
Posts: 5
Joined: 2014-05-14 20:21

Re: Switch from ADOD to MySQL

Post by johnhson » 2014-05-15 01:31

Thanks Fred

Downloaded the file http://sourceforge.net/projects/adodb/f ... -for-php5/ and copied the contents of the drivers directory over the existing /adodb/drivers

Then copied adodb.inc.php over /adodb/adodb.inc.ph

Is there anything else I need to do as I cannot get a connection to the MySQL db - clicking on a recordset shows the contents but hitting test results in "An unidentified error has occurred"

Using DW 7.0.1 in compat. mode for windows XP on windows 7.
Using WAMPserver 64, php 5.5.12 MySQL 5.6.17

I'd also told the database to use oldpasswords as per server set up

Carrots are much easier to grow than php!

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 » 2014-05-15 22:06

John I have no idea, not using ADODB.

Check if there is a folder called _mmServerScripts on your server in the root of your site.
It should have an error_log in it. You might find the answer in there,

if all else fails delete the db connection and rename / delete the _mmServerScripts folder and start over.

johnhson
Posts: 5
Joined: 2014-05-14 20:21

Re: Switch from ADOD to MySQL

Post by johnhson » 2014-05-15 23:59

Fred wrote:John I have no idea, not using ADODB.
.
At the risk of looking laughably stupid - are you saying it is possible to use Interakt / Phakt etc without using the ADODB drivers? I'm only using MySQL so not got any need for all the other bits.

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 » 2014-05-16 16:44

John the only things that I have installed is the interakt extensions with the advance recordset extension (AWRS) that was included in the file you originally received from interakt.
No Phakt or ADODB drivers

Post Reply