Difference in adodb tables?

Have a question or a suggestion about a 3rd party addon module or plugin?
Let us know here.
Post Reply
User avatar
Dr.CSS
Moderator
Moderator
Posts: 12711
Joined: Thu Mar 09, 2006 5:32 am
Location: Arizona

Difference in adodb tables?

Post 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();
}
Last edited by Anonymous on Sun Jul 22, 2007 10:27 pm, edited 1 time in total.
casidougal
Forum Members
Forum Members
Posts: 98
Joined: Tue Jun 06, 2006 10:08 pm
Location: USA

Re: Difference in adodb tables?

Post 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! :)
calguy1000
Support Guru
Support Guru
Posts: 8169
Joined: Tue Oct 19, 2004 6:44 pm
Location: Fernie British Columbia, Canada

Re: Difference in adodb tables?

Post by calguy1000 »

Some text searches showed me that adodb_lite doesn't support the MetaTables function.

You'll have to use the full adodb.
Follow me on twitter
Please post system information from "Extensions >> System Information" (there is a bbcode option) on all posts asking for assistance.
--------------------
If you can't bother explaining your problem well, you shouldn't expect much in the way of assistance.
casidougal
Forum Members
Forum Members
Posts: 98
Joined: Tue Jun 06, 2006 10:08 pm
Location: USA

Re: Difference in adodb tables?

Post 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.
calguy1000
Support Guru
Support Guru
Posts: 8169
Joined: Tue Oct 19, 2004 6:44 pm
Location: Fernie British Columbia, Canada

Re: Difference in adodb tables?

Post 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'
Follow me on twitter
Please post system information from "Extensions >> System Information" (there is a bbcode option) on all posts asking for assistance.
--------------------
If you can't bother explaining your problem well, you shouldn't expect much in the way of assistance.
casidougal
Forum Members
Forum Members
Posts: 98
Joined: Tue Jun 06, 2006 10:08 pm
Location: USA

Re: Difference in adodb tables?

Post by casidougal »

My sincerest gratitude to you calguy1000 for taking the time to share your knowledge. I will give it a shot asap.
User avatar
Dr.CSS
Moderator
Moderator
Posts: 12711
Joined: Thu Mar 09, 2006 5:32 am
Location: Arizona

Re: Difference in adodb tables?

Post 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...
calguy1000
Support Guru
Support Guru
Posts: 8169
Joined: Tue Oct 19, 2004 6:44 pm
Location: Fernie British Columbia, Canada

Re: Difference in adodb tables?

Post 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
Follow me on twitter
Please post system information from "Extensions >> System Information" (there is a bbcode option) on all posts asking for assistance.
--------------------
If you can't bother explaining your problem well, you shouldn't expect much in the way of assistance.
casidougal
Forum Members
Forum Members
Posts: 98
Joined: Tue Jun 06, 2006 10:08 pm
Location: USA

Re: Difference in adodb tables?

Post 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.
Post Reply

Return to “Modules/Add-Ons”