Thread: [SL] Help on SQL-Ledger needed ...

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

Hi all,

We are evaluating SQL-Ledger. Installation and configuration when well
except when user attempt to log-in, the page returns with following
error:

Error!
SELECT version FROM defaults
ERROR: relation "defaults" does not exist

The above did not occur for Admin (admin.pl) login but only on user
(login.pl) login.

Our test system info as follow:
OS: Kubuntu Dapper 6.06
Kernel: 2.6.15-28-amd64-generic
Apache: 2.0.55
PostgreSQL: 8.1.8 (with schemas)
Perl: 5.8.7

Any help is greatly appreciated. I am not aware of any community so I
post here.

Do direct me to the correct channel.

Thanks.

Best regards,
Joshua Frasir Chan
IT Administrator
* * * * *
OAAG (S) PTE. LTD.
60 Kaki Bukit Place
#09-10 Eunos Techpark II
Singapore 415979
Tel: (65)6744-1811
DID: (65)6751-5679
Fax: (65)6280-0090
Email: jo...@oa...
www.oaag.com
24hr regional PGA Assist: (65)6280-0808
Company Registration No.: 200003073H
Singapore . Hong Kong . Malaysia . Philippines . Taiwan . South Korea .
Indonesia .
Thailand . China . Sri Lanka . India . Japan . Australia . South Africa
. Brazil .
* * * * *
Warning:
This communication, including any attachments therein, may contain
privileged/confidential information
that is solely intended for the individual or entity named as
recipientIf you are not the intended recipient,=20
please take notice that any disclosure, copying, distribution,
review,retransmission or taking of any other=20
action in reliance upon, of any part of the content of this
informationis strictly prohibited.

If you are not the intended recipient, please notify the sender by
return email and delete this communication
wholly from any storage media.

Thank you.

-----Original Message-----
From: sql...@li...
[mailto:sql...@li...] On Behalf Of
sql...@li...
Sent: Saturday, April 07, 2007 6:27 AM
To: sql...@li...
Subject: sql-ledger-users Digest, Vol 12, Issue 1

Send sql-ledger-users mailing list submissions to
	sql...@li...

To subscribe or unsubscribe via the World Wide Web, visit
	https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
or, via email, send a message with subject or body 'help' to
	sql...@li...

You can reach the person managing the list at
	sql...@li...

When replying, please edit your Subject line so it is more specific than
"Re: Contents of sql-ledger-users digest..."

Today's Topics:

   1. Re: Best Linux OS for SL? (Oliver Heesakkers)
   2. Re: Best Linux OS for SL? (Andrei Kolu)
   3. Re: Best Linux OS for SL? (ATM Logic)
   4. Re: SQL-Ledger from Windows Mobile 5.0 (Colin Manning)
   5. Payroll (Jigme Datse)
   6. Re: Project details for each timecard (Rune Bromer)
   7. Re: Best Linux OS for SL? (Vladimir Botka)
   8. Purchase Order field? (Danita Zanre)
   9. Re: Payroll (David Boyle)
  10. Re: Purchase Order field? (R Pennington)
  11. Re: Payroll (Jeff Roberts)
  12. Re: Best Linux OS for SL? (Wallace Roberts Consulting)
  13. Re: Best Linux OS for SL? (Bob Crandell)
  14. Re: Project details for each timecard (Victor H. Goff III)
  15. HTML Invoice Template - broken image (Myk Robinson)
  16. upgrading to 2.8 (Tage Danielsen)
  17. Problems upgrading from 2.6.27 to 2.8.0 (Glen Morris)
  18. Re: Problems upgrading from 2.6.27 to 2.8.0 (Dieter Simader)
  19. Re: Problems upgrading from 2.6.27 to 2.8.0 (ATM Logic)
  20. Re: Problems upgrading from 2.6.27 to 2.8.0 (Tage Danielsen)
  21. Upgrade to 2.7 or 2.8? (ATM Logic)
  22. Re: Problems upgrading from 2.6.27 to 2.8.0 (George Osvald)
  23. Re: Upgrade to 2.7 or 2.8? (Mark Lubratt)
  24. Restoring from a pg_dump (Glen Morris)
  25. Can't process recurring transactions after upgrade to 2.8.0
      (Glen Morris)
  26. Re: Problems upgrading from 2.6.27 to 2.8.0 (Tage Danielsen)
  27. Re: Restoring from a pg_dump (R Pennington)
  28. Re: Restoring from a pg_dump (George Osvald)
  29. Looking for a bookkeeper who knows how to use SQL-Ledger
      (hh...@ch...)
  30. SQL-Ledger on Apache Tomcat: it works (hh...@ch...)
  31. AR balance sheet vs trial balance vs outstanding (Chris Johnson)

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

Message: 1
Date: Tue, 27 Mar 2007 00:51:02 +0200
From: Oliver Heesakkers <sl...@he...>
Subject: Re: [SL] Best Linux OS for SL?
To: sql...@li...
Message-ID: <200...@he...>
Content-Type: text/plain;  charset=3D"iso-8859-1"

Op Monday 26 March 2007 19:31:22 schreef ATM Logic:
> Thanks, tried it on my VM Ware unit and it failed, will try on the=20
> server (re-installing the 6.2 now)
>

