Patch for Bug 1227 Cross Sites

We are running into the error message described in Bug 1227
and cannot revert
back to the 1.10.1 as a workaround.  I tried patching based
on the old email
thread based on 1.8.6 and for a while it did seem to work as
long as it was
in one site.  However, the bug is back when associating a
story between
sites.  Anyone have any thoughts on this or should I file
another bug report?

Thanks,

Chris

Chris Heiland
Web Developer
425.352.3658
Web Services
Information Systems, Campus Box 358540
University of Washington Bothell

On Jan 26, 2007, at 10:05 AM, Chris Heiland wrote:

> We are running into the error message described in Bug
1227 and  
> cannot revert
> back to the 1.10.1 as a workaround.  I tried patching
based on the  
> old email
> thread based on 1.8.6 and for a while it did seem to
work as long  
> as it was
> in one site.  However, the bug is back when associating
a story  
> between
> sites.  Anyone have any thoughts on this or should I
file another  
> bug report?

According to that bug report (and the link I posted
yesterday), that  
bug has been fixed. Try applying this patch:

   http://viewsvn.bricolage.cc/bricolage/branches/
rev_1_10/lib/Bric/ 
Dist/Resource.pm?r1=7760&r2=7759&pathrev=7760&vi
ew=patch

Best,

David

-----Original Message-----
From: David E. Wheeler [mailto:davidkineticode.com] 
Sent: Friday, January 26, 2007 10:10 AM
To: userslists.bricolage.cc
Subject: Re: Patch for Bug 1227 Cross Sites

On Jan 26, 2007, at 10:05 AM, Chris Heiland wrote:

> We are running into the error message described in Bug
1227 and cannot 
> revert back to the 1.10.1 as a workaround.  I tried
patching based on 
> the old email thread based on 1.8.6 and for a while it
did seem to 
> work as long as it was in one site.  However, the bug
is back when 
> associating a story between sites.  Anyone have any
thoughts on this 
> or should I file another bug report?

According to that bug report (and the link I posted
yesterday), that bug has
been fixed. Try applying this patch:

   http://viewsvn.bricolage.cc/bricolage/branches/
rev_1_10/lib/Bric/
Dist/Resource.pm?r1=7760&r2=7759&pathrev=7760&vi
ew=patch

Best,

David

I applied the patch and it did fix the error as long as I
was within a site.
I am including the stack trace below.  I still have some
more testing to do,
but I thought I would see if anyone has seen it.

[Thu Jan 25 21:40:42 2007] [error] [client xxx.xxx.xxx.xxx]
Unable to execute
SQL statement: DBD::Pg::st execute failed: ERROR:  duplicate
key violates
unique constraint "pk_job__resource"n [for
Statement "n            INSERT
INTO job__resource (job__id, resource__id)n           
VALUES (?, ?)n
" with ParamValues: 1='59047', 2='1575'] at
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1083,
<GEN105> line
151.nnStack:n 
[/usr/local/bricolage/lib/Bric/Util/DBI.pm:1083]n
[/usr/local/bricolage/lib/Bric/Util/Coll/Resource.pm:188]n
[/usr/local/bricolage/lib/Bric/Util/Job.pm:1798]n
[/usr/local/bricolage/lib/Bric/Util/Burner.pm:988]n
[/usr/local/bricolage/lib/Bric/Util/Burner.pm:1084]n
[/usr/local/bricolage/lib/Bric/Util/Burner.pm:1118]n
[/usr/local/bricolage/lib/Bric/Util/Burner.pm:1154]n
[/usr/local/bricolage/data/burn/sandbox/user_1024/oc_1036/au
tohandler:128]n
[/usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Component.pm:135]
n
[/usr/local/bricolage/lib/Bric/Util/DBI.pm:1084]
[/usr/local/bricolage/lib/Bric/Util/Coll/Resource.pm:188]
[/usr/local/bricolage/lib/Bric/Util/Job.pm:1798]
[/usr/local/bricolage/lib/Bric/Util/Burner.pm:988]
[/usr/local/bricolage/lib/Bric/Util/Burner.pm:1084]
[/usr/local/bricolage/lib/Bric/Util/Burner.pm:1118]
[/usr/local/bricolage/lib/Bric/Util/Burner.pm:1154]
[/usr/local/bricolage/data/burn/sandbox/user_1024/oc_1036/au
tohandler:128]
[/usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Component.pm:135]

[/usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm:1251]
[/usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm:460]
[/usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Interp.pm:342]
[/usr/local/bricolage/lib/Bric/Util/Burner/Mason.pm:268]
[/usr/local/bricolage/lib/Bric/Util/Burner.pm:1493]
[/usr/local/bricolage/lib/Bric/Util/Burner.pm:967]
[/usr/local/bricolage/lib/Bric/App/Callback/Publish.pm:117]
[/usr/local/bricolage/comp/workflow/profile/preview/dhandler
:36]
[/usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Component.pm:135]

[/usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm:1256]
[/usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm:915]
[/usr/local/bricolage/comp/autohandler:7]
[/usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Component.pm:135]

[/usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm:1251]
[/usr/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm:460]
[/usr/lib/perl5/site_perl/5.8.5/HTML/Mason/ApacheHandler.pm:
168]
[/usr/lib/perl5/site_perl/5.8.5/HTML/Mason/ApacheHandler.pm:
826]
[/usr/local/bricolage/lib/Bric/App/Handler.pm:311]

Thanks,

Chris

On Jan 26, 2007, at 11:01 AM, Chris Heiland wrote:

> I applied the patch and it did fix the error as long as
I was  
> within a site.
> I am including the stack trace below.  I still have
some more  
> testing to do,
> but I thought I would see if anyone has seen it.

Ah, no. Sorry for the confusion. Would you be so kind as to
file a  
bur report?

   http://bugs.bricolage.cc/

Please include a reference to the original fix.

Thanks,

David

Bug Filed:

http://
bugs.bricolage.cc/show_bug.cgi?id=1266

Chris

-----Original Message-----
From: David E. Wheeler [mailto:davidkineticode.com] 
Sent: Monday, January 29, 2007 10:11 AM
To: userslists.bricolage.cc
Subject: Re: Patch for Bug 1227 Cross Sites

On Jan 26, 2007, at 11:01 AM, Chris Heiland wrote:

> I applied the patch and it did fix the error as long as
I was within a 
> site.
> I am including the stack trace below.  I still have
some more testing 
> to do, but I thought I would see if anyone has seen
it.

Ah, no. Sorry for the confusion. Would you be so kind as to
file a bur
report?

   http://bugs.bricolage.cc/

Please include a reference to the original fix.

Thanks,

David

On Jan 29, 2007, at 2:47 PM, Chris Heiland wrote:

> Bug Filed:
>
> http://
bugs.bricolage.cc/show_bug.cgi?id=1266

Thanks.

David