Bug #18197 for Catalyst-Model-CDBI: Can't find method set_sql trying to create a model from mysql

Thu Mar 16 07:57:15 2006 DIEGOK [...] cpan.org - Ticket created

Subject:

Can't find method set_sql trying to create a model from mysql

I'm getting the following error trying to create the model from a mysql backend Show quoted text

> script/admin_create.pl model CDBI CDBI dbi:mysql:database user pass

Couldn't require loader class "Class::DBI::Loader::mysql", "Can't locate object method "set_sql" via package "Class::DBI::mysql" at /usr/local/lib/perl5/site_perl/5.8.8/Class/DBI/mysql.pm line 58. Compilation failed in require at /usr/local/lib/perl5/site_perl/5.8.8/Class/DBI/Loader/mysql.pm line 8. Compilation failed in require at (eval 17) line 2. BEGIN failed--compilation aborted at (eval 17) line 2. " at /usr/local/lib/perl5/site_perl/5.8.8/Class/DBI/Loader.pm line 81. I found that the problem is it doesn't use Class::DBI before call his method "set_sql". I fixed it adding "use Class::DBI" sooner into Catalyst::Helper::Model::CDBI. Please contact me if you need some extra test. I'll be glad to help.

Thu Mar 16 07:58:22 2006 DIEGOK [...] cpan.org - Status changed from 'new' to 'open'

Sun Apr 02 07:19:06 2006 mramberg [...] cpan.org - Correspondence added

Hi Diego. Not quite sure what you are talking about here. Catalyst::Helper::Model::CDBI uses Class::DBI::Loader, and there is no set_sql in the helper at all. Maybe you really want to submit a bug on Class::DBI::Loader? If that is the case, please reply here so I can get this ticket closed, if not, please describe your problem closer. Marcus On Thu Mar 16 07:57:15 2006, DIEGOK wrote: Show quoted text

> I'm getting the following error trying to create the model from a mysql > backend >

> > script/admin_create.pl model CDBI CDBI dbi:mysql:database user pass

> > Couldn't require loader class "Class::DBI::Loader::mysql", "Can't locate > object method "set_sql" via package "Class::DBI::mysql" at > /usr/local/lib/perl5/site_perl/5.8.8/Class/DBI/mysql.pm line 58. > Compilation failed in require at > /usr/local/lib/perl5/site_perl/5.8.8/Class/DBI/Loader/mysql.pm line 8. > Compilation failed in require at (eval 17) line 2. > BEGIN failed--compilation aborted at (eval 17) line 2. > " at /usr/local/lib/perl5/site_perl/5.8.8/Class/DBI/Loader.pm line 81. > > I found that the problem is it doesn't use Class::DBI before call his > method "set_sql". > > I fixed it adding "use Class::DBI" sooner into > Catalyst::Helper::Model::CDBI. > > Please contact me if you need some extra test. I'll be glad to help. >

Fri Jun 02 08:05:04 2006 Guest - Correspondence added

From:

matthias [...] volltext.net

On Sun Apr 02 07:19:06 2006, MRAMBERG wrote: Show quoted text

> Hi Diego. Not quite sure what you are talking about here. > Catalyst::Helper::Model::CDBI uses > Class::DBI::Loader, and there is no set_sql in the helper at all. > Maybe you really want to > submit a bug on Class::DBI::Loader? If that is the case, please reply > here so I can get this > ticket closed, if not, please describe your problem closer.

hello, i had same problem with debian sarge, perl 5.8.4 and Catalyst::Helper::Model::CDBI version; attached patch made it go away --------->8---------------------------------------------------------- kaelte:app$ ./script/app_create.pl model UserData CDBI dbi:mysql:db user pass [...] Couldn't require loader class "Class::DBI::Loader::mysql", "Can't locate object method "set_sql" via package "Class::DBI::mysql" at /usr/local/share/perl/5.8.4/Class/DBI/mysql.pm line 58. Compilation failed in require at /usr/local/share/perl/5.8.4/Class/DBI/Loader/mysql.pm line 8. Compilation failed in require at (eval 13) line 2. BEGIN failed--compilation aborted at (eval 13) line 2. " at /usr/local/share/perl/5.8.4/Class/DBI/Loader.pm line 81. kaelte:app$ --------->8---------------------------------------------------------- Show quoted text

> On Thu Mar 16 07:57:15 2006, DIEGOK wrote:

> > I'm getting the following error trying to create the model from a

> mysql

> > backend > >

> > > script/admin_create.pl model CDBI CDBI dbi:mysql:database user

> pass

> > > > Couldn't require loader class "Class::DBI::Loader::mysql", "Can't

> locate

> > object method "set_sql" via package "Class::DBI::mysql" at > > /usr/local/lib/perl5/site_perl/5.8.8/Class/DBI/mysql.pm line 58. > > Compilation failed in require at > > /usr/local/lib/perl5/site_perl/5.8.8/Class/DBI/Loader/mysql.pm line

> 8.

> > Compilation failed in require at (eval 17) line 2. > > BEGIN failed--compilation aborted at (eval 17) line 2. > > " at /usr/local/lib/perl5/site_perl/5.8.8/Class/DBI/Loader.pm line

> 81.

> > > > I found that the problem is it doesn't use Class::DBI before call

> his

> > method "set_sql". > > > > I fixed it adding "use Class::DBI" sooner into > > Catalyst::Helper::Model::CDBI. > > > > Please contact me if you need some extra test. I'll be glad to help. > >

> >

--- Catalyst/Helper/Model/CDBI.pm.orig 2006-06-02 13:53:59.000000000 +0200 +++ Catalyst/Helper/Model/CDBI.pm 2006-06-02 13:46:26.000000000 +0200 @@ -2,6 +2,7 @@ use strict; use Class::DBI::Loader; +use Class::DBI; use File::Spec; =head1 NAME

Fri Jun 02 08:10:19 2006 Guest - Correspondence added

From:

matthias [...] volltext.net

On Fri Jun 02 08:05:04 2006, guest wrote: Show quoted text

> i had same problem with debian sarge, perl 5.8.4 and > Catalyst::Helper::Model::CDBI version; [-_-]

yes version is actually 0.11 cheers matthias

Mon Feb 08 21:36:44 2010 bobtfish [...] bobtfish.net - Correspondence added

Fixed in the latest version, which also however adds a deprecation notice.

Mon Feb 08 21:36:47 2010 bobtfish [...] bobtfish.net - Status changed from 'open' to 'resolved'