Re: [Ledger-smb-users] POS Screen - Errors when posting an invoice

2008-05-31 Thread Chris Travers
Ok. Maybe we can spend some time over IRC tomorrow on this issue. Best Wishes, Chris Travers - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vs

Re: [Ledger-smb-users] POS Screen - Errors when posting an invoice

2008-05-31 Thread steven . marshall
ists.sourceforge.net > > cc > > Subject > > Re: [Ledger-smb-users] POS Screen - Errors when posting an invoice > > Looking at the code, it looks like one must set up a printer in the > user profile as well. I do

Re: [Ledger-smb-users] POS Screen - Errors when posting an invoice

2008-05-31 Thread Chris Travers
Looking at the code, it looks like one must set up a printer in the user profile as well. I don't remember adding such a change but. Best Wishes, Chris Travers - This SF.net email is sponsored by: Microsoft Defy all chal

Re: [Ledger-smb-users] POS Screen - Errors when posting an invoice

2008-05-31 Thread steven . marshall
ists.sourceforge.net > > cc > > Subject > > Re: [Ledger-smb-users] POS Screen - Errors when posting an invoice > > In that case, I suspect some sort of dependency issue with pg_dump. > > What version of PostgreSQL are you running? > > Best Wishes, > Chris Traver

Re: [Ledger-smb-users] POS Screen - Errors when posting an invoice

2008-05-31 Thread Chris Travers
In that case, I suspect some sort of dependency issue with pg_dump. What version of PostgreSQL are you running? Best Wishes, Chris Travers - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visu

Re: [Ledger-smb-users] POS Screen - Errors when posting an invoice

2008-05-31 Thread steven . marshall
ists.sourceforge.net > > cc > > Subject > > Re: [Ledger-smb-users] POS Screen - Errors when posting an invoice > > On Thu, May 29, 2008 at 6:35 PM, <[EMAIL PROTECTED]> wrote: > > > > > > > Yes. Here are the errors I received. I cut out some misc.

Re: [Ledger-smb-users] POS Screen - Errors when posting an invoice

2008-05-31 Thread Chris Travers
On Thu, May 29, 2008 at 6:35 PM, <[EMAIL PROTECTED]> wrote: > > > Yes. Here are the errors I received. I cut out some misc. items from the > log that were not relevant. > > [EMAIL PROTECTED]:~/data> pg_dump -a tatylee > tatyleebackup.sql > [EMAIL PROTECTED]:~/data> psql -d ledgersmbtest -f taty

Re: [Ledger-smb-users] POS Screen - Errors when posting an invoice

2008-05-30 Thread Jeff Kowalczyk
Stroller wrote: > Any chance you could make your posts to the list in plain-text > format, please? Your fixed-width font shows up very small on my > system, and is quite difficult to read; even when enlarged (which is > an inconvenience) is it still grey, rather than black. Seconding that; m

Re: [Ledger-smb-users] POS Screen - Errors when posting an invoice

2008-05-30 Thread steven . marshall
I think I have solved many of the issues resulting from the SQL-Ledger to LedgerSMB migration and want to post my steps here for others who have similar issues. The main blocking issue was "ERROR: permission denied for relation ar". In addition, it appears that there is a bug in Pg-upgrade-2

Re: [Ledger-smb-users] POS Screen - Errors when posting an invoice

2008-05-29 Thread steven . marshall
[EMAIL PROTECTED] wrote on 05/29/2008 06:26:21 PM: > "Chris Travers" <[EMAIL PROTECTED]> > > defaults should be dumped. If it is not being dumped, I wonder why. > > Any errors in the PostgreSQL error log? > > Best Wishes, > Chris Travers > > Yes. Here are the errors I received. I cut out

Re: [Ledger-smb-users] POS Screen - Errors when posting an invoice

2008-05-29 Thread Luke
On Thu, 29 May 2008, Stroller wrote: > You snipped too early. > > Without the linebreak, he said: > >[EMAIL PROTECTED]:~> grep -i printer >/usr/local/ledgersmb/ledgersmb.conf -A 3 >[printers] ># Available printers >#Laser = lpr -Plaser >#Epson = lpr -PEpson >

Re: [Ledger-smb-users] POS Screen - Errors when posting an invoice