I reccomend using Portsnap instead of cvsup.

http://www.freebsd.org/doc/en_US.ISO8859-1/books/handbook/portsnap.html

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

Message: 2
Date: Tue, 27 Mar 2007 12:03:04 +0300
From: Andrei Kolu <and...@ma...>
Subject: Re: [SL] Best Linux OS for SL?
To: sql...@li...
Message-ID: <200...@ma...>
Content-Type: text/plain;  charset=3D"iso-8859-1"

On Monday 26 March 2007 8:31 pm, ATM Logic wrote:
> Thanks, tried it on my VM Ware unit and it failed, will try on the=20
> server (re-installing the 6.2 now)
>
csup is already in FreeBSD 6.2 base system- I referred to 6.1 in case
you have older installation.

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

Message: 3
Date: Tue, 27 Mar 2007 00:17:55 -0500
From: "ATM Logic" <atm...@km...>
Subject: Re: [SL] Best Linux OS for SL?
To: <sql...@li...>
Message-ID: <000001c7702f$4754c4a0$6800a8c0@ATMLogic.local>
Content-Type: text/plain;	charset=3D"us-ascii"

Thanks for taking the time for the help, however I have tried 2 flavors
of
FreeBSD, and as much as I would like it to work, I am getting little
failures here here and there (pkg_add -r csup, fails, even when I get
sql-ledger installed, I don't have pico to edit, so forced to use other
apps, then I am a little confused... No Lynx, or links, not even mc...

So... Going with CentOS, I know it well enough, and will try FreeBSD as
a
project, not a production unit.

> >
>=20
> I reccomend using Portsnap instead of cvsup.
>=20
> http://www.freebsd.org/doc/en_US.ISO8859-1/books/handbook/port
> snap.html
>=20
> --------------------------------------------------------------
> -----------
> Take Surveys. Earn Cash. Influence the Future of IT Join=20
> SourceForge.net's Techsay panel and you'll get the chance to=20
> share your opinions on IT & business topics through brief=20
> surveys-and earn cash=20
> http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge
&CID=3DDEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>=20

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

Message: 4
Date: Tue, 27 Mar 2007 18:17:15 +0800
From: Colin Manning <co...@it...>
Subject: Re: [SL] SQL-Ledger from Windows Mobile 5.0
To: sql...@li...
Message-ID: <460...@it...>
Content-Type: text/plain; charset=3D"us-ascii"

Awesome.

Lynx style menu works better with dopod anyway - Display is small.

Dieter Simader wrote:
> pass terminal=3Dlynx on the URL
>
> http://localhost/sql-ledger/login.pl?terminal=3Dlynx
>
> Looks like the browser does not like the Javascript code.
>
> If you don't like the lynx style menu force Javascript off
>
>
http://localhost/sql-ledger/login.pl?action=3Dlogin&login=3Dthe_login&pas=
swo
rd=3Dthe_password
>
>  =20

--=20
Regards,

*Colin Manning* B Sc.

/Computer service, sales and support./
I.T. Navigate Pty Ltd
Phone: (08) 9574 0200
Mobile: 0412 384 242
ABN:61 108 296 288

<http://www.itnavigate.com.au>
www.itnavigate.com.au <http://www.itnavigate.com.au>

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

Message: 5
Date: Mon, 26 Mar 2007 18:31:07 -0700
From: "Jigme Datse" <jig...@gm...>
Subject: [SL] Payroll
To: sql...@li...
Message-ID:
	<b3f...@ma...>
Content-Type: text/plain; charset=3DISO-8859-1; format=3Dflowed

I'm looking at my setup for SL and right now I'm not seeing any
payroll module.  That is while I see the HR module, and the Projects
module, I don't see a way to print up cheques/cheque stubs for the
hours that my employees have put in.  Am I missing something obvious?
I think I've gone through a few times to figure this out, and put the
payroll through, but the only way that I can see this right now, is to
manually enter the cheques, and stubs through the general ledger.

Jigme Datse

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

Message: 6
Date: Tue, 27 Mar 2007 12:22:18 +0200
From: Rune Bromer <run...@co...>
Subject: Re: [SL] Project details for each timecard
To: sql...@li...
Message-ID: <460...@co...>
Content-Type: text/plain; charset=3DISO-8859-1; format=3Dflowed

Tom Diehl wrote:
> On Mon, 26 Mar 2007, Rune Bromer wrote:
>=20
>> Tom Diehl wrote:
>>> Yep, This is my exact situation. When you generate the sales order
click
>>> the details button and you will get entries on the sales order for
each
>>> timecard.
>>>
>>> Regards,
>> When I click the generate button I get blank list. Should the sale
order
>> be visible somewhere? And how do you generate a invoice from it?
>=20
> Look under sales orders and you should see the new sales orders. The
timecards
> will be gone from view because they are allocated.

Thanks for the reply, but I'm still lost. Where in the menu do I find=20
this? I can find "something" in the consolidate submenu, but there I can

see 3 entries (2, 2 and -2 hours). Where can I generate an invoice?

Rune

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

Message: 7
Date: Tue, 27 Mar 2007 10:17:23 +0200
From: Vladimir Botka <vl...@bo...>
Subject: Re: [SL] Best Linux OS for SL?
To: sql...@li...
Message-ID: <20070327101723.3e8cfa39@srv>
Content-Type: text/plain; charset=3DUS-ASCII

Hello,
if you installed from CD then you can install the port collection much
faster this way:
1. put your CD in
2. as a root type # sysinstal
3. go to CONFIGURE->DISTRIBUTIONS
4. check out the [x] ports
5. and press [OK]
The port collection will be installed from your CD. Then you can find
the SL in /usr/ports/finance directory. <gently flame=3Doff> But in the
long run with FreeBSD you can not avoid reading the handbook. It will
pay you in time. I promisse.

Cheers, -vlado

> Any Idea what I am missing??
>=20
> I have freeBSD installed, and I go to cd /usr/ports/ and ... There is
> nothing there... I cannot go to finance  etc...  Tried and failed
> with the VMWare, then on the full meal deal??
>=20
>=20
>=20
> ??
> > >=20
> > > If you're really insistent on having a GUI check out=20
> > www.pcbsd.org -=20
> > > FBSD + KDE
> > >=20
> >=20
> > Looks like I cannot install SQL on the VMWare package of this  :(
> >=20
> > At least not using:
> > cd /usr/ports/finance/sql-ledger/ && make install clean
> >=20
> >=20
> > --------------------------------------------------------------
> > -----------
> > Take Surveys. Earn Cash. Influence the Future of IT Join=20
> > SourceForge.net's Techsay panel and you'll get the chance to=20
> > share your opinions on IT & business topics through brief=20
> > surveys-and earn cash=20
> > http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge
> > &CID=3DDEVDEV
> > _______________________________________________
> > sql-ledger-users mailing list
> > sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> >=20
>=20
>=20
>
------------------------------------------------------------------------
-
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to
> share your opinions on IT & business topics through brief surveys-and
> earn cash
>
http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3D=
DEVDE
V
> _______________________________________________ sql-ledger-users
> mailing list sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>=20

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

Message: 8
Date: Tue, 27 Mar 2007 11:14:41 -0600
From: "Danita Zanre" <da...@ca...>
Subject: [SL] Purchase Order field?
To: <sql...@li...>
Message-ID: <460...@ca...>
Content-Type: text/plain; charset=3DUS-ASCII

Maybe I'm just blind, but I can't seem to find a variable to replace the
"order" field in an invoice with "Purchase Order" - in our business, we
really never have a need to pass our internal "Sales Order" information
to the invoice, but we always need to pass the "purchase order" info.
I've just taken to putting the purchase order number in the "order"
field, but if there is a way to pass this info to the invoice I'd be
happier.

Thanks.

Danita

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

Message: 9
Date: Tue, 27 Mar 2007 10:04:11 -0500
From: David Boyle <dav...@sb...>
Subject: Re: [SL] Payroll
To: sql...@li...
Message-ID: <1175007851.5002.6.camel@Conall>
Content-Type: text/plain

On Mon, 2007-03-26 at 18:31 -0700, Jigme Datse wrote:
> I'm looking at my setup for SL and right now I'm not seeing any
> payroll module.  That is while I see the HR module, and the Projects
> module, I don't see a way to print up cheques/cheque stubs for the
> hours that my employees have put in.  Am I missing something obvious?
> I think I've gone through a few times to figure this out, and put the
> payroll through, but the only way that I can see this right now, is to
> manually enter the cheques, and stubs through the general ledger.

I have my associates/employees set up as vendors and pay out using Add
AP Transaction.  Entering the transaction this way allows me to enter
Gross Pay under whatever expense account I am paying them through and
entering deductions in the same transaction for withheld payroll taxes,
garnishments and other items.  Works for us, but your mileage may vary.

HTH,
David Boyle
NAPCO

>=20
> Jigme Datse
>=20
>
------------------------------------------------------------------------
-
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to
share your
> opinions on IT & business topics through brief surveys-and earn cash
>
http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3D=
DEVDE
V
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

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

Message: 10
Date: Tue, 27 Mar 2007 15:24:45 -0500
From: R Pennington <arc...@mt...>
Subject: Re: [SL] Purchase Order field?
To: sql...@li...
Message-ID: <200...@mt...>
Content-Type: text/plain;  charset=3D"iso-8859-1"

On Tuesday 27 March 2007 12:14 pm, Danita Zanre wrote:
> I've just taken to putting the purchase order number in the "order"
field, but if there is a way to pass this info to the invoice I'd be
happier.
>=20
<%ponumber%>

Cheers,
Roy

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

Message: 11
Date: Tue, 27 Mar 2007 12:53:20 -0700
From: Jeff Roberts <je...@jr...>
Subject: Re: [SL] Payroll
To: sql...@li...
Message-ID: <460...@jr...>
Content-Type: text/plain; charset=3DISO-8859-1; format=3Dflowed

Hi Jigme

I do the same as David, if you set up your 'deduction' liability=20
accounts (tax owing, employment insurance owing, pension owing etc) they

will appear in the drop down menus of the AP module. You can put in the=20
gross pay and assign it to an expense and then use negative numbers to=20
'deduct' from the gross and assign the 'deductions' to liability=20
accounts. When I'm all done printing the cheques I do a GL entry to=20
account for the matching expenses, I, for example, expense the amount I=20
have to match on their pension contributions (Pension expense) and add=20
it to a liability account called 'pension owing' (same account I used=20
when cutting their cheque). This way both my contribution and their=20
contribution end up in the same liability account. At the end of the=20
month when it's time for remittance I pay from a bank account and=20
decrease the liability account back to zero.

None of this does anything for the calculations that have to be made to=20
determine how much each employee has to pay each of the various=20
deductions. I have a spreadsheet with the Canadian formulas in it to do=20
that and it's printout is what I use to cut the cheques and do the GL
entry.

Jeff Roberts

David Boyle wrote:
> On Mon, 2007-03-26 at 18:31 -0700, Jigme Datse wrote:
>  =20
>> I'm looking at my setup for SL and right now I'm not seeing any
>> payroll module.  That is while I see the HR module, and the Projects
>> module, I don't see a way to print up cheques/cheque stubs for the
>> hours that my employees have put in.  Am I missing something obvious?
>> I think I've gone through a few times to figure this out, and put the
>> payroll through, but the only way that I can see this right now, is
to
>> manually enter the cheques, and stubs through the general ledger.
>>    =20
>
> I have my associates/employees set up as vendors and pay out using Add
> AP Transaction.  Entering the transaction this way allows me to enter
> Gross Pay under whatever expense account I am paying them through and
> entering deductions in the same transaction for withheld payroll
taxes,
> garnishments and other items.  Works for us, but your mileage may
vary.
>
> HTH,
> David Boyle
> NAPCO
>
>
>  =20
>> Jigme Datse
>>
>>
------------------------------------------------------------------------
-
>> Take Surveys. Earn Cash. Influence the Future of IT
>> Join SourceForge.net's Techsay panel and you'll get the chance to
share your
>> opinions on IT & business topics through brief surveys-and earn cash
>>
http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3D=
DEVDE
V
>> _______________________________________________
>> sql-ledger-users mailing list
>> sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>    =20
>
>
>
------------------------------------------------------------------------
-
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to
share your
> opinions on IT & business topics through brief surveys-and earn cash
>
http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3D=
DEVDE
V
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>
>  =20

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

Message: 12
Date: Tue, 27 Mar 2007 20:55:44 -0700
From: "Wallace Roberts Consulting" <wrc...@gm...>
Subject: Re: [SL] Best Linux OS for SL?
To: sql...@li...
Message-ID:
	<a7a...@ma...>
Content-Type: text/plain; charset=3DISO-8859-1; format=3Dflowed

On 3/27/07, Vladimir Botka <vl...@bo...> wrote:
> But in the
> long run with FreeBSD you can not avoid reading the handbook. It will
> pay you in time. I promisse.

... OR ...

Simply use Fedora Core instead, & it will automagically work.

--
Best Regards,
Wallace

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

Message: 13
Date: Wed, 28 Mar 2007 11:29:49 -0700
From: Bob Crandell <bo...@co...>
Subject: Re: [SL] Best Linux OS for SL?
To: sql...@li...
Message-ID: <117...@bo...puterbaseusa.loc>
Content-Type: text/plain

On Tue, 2007-03-27 at 20:55 -0700, Wallace Roberts Consulting wrote:
> On 3/27/07, Vladimir Botka <vl...@bo...> wrote:
> > But in the
> > long run with FreeBSD you can not avoid reading the handbook. It
will
> > pay you in time. I promisse.
>=20
> ... OR ...
>=20
> Simply use Fedora Core instead, & it will automagically work.
>=20
I've had the same results with SuSE.

Bob C.

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

Message: 14
Date: Wed, 28 Mar 2007 16:17:24 -0500
From: "Victor H. Goff III" <kee...@gm...>
Subject: Re: [SL] Project details for each timecard
To: sql...@li...
Message-ID:
	<324...@ma...>
Content-Type: text/plain; charset=3DISO-8859-1; format=3Dflowed

You would then generate an invoice from the sales order.  (At least
this is the normal chain of events for us.... )

On 3/27/07, Rune Bromer <run...@co...> wrote:
> Tom Diehl wrote:
> > On Mon, 26 Mar 2007, Rune Bromer wrote:
> >
> >> Tom Diehl wrote:
> >>> Yep, This is my exact situation. When you generate the sales order
click
> >>> the details button and you will get entries on the sales order for
each
> >>> timecard.
> >>>
> >>> Regards,
> >> When I click the generate button I get blank list. Should the sale
order
> >> be visible somewhere? And how do you generate a invoice from it?
> >
> > Look under sales orders and you should see the new sales orders. The
timecards
> > will be gone from view because they are allocated.
>
> Thanks for the reply, but I'm still lost. Where in the menu do I find
> this? I can find "something" in the consolidate submenu, but there I
can
> see 3 entries (2, 2 and -2 hours). Where can I generate an invoice?
>
> Rune
>
>
------------------------------------------------------------------------
-
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to
share your
> opinions on IT & business topics through brief surveys-and earn cash
>
http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3D=
DEVDE
V
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

--=20
Warmest Regards,

Victor H. Goff III
Sr. Network Administrator
Voice: (405) 213-0549
Fax: (206)309-0765
http://dgcc.custompcinc.net/

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

Message: 15
Date: Wed, 28 Mar 2007 16:03:06 -0500
From: Myk Robinson <myk...@gm...>
Subject: [SL] HTML Invoice Template - broken image
To: sql...@li...
Message-ID: <200...@gm...>
Content-Type: text/plain;  charset=3D"us-ascii"

Hey-

All of a sudden after an upgrade, my html invoice template is broken. My
Latex=20
template is working fine..

the image I am trying to reference is called "new_logo.jpg"

Its location is
/usr/local/sql-ledger/templates/myk.robinson/new_logo.jpg

Please advise as to the proper way to refer to this image..

thanks,
-myk

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

Message: 16
Date: Sun, 01 Apr 2007 21:24:53 +0200
From: Tage Danielsen <ta...@ht...>
Subject: [SL] upgrading to 2.8
To: sql...@li...
Message-ID: <461...@ht...>
Content-Type: text/plain; charset=3DISO-8859-1; format=3Dflowed

Hello

Tage from Denmark

I am upgrading from 2.7.27 to 2.8 and get this error

**************************************
Upgrading to Version 2.8.0 ...
Error!

insert into defau (fldname, fldvalue) values ('inventory_accno_id',=20
(select inventory_accno_id from defaults))
ERROR: more than one row returned by a subquery used as an expression

****************************************

somebody able to help?

Thanks
/tage

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

Message: 17
Date: Mon, 02 Apr 2007 09:48:45 +1000
From: Glen Morris <gl...@au...>
Subject: [SL] Problems upgrading from 2.6.27 to 2.8.0
To: sql...@li...
Message-ID: <461...@au...>
Content-Type: text/plain; charset=3DISO-8859-1; format=3Dflowed

When I upgraded from 2.6.27 to 2.8.0 I couldn't login.

I unlocked the system from the admin interface but when I try to login I

get:

    Upgrading to Version 2.8.0 ...

        Error!

    *create sequence assemblyid*
    *ERROR: relation "assemblyid" already exists*

*
*Also according to the upgrade docs there should be the following files=20
in the templates directory but they aren't there:

    3. copy the following templates from the templates directory to
       your private directory

       Default-credit_invoice.html
       Default-credit_invoice.tex
       Default-debit_invoice.html
       Default-debit_invoice.tex

Regards, Glen
**

--=20
Glen Morris: Arachnoid Australia
613 90175780 Melbourne | 612 90164032 Sydney
613 98961811 VoIP | Mbl 0419299140
Skype=3Dglenmo. PO Box 214, Healesville VIC 3777, Australia

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

Message: 18
Date: Mon, 02 Apr 2007 11:04:19 -0600 (MDT)
From: Dieter Simader <dsi...@sq...>
Subject: Re: [SL] Problems upgrading from 2.6.27 to 2.8.0
To: sql...@li...
Message-ID: <200...@gu...>
Content-Type: TEXT/PLAIN; charset=3DUS-ASCII; format=3Dflowed

The easiest is to restore from a backup, delete the second record in the

defaults table and upgrade again.

If you don't have a backup you have no choice but to do a manual upgrade

from the point on when the upgrade script failed. The upgrade failed in=20
Pg-upgrade-2.7.5-2.7.6.sql when it tried to rewrite the defaults table.

--=20
Dieter Simader       http://www.sql-ledger.com   Tel: (780) 472-8161
DWS Systems Inc.        Accounting Software      Fax: (780) 478-5281
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D On a clear disk you can seek =
forever =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

On Mon, 2 Apr 2007, Glen Morris wrote:

> When I upgraded from 2.6.27 to 2.8.0 I couldn't login.
>
> I unlocked the system from the admin interface but when I try to login
I
> get:
>
>    Upgrading to Version 2.8.0 ...
>
>
>        Error!
>
>    *create sequence assemblyid*
>    *ERROR: relation "assemblyid" already exists*
>
> *
> *Also according to the upgrade docs there should be the following
files
> in the templates directory but they aren't there:
>
>    3. copy the following templates from the templates directory to
>       your private directory
>
>       Default-credit_invoice.html
>       Default-credit_invoice.tex
>       Default-debit_invoice.html
>       Default-debit_invoice.tex
>
> Regards, Glen
> **
>
>

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

Message: 19
Date: Mon, 2 Apr 2007 12:41:15 -0500
From: "ATM Logic" <atm...@km...>
Subject: Re: [SL] Problems upgrading from 2.6.27 to 2.8.0
To: <sql...@li...>
Message-ID: <015001c7754e$1d9f8180$6800a8c0@ATMLogic.local>
Content-Type: text/plain;	charset=3D"US-ASCII"

I am back at 2.6.14 and was just about to go to the 2.7 (support)
version...
Should I jump to 2.8 instead?  After a backup, should I be worried about
the
update? =20
=20
> The easiest is to restore from a backup, delete the second=20
> record in the defaults table and upgrade again.
>=20

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

Message: 20
Date: Mon, 02 Apr 2007 19:56:33 +0200
From: Tage Danielsen <ta...@ht...>
Subject: Re: [SL] Problems upgrading from 2.6.27 to 2.8.0
To: sql...@li...
Message-ID: <461...@ht...>
Content-Type: text/plain; charset=3DISO-8859-1; format=3Dflowed

Dieter Simader wrote:
> The easiest is to restore from a backup, delete the second record in
the=20
> defaults table and upgrade again.
>
> If you don't have a backup you have no choice but to do a manual
upgrade=20
> from the point on when the upgrade script failed. The upgrade failed
in=20
> Pg-upgrade-2.7.5-2.7.6.sql when it tried to rewrite the defaults
table.
>
>  =20
Sorry it don't work, and come with this error

Upgrading to Version 2.8.0 ...
Error!

create table cargo (id int not null, trans_id int not null, package=20
text, netweight float4, grossweight float4, volume float4)
ERROR: could not create relation 1663/17233/111289: Filen eksisterer=20
{file exist}

hope it will be better

Tage from Denmark

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

Message: 21
Date: Mon, 2 Apr 2007 14:30:35 -0500
From: "ATM Logic" <atm...@km...>
Subject: [SL] Upgrade to 2.7 or 2.8?
To: <sql...@li...>
Message-ID: <017d01c7755d$63c7b830$6800a8c0@ATMLogic.local>
Content-Type: text/plain;	charset=3D"US-ASCII"

I am back at 2.6.14 and was just about to go to the 2.7 (support)
version...

Should I jump to 2.8 instead? After a backup, should I be worried about
the
update?=20

PS, sorry to hijack the "Problems upgrading from 2.6.27 to 2.8.0"
earlier...

=20

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

Message: 22
Date: Tue, 3 Apr 2007 09:28:21 +1000
From: George Osvald <geo...@ya...>
Subject: Re: [SL] Problems upgrading from 2.6.27 to 2.8.0
To: sql...@li...
Message-ID: <200...@ya...>
Content-Type: text/plain;  charset=3D"iso-8859-1"

On Tuesday 03 April 2007 03:56, Tage Danielsen wrote:
> Dieter Simader wrote:
> > The easiest is to restore from a backup, delete the second record in
the
> > defaults table and upgrade again.
> >
> > If you don't have a backup you have no choice but to do a manual
upgrade
> > from the point on when the upgrade script failed. The upgrade failed
in
> > Pg-upgrade-2.7.5-2.7.6.sql when it tried to rewrite the defaults
table.
>
> Sorry it don't work, and come with this error

I have done this once before for earlier version. If you do not have
backup or=20
at least system backup to get back to previous version you will have to
go=20
manually and delete all existing files, tables and edit the sql file
error by=20
error. Every time you do something run the setup it will give you
another=20
error. Then you will have to back track and repeat all the steps you
have=20
made to that point and so on. It is painfull but it will teach you one
thing:
Always have a backup before any upgrade.

> Upgrading to Version 2.8.0 ...
> Error!
>
> create table cargo (id int not null, trans_id int not null, package
> text, netweight float4, grossweight float4, volume float4)
> ERROR: could not create relation 1663/17233/111289: Filen eksisterer
> {file exist}
>
> hope it will be better
>
> Tage from Denmark
>
>
------------------------------------------------------------------------
-
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to
share
> your opinions on IT & business topics through brief surveys-and earn
cash
>
http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3D=
DEVDE
V
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

--=20
George
AUSTRALIA
http://www.okstudio.com.au

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

Message: 23
Date: Mon, 2 Apr 2007 16:52:47 -0500
From: Mark Lubratt <mar...@in...>
Subject: Re: [SL] Upgrade to 2.7 or 2.8?
To: sql...@li...
Message-ID: <1D2...@in...>
Content-Type: text/plain; charset=3DUS-ASCII; delsp=3Dyes; =
format=3Dflowed

After a couple of tries, my upgrade went smoothly when I made sure =20
that I had one and only one entry (tuple) in the defaults table.

On Apr 2, 2007, at 2:30 PM, ATM Logic wrote:

> I am back at 2.6.14 and was just about to go to the 2.7 (support) =20
> version...
>
> Should I jump to 2.8 instead? After a backup, should I be worried =20
> about the
> update?
>
> PS, sorry to hijack the "Problems upgrading from 2.6.27 to 2.8.0" =20
> earlier...
>
>
>
> ----------------------------------------------------------------------

> ---
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to =20
> share your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?=20
> page=3Djoin.php&p=3Dsourceforge&CID=3DDEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

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

Message: 24
Date: Tue, 03 Apr 2007 09:01:52 +1000
From: Glen Morris <gl...@au...>
Subject: [SL] Restoring from a pg_dump
To: sql...@li...
Message-ID: <461...@au...>
Content-Type: text/plain; charset=3DISO-8859-1; format=3Dflowed

I have a script that backs up my psql databases each night (SL 2.6.27).=20
For the first time I tried to restore (because of failed 2.8.0 upgrade)=20
from one but it failed. I used this command to create the backup:

    pg_dump -U sql-ledger dea > /spare/backup/postgresql/pgsql-dea_`date
    +%G%m%d`.sql

And then tried to restore as per the manual with:

    psql -U sql-ledger dea < pgsql-dea_20070402.sql

gives lots of:

    invalid command \N
    invalid command \N
    invalid command \N
    invalid command \N
    ERROR:  syntax error at or near "10078" at character 1
    LINE 1: 10078 johne

Restoring from a SL backup works fine but I don't have one that's as=20
current as the pg_dump.

Regards Glen

--=20
Glen Morris: Arachnoid Australia
613 90175780 Melbourne | 612 90164032 Sydney
613 98961811 VoIP | Mbl 0419299140
Skype=3Dglenmo. PO Box 214, Healesville VIC 3777, Australia

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

Message: 25
Date: Tue, 03 Apr 2007 09:45:25 +1000
From: Glen Morris <gl...@au...>
Subject: [SL] Can't process recurring transactions after upgrade to
	2.8.0
To: sql...@li...
Message-ID: <461...@au...>
Content-Type: text/plain; charset=3DISO-8859-1; format=3Dflowed

When I go to process recurring transactions I get the following error:

*Posting Sales Invoice 1 ... **DBD::Pg::db do failed: ERROR: syntax=20
error at or near "WHERE" at character 44
*

    Error!

*UPDATE exchangerate
SET
WHERE curr =3D 'AUD'
AND transdate =3D '01-04-2007'
ERROR: syntax error at or near "WHERE" at character 44*

--=20
Glen Morris: Arachnoid Australia
613 90175780 Melbourne | 612 90164032 Sydney
613 98961811 VoIP | Mbl 0419299140
Skype=3Dglenmo. PO Box 214, Healesville VIC 3777, Australia

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

Message: 26
Date: Tue, 03 Apr 2007 07:09:52 +0200
From: Tage Danielsen <ta...@ht...>
Subject: Re: [SL] Problems upgrading from 2.6.27 to 2.8.0
To: sql...@li...
Message-ID: <461...@ht...>
Content-Type: text/plain; charset=3DISO-8859-1; format=3Dflowed

George Osvald wrote:
> On Tuesday 03 April 2007 03:56, Tage Danielsen wrote:
>  =20
>> Dieter Simader wrote:
>>    =20
>>> The easiest is to restore from a backup, delete the second record in
the
>>> defaults table and upgrade again.
>>>
>>> If you don't have a backup you have no choice but to do a manual
upgrade
>>> from the point on when the upgrade script failed. The upgrade failed
in
>>> Pg-upgrade-2.7.5-2.7.6.sql when it tried to rewrite the defaults
table.
>>>      =20
>> Sorry it don't work, and come with this error
>>    =20
>
> I have done this once before for earlier version. If you do not have
backup or=20
> at least system backup to get back to previous version you will have
to go=20
> manually and delete all existing files, tables and edit the sql file
error by=20
> error. Every time you do something run the setup it will give you
another=20
> error. Then you will have to back track and repeat all the steps you
have=20
> made to that point and so on. It is painfull but it will teach you one
thing:
> Always have a backup before any upgrade.
>
>
>  =20
>> Upgrading to Version 2.8.0 ...
>> Error!
>>
>> create table cargo (id int not null, trans_id int not null, package
>> text, netweight float4, grossweight float4, volume float4)
>> ERROR: could not create relation 1663/17233/111289: Filen eksisterer
>> {file exist}
>>
>> hope it will be better
>>
>> Tage from Denmark
>>
>>
------------------------------------------------------------------------
-
>> Take Surveys. Earn Cash. Influence the Future of IT
>> Join SourceForge.net's Techsay panel and you'll get the chance to
share
>> your opinions on IT & business topics through brief surveys-and earn
cash
>>
http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3D=
DEVDE
V
>> _______________________________________________
>> sql-ledger-users mailing list
>> sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>    =20
>
>  =20
The problem is not backup, I made at filebackup of database and=20
sql-ledger, and I am running 2.6.27 very OK, but I like to upgrade to=20
2.8 due to new features, and this is not running.

Tage from Denmark

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

Message: 27
Date: Thu, 5 Apr 2007 09:18:09 -0500
From: R Pennington <arc...@mt...>
Subject: Re: [SL] Restoring from a pg_dump
To: sql...@li...
Message-ID: <200...@mt...>
Content-Type: text/plain;  charset=3D"iso-8859-1"

On Monday 02 April 2007 6:01 pm, Glen Morris wrote:
> I have a script that backs up my psql databases each night (SL
2.6.27).=20
> For the first time I tried to restore (because of failed 2.8.0
upgrade)=20
> from one but it failed. I used this command to create the backup:
>=20
>     pg_dump -U sql-ledger dea >
/spare/backup/postgresql/pgsql-dea_`date
>     +%G%m%d`.sql
>=20
> And then tried to restore as per the manual with:
>=20
>     psql -U sql-ledger dea < pgsql-dea_20070402.sql
>=20
>=20
> gives lots of:
>=20
>     invalid command \N
>     invalid command \N
>     invalid command \N
>     invalid command \N
>     ERROR:  syntax error at or near "10078" at character 1
>     LINE 1: 10078 johne
>=20
> Restoring from a SL backup works fine but I don't have one that's as=20
> current as the pg_dump.
>=20
> Regards Glen
>=20
>=20
Hi Glen

use pg_restore to restore the data.
pg_dump and pg_restore are designed to be used together.

"psql -U sql-ledger dea < pgsql-dea_20070402.sql" works for restoring SL
backups

Cheers,
Roy

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

Message: 28
Date: Fri, 6 Apr 2007 10:06:08 +1000
From: George Osvald <geo...@ya...>
Subject: Re: [SL] Restoring from a pg_dump
To: sql...@li...
Message-ID: <200...@ya...>
Content-Type: text/plain;  charset=3D"iso-8859-1"

On Friday 06 April 2007 00:18, R Pennington wrote:
> On Monday 02 April 2007 6:01 pm, Glen Morris wrote:
> > I have a script that backs up my psql databases each night (SL
2.6.27).
> > For the first time I tried to restore (because of failed 2.8.0
upgrade)
> > from one but it failed. I used this command to create the backup:
> >
> >     pg_dump -U sql-ledger dea >
/spare/backup/postgresql/pgsql-dea_`date
> >     +%G%m%d`.sql
> >
> > And then tried to restore as per the manual with:
> >
> >     psql -U sql-ledger dea < pgsql-dea_20070402.sql
> >
> >
> > gives lots of:
> >
> >     invalid command \N
> >     invalid command \N
> >     invalid command \N
> >     invalid command \N
> >     ERROR:  syntax error at or near "10078" at character 1
> >     LINE 1: 10078 johne
> >
> > Restoring from a SL backup works fine but I don't have one that's as
> > current as the pg_dump.
> >
> > Regards Glen
>

When I was using a backup file created from SL I would change for
postgres=20
user and then go:

psql \i backup.sql mydatabase

If I was getting any error messages either from sql traceback or after
login I=20
would copy those on clipboard resolve and run the command again. (for
example=20
I had existing tables that I had to delete) I also found that I had to

delete my database before restoring otherwise I would get double
entries.

Normally how ever I am running automatic backups from cron for the whole

system and also for databases. Something like this:
0 4 * * *	postgres pg_dump --format=3Dt mydatabase > backup.tgz
20 4 * * *	postgres   pg_dumpall > alldata.sql

Typically I would restore from alldata.sql with:

psql template1 -f alldata.sql

that resores your whole database structure.

--=20
George
AUSTRALIA
http://www.okstudio.com.au

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

Message: 29
Date: Thu, 5 Apr 2007 23:33:08 -0700
From: hh...@ch...
Subject: [SL] Looking for a bookkeeper who knows how to use SQL-Ledger
To: sql...@li...
Message-ID: <200...@ch...>
Content-Type: text/plain;  charset=3D"us-ascii"

SQL-Ledger seems to be a very powerful accounting system.  We need help
from a=20
bookkeeper who knows how to use this program.  Please contact me if you
are=20
such a person or know such a person.  We need part-time help starting=20
immediately.  It would be great to find someone in the Los Angeles area.

Thank you

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

Message: 30
Date: Thu, 5 Apr 2007 23:44:25 -0700
From: hh...@ch...
Subject: [SL] SQL-Ledger on Apache Tomcat: it works
To: sql...@li...
Message-ID: <200...@ch...>
Content-Type: text/plain;  charset=3D"us-ascii"

If anyone is interested in information about running SQL-Ledger on
Apache=20
Tomcat, let me know.  I had to make some modifications to the CGI
servlet=20
that comes with Tomcat, but I did that and it's fine. I would be happy
to=20
share my modified servlet with anyone who wants it.  If someone could
post it=20
somewhere that would be great too.

SQL-Ledger was the last and only thing I was using Apache HTTPD for so
it was=20
great to finally get it to Tomcat and get rid of Apache HTTPD.

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

Message: 31
Date: Fri, 6 Apr 2007 16:36:40 -0300 (ART)
From: Chris Johnson <vac...@ya...>
Subject: [SL] AR balance sheet vs trial balance vs outstanding
To: sql...@li...
Message-ID: <999...@we...>
Content-Type: text/plain; charset=3Diso-8859-1

Hi all,
=20
 I am working on closing out 2005 (still!). After a long time looking at
the books and reports, talking with the accountant etc, I am suspecting
the Accounts Receivable as having to do with my problem, so I wanted to
see if anyone could shed some light on this issue.=20
=20
 My accounting is on a cash basis, and I am generating the balance sheet
[1] and seeing a line for AR in assets. When I generate the trial
balance, I see an amount for AR that is different (larger) than what
showed on the balance sheet. I also tried to compare this to what I get
if I do a report on open AR transactions - and I get yet another number
for outstanding AR! Any idea why these would be different?=20
=20
 The other thing I am suspecting has to do with the current earnings vs
net income. I performed a "year end" process at 12-31-2005. However, my
current earnings (Balance Sheet) and net income (Income Statement) still
do not match. I thought this process was supposed to bring these two
into line. Any suggestions on bringing them into balance?=20
=20
 Thanks in advance for your help in setting this issue.=20
=20
 Regards,
 Chris
=20
 [1] Why is AR shown on the balance sheet for cash accounting?=20

 	=09
---------------------------------
 Pregunt?. Respond?. Descubr?.
 Todo lo que quer?as saber, y lo que ni imaginabas,
 est? en Yahoo! Respuestas (Beta).
 Probalo ya!=20

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

------------------------------------------------------------------------
-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share
your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3D=
DEVDE
V

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

_______________________________________________
sql-ledger-users mailing list
sql...@li...
https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

End of sql-ledger-users Digest, Vol 12, Issue 1
***********************************************