sql-ledger-users — SQL-Ledger users

Re: [SL] Upgrading database error: drop trigger del_recurring ON oe

[Armaghan S. <sa...@le...>]

Yes, this should have no effect on your installation. This statement
only attempts to remove a non-existing trigger.

It seems that server side database functionality (procedures and
triggers written in plpgsql) has been removed in the latest version.

Regards

Armaghan Saqib

http://www.ledger123.com


On 12/8/07, Prem Pradeep <pre...@gm...> wrote:
> Got this error message when logging into the upgraded SL.
>
> Upgrading to Version 2.8.8 ...
> Error!
> drop trigger del_recurring ON oe
> ERROR: trigger "del_recurring" for table "oe" does not exist
>
> What does it mean?
>
> Anyway, after that, I had to unlock the program two times, and after that it
> all functions wel.
> Well..at least I hope so, or would the error message have some permanent
> impact
>
> Any ideas?
> Thanks
> Prem
> -------------------------------------------------------------------------
> SF.Net email is sponsored by:
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services for
> just about anything Open Source.
> http://sourceforge.net/services/buy/index.php
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

Re: [SL] How do I configure SQL-Ledger to use a smarthost for all outbound e-mail?

[Stroller <lin...@my...>]

I previously sent this a couple of days ago, but it doesn't seem to  
have appeared on the list?


On 6 Dec 2007, at 22:06, Colin Manning wrote:
> ...
> So, how do I configure SQL-Ledger to use a smarthost for all outbound
> e-mail?

ssmtp is how I'd do it:

$ eix ssmtp
* mail-mta/ssmtp
      Available versions:  2.61-r2 [M]~2.61-r30 [M]~2.61-r31 {ipv6  
mailwrapper md5sum ssl}
      Homepage:            ftp://ftp.debian.org/debian/pool/main/s/ 
ssmtp/
      Description:         Extremely simple MTA to get mail off the  
system to a Mailhub
$

Stroller.

[SL] Upgrading database error: drop trigger del_recurring ON oe

[Prem P. <pre...@gm...>]

Got this error message when logging into the upgraded SL.

Upgrading to Version 2.8.8 ...
Error!
drop trigger del_recurring ON oe
ERROR: trigger "del_recurring" for table "oe" does not exist

What does it mean?

Anyway, after that, I had to unlock the program two times, and after that it
all functions wel.
Well..at least I hope so, or would the error message have some permanent
impact

Any ideas?
Thanks
Prem

Re: [SL] How do I configure SQL-Ledger to use a smarthost for all outbound e-mail?

[Michael H. <mh...@it...>]

This isn't really a SQL-Ledger question as it depends on the local  
mail configuration for that machine.  That said, if we can have a bit  
more info about the machine perhaps somebody will have a quick and  
easy answer.


Thanks,

Michael


On Dec 6, 2007, at 2:06 PM, Colin Manning wrote:

> I now have a virtual machine dedicated to SQL-Ledger. However due to
> everyone's SPAM controls, I cannot deliver mail from this machine, as
> the name does not resolve :-(.
>
> So, how do I configure SQL-Ledger to use a smarthost for all outbound
> e-mail?
>
>
> ---------------------------------------------------------------------- 
> ---
> SF.Net email is sponsored by:
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services for
> just about anything Open Source.
> http://sourceforge.net/services/buy/index.php
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] How do I configure SQL-Ledger to use a smarthost for all outbound e-mail?

[Stroller <lin...@my...>]

On 6 Dec 2007, at 22:06, Colin Manning wrote:
> ...
> So, how do I configure SQL-Ledger to use a smarthost for all outbound
> e-mail?

ssmtp is how I'd do it:

$ eix ssmtp
* mail-mta/ssmtp
      Available versions:  2.61-r2 [M]~2.61-r30 [M]~2.61-r31 {ipv6  
mailwrapper md5sum ssl}
      Homepage:            ftp://ftp.debian.org/debian/pool/main/s/ 
ssmtp/
      Description:         Extremely simple MTA to get mail off the  
system to a Mailhub
$

Stroller.

[SL] How do I configure SQL-Ledger to use a smarthost for all outbound e-mail?

[Colin M. <co...@it...>]

I now have a virtual machine dedicated to SQL-Ledger. However due to =

everyone's SPAM controls, I cannot deliver mail from this machine, as =