2008-05-29 Thread Chris Travers
On Thu, May 29, 2008 at 3:04 PM, Stroller <[EMAIL PROTECTED]> wrote: > > On 29 May 2008, at 22:16, [EMAIL PROTECTED] wrote: >> ... it >> doesn't appear that my data from the defaults table was included in my >> backup, therefore, it didn't get restored into my test database >> >> >> [EMAIL PROTECT

Re: [Ledger-smb-users] POS Screen - Errors when posting an invoice

2008-05-29 Thread Stroller
On 29 May 2008, at 22:16, [EMAIL PROTECTED] wrote: > ... it > doesn't appear that my data from the defaults table was included in my > backup, therefore, it didn't get restored into my test database > > > [EMAIL PROTECTED]:~/data> pg_dump -a tatylee > tatyleebackup.sql > [EMAIL PROTECTED]:~/data>

Re: [Ledger-smb-users] POS Screen - Errors when posting an invoice

2008-05-29 Thread Stroller
On 29 May 2008, at 16:30, Luke wrote: > On Thu, 29 May 2008, [EMAIL PROTECTED] wrote: > >>> Have you set up the printer in Ledger-SMB? > [.] >> Yes, I have setup the printer in LedgerSMB. Here is my printer >> configuration. I am mainly concerned with the Star Receipt Printer. >> >> [EMAIL PROT

Re: [Ledger-smb-users] POS Screen - Errors when posting an invoice

2008-05-29 Thread steven . marshall
I am still researching my issue and have come to the conclusion that the SQL-Ledger to LedgerSMB migration has screwed up my database. I am hoping someone can help me fix this. 1. I created two new datasets via the LedgerSMB admin.pl. I then compared these two databases, via pgAdmin, with m

Re: [Ledger-smb-users] POS Screen - Errors when posting an invoice

2008-05-29 Thread steven . marshall
OK. I fixed the issue where I couldn't generate a PDF. It turns out that when I copied my settings from sql-ledger.conf to ledgersmb.conf I had a typo in the following line: WRONG: PATH: /usr/local/texlive/2007/bin/i386-linux"; CORRECT:PATH: /usr/local/texlive/2007/bin/i386-linux Thi

Re: [Ledger-smb-users] POS Screen - Errors when posting an invoice

2008-05-29 Thread steven . marshall
Yes, I can print to this using the `lpr -P Star_TSP643U file.txt' using the command line from a Unix shell. I do not appear to be able to generate a PDF via LedgerSMB either. I have SQL-Ledger also installed on the same machine with a previous backup dataset. From SQL-Ledger I am able to gen

Re: [Ledger-smb-users] POS Screen - Errors when posting an invoice

2008-05-29 Thread Luke
On Thu, 29 May 2008, [EMAIL PROTECTED] wrote: > > Have you set up the printer in Ledger-SMB? [.] > Yes, I have setup the printer in LedgerSMB. Here is my printer > configuration. I am mainly concerned with the Star Receipt Printer. > > [EMAIL PROTECTED]:~> grep -i printer > /usr/local/ledgers

Re: [Ledger-smb-users] POS Screen - Errors when posting an invoice

2008-05-29 Thread Stroller
On 29 May 2008, at 15:55, [EMAIL PROTECTED] wrote: >> On Wed, 28 May 2008, [EMAIL PROTECTED] wrote: >> >>> I am having several issues trying to post an invoice via the POS >>> Add Invoice screen. This is a recent SQL-Ledger to LedgerSMB >>> migration. When I create a sale and click on Print an

Re: [Ledger-smb-users] POS Screen - Errors when posting an invoice

2008-05-29 Thread Stroller
On 29 May 2008, at 15:45, [EMAIL PROTECTED] wrote: > ... > Yes, I have setup the printer in LedgerSMB. Here is my printer > configuration. I am mainly concerned with the Star Receipt Printer. > > [EMAIL PROTECTED]:~> grep -i printer > /usr/local/ledgersmb/ledgersmb.conf -A 3 > [printers] > # Ava

Re: [Ledger-smb-users] POS Screen - Errors when posting an invoice

2008-05-29 Thread steven . marshall
Luke <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > > 05/28/2008 11:51 PM > > Please respond to > ledger-smb-users@lists.sourceforge.net > > To > > ledger-smb-users@lists.sourceforge.net > > cc > > Subject > > Re: [Ledger-smb-use

Re: [Ledger-smb-users] POS Screen - Errors when posting an invoice

2008-05-29 Thread steven . marshall
> > Have you set up the printer in Ledger-SMB? > >$ grep -i printer /usr/local/ledgersmb/ledgersmb.conf -A 3 >[printers] ># Available printers >#Laser = lpr -Plaser >#Epson = lpr -PEpson >Laserjet4000 = lpr -PLaserjet4000 >$ > Yes, I have setup the printer

Re: [Ledger-smb-users] POS Screen - Errors when posting an invoice

2008-05-28 Thread Luke
On Wed, 28 May 2008, [EMAIL PROTECTED] wrote: > I am having several issues trying to post an invoice via the POS Add > Invoice screen. This is a recent SQL-Ledger to LedgerSMB migration. When > I create a sale and click on Print and Post, I get two issues. > > 1. The receipt is displayed in t

Re: [Ledger-smb-users] POS Screen - Errors when posting an invoice

2008-05-28 Thread Stroller
Hi Steven, Any chance you could make your posts to the list in plain-text format, please? Your fixed-width font shows up very small on my system, and is quite difficult to read; even when enlarged (which is an inconvenience) is it still grey, rather than black. On 28 May 2008, at 22:36, [E

[Ledger-smb-users] POS Screen - Errors when posting an invoice

2008-05-28 Thread steven . marshall
I am having several issues trying to post an invoice via the POS Add Invoice screen. This is a recent SQL-Ledger to LedgerSMB migration. When I create a sale and click on Print and Post, I get two issues. 1. The receipt is displayed in the browser window instead of being sent to the receipt p