Bug #28460 for WWW-Myspace-Data: _loader method failing with empty tables?

Wed Jul 25 00:12:36 2007 GRANTG [...] cpan.org - Ticket created

Subject:

_loader method failing with empty tables?

When running FriendAdder on a new database, the "friend_adder.pl" script dies with the following error: Can't call method "db_Main" on an undefined value at /Library/Perl/5.8.6/Class/DBI/Loader/mysql.pm line 43. The error is generated by this call in Data.pm->_loader: my $loader = Class::DBI::Loader->new( dsn => $self->{'db'}->{'dsn'}, user => $self->{'db'}->{'user'}, password => $self->{'db'}->{'password'}, options => $options, namespace => 'WWW::Myspace::Data', relationships => 1, options => { AutoCommit => 1 }, inflect => { child => 'children' }, additional_classes => qw/Class::DBI::AbstractSearch/, ); This occurs with a valid database named "friends", dsn set to "dbi:mysql:friends", username and password verified correct, and "mysql.txt" commands run without error to create the database.

Wed Jul 25 01:34:45 2007 olaf [...] wundersolutions.com - Correspondence added

From:

olaf [...] wundersolutions.com

Hey Grant, Which version of Class::DBI::Loader do you have installed? Olaf

Wed Jul 25 01:34:46 2007 The RT System itself - Status changed from 'new' to 'open'

Wed Jul 25 01:42:09 2007 grantg [...] spamarrest.com - Correspondence added

