Welcome, Guest. Please login or register.
Did you miss your activation email?
03 Jul 2009, 23:45

Login with username, password and session length
Home Chat Help Search Calendar Login Register
Pages: [1]
Print
Author Topic: Difference in adodb tables?  (Read 1574 times)
0 Members and 1 Guest are viewing this topic.
mark
Administrator
Power Poster
*****

Karma: 131
Offline Offline

Posts: 6566

Location: Arizona



WWW
« on: 22 Jul 2007, 17:15 »

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 Edit: 22 Jul 2007, 18:27 by mark » Logged

Go to Extensions Modules/Tags click the name of the module/tag or the word Help to the right to get the parameters it takes...
Right click and view source is a great way to see what you have to work with...
Not sure what ver. CMSMS, PHP, server OS, etc. look at the System Information page...
OK if you removed the default content read it here... http://multiintech.com/defaultcontent/
People are Wonderful... Business is Great... Life is Terrific
casidougal
Forum Members
**

Karma: 3
Offline Offline

Posts: 84

Location: USA


« Reply #1 on: 26 Jul 2007, 17:51 »

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! Smiley
Logged
calguy1000
CMS GURU - 2nd Tier Support.
Dev Team Member
Power Poster
*****

Karma: 149
Offline Offline

Posts: 4328

Location: Calgary, Canada

Gravatar

Second Tier support


WWW
« Reply #2 on: 26 Jul 2007, 18:17 »

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

You'll have to use the full adodb.
Logged

I support other dev-team members, and support personnel only.
--
Questions relating to my modules are answered to paying customers, or when I have the time and motivation to.
--
Please don't email me with questions unless you are one of:
  a) A dev team or support-team member
  b) an existing  customer with a valid, and current question
  c) willing to pay for some of my time.
I'm sorry it has to be this way, but if I answered everybody's questions, all of the time, I would never ever get anything done.
----------------
Don't make me angry..... you won't like me when I'm angry....
casidougal
Forum Members
**

Karma: 3
Offline Offline

Posts: 84

Location: USA


« Reply #3 on: 27 Jul 2007, 11:02 »

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.
Logged
calguy1000
CMS GURU - 2nd Tier Support.
Dev Team Member
Power Poster
*****

Karma: 149
Offline Offline

Posts: 4328

Location: Calgary, Canada

Gravatar

Second Tier support


WWW
« Reply #4 on: 27 Jul 2007, 11:08 »

You need to:

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

Logged

I support other dev-team members, and support personnel only.
--
Questions relating to my modules are answered to paying customers, or when I have the time and motivation to.
--
Please don't email me with questions unless you are one of:
  a) A dev team or support-team member
  b) an existing  customer with a valid, and current question
  c) willing to pay for some of my time.
I'm sorry it has to be this way, but if I answered everybody's questions, all of the time, I would never ever get anything done.
----------------
Don't make me angry..... you won't like me when I'm angry....
casidougal
Forum Members
**

Karma: 3
Offline Offline

Posts: 84

Location: USA


« Reply #5 on: 27 Jul 2007, 11:19 »

My sincerest gratitude to you calguy1000 for taking the time to share your knowledge. I will give it a shot asap.
Logged
mark
Administrator
Power Poster
*****

Karma: 131
Offline Offline

Posts: 6566

Location: Arizona



WWW
« Reply #6 on: 27 Jul 2007, 21:35 »

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...
Logged

Go to Extensions Modules/Tags click the name of the module/tag or the word Help to the right to get the parameters it takes...
Right click and view source is a great way to see what you have to work with...
Not sure what ver. CMSMS, PHP, server OS, etc. look at the System Information page...
OK if you removed the default content read it here... http://multiintech.com/defaultcontent/
People are Wonderful... Business is Great... Life is Terrific
calguy1000
CMS GURU - 2nd Tier Support.
Dev Team Member
Power Poster
*****

Karma: 149
Offline Offline

Posts: 4328

Location: Calgary, Canada

Gravatar

Second Tier support


WWW
« Reply #7 on: 27 Jul 2007, 21:52 »

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.

Quote
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.

Quote
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.

Quote
I think that's all for now...
That's good enough for now  Cheesy
Logged

I support other dev-team members, and support personnel only.
--
Questions relating to my modules are answered to paying customers, or when I have the time and motivation to.
--
Please don't email me with questions unless you are one of:
  a) A dev team or support-team member
  b) an existing  customer with a valid, and current question
  c) willing to pay for some of my time.
I'm sorry it has to be this way, but if I answered everybody's questions, all of the time, I would never ever get anything done.
----------------
Don't make me angry..... you won't like me when I'm angry....
casidougal
Forum Members
**

Karma: 3
Offline Offline

Posts: 84

Location: USA


« Reply #8 on: 28 Jul 2007, 10:43 »

... 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.
Logged
Pages: [1]
Print
Jump to: