Re: [SL] Bizarre copy of ARRAY and.... Attempt to free unreferenced scalar etc

[Roy P <or...@sh...>]

On April 17, 2008 01:45:33 pm Roy W Pennington wrote:
> These problems that have recently been posted in the list seem to be due to
> a new version of either DBI     DBD-PG    perl or postgresql
>
> I'm running Version 2.6.27 and everything worked fine on mandriva 2008.
>
> I just upgraded to mandriva 2008.1 spring to try solve a DVD burner
> problem.
>
> Now I get the "....Attempt to free unreferenced scalar....." error when
> printing.
>
> I get this error when "posting as new" invoices...
>
> DBD::Pg::db do failed: ERROR: syntax error at or near ")"
> LINE 4: '04-03-2008', NULL, )
> ^ at SL/IS.pm line 854.
>
>
> a bit of testing with 2.8 and even with dieter's fix...
> http://abacus.sql-ledger.com/userforum/forum_entry.php?id=911
>
> i get the bizarre copy of array error as noted in this thread.
> http://abacus.sql-ledger.com/userforum/forum_entry.php?id=941
>
> previously running
> postgresql 8.2.6
> perl-DBD-pg-1.49
> perl-DBI 1.59
>
> now running
> postgresql 8.2.7
> perl-DBD-pg 2.2.2
> perl-DBI 1.601
>
> I suspect it's an DBD/DBI issue
> anyone narrow this down ?
>

On more investigation...
I tested postgresql 8.2.6 and 8.3 with a clean install and still no luck.
So it appears this is due to Perl 5.10, DBI 1.601, or DBD-pg 2.2.2.

I'll try getting the latest DBI and DBD-pg from cpan to see if that fixes it.

Any ideas ?
Roy