Re: [SL] Sometimes can't print Sales Orders or Invoices

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

Hello List,

I have received a solution to this problem and I will share it with you. I was 
sent a patch by a fellow, Justin Wheeler, but I don't know how to apply the 
patch so I asked and this is the reply:

______________________________

Go into your sql ledger directory and go to the SL/Form.pm file.

Look for line 1007 which should be:

$str = $self->{$var}[$i];

Change it to say:

my $ary_ref = $self->{ $var };
$str = defined $ary_ref->[ $i ] ? $ary_ref->[ $i ] : q{};

That should fix it up.

Of course, back up the file before you modify it, and put it back if it breaks 
something.

_________________________________

Now, I do have the patch and I don't see why I shouldn't send it to anyone who 
asks for it by contacting me offline. This has worked for me and I'm grateful 
to Mr. Wheeler for the solution.

________________________

Nicholas Thirkettle, OSB

Saint Joseph's Monastery
Natchez, MS 39120

www.osbms.org
________________________

On Saturday 07 March 2009 01:43:55 Michael Hasse wrote:
> It's easy to sell things that aren't in inventory, we do it all the
> time when parts come in last minute for a project with a tight
> schedule.  The system handles it just fine as a negative inventory
> quantity.
>     Not to mention having had new employees do some truly bizarre and
> creative stuff when trying to create, correct and/or sell assemblies
> with wrong parts and/or new parts I strongly doubt this is the cause
> of the issue as we've never seen this kind of thing come up before.
>
>
> Thanks,
>
> Michael
>
>
> On Mar 6, 2009, at 10:18 PM, Paul Tammes wrote:
>
> Keep using articles, but do it right.
>
> I would strongly advise to not change existing articles, but copy
> them (save
> as new) and then do some changing.
> So "PC c2d version 1" could be saved as new, e.g. "PC c4d version 1".
> THEN change the CPU in the assembly to a quadcore. That way, you will
> not
> try to sell or assemble a PC with a quadcore IN THE PAST while
> quadcore was
> not available.
>
> No wonder you can not get the invice to print. The item (or part of the
> assembly) was not at hand, so how could u have sold it to begin with?
>
> Maybe you could even do the new article bit now, setting original
> article
> back.
> Re-try the sales and if that works, make a new article.
>
> Basic idea: The flow of goods trough the accounting depratment should
> match
> the real world. If you do that, this kind of problem woul dnot arise
> again I
> take it.
> (Other kinds of problems will take their place, not to worry)
>
> Hth
>
> 2009/3/6 Nicholas Thirkettle OSB <brn...@os...>
>
> > I have a feeling that it may be something to do with the inventory
> > in my
> > case.
> > This problem started about the time that we changed the formula for
> > one of
> > the
> > products that we make. I have tried to recreate invoices using both
> > old and
> > new formulas and it happens only on the invoices that have the new
> > formula.
> > I'm about to give it up because a few days ago I was asked for
> > Departmental
> > Income Statements for last year and I realized that they always
> > specify
> > Cash
> > Basis. I think I may just set up all products as services and just
> > do a
> > manual
> > inventory periodically. The problem is that we won't be aware when
> > items
> > are
> > taken out of the shop and not written down. We only report and pay
> > taxes we
> > collect in the State of Mississippi so it would probably be a much
> > simpler
> > solution. Anyone see any potential problems with this?
> >
> > Br. Nicholas
> > --
> > ________________________
> >
> > Nicholas Thirkettle, OSB
> >
> > Saint Joseph's Monastery
> > Natchez, MS 39120
> >
> > www.osbms.org
> >
> > On Friday 06 March 2009 01:54:08 Paul Tammes wrote:
> >> The 'sometimes' part is evil. A problem that only hick ups now and
> >> then
> >
> > is
> >
> >> extremely hard to find, let alone solve. One wild guess: do the
> >> names of
> >> customers with print errors have any strange letters or signs, like
> >> unmlauts, # or ë?
> >> I seem to remember people with problems that disappeared when
> >> renamed to
> >
> > e
> >
> >> instead of ë. Or something silly like a space too much at the
> >> beginning
> >
> > of
> >
> >> the name, so" Jansen" iso "Jansen" might be cooking things up.
> >>
> >> Hth
> >>
> >> 2009/3/5 C. Duncan Hudson <du...@du...>
> >>
> >>> I'm having the same problem.  Not on every invoice, but frequently
> >>> enough that it's a major issue.
> >>> We're running SQL-Ledger 2.8.23, Fedora 10, Perl 5.10.0, Postgres
> >>> 8.3.4.1, and Apache 2.2.10.
> >>> I've spoken to Dieter about this and he insists that it's a Perl
> >>> problem.  I don't really care if it's
> >>> a Perl problem, or a Perl coding problem, but I need a solution
> >>> because
> >>> right now I can't
> >>> invoice all my customers.
> >>>
> >>> Dunc
> >>>
> >>> Nicholas Thirkettle OSB wrote:
> >>>> Hello,
> >>>>
> >>>> Sometimes when I try to print Sales Orders or Invoices I get the
> >>>
> >>> following
> >>>
> >>>> error:
> >>>>
> >>>> panic: attempt to copy freed scalar c3a488 to 8e4178 at SL/Form.pm
> >
> > line
> >
> >>> 1007
> >>>
> >>>> I have tried searching for a solution in the forums and I have
> >>>> found
> >
> > a
> >
> >>> similar
> >>>
> >>>> problem a number of versions ago. I haven't actually found a
> >
> > solution.
> >
> >>>> I
> >>>
> >>> am
> >>>
> >>>> using SQL-Ledger Version 2.8.23 and I believe that is the most
> >
> > recent.
> >
> >>> Some
> >>>
> >>>> inovices print just fine. I read that it is when an invoice has
> >>>> more
> >>>> than
> >>>
> >>> 4
> >>>
> >>>> lines and the invoice I'm having trouble with right now has 8. I
> >
> > tried
> >
> >>>> deleting all the lines except for 3 but I still have the problem.
> >>>>
> >>>> openSuse 11.0
> >>>> perl 5.10.0-37.6
> >>>> SQL-Ledger 2.8.23
> >>>>
> >>>> Any help is appreciated.
> >>>>
> >>>> Br. Nicholas
> >
> > ----------------------------------------------------------------------
> > ---
> >
> >>> ----- Open Source Business Conference (OSBC), March 24-25, 2009, San
> >>> Francisco, CA
> >>> -OSBC tackles the biggest issue in open source: Open Sourcing the
> >>> Enterprise
> >>> -Strategies to boost innovation and cut costs with open source
> >>> participation
> >>> -Receive a $600 discount off the registration fee with the source
> >>> code:
> >>> SFAD
> >>> http://p.sf.net/sfu/XcvMzF8H
> >>> _______________________________________________
> >>> sql-ledger-users mailing list
> >>> sql...@li...
> >>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> >
> > ----------------------------------------------------------------------
> > -----
> >
> >> --- Open Source Business Conference (OSBC), March 24-25, 2009, San
> >> Francisco, CA -OSBC tackles the biggest issue in open source: Open
> >
> > Sourcing
> >
> >> the Enterprise -Strategies to boost innovation and cut costs with
> >> open
> >> source participation -Receive a $600 discount off the registration
> >> fee
> >
> > with
> >
> >> the source code: SFAD http://p.sf.net/sfu/XcvMzF8H
> >> _______________________________________________
> >> sql-ledger-users mailing list
> >> sql...@li...
> >> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> >
> > ________________________
> >
> >
> >
> > ----------------------------------------------------------------------
> > --------
> > Open Source Business Conference (OSBC), March 24-25, 2009, San
> > Francisco,
> > CA
> > -OSBC tackles the biggest issue in open source: Open Sourcing the
> > Enterprise
> > -Strategies to boost innovation and cut costs with open source
> > participation
> > -Receive a $600 discount off the registration fee with the source
> > code:
> > SFAD
> > http://p.sf.net/sfu/XcvMzF8H
> > _______________________________________________
> > sql-ledger-users mailing list
> > sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
> ------------------------------------------------------------------------
> ------
> Open Source Business Conference (OSBC), March 24-25, 2009, San
> Francisco, CA
> -OSBC tackles the biggest issue in open source: Open Sourcing the
> Enterprise
> -Strategies to boost innovation and cut costs with open source
> participation
> -Receive a $600 discount off the registration fee with the source
> code: SFAD
> http://p.sf.net/sfu/XcvMzF8H
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>
> ---------------------------------------------------------------------------
>--- Open Source Business Conference (OSBC), March 24-25, 2009, San
> Francisco, CA -OSBC tackles the biggest issue in open source: Open Sourcing
> the Enterprise -Strategies to boost innovation and cut costs with open
> source participation -Receive a $600 discount off the registration fee with
> the source code: SFAD http://p.sf.net/sfu/XcvMzF8H
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users