[Catalyst] Re: DBI handle without magic when calling with dump_info=1 after updating Catalyst::Runtime
Hi Jeremy, Am 23.11.2010 um 18:15 schrieb Jeremy Dack: I have multiple views in my view folder but I am not using them at present; however just their presence seems to be enough to cause the resultset error. I've found that adding: $c-config-{'Action::RenderView'}-{ignore_classes} = []; To my root sub end : ActionClass('RenderView') stops the error from triggering. This seems to override it from ignoring the DBIx::Class::ResultSource::Table DBIx::Class::ResultSourceHandle as per the RenderView.pm (see below). $c-config-{'Action::RenderView'}-{ignore_classes} = ( ref($c-config-{'debug'}) eq 'HASH' ? $c-config-{'debug'}-{ignore_classes} : undef ) || [ qw/ DBIx::Class::ResultSource::Table DBIx::Class::ResultSourceHandle DateTime / ] unless exists $c-config-{'Action::RenderView'}-{ignore_classes}; I have no idea why this fixes the issue as I have only just started playing with Catalyst so I maybe talking rubbish however it has definitely solved my issues. I just found out I never got this email through the mailing list and found it in an archive on the web. Thanks you for this, this solves the issue at first glance! However, when using dump_info=1 I get the following lines on the console where the development server (the one that is shipped with Catalyst) is running: SV = IV(0x10535fb40) at 0x10535fb48 REFCNT = 1 FLAGS = (ROK,READONLY) RV = 0x1053d6148 SV = PVHV(0x1057f55f0) at 0x1053d6148 REFCNT = 1 FLAGS = (OBJECT,SHAREKEYS) STASH = 0x102282120 DBI::db ARRAY = 0x0 KEYS = 0 FILL = 0 MAX = 7 RITER = -1 EITER = 0x0 (in cleanup) dbih_getcom handle DBI::db=HASH(0x1053d6148) is not a DBI handle (has no magic) at /opt/local/lib/perl5/site_perl/5.12.2/Data/Visitor/Callback.pm line 97. Maybe someone can help sometime. For now it's working, thank you! Best, Matthias -- rainboxx Software Engineering Matthias Dietrich rainboxx Matthias Dietrich | Phone: +49 7141 / 2 39 14 71 Königsallee 43 | Fax : +49 3222 / 1 47 63 00 71638 Ludwigsburg| Mobil: +49 151 / 50 60 78 64 | WWW : http://www.rainboxx.de CPAN: http://search.cpan.org/~mdietrich/ XING: https://www.xing.com/profile/Matthias_Dietrich18 GULP: http://www.gulp.de/profil/rainboxx.html ___ List: Catalyst@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/
Re: [Catalyst] Re: DBI handle without magic when calling with dump_info=1 after updating Catalyst::Runtime
On 1 Mar 2011, at 17:38, Matthias Dietrich wrote: I just found out I never got this email through the mailing list and found it in an archive on the web. Thanks you for this, this solves the issue at first glance! However, when using dump_info=1 I get the following lines on the console where the development server (the one that is shipped with Catalyst) is running: What perl version are you using here? Cheers t0m ___ List: Catalyst@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/
Re: [Catalyst] Re: DBI handle without magic when calling with dump_info=1 after updating Catalyst::Runtime
Hi, Am 01.03.2011 um 19:06 schrieb Tomas Doran: What perl version are you using here? I'm on v5.12.2 on a Mac OS X 10.6.6 with a custom Perl build (via macports). Matthias -- rainboxx Software Engineering Matthias Dietrich rainboxx Matthias Dietrich | Phone: +49 7141 / 2 39 14 71 Königsallee 43 | Fax : +49 3222 / 1 47 63 00 71638 Ludwigsburg| Mobil: +49 151 / 50 60 78 64 | WWW : http://www.rainboxx.de CPAN: http://search.cpan.org/~mdietrich/ XING: https://www.xing.com/profile/Matthias_Dietrich18 GULP: http://www.gulp.de/profil/rainboxx.html ___ List: Catalyst@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/
Re: [Catalyst] Re: DBI handle without magic when calling with dump_info=1 after updating Catalyst::Runtime
Hi, Am 01.03.2011 um 19:32 schrieb Tomas Doran: What perl version are you using here? I'm on v5.12.2 on a Mac OS X 10.6.6 with a custom Perl build (via macports). Bah, no idea what's going on there then :) oh, it's all the same... ;-) With custom I mean it's not the Perl that is shipped with Mac OS X, but it is a normal build (just like plain `make make install`). So nothing special in regard to configure options or build flags or something like that. This issue also happens with Perl v5.8.8 and v5.10.0 on usual Ubuntu systems, so it's nothing special to this Mac build. Matthias -- rainboxx Software Engineering Matthias Dietrich rainboxx Matthias Dietrich | Phone: +49 7141 / 2 39 14 71 Königsallee 43 | Fax : +49 3222 / 1 47 63 00 71638 Ludwigsburg| Mobil: +49 151 / 50 60 78 64 | WWW : http://www.rainboxx.de CPAN: http://search.cpan.org/~mdietrich/ XING: https://www.xing.com/profile/Matthias_Dietrich18 GULP: http://www.gulp.de/profil/rainboxx.html ___ List: Catalyst@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/
[Catalyst] Re: DBI handle without magic when calling with dump_info=1 after updating Catalyst::Runtime
Hi Jeremy, Am 23.11.2010 um 09:55 schrieb Jeremy Dack: Did you ever find a solution to the problem below as I’ve started to get the exact same issue on my windows box? I'm sorry I haven't and I'm still living with that issue. Maybe the list could help? Re: DBI handle without magic when calling with dump_info=1 after updating Catalyst::Runtime [In reply to] Hi list, does someone knows anything about this error? As it occurs on two of my systems (Linux, Mac) and at least on one unknown I heard of this seems not to be an error of my local installation. Here's my error description as of 24.08.2009: Hi, yesterday I've updated Catalyst::Runtime to 5.80011 and also did an update to several other modules (like Moose, DBIC, DBI and some plugins). Today I discovered that my DBI handle looses his magic when I call my app with parameter dump_info set to 1. This is the message printed on my console (current lates Mac OS X): $ sudo ./script/myapp_server.pl -p 80 -r You can connect to your server at http://rainboxx-pro.local SV = RV(0x24ae020) at 0x2501e60 REFCNT = 1 FLAGS = (ROK,READONLY) RV = 0x24f5f0c (in cleanup) dbih_getcom handle DBI::db=HASH(0x24f5f0c) is not a DBI handle (has no magic) at /opt/local/lib/perl5/site_perl/5.8.9/Data/Visitor/Callback.pm line 97. Each following request results in blank pages with exceptions in the log like: Can't call method resultset without a package or object reference at /opt/local/lib/perl5/site_perl/5.8.9/DBIx/Class/Schema.pm line 548. I need to restart the server to use it again. The error occurs everytime I'm surfing on my app and using dump_info then. If I restart the server and use dump_info with the first request, everthing is fine. If I access a normal controller page and use dump_info after that, the server goes down again. Do I need to update another module? Or is this a bug and if yes, of which module? Tell me how I can help to find this error. Thanks, matt P.S.: Although this seems to be as a question that should go to the DBIC list, I guess it is Catalyst related... Thanks -- rainboxx Software Engineering Matthias Dietrich rainboxx Matthias Dietrich | Phone: +49 7141 / 2 39 14 71 Königsallee 43 | Fax : +49 3222 / 1 47 63 00 71638 Ludwigsburg| Mobil: +49 151 / 50 60 78 64 | WWW : http://www.rainboxx.de CPAN: http://search.cpan.org/~mdietrich/ XING: https://www.xing.com/profile/Matthias_Dietrich18 GULP: http://www.gulp.de/profil/rainboxx.html ___ List: Catalyst@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/
[Catalyst] Re: DBI handle without magic when calling with dump_info=1 after updating Catalyst::Runtime
Hi Jeremy, I cc'ed the list again so they all can see that we discuss about this :-). Am 23.11.2010 um 14:13 schrieb Jeremy Dack: The problem seems to be with RenderView, do you use any custom views like JSON or is all your output HTML? I use some other views than HTML in some apps, but this issue only occurs when HTML (here: Mason) should be printed. AFAIK it also occurs when only a HTML/Mason view is available. Matt -- rainboxx Software Engineering Matthias Dietrich rainboxx Matthias Dietrich | Phone: +49 7141 / 2 39 14 71 Königsallee 43 | Fax : +49 3222 / 1 47 63 00 71638 Ludwigsburg| Mobil: +49 151 / 50 60 78 64 | WWW : http://www.rainboxx.de CPAN: http://search.cpan.org/~mdietrich/ XING: https://www.xing.com/profile/Matthias_Dietrich18 GULP: http://www.gulp.de/profil/rainboxx.html ___ List: Catalyst@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/
[Catalyst] RE: DBI handle without magic when calling with dump_info=1 after updating Catalyst::Runtime
Matt, I have multiple views in my view folder but I am not using them at present; however just their presence seems to be enough to cause the resultset error. I've found that adding: $c-config-{'Action::RenderView'}-{ignore_classes} = []; To my root sub end : ActionClass('RenderView') stops the error from triggering. This seems to override it from ignoring the DBIx::Class::ResultSource::Table DBIx::Class::ResultSourceHandle as per the RenderView.pm (see below). $c-config-{'Action::RenderView'}-{ignore_classes} = ( ref($c-config-{'debug'}) eq 'HASH' ? $c-config-{'debug'}-{ignore_classes} : undef ) || [ qw/ DBIx::Class::ResultSource::Table DBIx::Class::ResultSourceHandle DateTime / ] unless exists $c-config-{'Action::RenderView'}-{ignore_classes}; I have no idea why this fixes the issue as I have only just started playing with Catalyst so I maybe talking rubbish however it has definitely solved my issues. Good luck Jeremy. -Original Message- From: Matthias Dietrich [mailto:mdietr...@cpan.org] Sent: 23 November 2010 13:19 To: Jeremy Dack Cc: The elegant MVC web framework Subject: Re: DBI handle without magic when calling with dump_info=1 after updating Catalyst::Runtime Hi Jeremy, I cc'ed the list again so they all can see that we discuss about this :-). Am 23.11.2010 um 14:13 schrieb Jeremy Dack: The problem seems to be with RenderView, do you use any custom views like JSON or is all your output HTML? I use some other views than HTML in some apps, but this issue only occurs when HTML (here: Mason) should be printed. AFAIK it also occurs when only a HTML/Mason view is available. Matt -- rainboxx Software Engineering Matthias Dietrich rainboxx Matthias Dietrich | Phone: +49 7141 / 2 39 14 71 Königsallee 43 | Fax : +49 3222 / 1 47 63 00 71638 Ludwigsburg| Mobil: +49 151 / 50 60 78 64 | WWW : http://www.rainboxx.de CPAN: http://search.cpan.org/~mdietrich/ XING: https://www.xing.com/profile/Matthias_Dietrich18 GULP: http://www.gulp.de/profil/rainboxx.html ___ List: Catalyst@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/