Subject:	Re: [rt.cpan.org #28460] _loader method failing with empty tables?
Date:	Tue, 24 Jul 2007 22:41:37 -0700
To:	bug-WWW-Myspace-Data [...] rt.cpan.org
From:	Grant Grueninger <grantg [...] spamarrest.com>

0.32 On Jul 24, 2007, at 10:34 PM, Olaf Alders via RT wrote: Show quoted text

> > Queue: WWW-Myspace-Data > Ticket <URL: http://rt.cpan.org/Ticket/Display.html?id=28460 > > > Hey Grant, > > Which version of Class::DBI::Loader do you have installed? > > Olaf > > >

Wed Jul 25 08:20:31 2007 olaf [...] wundersolutions.com - Correspondence added

From:

olaf [...] wundersolutions.com

Try upgrading to 0.34 and running the script again. 0.32 seems to be buggy. You may need to download and install it by hand as the CPAN module may think that 0.32 is the current version. On Wed Jul 25 01:42:09 2007, grantg@spamarrest.com wrote: Show quoted text

> 0.32 >

Wed Jul 25 12:56:39 2007 grantg [...] spamarrest.com - Correspondence added

Subject:	Re: [rt.cpan.org #28460] _loader method failing with empty tables?
Date:	Wed, 25 Jul 2007 09:56:01 -0700
To:	bug-WWW-Myspace-Data [...] rt.cpan.org
From:	Grant Grueninger <grantg [...] spamarrest.com>

Any idea why CPAN thinks 0.32 is current? We should probably report that. I'd like to set 0.34 as the required version in Makefile.PL, but that'll confuse cpan installs... On Jul 25, 2007, at 5:20 AM, Olaf Alders via RT wrote: Show quoted text

> > <URL: http://rt.cpan.org/Ticket/Display.html?id=28460 > > > Try upgrading to 0.34 and running the script again. 0.32 seems to be > buggy. You may need to download and install it by hand as the CPAN > module may think that 0.32 is the current version. > > On Wed Jul 25 01:42:09 2007, grantg@spamarrest.com wrote:

>> 0.32 >>

> > > >

Wed Jul 25 14:37:44 2007 olaf [...] wundersolutions.com - Correspondence added

I figured it was just a freak thing on my end. So, you're seeing the same problem? If that's the case, let me know and I'll report it. On Mi. 25. Jul. 2007, 12:56:39, grantg@spamarrest.com wrote: Show quoted text

> Any idea why CPAN thinks 0.32 is current? We should probably report > that. I'd like to set 0.34 as the required version in Makefile.PL, > but that'll confuse cpan installs... > > On Jul 25, 2007, at 5:20 AM, Olaf Alders via RT wrote: >

> > > > <URL: http://rt.cpan.org/Ticket/Display.html?id=28460 > > > > > Try upgrading to 0.34 and running the script again. 0.32 seems to be > > buggy. You may need to download and install it by hand as the CPAN > > module may think that 0.32 is the current version. > > > > On Wed Jul 25 01:42:09 2007, grantg@spamarrest.com wrote:

> >> 0.32 > >>

> > > > > > > >

>

Wed Jul 25 14:48:59 2007 grantg [...] spamarrest.com - Correspondence added

Subject:	Re: [rt.cpan.org #28460] _loader method failing with empty tables?
Date:	Wed, 25 Jul 2007 11:48:19 -0700
To:	bug-WWW-Myspace-Data [...] rt.cpan.org
From:	Grant Grueninger <grantg [...] spamarrest.com>

Yup, same here. Says 0.32 is "up-to-date". If I go into the cpan shell and type "get Class::DBI::Loader", it gets version 0.32. Had to go to search.cpan.org and use the download link to get 0.34. On Jul 25, 2007, at 11:37 AM, Olaf Alders via RT wrote: Show quoted text

> > <URL: http://rt.cpan.org/Ticket/Display.html?id=28460 > > > I figured it was just a freak thing on my end. So, you're seeing the > same problem? If that's the case, let me know and I'll report it. > > On Mi. 25. Jul. 2007, 12:56:39, grantg@spamarrest.com wrote:

>> Any idea why CPAN thinks 0.32 is current? We should probably report >> that. I'd like to set 0.34 as the required version in Makefile.PL, >> but that'll confuse cpan installs... >> >> On Jul 25, 2007, at 5:20 AM, Olaf Alders via RT wrote: >>

>>> >>> <URL: http://rt.cpan.org/Ticket/Display.html?id=28460 > >>> >>> Try upgrading to 0.34 and running the script again. 0.32 seems >>> to be >>> buggy. You may need to download and install it by hand as the CPAN >>> module may think that 0.32 is the current version. >>> >>> On Wed Jul 25 01:42:09 2007, grantg@spamarrest.com wrote:

>>>> 0.32 >>>>

>>> >>> >>> >>>

>>

> > > >

Wed Jul 25 22:09:29 2007 olaf [...] wundersolutions.com - Correspondence added

On Wed Jul 25 14:48:59 2007, grantg@spamarrest.com wrote: Show quoted text

> Yup, same here. Says 0.32 is "up-to-date". If I go into the cpan > shell and type "get Class::DBI::Loader", it gets version 0.32. Had > to go to search.cpan.org and use the download link to get 0.34. >

Here's what I heard back on the CPAN issue: This is not a bug in the CPAN shell, but rather the CPAN module index appears to be out of date. If you look inside your/cpan/mirror/authors/02packages.details.tar.gz you'll find... Class::DBI::Loader 0.32 D/DM/DMAKI/Class-DBI-Loader-0.32.tar.gz Fortunately, Andres can poke the appropriate things to fix the index.

Wed Jul 25 22:15:46 2007 olaf [...] wundersolutions.com - Correspondence added

I've just changed the _loader routine. This bug should be fixed now. Let me know if it works for you.

Thu Jul 26 15:57:40 2007 grantg [...] spamarrest.com - Correspondence added

Subject:	Re: [rt.cpan.org #28460] _loader method failing with empty tables?
Date:	Thu, 26 Jul 2007 12:55:53 -0700
To:	bug-WWW-Myspace-Data [...] rt.cpan.org
From:	Grant Grueninger <grantg [...] spamarrest.com>

Actually, upgrading to Class::DBI::Loader fixed it. Changing the relationships setting is good though (if it's not needed) to make it work with 0.32 (in which it's noted that the "_relationship" method is "extremely experimental and not tested"). On Jul 25, 2007, at 7:15 PM, Olaf Alders via RT wrote: Show quoted text

> > Queue: WWW-Myspace-Data > Ticket <URL: http://rt.cpan.org/Ticket/Display.html?id=28460 > > > I've just changed the _loader routine. This bug should be fixed now. > Let me know if it works for you. > > >

Thu Jul 26 22:08:39 2007 olaf [...] wundersolutions.com - Correspondence added

From:

olaf [...] wundersolutions.com

On Thu Jul 26 15:57:40 2007, grantg@spamarrest.com wrote: Show quoted text

> Actually, upgrading to Class::DBI::Loader fixed it. Changing the > relationships setting is good though (if it's not needed) to make it > work with 0.32 (in which it's noted that the "_relationship" method > is "extremely experimental and not tested"). >

Yeah, I guess we know for sure that the relationships thing is a bit buggy. :) I've heard back about the CPAN module and they have now re-indexed, so that problem with the downloading should now be fixed as well.

Thu Jul 26 22:09:21 2007 olaf [...] wundersolutions.com - Status changed from 'open' to 'resolved'