Page 1 of 1

Difference in adodb tables?

Posted: Sun Jul 22, 2007 9:15 pm
by Dr.CSS
Is there a diff. in how the adodb tables are set in CMSMS1.1?...

I tried installing the Backup Module that I fixed to work in 1.0.*, available HERE, but now it throws an error...

Fatal error: Call to undefined method: pear_adoconnection->metatables() in /homepages/24/d151200904/htdocs/cmsms1.1/lib/adodb_lite/adodb-datadict.inc.php on line 218...

This is line 218, I'm thinking the module is looking for some tables but they are now named 'MetaTables' instead of what they used to be...

function MetaTables()
{
if (!$this->connection->IsConnected()) return array();
return $this->connection->MetaTables();
}

Re: Difference in adodb tables?

Posted: Thu Jul 26, 2007 9:51 pm
by casidougal
Mark,

I'm getting the exact same error...my whole project development process relies on the backup module (actually I started using the backup module based on a post you made...after a CMS MS update broke the functionality of the MySQL dump module for me) It's been working very nicely until 1.1

In any case, did you happen to come up with any insight on a fix for this?

I tried replicating replacing the following 1.1 code in adodb-datadict.inc.php :

MetaTables()
{
if (!$this->connection->IsConnected()) return array();
return $this->connection->MetaTables();
}

With the much longer code from adodb-datadict.inc.php in 1.0.8 (the backup module was working great for me on 1.08)...when I do that I start getting an error on line 251 of the backup module itself.

Thanks! :)

Re: Difference in adodb tables?

Posted: Thu Jul 26, 2007 10:17 pm
by calguy1000
Some text searches showed me that adodb_lite doesn't support the MetaTables function.

You'll have to use the full adodb.

Re: Difference in adodb tables?

Posted: Fri Jul 27, 2007 3:02 pm
by casidougal
calguy1000 wrote: Some text searches showed me that adodb_lite doesn't support the MetaTables function.

You'll have to use the full adodb.
Thanks a million for the insight, but can anyone dumb this down for a PHP neophyte like me?  i.e. what exactly are the steps involved to use the full adodb?

Thanks in advance.

Re: Difference in adodb tables?

Posted: Fri Jul 27, 2007 3:08 pm
by calguy1000
You need to:

a) download the adodb package from http://adodb.sourceforge.net/
b) unzip/untar it into /lib/adodb
    (adodb lite should be in lib/adodb_lite)
c) edit config.php and change 'use_adodb_lite' to 'false'

Re: Difference in adodb tables?

Posted: Fri Jul 27, 2007 3:19 pm
by casidougal
My sincerest gratitude to you calguy1000 for taking the time to share your knowledge. I will give it a shot asap.

Re: Difference in adodb tables?

Posted: Sat Jul 28, 2007 1:35 am
by Dr.CSS
So CMSMS changed which adodb it uses, cause I know my host hasn't...

And if so did they do it in 1.1?...

and can I change the module to look for something else?...

and how do I get the upgraded Backup module into the forge?...

I think that's all for now...

Re: Difference in adodb tables?

Posted: Sat Jul 28, 2007 1:52 am
by calguy1000
mark wrote: So CMSMS changed which adodb it uses, cause I know my host hasn't...

And if so did they do it in 1.1?...
CMS Changed to adodb_lite in the 0.12 or 0.13 days...  we include adodb_lite with the distribution (just not adodb). so there's nothing your host can/should do.
and can I change the module to look for something else?...
it's not a module thing it's a CMS Made Simple wide thing.  It either uses one database abstraction library/toolkit or the other.  Adodb_lite is faster than Adodb.... but Adodb has many more features.  Your choice... it appears that the backup module requires features from Adodb regular though.
and how do I get the upgraded Backup module into the forge?...
Well, that depends.... it may already be in the forge... The forge is just a repository for the code to prevent it from (hopefully / maybe) getting lost.  Your best bet would be to get ahold of the author of the module (or somebody willing to accept responsibility for it). and ask them to submit a new project to the forge (if a project isn't there already), or alternatively to release a new version.

If the author is asleep... then maybe somebody can be convinced to take responsibility for the module.
I think that's all for now...
That's good enough for now  :D

Re: Difference in adodb tables?

Posted: Sat Jul 28, 2007 2:43 pm
by casidougal
calguy1000 wrote: ... it appears that the backup module requires features from Adodb regular though.
Thanks again for sharing your insight...I'm learning a lot. I'm not sure if I understand this part about the backup module requiring Adodb regular...it was working fine on all versions (to my knowledge) up until 1.1 which was the first version that did incorporate Adodb regular.  So did you mean to say it might only work with Adodb lite?

Thanks in advance.