<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Hello again. My error got scrubbed earlier, so this is a second
attempt.<br>
<br>
I'm using Catalyst along with DBIC, and I recently got the error below.<code
class="error"><font color="#000000"> The interesting thing is that
even though this
error was thrown, the insert worked. The use case is simply that I've
just created a new 'User', and I now want to give that user a 'Role'.
I'm using a join table to do so. That table has the id's of both the
User and Role(s) associated.<br>
<br>
Is this a bug? The problem I have is that even though the insert
works, it blows up my Catalyst application.<br>
<br>
Thoughts?</font></code><code class="error"><font color="#000000"><br>
<br>
<br>
DBI Exception: DBD::mysql::st execute failed: Cannot add or update a
child row: a foreign key constraint fails (`WebStmt/users_roles`,
CONSTRAINT `users_roles_ibfk_2` FOREIGN KEY (`role_id`) REFERENCES
`roles` (`id`)) [for Statement "INSERT INTO users_roles ( role_id,
user_id) VALUES ( ?, ? )" with ParamValues: 0='HASH(0xb57f080)',
1='66']</font></code><br>
<br>
<br>
<br>
On 4/16/2010 5:54 AM, <a class="moz-txt-link-abbreviated" href="mailto:dbix-class-request@lists.scsys.co.uk">dbix-class-request@lists.scsys.co.uk</a> wrote:
<blockquote cite="mid:E1O2iG9-0000FD-3d@jules.scsys.co.uk" type="cite">
<pre wrap="">Send DBIx-Class mailing list submissions to
<a class="moz-txt-link-abbreviated" href="mailto:dbix-class@lists.scsys.co.uk">dbix-class@lists.scsys.co.uk</a>
To subscribe or unsubscribe via the World Wide Web, visit
<a class="moz-txt-link-freetext" href="http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class">http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class</a>
or, via email, send a message with subject or body 'help' to
<a class="moz-txt-link-abbreviated" href="mailto:dbix-class-request@lists.scsys.co.uk">dbix-class-request@lists.scsys.co.uk</a>
You can reach the person managing the list at
<a class="moz-txt-link-abbreviated" href="mailto:dbix-class-owner@lists.scsys.co.uk">dbix-class-owner@lists.scsys.co.uk</a>
When replying, please edit your Subject line so it is more specific
than "Re: Contents of DBIx-Class digest..."
Today's Topics:
1. Insert into join table succeeds but issues error anyway (Steve)
2. Result Classes (Ben Hitz)
3. Jobs, jobs, jobs, and jobs (don't forget about jobs!)
(fREW Schmidt)
4. can i add custom error info for throw_exception in
dbix::class 0.07006? (??)
5. Re: can i add custom error info for throw_exception in
dbix::class 0.07006? (Alexander Hartmaier)
6. Re: can i add custom error info for throw_exception in
dbix::class 0.07006? (??)
7. Re: New experimental development release of DBD::ODBC 1.23_4
- faster - please test (Martin Evans)
----------------------------------------------------------------------
Message: 1
Date: Thu, 15 Apr 2010 15:40:57 -0400
From: Steve <a class="moz-txt-link-rfc2396E" href="mailto:steve@matsch.com"><steve@matsch.com></a>
Subject: [Dbix-class] Insert into join table succeeds but issues error
anyway
To: <a class="moz-txt-link-abbreviated" href="mailto:dbix-class@lists.scsys.co.uk">dbix-class@lists.scsys.co.uk</a>
Message-ID: <a class="moz-txt-link-rfc2396E" href="mailto:4BC76BC9.1040603@matsch.com"><4BC76BC9.1040603@matsch.com></a>
Content-Type: text/plain; charset="us-ascii"
An HTML attachment was scrubbed...
URL: <a class="moz-txt-link-freetext" href="http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20100415/deaef6f4/attachment-0001.htm">http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20100415/deaef6f4/attachment-0001.htm</a>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: steve.vcf
Type: text/x-vcard
Size: 268 bytes
Desc: not available
Url : <a class="moz-txt-link-freetext" href="http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20100415/deaef6f4/steve-0001.vcf">http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20100415/deaef6f4/steve-0001.vcf</a>
------------------------------
Message: 2
Date: Thu, 15 Apr 2010 14:29:51 -0700
From: Ben Hitz <a class="moz-txt-link-rfc2396E" href="mailto:hitz@genome.stanford.edu"><hitz@genome.stanford.edu></a>
Subject: [Dbix-class] Result Classes
To: "DBIx::Class user and developer list"
<a class="moz-txt-link-rfc2396E" href="mailto:dbix-class@lists.scsys.co.uk"><dbix-class@lists.scsys.co.uk></a>
Message-ID: <a class="moz-txt-link-rfc2396E" href="mailto:AD38710A-14A1-4ECA-8A1C-86ECA5292CCE@genome.stanford.edu"><AD38710A-14A1-4ECA-8A1C-86ECA5292CCE@genome.stanford.edu></a>
Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes
I don't use load_namespaces, but I blundered into it via some Catalyst
docs.
</pre>
<blockquote type="cite">
<pre wrap="">With no arguments, this method uses Module::Find to load all your
Result classes from a sub-namespace Result under your Schema class'
namespace, i.e. with a Schema of MyDB::Schema all files in
MyDB::Schema::Result are assumed to be Result classes
</pre>
</blockquote>
<pre wrap="">
What is a "Result class" ? Did I miss a memo? I know what a
ResultSet class is (sort of) and I know what a ResultSource class is
(at least in the sense of it corresponding to a DB Table...) but this
terminology is new to me.
There is a link to a non-existent glossary entry in the
DBIx::Class::ResultSource POD as well.
"As mentioned above, a result source instance is created and stored
for you when you define a <a href=<a class="moz-txt-link-rfc2396E" href="http://search.cpan.org/~frew/DBIx-Class-0.08121/lib/DBIx/Class/Manual/Glossary.pod#Result_Class">"http://search.cpan.org/~frew/DBIx-Class-0.08121/lib/DBIx/Class/Manual/Glossary.pod#Result_Class
"</a>>Result Class</a>"
If I had to guess, I would say that Result Class = "class of
ResultSource instance object"... but that's just a guess.
Ben
--
Ben Hitz
Senior Scientific Programmer ** Saccharomyces Genome Database ** GO
Consortium
Stanford University ** <a class="moz-txt-link-abbreviated" href="mailto:hitz@genome.stanford.edu">hitz@genome.stanford.edu</a>
------------------------------
Message: 3
Date: Thu, 15 Apr 2010 19:49:24 -0500
From: fREW Schmidt <a class="moz-txt-link-rfc2396E" href="mailto:frioux@gmail.com"><frioux@gmail.com></a>
Subject: [Dbix-class] Jobs, jobs, jobs, and jobs (don't forget about
jobs!)
To: The elegant MVC web framework <a class="moz-txt-link-rfc2396E" href="mailto:catalyst@lists.scsys.co.uk"><catalyst@lists.scsys.co.uk></a>,
"DBIx::Class user and developer list" <a class="moz-txt-link-rfc2396E" href="mailto:dbix-class@lists.scsys.co.uk"><dbix-class@lists.scsys.co.uk></a>
Message-ID:
<a class="moz-txt-link-rfc2396E" href="mailto:l2wfb3648c61004151749s21b58735r83fcd29ef70ac3e3@mail.gmail.com"><l2wfb3648c61004151749s21b58735r83fcd29ef70ac3e3@mail.gmail.com></a>
Content-Type: text/plain; charset="iso-8859-1"
Hello all!
The company I am working for is hiring!
Required:
Experience with DBIx::Class and Catalyst
We are In Richardson, TX and willingness to relocate and work onsite is
highly preferred
Preferred:
Self starters
Experience with Javascript
Experience with ExtJS
We have done perl web development for nearly 10 years and we currently have
way too much work for our small shop (6~ developers) to handle. Except for
one product (which we own and sell) all of our work is currently long term
(1 year or more) contracts with a variety of customers. Since working here
(almost 2 years) we have moved from vanilla CGI + DBI with IIS to Catalyst,
DBIx::Class and mod_perl. If you are motivated and get results the people
running the company listen to you, so if you are stuck in a giant company
doing way too much PERL come join us!
Send your resumes my direction and feel free to email me or if you are on
IRC msg me (frew on perl, frooh on freenode) with any questions you might
have.
I look forward to hearing from you!
-- =
fREW Schmidt
<a class="moz-txt-link-freetext" href="http://blog.afoolishmanifesto.com">http://blog.afoolishmanifesto.com</a>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <a class="moz-txt-link-freetext" href="http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20100415/dac=">http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20100415/dac=</a>
cf50b/attachment-0001.htm
------------------------------
Message: 4
Date: Fri, 16 Apr 2010 16:21:09 +0800
From: ?? <a class="moz-txt-link-rfc2396E" href="mailto:swansun95@gmail.com"><swansun95@gmail.com></a>
Subject: [Dbix-class] can i add custom error info for throw_exception
in dbix::class 0.07006?
To: <a class="moz-txt-link-abbreviated" href="mailto:dbix-class@lists.scsys.co.uk">dbix-class@lists.scsys.co.uk</a>
Message-ID:
<a class="moz-txt-link-rfc2396E" href="mailto:p2o97bca8a81004160121ub04edfe2w7a74d07553633438@mail.gmail.com"><p2o97bca8a81004160121ub04edfe2w7a74d07553633438@mail.gmail.com></a>
Content-Type: text/plain; charset="iso-8859-1"
hi, all
i have a question about dbix::class 0.07006 ( i know it's old, but my
codes are base on it...). i want to add host IP of mysql db into the error
info of dbix's exception.
so that it's helpful for us to debug our codes.
i just read the doc of newest version of dbix::class (0.08121), seems it
provide a way to make a custom throw_exception myself. then i read doc of
0.07006, doesn't
see such method as 0.08121.
so, i wanna ask, is there any anything i can do to add host IP into error
info of dbix's exception of version 0.07006
any tips are appreciated. thank you !
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <a class="moz-txt-link-freetext" href="http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20100416/c43=">http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20100416/c43=</a>
7eea9/attachment-0001.htm
------------------------------
Message: 5
Date: Fri, 16 Apr 2010 08:50:57 +0000
From: Alexander Hartmaier <a class="moz-txt-link-rfc2396E" href="mailto:alexander.hartmaier@t-systems.at"><alexander.hartmaier@t-systems.at></a>
Subject: Re: [Dbix-class] can i add custom error info for
throw_exception in dbix::class 0.07006?
To: "DBIx::Class user and developer list"
<a class="moz-txt-link-rfc2396E" href="mailto:dbix-class@lists.scsys.co.uk"><dbix-class@lists.scsys.co.uk></a>
Message-ID: <1271407857.2592.22.camel@ahartmai-nb>
Content-Type: text/plain; charset="UTF-8"
Why do you not test your model with the newest DBIx::Class version and
just upgrade if everything works?
--
Best regards, Alex
Am Freitag, den 16.04.2010, 10:21 +0200 schrieb 老邪:
</pre>
<blockquote type="cite">
<pre wrap="">hi, all
i have a question about dbix::class 0.07006 ( i know it's old, but
my codes are base on it...). i want to add host IP of mysql db into
the error info of dbix's exception.
so that it's helpful for us to debug our codes.
i just read the doc of newest version of dbix::class (0.08121),
seems it provide a way to make a custom throw_exception myself. then i
read doc of 0.07006, doesn't
see such method as 0.08121.
so, i wanna ask, is there any anything i can do to add host IP into
error info of dbix's exception of version 0.07006
any tips are appreciated. thank you !
</pre>
</blockquote>
<pre wrap="">
*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*
T-Systems Austria GesmbH Rennweg 97-99, 1030 Wien
Handelsgericht Wien, FN 79340b
*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*
Notice: This e-mail contains information that is confidential and may be privileged.
If you are not the intended recipient, please notify the sender and then
delete this e-mail immediately.
*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*
------------------------------
Message: 6
Date: Fri, 16 Apr 2010 16:54:29 +0800
From: ?? <a class="moz-txt-link-rfc2396E" href="mailto:swansun95@gmail.com"><swansun95@gmail.com></a>
Subject: Re: [Dbix-class] can i add custom error info for
throw_exception in dbix::class 0.07006?
To: "DBIx::Class user and developer list"
<a class="moz-txt-link-rfc2396E" href="mailto:dbix-class@lists.scsys.co.uk"><dbix-class@lists.scsys.co.uk></a>
Message-ID:
<a class="moz-txt-link-rfc2396E" href="mailto:n2s97bca8a81004160154se67cbd04w809b4ed484d2252a@mail.gmail.com"><n2s97bca8a81004160154se67cbd04w809b4ed484d2252a@mail.gmail.com></a>
Content-Type: text/plain; charset="utf-8"
d2UgZGlkLCBvdXIgY29kZSBpcyBub3QgZ29vZCBlbm91Z2ggdG8gd29yayB3aXRoIG5ld2VzdCBk
Yml4OjpjbGFzcywgc28sCmhhdmUgdG8gc3RheSBpbiAwLjA3IHZlcnNpb24gbm93IDooCgpPbiBG
cmksIEFwciAxNiwgMjAxMCBhdCA0OjUwIFBNLCBBbGV4YW5kZXIgSGFydG1haWVyIDwKYWxleGFu
ZGVyLmhhcnRtYWllckB0LXN5c3RlbXMuYXQ+IHdyb3RlOgoKPiBXaHkgZG8geW91IG5vdCB0ZXN0
IHlvdXIgbW9kZWwgd2l0aCB0aGUgbmV3ZXN0IERCSXg6OkNsYXNzIHZlcnNpb24gYW5kCj4ganVz
dCB1cGdyYWRlIGlmIGV2ZXJ5dGhpbmcgd29ya3M/Cj4KPiAtLQo+IEJlc3QgcmVnYXJkcywgQWxl
eAo+Cj4KPiBBbSBGcmVpdGFnLCBkZW4gMTYuMDQuMjAxMCwgMTA6MjEgKzAyMDAgc2NocmllYiDo
gIHpgqo6Cj4gPiBoaSwgYWxsCj4gPiAgICAgaSBoYXZlIGEgcXVlc3Rpb24gYWJvdXQgZGJpeDo6
Y2xhc3MgMC4wNzAwNiAoIGkga25vdyBpdCdzIG9sZCwgYnV0Cj4gPiBteSBjb2RlcyBhcmUgYmFz
ZSBvbiBpdC4uLikuIGkgd2FudCB0byBhZGQgaG9zdCBJUCBvZiBteXNxbCBkYiBpbnRvCj4gPiB0
aGUgZXJyb3IgaW5mbyBvZiBkYml4J3MgZXhjZXB0aW9uLgo+ID4gc28gdGhhdCBpdCdzIGhlbHBm
dWwgZm9yIHVzIHRvIGRlYnVnIG91ciBjb2Rlcy4KPiA+ICAgIGkganVzdCByZWFkIHRoZSBkb2Mg
b2YgbmV3ZXN0IHZlcnNpb24gb2YgZGJpeDo6Y2xhc3MgKDAuMDgxMjEpLAo+ID4gc2VlbXMgaXQg
cHJvdmlkZSBhIHdheSB0byBtYWtlIGEgY3VzdG9tIHRocm93X2V4Y2VwdGlvbiBteXNlbGYuIHRo
ZW4gaQo+ID4gcmVhZCBkb2Mgb2YgMC4wNzAwNiwgZG9lc24ndAo+ID4gc2VlIHN1Y2ggbWV0aG9k
IGFzIDAuMDgxMjEuCj4gPiAgICBzbywgaSB3YW5uYSBhc2ssIGlzIHRoZXJlIGFueSBhbnl0aGlu
ZyBpIGNhbiBkbyB0byBhZGQgaG9zdCBJUCBpbnRvCj4gPiBlcnJvciBpbmZvIG9mIGRiaXgncyBl
eGNlcHRpb24gb2YgdmVyc2lvbiAwLjA3MDA2Cj4gPiAgICBhbnkgdGlwcyBhcmUgYXBwcmVjaWF0
ZWQuIHRoYW5rIHlvdSAhCj4KPgo+Cj4gKiIqIioiKiIqIioiKiIqIioiKiIqIioiKiIqIioiKiIq
IioiKiIqIioiKiIqIioiKiIqIioiKiIqIioiKiIqIioiKiIqIioiKiIqIioKPiBULVN5c3RlbXMg
QXVzdHJpYSBHZXNtYkggICBSZW5ud2VnIDk3LTk5LCAxMDMwIFdpZW4KPiBIYW5kZWxzZ2VyaWNo
dCBXaWVuLCBGTiA3OTM0MGIKPgo+ICoiKiIqIioiKiIqIioiKiIqIioiKiIqIioiKiIqIioiKiIq
IioiKiIqIioiKiIqIioiKiIqIioiKiIqIioiKiIqIioiKiIqIioiKiIqCj4gTm90aWNlOiBUaGlz
IGUtbWFpbCBjb250YWlucyBpbmZvcm1hdGlvbiB0aGF0IGlzIGNvbmZpZGVudGlhbCBhbmQgbWF5
IGJlCj4gcHJpdmlsZWdlZC4KPiBJZiB5b3UgYXJlIG5vdCB0aGUgaW50ZW5kZWQgcmVjaXBpZW50
LCBwbGVhc2Ugbm90aWZ5IHRoZSBzZW5kZXIgYW5kIHRoZW4KPiBkZWxldGUgdGhpcyBlLW1haWwg
aW1tZWRpYXRlbHkuCj4KPiAqIioiKiIqIioiKiIqIioiKiIqIioiKiIqIioiKiIqIioiKiIqIioi
KiIqIioiKiIqIioiKiIqIioiKiIqIioiKiIqIioiKiIqIioiKgo+Cj4gX19fX19fX19fX19fX19f
X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX18KPiBMaXN0OiBodHRwOi8vbGlzdHMuc2Nz
eXMuY28udWsvY2dpLWJpbi9tYWlsbWFuL2xpc3RpbmZvL2RiaXgtY2xhc3MKPiBJUkM6IGlyYy5w
ZXJsLm9yZyNkYml4LWNsYXNzCj4gU1ZOOiBodHRwOi8vZGV2LmNhdGFseXN0LnBlcmwub3JnL3Jl
cG9zL2Jhc3QvREJJeC1DbGFzcy8KPiBTZWFyY2hhYmxlIEFyY2hpdmU6Cj4gaHR0cDovL3d3dy5n
cm9rYmFzZS5jb20vZ3JvdXAvZGJpeC1jbGFzc0BsaXN0cy5zY3N5cy5jby51awo+Ci0tLS0tLS0t
LS0tLS0tIG5leHQgcGFydCAtLS0tLS0tLS0tLS0tLQpBbiBIVE1MIGF0dGFjaG1lbnQgd2FzIHNj
cnViYmVkLi4uClVSTDogaHR0cDovL2xpc3RzLnNjc3lzLmNvLnVrL3BpcGVybWFpbC9kYml4LWNs
YXNzL2F0dGFjaG1lbnRzLzIwMTAwNDE2Lzk2NWIwNmNlL2F0dGFjaG1lbnQtMDAwMS5odG0K
------------------------------
Message: 7
Date: Fri, 16 Apr 2010 10:54:19 +0100
From: Martin Evans <a class="moz-txt-link-rfc2396E" href="mailto:martin.evans@easysoft.com"><martin.evans@easysoft.com></a>
Subject: Re: [Dbix-class] New experimental development release of
DBD::ODBC 1.23_4 - faster - please test
To: "DBIx::Class user and developer list"
<a class="moz-txt-link-rfc2396E" href="mailto:dbix-class@lists.scsys.co.uk"><dbix-class@lists.scsys.co.uk></a>
Message-ID: <a class="moz-txt-link-rfc2396E" href="mailto:4BC833CB.1070800@easysoft.com"><4BC833CB.1070800@easysoft.com></a>
Content-Type: text/plain; charset=ISO-8859-1
fREW Schmidt wrote:
</pre>
<blockquote type="cite">
<pre wrap="">
On Wed, Apr 14, 2010 at 3:12 PM, Martin J. Evans
<<a class="moz-txt-link-abbreviated" href="mailto:martin.evans@easysoft.com">martin.evans@easysoft.com</a> <a class="moz-txt-link-rfc2396E" href="mailto:martin.evans@easysoft.com"><mailto:martin.evans@easysoft.com></a>> wrote:
I have just uploaded a new development release of DBD::ODBC 1.23_4 to
CPAN. This is very much an experimental release but unless I hear any
negative reports I will release this as 1.24.
Ok, we have installed this on both Linux and Strawberry perl (32 bit.)
We'll let you know if we have any issues, but so far everything is
working.
--
fREW Schmidt
<a class="moz-txt-link-freetext" href="http://blog.afoolishmanifesto.com">http://blog.afoolishmanifesto.com</a>
------------------------------------------------------------------------
_______________________________________________
List: <a class="moz-txt-link-freetext" href="http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class">http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class</a>
IRC: irc.perl.org#dbix-class
SVN: <a class="moz-txt-link-freetext" href="http://dev.catalyst.perl.org/repos/bast/DBIx-Class/">http://dev.catalyst.perl.org/repos/bast/DBIx-Class/</a>
Searchable Archive: <a class="moz-txt-link-freetext" href="http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk">http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk</a>
</pre>
</blockquote>
<pre wrap="">
Thanks for letting me know fREW.
So far I have an unconfirmed report of a memory leak but sometimes these
are in the drivers and not DBI/DBD::ODBC.
Martin
</pre>
</blockquote>
</body>
</html>