the name does not resolve :-(.

So, how do I configure SQL-Ledger to use a smarthost for all outbound =

e-mail?

Re: [SL] HASH Reference error when printing or e-mailing

[Colin M. <co...@it...>]

Thanks for this tip Trevor,

I installed vmware player and run fc6 for there just for SL till this 
gets resolved.

Trevor Hennion wrote:
> Colin,
>
> This bit me this afternoon and it is due to an upgrade of Perl on 
> Fedora7 and Fedora8.
>
> I tried some fix suggested in the support forum but it didn't work.
>
> To make sure I could get invoices out this afternoon I had to install 
> SQL-Ledger on another box running Fedora5, without the updated Perl 
> version, and that worked OK.
>
> If this doesn't get fixed soon a lot more people will feel the pain.
>
> Regards
>
> Trevor Hennion
>
>   

Re: [SL] HASH Reference error when printing or e-mailing

[Colin M. <co...@it...>]

i.e. lines 1375 - 1390

Colin Manning wrote:
> If I comment out the offending lines in OE.pm I get the following output.
>
> Take note of the Order Number.
>
>
> Don't know if this is a red herring, or useful information....
>
>
>         I.T. Navigate Pty Ltd
>         PO Box 562
>         Bakers Hill Western Australia 6562
>
> 		
>
>
>         Tel: 08 9574 0200
>         Fax: 08 9574 0201
>
> ------------------------------------------------------------------------
>
> 	
>
>
>         S A L E S O R D E R
>
> 	
> To 	Ship To
> Client 	Client
>
> 	
> Order # 	Order Date 	Required by 	Salesperson 	Shipping Point 	Ship Via
> 1 	29/11/2007 	
> 	Colin Manning 		
>
> 	
> Item 	Number 	Description 	Qt'y 		Price 	Disc % 	Amount
> 1. 	B/H Consulting 	Business Hours Consulting : 	4 	Hours 	1.00 	
> 	4.00
> 20051101. 	B/H Consulting 	Business Hours Consulting :
>
> 	9 	Hours 	1.00 	
> 	9.00
> 20101101. 	B/H Consulting 	Business Hours Consulting :
>
> 	3 	Hours 	1.00 	
> 	3.00
> ------------------------------------------------------------------------
> Subtotal 	16.00
> OUTPUT GST on 16.00 @ 10 % 	1.60
> 	
> ------------------------------------------------------------------------
> Seventeen ***** 60/100
> Terms Net *7* days 	Total 	17.60
>
> 	
> All prices in AUD Funds
>
> 	
> Special order items are subject to a 10% order cancellation fee. 	X
>
>
>
>
> Dieter Simader wrote:
>   
>> On Mon, 3 Dec 2007, Trevor Hennion wrote:
>>
>>   
>>     
>>> Dieter Simader wrote:
>>>     
>>>       
>>>> On Mon, 3 Dec 2007, Trevor Hennion wrote:
>>>>
>>>>       
>>>>         
>>>>> Colin,
>>>>>
>>>>> This bit me this afternoon and it is due to an upgrade of Perl on
>>>>> Fedora7 and Fedora8.
>>>>>
>>>>> I tried some fix suggested in the support forum but it didn't work.
>>>>>
>>>>> To make sure I could get invoices out this afternoon I had to install
>>>>> SQL-Ledger on another box running Fedora5, without the updated Perl
>>>>> version, and that worked OK.
>>>>>
>>>>> If this doesn't get fixed soon a lot more people will feel the pain.
>>>>>         
>>>>>           
>>>> change the code in OE.pm on line 1375 to
>>>>
>>>> # adjust taxes for lineitems
>>>> my $total = 0;
>>>> for my $ref (@{ $form->{lineitems} }) {
>>>>    $total += $ref->{tax};
>>>> }
>>>>
>>>> report back if perl still barfs after the change.
>>>>
>>>>       
>>>>         
>>> Dieter,
>>>
>>> Thanks for the reply, however I'm sorry to say it didn't work.
>>> Still get:
>>>
>>> Error!
>>> Not a HASH reference at SL/IS.pm line 395.
>>> Attempt to free unreferenced scalar: SV 0x944bfb8, Perl interpreter:
>>> 0x8d45008 at SL/IS.pm line 395.
>>>     
>>>       
>> OE.pm and IS.pm are two different things. This particular code construct 
>> also exists in other modules, so let's not test something you have not 
>> made changes to. Of course there will still be an error if you haven't 
>> made the change yet.
>>
>> So, please edit IS.pm and make the change and report back or try to print 
>> an order with the changed OE.pm file. If printing an order works we change 
>> all the other occurances where this code construct exists in the code. 
>> clear as mud?
>>
>> -------------------------------------------------------------------------
>> SF.Net email is sponsored by: The Future of Linux Business White Paper
>> from Novell.  From the desktop to the data center, Linux is going
>> mainstream.  Let it simplify your IT future.
>> http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4
>> _______________________________________________
>> sql-ledger-users mailing list
>> sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>   
>>     
>
> -------------------------------------------------------------------------
> SF.Net email is sponsored by: The Future of Linux Business White Paper
> from Novell.  From the desktop to the data center, Linux is going
> mainstream.  Let it simplify your IT future.
> http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>   

Re: [SL] HASH Reference error when printing or e-mailing

[Colin M. <co...@it...>]

If I comment out the offending lines in OE.pm I get the following output.

Take note of the Order Number.


Don't know if this is a red herring, or useful information....


        I.T. Navigate Pty Ltd
        PO Box 562
        Bakers Hill Western Australia 6562

		


        Tel: 08 9574 0200
        Fax: 08 9574 0201

------------------------------------------------------------------------

	


        S A L E S O R D E R

	
To 	Ship To
Client 	Client

	
Order # 	Order Date 	Required by 	Salesperson 	Shipping Point 	Ship Via
1 	29/11/2007 	
	Colin Manning 		

	
Item 	Number 	Description 	Qt'y 		Price 	Disc % 	Amount
1. 	B/H Consulting 	Business Hours Consulting : 	4 	Hours 	1.00 	
	4.00
20051101. 	B/H Consulting 	Business Hours Consulting :

	9 	Hours 	1.00 	
	9.00
20101101. 	B/H Consulting 	Business Hours Consulting :

	3 	Hours 	1.00 	
	3.00
------------------------------------------------------------------------
Subtotal 	16.00
OUTPUT GST on 16.00 @ 10 % 	1.60
	
------------------------------------------------------------------------
Seventeen ***** 60/100
Terms Net *7* days 	Total 	17.60

	
All prices in AUD Funds

	
Special order items are subject to a 10% order cancellation fee. 	X




Dieter Simader wrote:
> On Mon, 3 Dec 2007, Trevor Hennion wrote:
>
>   
>> Dieter Simader wrote:
>>     
>>> On Mon, 3 Dec 2007, Trevor Hennion wrote:
>>>
>>>       
>>>> Colin,
>>>>
>>>> This bit me this afternoon and it is due to an upgrade of Perl on
>>>> Fedora7 and Fedora8.
>>>>
>>>> I tried some fix suggested in the support forum but it didn't work.
>>>>
>>>> To make sure I could get invoices out this afternoon I had to install
>>>> SQL-Ledger on another box running Fedora5, without the updated Perl
>>>> version, and that worked OK.
>>>>
>>>> If this doesn't get fixed soon a lot more people will feel the pain.
>>>>         
>>> change the code in OE.pm on line 1375 to
>>>
>>> # adjust taxes for lineitems
>>> my $total = 0;
>>> for my $ref (@{ $form->{lineitems} }) {
>>>    $total += $ref->{tax};
>>> }
>>>
>>> report back if perl still barfs after the change.
>>>
>>>       
>> Dieter,
>>
>> Thanks for the reply, however I'm sorry to say it didn't work.
>> Still get:
>>
>> Error!
>> Not a HASH reference at SL/IS.pm line 395.
>> Attempt to free unreferenced scalar: SV 0x944bfb8, Perl interpreter:
>> 0x8d45008 at SL/IS.pm line 395.
>>     
>
> OE.pm and IS.pm are two different things. This particular code construct 
> also exists in other modules, so let's not test something you have not 
> made changes to. Of course there will still be an error if you haven't 
> made the change yet.
>
> So, please edit IS.pm and make the change and report back or try to print 
> an order with the changed OE.pm file. If printing an order works we change 
> all the other occurances where this code construct exists in the code. 
> clear as mud?
>
> -------------------------------------------------------------------------
> SF.Net email is sponsored by: The Future of Linux Business White Paper
> from Novell.  From the desktop to the data center, Linux is going
> mainstream.  Let it simplify your IT future.
> http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>   

Re: [SL] HASH Reference error when printing or e-mailing

[Colin M. <co...@it...>]

Hmm...

Same error.

Dieter Simader wrote:
> On Mon, 3 Dec 2007, Trevor Hennion wrote:
>
>   
>> Colin,
>>
>> This bit me this afternoon and it is due to an upgrade of Perl on
>> Fedora7 and Fedora8.
>>
>> I tried some fix suggested in the support forum but it didn't work.
>>
>> To make sure I could get invoices out this afternoon I had to install
>> SQL-Ledger on another box running Fedora5, without the updated Perl
>> version, and that worked OK.
>>
>> If this doesn't get fixed soon a lot more people will feel the pain.
>>     
>
> change the code in OE.pm on line 1375 to
>
> # adjust taxes for lineitems
> my $total = 0;
> for my $ref (@{ $form->{lineitems} }) {
>    $total += $ref->{tax};
> }
>
> report back if perl still barfs after the change.
>
> -------------------------------------------------------------------------
> SF.Net email is sponsored by: The Future of Linux Business White Paper
> from Novell.  From the desktop to the data center, Linux is going
> mainstream.  Let it simplify your IT future.
> http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>   

Re: [SL] HASH Reference error when printing or e-mailing

[Dieter S. <dsi...@sq...>]

On Mon, 3 Dec 2007, Trevor Hennion wrote:

> Dieter Simader wrote:
>> On Mon, 3 Dec 2007, Trevor Hennion wrote:
>>
>>> Colin,
>>>
>>> This bit me this afternoon and it is due to an upgrade of Perl on
>>> Fedora7 and Fedora8.
>>>
>>> I tried some fix suggested in the support forum but it didn't work.
>>>
>>> To make sure I could get invoices out this afternoon I had to install
>>> SQL-Ledger on another box running Fedora5, without the updated Perl
>>> version, and that worked OK.
>>>
>>> If this doesn't get fixed soon a lot more people will feel the pain.
>>
>> change the code in OE.pm on line 1375 to
>>
>> # adjust taxes for lineitems
>> my $total = 0;
>> for my $ref (@{ $form->{lineitems} }) {
>>    $total += $ref->{tax};
>> }
>>
>> report back if perl still barfs after the change.
>>
>
> Dieter,
>
> Thanks for the reply, however I'm sorry to say it didn't work.
> Still get:
>
> Error!
> Not a HASH reference at SL/IS.pm line 395.
> Attempt to free unreferenced scalar: SV 0x944bfb8, Perl interpreter:
> 0x8d45008 at SL/IS.pm line 395.

OE.pm and IS.pm are two different things. This particular code construct 
also exists in other modules, so let's not test something you have not 
made changes to. Of course there will still be an error if you haven't 
made the change yet.

So, please edit IS.pm and make the change and report back or try to print 
an order with the changed OE.pm file. If printing an order works we change 
all the other occurances where this code construct exists in the code. 
clear as mud?

Re: [SL] HASH Reference error when printing or e-mailing

[Trevor H. <tre...@th...>]

Dieter Simader wrote:
> On Mon, 3 Dec 2007, Trevor Hennion wrote:
> 
>> Colin,
>>
>> This bit me this afternoon and it is due to an upgrade of Perl on
>> Fedora7 and Fedora8.
>>
>> I tried some fix suggested in the support forum but it didn't work.
>>
>> To make sure I could get invoices out this afternoon I had to install
>> SQL-Ledger on another box running Fedora5, without the updated Perl
>> version, and that worked OK.
>>
>> If this doesn't get fixed soon a lot more people will feel the pain.
> 
> change the code in OE.pm on line 1375 to
> 
> # adjust taxes for lineitems
> my $total = 0;
> for my $ref (@{ $form->{lineitems} }) {
>    $total += $ref->{tax};
> }
> 
> report back if perl still barfs after the change.
> 

Dieter,

Thanks for the reply, however I'm sorry to say it didn't work.
Still get:

Error!
Not a HASH reference at SL/IS.pm line 395.
Attempt to free unreferenced scalar: SV 0x944bfb8, Perl interpreter: 
0x8d45008 at SL/IS.pm line 395.


This is a link to the recent Perl upgrade http://lwn.net/Alerts/258413/
Doesn't mean much to me!

Regards

Trevor

-- 
Infocentrality Ltd
http://www.infocentrality.co.uk

Re: [SL] HASH Reference error when printing or e-mailing

[Dieter S. <dsi...@sq...>]

On Mon, 3 Dec 2007, Trevor Hennion wrote:

> Colin,
>
> This bit me this afternoon and it is due to an upgrade of Perl on
> Fedora7 and Fedora8.
>
> I tried some fix suggested in the support forum but it didn't work.
>
> To make sure I could get invoices out this afternoon I had to install
> SQL-Ledger on another box running Fedora5, without the updated Perl
> version, and that worked OK.
>
> If this doesn't get fixed soon a lot more people will feel the pain.

change the code in OE.pm on line 1375 to

# adjust taxes for lineitems
my $total = 0;
for my $ref (@{ $form->{lineitems} }) {
   $total += $ref->{tax};
}

report back if perl still barfs after the change.

Re: [SL] HASH Reference error when printing or e-mailing

[Trevor H. <tre...@th...>]

Colin,

This bit me this afternoon and it is due to an upgrade of Perl on 
Fedora7 and Fedora8.

I tried some fix suggested in the support forum but it didn't work.

To make sure I could get invoices out this afternoon I had to install 
SQL-Ledger on another box running Fedora5, without the updated Perl 
version, and that worked OK.

If this doesn't get fixed soon a lot more people will feel the pain.

Regards

Trevor Hennion

-- 
Infocentrality Ltd
http://www.infocentrality.co.uk


Colin Manning wrote:
> Thanks for the reply Michael.
> 
> Data was not migrated.
> 
> If I create a new database and create only one customer and one service 
> and then try and invoice or a sales order I get a HASH reference error.
> 
> Has anyone had SL working with Fedora 8? Fedora 7? perl-5.8.8?
> 
> Permissions are as set by setup.pl, and checked against the FAQ.
> 
> Colin.
> 
> Michael Hasse wrote:
>> If it was migrated from an old machine maybe it's something simple  
>> like a file or folder with bad permissions...?
>>
>>
>> Thanks,
>>
>> Michael
>>
>>
>> On Dec 2, 2007, at 12:10 AM, Colin Manning wrote:
>>
>>   
>>> Hi All,
>>>
>>> I have narrowed my problem down to something to do with tax.
>>>
>>> Lines 1375 - 1379 from OE.pm:
>>>
>>> # adjust taxes for lineitems
>>> my $total = 0;
>>> for (@{ $form->{lineitems} }) {
>>> $total += $_->{tax};
>>> }
>>>
>>> I had this all working before my old machine died, but I just can't  
>>> get
>>> this working. - very frustrating - invoices are keyed in (as sales
>>> orders), but I can't print, so can I get paid :-(.
>>>
>>> Please help.
>>>
>>>
>>> I have set up the taxes correctly in the system ==> taxes page, and  
>>> set
>>> my ABN in the system --> defaults page - any hints please?
>>>
>>>
>>>
>>>
>>>
>>> Colin Manning wrote:
>>>     
>>>> Thanks Michael.
>>>>
>>>> I've searched the mailing list for "hash reference" and "unreferenced
>>>> scalar" and didn't find any solutions. the second search returned  
>>>> this
>>>> thread and a similar (unanswered) post on 2007-10-22.
>>>>
>>>> is perl-5.8.8 supported?
>>>>
>>>> I'm using postgresql-8.2.5-1.fc8
>>>>
>>>> I have done a default install - using setup.pl to my fedora 8 box.
>>>> Create one dataset and one user (administrator type), one client  
>>>> and one
>>>> service.
>>>>
>>>> Try to print (even HTML) and it errors.
>>>>
>>>> I have not performed any customisation.
>>>>
>>>> Any further ideas?
>>>>
>>>>
>>>>
>>>>
>>>> Michael Hasse wrote:
>>>>
>>>>       
>>>>> Had this awhile back when we were customizing the invoice layout.
>>>>> Don't remember the exact cause but it ended up being a "special"
>>>>> character which wasn't being escaped properly.  It would display  
>>>>> fine
>>>>> but when converting to PDF, printing etc the interpreter wasn't
>>>>> happy.  As I recall somebody Googled the error and found the cause
>>>>> pretty quickly.
>>>>>
>>>>>
>>>>> Thanks,
>>>>>
>>>>> Michael
>>>>>
>>>>>
>>>>> On Nov 28, 2007, at 4:27 PM, Colin Manning wrote:
>>>>>
>>>>>
>>>>>
>>>>>         
>>>>>> Hi All,
>>>>>>
>>>>>> I get this error when trying to print or email an order
>>>>>>
>>>>>>
>>>>>>     Error!
>>>>>>
>>>>>> *Not a HASH reference at SL/OE.pm line 1378.
>>>>>> **Attempt to free unreferenced scalar: SV 0xa1d572c, Perl  
>>>>>> interpreter:
>>>>>> 0x98d6008 at SL/OE.pm line 1378.
>>>>>> *
>>>>>>
>>>>>> I'm using Fedora 8, (had the same error on Fedora 7) SL 2.8.8
>>>>>>
>>>>>> Any tips?
>>>>>>
>>>>>> Have been working fine on Fedora Core 6 for a while.  :-(
>>>>>>
>>>>>> Colin.
>>>>>>

Re: [SL] HASH Reference error when printing or e-mailing

[Colin M. <co...@it...>]

Thanks for the reply Michael.

Data was not migrated.

If I create a new database and create only one customer and one service 
and then try and invoice or a sales order I get a HASH reference error.

Has anyone had SL working with Fedora 8? Fedora 7? perl-5.8.8?

Permissions are as set by setup.pl, and checked against the FAQ.

Colin.

Michael Hasse wrote:
> If it was migrated from an old machine maybe it's something simple  
> like a file or folder with bad permissions...?
>
>
> Thanks,
>
> Michael
>
>
> On Dec 2, 2007, at 12:10 AM, Colin Manning wrote:
>
>   
>> Hi All,
>>
>> I have narrowed my problem down to something to do with tax.
>>
>> Lines 1375 - 1379 from OE.pm:
>>
>> # adjust taxes for lineitems
>> my $total = 0;
>> for (@{ $form->{lineitems} }) {
>> $total += $_->{tax};
>> }
>>
>> I had this all working before my old machine died, but I just can't  
>> get
>> this working. - very frustrating - invoices are keyed in (as sales
>> orders), but I can't print, so can I get paid :-(.
>>
>> Please help.
>>
>>
>> I have set up the taxes correctly in the system ==> taxes page, and  
>> set
>> my ABN in the system --> defaults page - any hints please?
>>
>>
>>
>>
>>
>> Colin Manning wrote:
>>     
>>> Thanks Michael.
>>>
>>> I've searched the mailing list for "hash reference" and "unreferenced
>>> scalar" and didn't find any solutions. the second search returned  
>>> this
>>> thread and a similar (unanswered) post on 2007-10-22.
>>>
>>> is perl-5.8.8 supported?
>>>
>>> I'm using postgresql-8.2.5-1.fc8
>>>
>>> I have done a default install - using setup.pl to my fedora 8 box.
>>> Create one dataset and one user (administrator type), one client  
>>> and one
>>> service.
>>>
>>> Try to print (even HTML) and it errors.
>>>
>>> I have not performed any customisation.
>>>
>>> Any further ideas?
>>>
>>>
>>>
>>>
>>> Michael Hasse wrote:
>>>
>>>       
>>>> Had this awhile back when we were customizing the invoice layout.
>>>> Don't remember the exact cause but it ended up being a "special"
>>>> character which wasn't being escaped properly.  It would display  
>>>> fine
>>>> but when converting to PDF, printing etc the interpreter wasn't
>>>> happy.  As I recall somebody Googled the error and found the cause
>>>> pretty quickly.
>>>>
>>>>
>>>> Thanks,
>>>>
>>>> Michael
>>>>
>>>>
>>>> On Nov 28, 2007, at 4:27 PM, Colin Manning wrote:
>>>>
>>>>
>>>>
>>>>         
>>>>> Hi All,
>>>>>
>>>>> I get this error when trying to print or email an order
>>>>>
>>>>>
>>>>>     Error!
>>>>>
>>>>> *Not a HASH reference at SL/OE.pm line 1378.
>>>>> **Attempt to free unreferenced scalar: SV 0xa1d572c, Perl  
>>>>> interpreter:
>>>>> 0x98d6008 at SL/OE.pm line 1378.
>>>>> *
>>>>>
>>>>> I'm using Fedora 8, (had the same error on Fedora 7) SL 2.8.8
>>>>>
>>>>> Any tips?
>>>>>
>>>>> Have been working fine on Fedora Core 6 for a while.  :-(
>>>>>
>>>>> Colin.
>>>>>
>>>>> ------------------------------------------------------------------- 
>>>>> ---
>>>>> ---
>>>>> SF.Net email is sponsored by: The Future of Linux Business White  
>>>>> Paper
>>>>> from Novell.  From the desktop to the data center, Linux is going
>>>>> mainstream.  Let it simplify your IT future.
>>>>> http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4
>>>>> _______________________________________________
>>>>> sql-ledger-users mailing list
>>>>> sql...@li...
>>>>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>>>>
>>>>>
>>>>>           
>>>> -------------------------------------------------------------------- 
>>>> -----
>>>> SF.Net email is sponsored by: The Future of Linux Business White  
>>>> Paper
>>>> from Novell.  From the desktop to the data center, Linux is going
>>>> mainstream.  Let it simplify your IT future.
>>>> http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4
>>>> _______________________________________________
>>>> sql-ledger-users mailing list
>>>> sql...@li...
>>>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>>>
>>>>
>>>>         
>>> --------------------------------------------------------------------- 
>>> ----
>>> SF.Net email is sponsored by: The Future of Linux Business White  
>>> Paper
>>> from Novell.  From the desktop to the data center, Linux is going
>>> mainstream.  Let it simplify your IT future.
>>> http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4
>>> _______________________________________________
>>> sql-ledger-users mailing list
>>> sql...@li...
>>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>>
>>>       
>> ---------------------------------------------------------------------- 
>> ---
>> SF.Net email is sponsored by: The Future of Linux Business White Paper
>> from Novell.  From the desktop to the data center, Linux is going
>> mainstream.  Let it simplify your IT future.
>> http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4
>> _______________________________________________
>> sql-ledger-users mailing list
>> sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>     
>
>
> -------------------------------------------------------------------------
> SF.Net email is sponsored by: The Future of Linux Business White Paper
> from Novell.  From the desktop to the data center, Linux is going
> mainstream.  Let it simplify your IT future.
> http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>   

Re: [SL] HASH Reference error when printing or e-mailing

[Michael H. <mh...@it...>]

If it was migrated from an old machine maybe it's something simple  
like a file or folder with bad permissions...?


Thanks,

Michael


On Dec 2, 2007, at 12:10 AM, Colin Manning wrote:

> Hi All,
>
> I have narrowed my problem down to something to do with tax.
>
> Lines 1375 - 1379 from OE.pm:
>
> # adjust taxes for lineitems
> my $total = 0;
> for (@{ $form->{lineitems} }) {
> $total += $_->{tax};
> }
>
> I had this all working before my old machine died, but I just can't  
> get
> this working. - very frustrating - invoices are keyed in (as sales
> orders), but I can't print, so can I get paid :-(.
>
> Please help.
>
>
> I have set up the taxes correctly in the system ==> taxes page, and  
> set
> my ABN in the system --> defaults page - any hints please?
>
>
>
>
>
> Colin Manning wrote:
>> Thanks Michael.
>>
>> I've searched the mailing list for "hash reference" and "unreferenced
>> scalar" and didn't find any solutions. the second search returned  
>> this
>> thread and a similar (unanswered) post on 2007-10-22.
>>
>> is perl-5.8.8 supported?
>>
>> I'm using postgresql-8.2.5-1.fc8
>>
>> I have done a default install - using setup.pl to my fedora 8 box.
>> Create one dataset and one user (administrator type), one client  
>> and one
>> service.
>>
>> Try to print (even HTML) and it errors.
>>
>> I have not performed any customisation.
>>
>> Any further ideas?
>>
>>
>>
>>
>> Michael Hasse wrote:
>>
>>> Had this awhile back when we were customizing the invoice layout.
>>> Don't remember the exact cause but it ended up being a "special"
>>> character which wasn't being escaped properly.  It would display  
>>> fine
>>> but when converting to PDF, printing etc the interpreter wasn't
>>> happy.  As I recall somebody Googled the error and found the cause
>>> pretty quickly.
>>>
>>>
>>> Thanks,
>>>
>>> Michael
>>>
>>>
>>> On Nov 28, 2007, at 4:27 PM, Colin Manning wrote:
>>>
>>>
>>>
>>>> Hi All,
>>>>
>>>> I get this error when trying to print or email an order
>>>>
>>>>
>>>>     Error!
>>>>
>>>> *Not a HASH reference at SL/OE.pm line 1378.
>>>> **Attempt to free unreferenced scalar: SV 0xa1d572c, Perl  
>>>> interpreter:
>>>> 0x98d6008 at SL/OE.pm line 1378.
>>>> *
>>>>
>>>> I'm using Fedora 8, (had the same error on Fedora 7) SL 2.8.8
>>>>
>>>> Any tips?
>>>>
>>>> Have been working fine on Fedora Core 6 for a while.  :-(
>>>>
>>>> Colin.
>>>>
>>>> ------------------------------------------------------------------- 
>>>> ---
>>>> ---
>>>> SF.Net email is sponsored by: The Future of Linux Business White  
>>>> Paper
>>>> from Novell.  From the desktop to the data center, Linux is going
>>>> mainstream.  Let it simplify your IT future.
>>>> http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4
>>>> _______________________________________________
>>>> sql-ledger-users mailing list
>>>> sql...@li...
>>>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>>>
>>>>
>>> -------------------------------------------------------------------- 
>>> -----
>>> SF.Net email is sponsored by: The Future of Linux Business White  
>>> Paper
>>> from Novell.  From the desktop to the data center, Linux is going
>>> mainstream.  Let it simplify your IT future.
>>> http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4
>>> _______________________________________________
>>> sql-ledger-users mailing list
>>> sql...@li...
>>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>>
>>>
>>
>> --------------------------------------------------------------------- 
>> ----
>> SF.Net email is sponsored by: The Future of Linux Business White  
>> Paper
>> from Novell.  From the desktop to the data center, Linux is going
>> mainstream.  Let it simplify your IT future.
>> http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4
>> _______________________________________________
>> sql-ledger-users mailing list
>> sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>
>
>
> ---------------------------------------------------------------------- 
> ---
> SF.Net email is sponsored by: The Future of Linux Business White Paper
> from Novell.  From the desktop to the data center, Linux is going
> mainstream.  Let it simplify your IT future.
> http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] HASH Reference error when printing or e-mailing

[Colin M. <co...@it...>]

Hi All,

I have narrowed my problem down to something to do with tax.

Lines 1375 - 1379 from OE.pm:

# adjust taxes for lineitems
my $total = 0;
for (@{ $form->{lineitems} }) {
$total += $_->{tax};
}

I had this all working before my old machine died, but I just can't get 
this working. - very frustrating - invoices are keyed in (as sales 
orders), but I can't print, so can I get paid :-(.

Please help.


I have set up the taxes correctly in the system ==> taxes page, and set 
my ABN in the system --> defaults page - any hints please?





Colin Manning wrote:
> Thanks Michael.
>
> I've searched the mailing list for "hash reference" and "unreferenced 
> scalar" and didn't find any solutions. the second search returned this 
> thread and a similar (unanswered) post on 2007-10-22.
>
> is perl-5.8.8 supported?
>
> I'm using postgresql-8.2.5-1.fc8
>
> I have done a default install - using setup.pl to my fedora 8 box. 
> Create one dataset and one user (administrator type), one client and one 
> service.
>
> Try to print (even HTML) and it errors.
>
> I have not performed any customisation.
>
> Any further ideas?
>
>
>
>
> Michael Hasse wrote:
>   
>> Had this awhile back when we were customizing the invoice layout.   
>> Don't remember the exact cause but it ended up being a "special"  
>> character which wasn't being escaped properly.  It would display fine  
>> but when converting to PDF, printing etc the interpreter wasn't  
>> happy.  As I recall somebody Googled the error and found the cause  
>> pretty quickly.
>>
>>
>> Thanks,
>>
>> Michael
>>
>>
>> On Nov 28, 2007, at 4:27 PM, Colin Manning wrote:
>>
>>   
>>     
>>> Hi All,
>>>
>>> I get this error when trying to print or email an order
>>>
>>>
>>>     Error!
>>>
>>> *Not a HASH reference at SL/OE.pm line 1378.
>>> **Attempt to free unreferenced scalar: SV 0xa1d572c, Perl interpreter:
>>> 0x98d6008 at SL/OE.pm line 1378.
>>> *
>>>
>>> I'm using Fedora 8, (had the same error on Fedora 7) SL 2.8.8
>>>
>>> Any tips?
>>>
>>> Have been working fine on Fedora Core 6 for a while.  :-(
>>>
>>> Colin.
>>>
>>> ---------------------------------------------------------------------- 
>>> ---
>>> SF.Net email is sponsored by: The Future of Linux Business White Paper
>>> from Novell.  From the desktop to the data center, Linux is going
>>> mainstream.  Let it simplify your IT future.
>>> http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4
>>> _______________________________________________
>>> sql-ledger-users mailing list
>>> sql...@li...
>>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>>     
>>>       
>> -------------------------------------------------------------------------
>> SF.Net email is sponsored by: The Future of Linux Business White Paper
>> from Novell.  From the desktop to the data center, Linux is going
>> mainstream.  Let it simplify your IT future.
>> http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4
>> _______________________________________________
>> sql-ledger-users mailing list
>> sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>   
>>     
>
> -------------------------------------------------------------------------
> SF.Net email is sponsored by: The Future of Linux Business White Paper
> from Novell.  From the desktop to the data center, Linux is going
> mainstream.  Let it simplify your IT future.
> http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>   

Re: [SL] Errors restoring Database

[Bob G. <bo...@rc...>]

On Nov 29, 2007, at 19:34, Stuart Luppescu wrote:

> On =E6=9C=A8, 2007-11-29 at 13:52 -0600, Stan Williams wrote:
>> Hi.
>>
>> I'm using Sql-Ledger 2.8.8 and Postgres 8.1.9. Every night I do a
>> database dump using the following command:
>>
>> pg_dump dataset =E2=80=93U username | gzip > filename.gz
>>
>> Today I dropped my database then recreated it in Sql-Ledger =20
>> Administration.
>>
>> When I try to resore the database using to following:
>>
>> psql dataset =E2=80=93U username < input file name
>
> I believe that if you're using pg_dump for the backup, you should use
> pg_restore to restore it. I'm doing something like this:
>
>         pg_dump -F t databasename > backupfile
>
> for the backup, and this:
>
>         pg_restore -c -U sql-ledger -d databasename -F t backupfile
>
> I have found that you need the -c in there to wipe out the old =20
> database
> so you don't get those annoying ``already exists'' messages.
>
> --=20
> Stuart Luppescu -=3D- s-luppescu .at. uchicago.edu
> University of Chicago (^_^)/ CCSR
> =E6=89=8D=E6=96=87=E3=81=A8=E6=99=BA=E5=A5=88=E7=BE=8E=E3=81=AE=E7=88=B6=
 -=3D-=3D- Kernel 2.6.20-gentoo-r
> It takes a special kind of courage to face what we
> all have to face.
>

If the other fixes mentioned have not solved the problem, you might =20
change your user to 'postgres' before executing the restore command. =20
As in:

[root@bacstx ~]# su postgres
[postgres@bacstx user]# psql bayarea < bayareadb

The prompt on this last line might look different as

bash-3.2$

This depends on your operating system and the preferences you have =20
chosen.

If you do:

[root@bacstx ~]# su - postgres

You will get thrown into the postgres home directory - your backup =20
file is not there..

Have fun

Bob G=

Re: [SL] Setting up a non-profit

[Bob G. <bo...@rc...>]

On Nov 28, 2007, at 16:52, Paul Tammes wrote:

> <snip>

> And like I said, we are overprotective on privacy in Europe.
> I mean, who would be ashamed if it became public that they give  
> money to
> church or charity?


If you are in the US, and the church happens to be a muslim  
organization, there might be a problem :-)

Unfortunate, but true.

Bob G

Re: [SL] HASH Reference error when printing or e-mailing

[Colin M. <co...@it...>]

Thanks Michael.

I've searched the mailing list for "hash reference" and "unreferenced 
scalar" and didn't find any solutions. the second search returned this 
thread and a similar (unanswered) post on 2007-10-22.

is perl-5.8.8 supported?

I'm using postgresql-8.2.5-1.fc8

I have done a default install - using setup.pl to my fedora 8 box. 
Create one dataset and one user (administrator type), one client and one 
service.

Try to print (even HTML) and it errors.

I have not performed any customisation.

Any further ideas?




Michael Hasse wrote:
> Had this awhile back when we were customizing the invoice layout.   
> Don't remember the exact cause but it ended up being a "special"  
> character which wasn't being escaped properly.  It would display fine  
> but when converting to PDF, printing etc the interpreter wasn't  
> happy.  As I recall somebody Googled the error and found the cause  
> pretty quickly.
>
>
> Thanks,
>
> Michael
>
>
> On Nov 28, 2007, at 4:27 PM, Colin Manning wrote:
>
>   
>> Hi All,
>>
>> I get this error when trying to print or email an order
>>
>>
>>     Error!
>>
>> *Not a HASH reference at SL/OE.pm line 1378.
>> **Attempt to free unreferenced scalar: SV 0xa1d572c, Perl interpreter:
>> 0x98d6008 at SL/OE.pm line 1378.
>> *
>>
>> I'm using Fedora 8, (had the same error on Fedora 7) SL 2.8.8
>>
>> Any tips?
>>
>> Have been working fine on Fedora Core 6 for a while.  :-(
>>
>> Colin.
>>
>> ---------------------------------------------------------------------- 
>> ---
>> SF.Net email is sponsored by: The Future of Linux Business White Paper
>> from Novell.  From the desktop to the data center, Linux is going
>> mainstream.  Let it simplify your IT future.
>> http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4
>> _______________________________________________
>> sql-ledger-users mailing list
>> sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>     
>
>
> -------------------------------------------------------------------------
> SF.Net email is sponsored by: The Future of Linux Business White Paper
> from Novell.  From the desktop to the data center, Linux is going
> mainstream.  Let it simplify your IT future.
> http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>   

Re: [SL] Errors restoring Database

[Stuart L. <sl...@cc...>]

On 木, 2007-11-29 at 13:52 -0600, Stan Williams wrote:
> Hi.
> 
> I'm using Sql-Ledger 2.8.8 and Postgres 8.1.9. Every night I do a 
> database dump using the following command:
> 
> pg_dump dataset –U username | gzip > filename.gz
> 
> Today I dropped my database then recreated it in Sql-Ledger Administration.
> 
> When I try to resore the database using to following:
> 
> psql dataset –U username < input file name

I believe that if you're using pg_dump for the backup, you should use
pg_restore to restore it. I'm doing something like this:
        
        pg_dump -F t databasename > backupfile
        
for the backup, and this:
        
        pg_restore -c -U sql-ledger -d databasename -F t backupfile
        
I have found that you need the -c in there to wipe out the old database
so you don't get those annoying ``already exists'' messages.
        
-- 
Stuart Luppescu -=- s-luppescu .at. uchicago.edu        
University of Chicago (^_^)/ CCSR 
才文と智奈美の父 -=-=- Kernel 2.6.20-gentoo-r
It takes a special kind of courage to face what we
all have to face. 

Re: [SL] Errors restoring Database

[Dieter S. <dsi...@sq...>]

> Hi.
>
> I'm using Sql-Ledger 2.8.8 and Postgres 8.1.9. Every night I do a
> database dump using the following command:
>
> pg_dump dataset U username | gzip > filename.gz
>
> Today I dropped my database then recreated it in Sql-Ledger Administration.
>
> When I try to resore the database using to following:
>
> psql dataset U username < input file name
>
> I get the following errors:

You cannot restore a database over top of an already existing. drop the 
database then create a blank one and restore.

[SL] Errors restoring Database

[Stan W. <st...@ba...>]

Hi.

I'm using Sql-Ledger 2.8.8 and Postgres 8.1.9. Every night I do a =

database dump using the following command:

pg_dump dataset =96U username | gzip > filename.gz

Today I dropped my database then recreated it in Sql-Ledger Administration.

When I try to resore the database using to following:

psql dataset =96U username < input file name

I get the following errors:

[root@bacstx ~]# psql bayarea -U sql-ledger < bayareadb
SET
SET
SET
ERROR: must be owner of schema public
ERROR: must be superuser to create procedural language
SET
CREATE FUNCTION
ALTER FUNCTION
SET
SET
ERROR: relation "acc_trans" already exists
ALTER TABLE
ERROR: relation "addressid" already exists
ALTER TABLE
setval
--------
155
(1 row)

ERROR: relation "address" already exists
ALTER TABLE
ERROR: relation "id" already exists
ALTER TABLE
setval
--------
11054
(1 row)

ERROR: relation "ap" already exists
ALTER TABLE
ERROR: relation "ar" already exists
ALTER TABLE
ERROR: relation "assemblyid" already exists
ALTER TABLE
setval
--------
16
(1 row)..............
ERROR: duplicate key violates unique constraint "curr_pkey"
CONTEXT: COPY curr, line 1: "1 USD 2"
ERROR: multiple primary keys for table "address" are not allowed
ERROR: multiple primary keys for table "br" are not allowed
ERROR: multiple primary keys for table "contact" are not allowed
ERROR: multiple primary keys for table "curr" are not allowed
ERROR: multiple primary keys for table "customer" are not allowed
ERROR: multiple primary keys for table "paymentmethod" are not allowed
ERROR: multiple primary keys for table "vendor" are not allowed
ERROR: relation "acc_trans_chart_id_key" already exists
ERROR: relation "acc_trans_source_key" already exists
ERROR: relation "acc_trans_trans_id_key" already exists
ERROR: relation "acc_trans_transdate_key" already exists
ERROR: relation "ap_employee_id_key" already exists
ERROR: relation "ap_id_key" already exists
ERROR: relation "ap_invnumber_key" already exists
ERROR: relation "ap_ordnumber_key" already exists
ERROR: relation "ap_quonumber_key" already exists
ERROR: relation "ap_transdate_key" already exists
ERROR: relation "ap_vendor_id_key" already exists
ERROR: relation "ar_customer_id_key" already exists
ERROR: relation "ar_employee_id_key" already exists
ERROR: relation "ar_id_key" already exists
ERROR: relation "ar_invnumber_key" already exists
ERROR: relation "ar_ordnumber_key" already exists
ERROR: relation "ar_quonumber_key" already exists
ERROR: relation "ar_transdate_key" already exists
ERROR: relation "assembly_id_key" already exists
ERROR: relation "audittrail_trans_id_key" already exists
ERROR: relation "cargo_id_key" already exists
ERROR: relation "chart_accno_key" already exists
ERROR: relation "chart_category_key" already exists
ERROR: relation "chart_gifi_accno_key" already exists
ERROR: relation "chart_id_key" already exists
ERROR: relation "chart_link_key" already exists
ERROR: relation "customer_contact_key" already exists
ERROR: relation "customer_customer_id_key" already exists
ERROR: relation "customer_customernumber_key" already exists
ERROR: relation "customer_name_key" already exists
ERROR: relation "department_id_key" already exists
ERROR: relation "employee_id_key" already exists
ERROR: relation "employee_login_key" already exists
ERROR: relation "employee_name_key" already exists
ERROR: relation "exchangerate_ct_key" already exists
ERROR: relation "gifi_accno_key" already exists
ERROR: relation "gl_description_key" already exists
ERROR: relation "gl_employee_id_key" already exists
ERROR: relation "gl_id_key" already exists
ERROR: relation "gl_reference_key" already exists
ERROR: relation "gl_transdate_key" already exists
ERROR: relation "inventory_parts_id_key" already exists
ERROR: relation "invoice_id_key" already exists
ERROR: relation "invoice_trans_id_key" already exists
ERROR: relation "jcitems_id_key" already exists
ERROR: relation "language_code_key" already exists
ERROR: relation "makemodel_make_key" already exists
ERROR: relation "makemodel_model_key" already exists
ERROR: relation "makemodel_parts_id_key" already exists
ERROR: relation "oe_employee_id_key" already exists
ERROR: relation "oe_id_key" already exists
ERROR: relation "oe_ordnumber_key" already exists
ERROR: relation "oe_transdate_key" already exists
ERROR: relation "orderitems_trans_id_key" already exists
ERROR: relation "parts_description_key" already exists
ERROR: relation "parts_id_key" already exists
ERROR: relation "parts_partnumber_key" already exists
ERROR: relation "partscustomer_customer_id_key" already exists
ERROR: relation "partscustomer_parts_id_key" already exists
ERROR: relation "partsgroup_id_key" already exists
ERROR: relation "partsgroup_key" already exists
ERROR: relation "partstax_parts_id_key" already exists
ERROR: relation "partsvendor_parts_id_key" already exists
ERROR: relation "partsvendor_vendor_id_key" already exists
ERROR: relation "pricegroup_id_key" already exists
ERROR: relation "pricegroup_pricegroup_key" already exists
ERROR: relation "project_id_key" already exists
ERROR: relation "projectnumber_key" already exists
ERROR: relation "shipto_trans_id_key" already exists
ERROR: relation "status_trans_id_key" already exists
ERROR: relation "translation_trans_id_key" already exists
ERROR: relation "vendor_contact_key" already exists
ERROR: relation "vendor_name_key" already exists
ERROR: relation "vendor_vendornumber_key" already exists
ERROR: relation "vendortax_vendor_id_key" already exists
ERROR: constraint "vr_br_id_fkey" for relation "vr" already exists
WARNING: no privileges could be revoked
REVOKE
WARNING: no privileges could be revoked
REVOKE
WARNING: no privileges were granted
GRANT
WARNING: no privileges were granted
GRANT


Complete errors attached as a text file

Can anyone help?

Thanks,

Stan Williams


-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: dberrors.txt

Re: [SL] HASH Reference error when printing or e-mailing

[Michael H. <mh...@it...>]

Had this awhile back when we were customizing the invoice layout.   
Don't remember the exact cause but it ended up being a "special"  
character which wasn't being escaped properly.  It would display fine  
but when converting to PDF, printing etc the interpreter wasn't  
happy.  As I recall somebody Googled the error and found the cause  
pretty quickly.


Thanks,

Michael


On Nov 28, 2007, at 4:27 PM, Colin Manning wrote:

> Hi All,
>
> I get this error when trying to print or email an order
>
>
>     Error!
>
> *Not a HASH reference at SL/OE.pm line 1378.
> **Attempt to free unreferenced scalar: SV 0xa1d572c, Perl interpreter:
> 0x98d6008 at SL/OE.pm line 1378.
> *
>
> I'm using Fedora 8, (had the same error on Fedora 7) SL 2.8.8
>
> Any tips?
>
> Have been working fine on Fedora Core 6 for a while.  :-(
>
> Colin.
>
> ---------------------------------------------------------------------- 
> ---
> SF.Net email is sponsored by: The Future of Linux Business White Paper
> from Novell.  From the desktop to the data center, Linux is going
> mainstream.  Let it simplify your IT future.
> http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

[SL] HASH Reference error when printing or e-mailing

[Colin M. <co...@it...>]

Hi All,

I get this error when trying to print or email an order


    Error!

*Not a HASH reference at SL/OE.pm line 1378.
**Attempt to free unreferenced scalar: SV 0xa1d572c, Perl interpreter: 
0x98d6008 at SL/OE.pm line 1378.
*

I'm using Fedora 8, (had the same error on Fedora 7) SL 2.8.8

Any tips?

Have been working fine on Fedora Core 6 for a while.  :-(

Colin.