Matt, thanks for helping me out. Comments below:<br><br><div class="gmail_quote">On Thu, Aug 20, 2009 at 3:47 PM, Matt Whipple <span dir="ltr">&lt;<a href="mailto:matt@mattwhipple.com">matt@mattwhipple.com</a>&gt;</span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Collin Condray wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
I have recently updated my Catalyst installation from 5.71001 to version 5.80007 and have made one of my websites completely unusable. I followed the instructions in the tutorial (<a href="http://search.cpan.org/%7Ehkclark/Catalyst-Manual-5.8000/lib/Catalyst/Manual/Tutorial/04_BasicCRUD.pod" target="_blank">http://search.cpan.org/~hkclark/Catalyst-Manual-5.8000/lib/Catalyst/Manual/Tutorial/04_BasicCRUD.pod</a> &lt;<a href="http://search.cpan.org/%7Ehkclark/Catalyst-Manual-5.8000/lib/Catalyst/Manual/Tutorial/04_BasicCRUD.pod" target="_blank">http://search.cpan.org/%7Ehkclark/Catalyst-Manual-5.8000/lib/Catalyst/Manual/Tutorial/04_BasicCRUD.pod</a>&gt;) to update the database to use load_components and have updated my schema files to match. However, when I go to my site I get the following error message:<div class="im">
<br>
<br>
DBIx::Class::ResultSet::next(): DBI Connection failed: Can&#39;t connect to data source &#39;HASH(0x9e139e0)&#39; because I can&#39;t work out what driver to use (it doesn&#39;t seem to contain a &#39;dbi:driver:&#39; prefix and the DBI_DRIVER env var is not set) at /home/me/local/share/perl/5.8.4/DBIx/Class/Storage/DBI.pm line 840<br>

</div></blockquote>
The error message there would seem to say that the dsn isn&#39;t being retrieved properly out of the config info<div class="im"><br></div></blockquote><div><br>Agreed.<br> </div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div class="im">
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>
My connection string looks OK and matches the tutorial&#39;s example code:<br>
<br>
__PACKAGE__-&gt;config(<br>
    schema_class =&gt; &#39;wppig::Schema&#39;,<br>
    connect_info =&gt; [<br>
        &#39;dbi:SQLite:wppig.db3&#39;,<br>
    ],<br>
);<br>
</blockquote></div>
I&#39;d opt for the more explicit and scalable key/value option of:<br>
<br>
   connect_info =&gt; {<br>
      dsn =&gt; &#39;dbi:SQLite:wppig.db3&#39;,<br>
   },<br>
<br>
<br>
But judging from the docs (which confusing do say arrayref)<br>
<a href="http://search.cpan.org:80/%7Emstrout/Catalyst-Model-DBIC-Schema-0.26/lib/Catalyst/Model/DBIC/Schema.pm#connect_info" target="_blank">http://search.cpan.org:80/~mstrout/Catalyst-Model-DBIC-Schema-0.26/lib/Catalyst/Model/DBIC/Schema.pm#connect_info</a><br>

<br>
I&#39;d say you&#39;d be looking for<div class="im"><br>
   connect_info =&gt; &#39;dbi:SQLite:wppig.db3&#39;,<br>
<br>
<br></div></blockquote><div><br>I&#39;ve tried both formulations of the config string<br><br>__PACKAGE__-&gt;config(<br>
    schema_class =&gt; &#39;wppig::Schema&#39;,<br>
    connect_info =&gt; {<br>
       dsn =&gt;  &#39;dbi:SQLite:wppig.db3&#39;,<br>
    },<br>
);<br> <br>__PACKAGE__-&gt;config(<br>

    schema_class =&gt; &#39;wppig::Schema&#39;,<br>

    connect_info =&gt;  &#39;dbi:SQLite:wppig.db3&#39;,<br>

);<br><br>and even from the docs that you cite<br>
<br>__PACKAGE__-&gt;config(<br>


    schema_class =&gt; &#39;wppig::Schema&#39;,<br>


    connect_info =&gt;   {<br>

       dsn =&gt;  &#39;dbi:SQLite:dbname=wppig.db3&#39;,<br>

    },<br> );<br>
<br>But I still get the same error message. No matter if I&#39;ve got a hashref or a string set for connect_info I still see the &quot;Can&#39;t connect to data source &#39;HASH(0x9e139e0)&#39; &quot; error.<br><br>Interestingly, when I remove the connect_info line I see this in the logs:<br>
&quot; Couldn&#39;t instantiate component &quot;wppig::Model::wppigDB&quot;, Either -&gt;config-&gt;{connect_info} must be defined for wppig::Model::wppigDB or wppig::Schema must have connect info defined on it.&quot;<br>
<br>Since the the wppig/Schema.pm file has no config information in it, it must mean there&#39;s probably no other config file squirreled away affecting the connection.<br><br></div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div class="im"></div>
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)<br>
<br></blockquote><div><br>Guilty as charged, I&#39;ll fix it as soon as I can get to it.<br> </div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">

<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div class="im">
<br>
Debugging says the piece of code that it&#39;s hanging on looks like this:<br>
<br>
my $result = $c-&gt;model(&#39;DB::Result::Tag&#39;)-&gt;search(<br>
    { },<br>
            { join      =&gt; { &#39;items_tag&#39; =&gt; &#39;tag&#39; } }<br>
);<br>
<br>
while ( my $tag = $result-&gt;next ) { # Hangs here<br>
    $tag_count{ $tag-&gt;tag }++;<br>
}<br>
<br>
So it looks like the class is loading but I can&#39;t do anything with the ResultSet.<br>
<br>
Any idea of why this is failing? Did I miss a step somewhere in the conversion? I&#39;d be happy to provide more information if needed.<br>
<br>
Thanks in advance for your help.<br>
<br>
Collin Condray<br>
@ccondray<br>
</div><a href="http://condray.net" target="_blank">condray.net</a> &lt;<a href="http://condray.net" target="_blank">http://condray.net</a>&gt;<br>
------------------------------------------------------------------------<br>
<br>
_______________________________________________<br>
List: <a href="mailto:Catalyst@lists.scsys.co.uk" target="_blank">Catalyst@lists.scsys.co.uk</a><br>
Listinfo: <a href="http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst" target="_blank">http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst</a><br>
Searchable archive: <a href="http://www.mail-archive.com/catalyst@lists.scsys.co.uk/" target="_blank">http://www.mail-archive.com/catalyst@lists.scsys.co.uk/</a><br>
Dev site: <a href="http://dev.catalyst.perl.org/" target="_blank">http://dev.catalyst.perl.org/</a><br>
  <br>
</blockquote>
<br>
<br>
_______________________________________________<br>
List: <a href="mailto:Catalyst@lists.scsys.co.uk" target="_blank">Catalyst@lists.scsys.co.uk</a><br>
Listinfo: <a href="http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst" target="_blank">http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst</a><br>
Searchable archive: <a href="http://www.mail-archive.com/catalyst@lists.scsys.co.uk/" target="_blank">http://www.mail-archive.com/catalyst@lists.scsys.co.uk/</a><br>
Dev site: <a href="http://dev.catalyst.perl.org/" target="_blank">http://dev.catalyst.perl.org/</a><br>
</blockquote></div><br><br>
If there&#39;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.<br>
<br><br clear="all">Collin Condray<br>@ccondray<br><a href="http://condray.net">condray.net</a><br>
<br><br>