[Catalyst] DBI SQLite driver missing after Catalyst update.

Matt Whipple matt at mattwhipple.com
Fri Aug 21 12:54:01 GMT 2009


>
>
> I've tried both formulations of the config string
>
> __PACKAGE__->config(
>    schema_class => 'wppig::Schema',
>    connect_info => {
>       dsn =>  'dbi:SQLite:wppig.db3',
>    },
> );
>  
> __PACKAGE__->config(
>    schema_class => 'wppig::Schema',
>    connect_info =>  'dbi:SQLite:wppig.db3',
> );
>
> and even from the docs that you cite
>
> __PACKAGE__->config(
>    schema_class => 'wppig::Schema',
>    connect_info =>  {
>       dsn =>  'dbi:SQLite:dbname=wppig.db3',
>    },
>  );
>
> But I still get the same error message. No matter if I've got a 
> hashref or a string set for connect_info I still see the "Can't 
> connect to data source 'HASH(0x9e139e0)' " error.
>
> Interestingly, when I remove the connect_info line I see this in the logs:
> " Couldn't instantiate component "wppig::Model::wppigDB", Either 
> ->config->{connect_info} must be defined for wppig::Model::wppigDB or 
> wppig::Schema must have connect info defined on it."

I'd suggest testing placing the connect_info in the app's config file 
(designated for the model), or in the schema file.  With the info in the 
schema file it isolates the connection within DBIC.

>
> Since the the wppig/Schema.pm file has no config information in it, it 
> must mean there's probably no other config file squirreled away 
> affecting the connection.
>
>     As a side not you may want to meditate on the fact that you
>     apparently simultaneously introduced instability into a
>     development and a production environment (according to the other
>     reply thread)
>
>
> Guilty as charged, I'll fix it as soon as I can get to it.
>  
>
>
>         Debugging says the piece of code that it's hanging on looks
>         like this:
>
>         my $result = $c->model('DB::Result::Tag')->search(
>            { },
>                    { join      => { 'items_tag' => 'tag' } }
>         );
>
>         while ( my $tag = $result->next ) { # Hangs here
>            $tag_count{ $tag->tag }++;
>         }
>
>         So it looks like the class is loading but I can't do anything
>         with the ResultSet.
>
>         Any idea of why this is failing? Did I miss a step somewhere
>         in the conversion? I'd be happy to provide more information if
>         needed.
>
>         Thanks in advance for your help.
>
>
>
> If there's something else about my app that I can show you to help 
> solve this problem, please let me know. Thanks again for your help.
>
>
> Collin Condray
> @ccondray
> condray.net <http://condray.net>
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> List: Catalyst at lists.scsys.co.uk
> Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
> Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/
> Dev site: http://dev.catalyst.perl.org/
>   




More information about the Catalyst mailing list