Menu
▾
▴
Re: [SL] Help on SQL-Ledger needed ...
|
From: Bob G. <bo...@rc...> - 2007-10-01 13:38:46
|
My guess is that you have not yet created some of the tables. Have you skipped a step in the new user list? I had this same error a couple of days ago. The reason was that I had dumped all my data and then did a DROP DATABASE "sql-ledger"; CREATE DATABASE "sql-ledger"; on another machine in preparation to load the dumped data. I was interrupted and forgot to do the load. When I next logged in, I got the error you noted. The database sql-ledger was there, but it was empty. Have fun Bob G On Mon, 2007-04-09 at 00:55 -0400, Joshua Chan wrote: > 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, > please take notice that any disclosure, copying, distribution, > review,retransmission or taking of any other > 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="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 > > 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="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 > > 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="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. > > > > > > > > > I reccomend using Portsnap instead of cvsup. > > > > http://www.freebsd.org/doc/en_US.ISO8859-1/books/handbook/port > > snap.html > > > > -------------------------------------------------------------- > > ----------- > > 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=join.php&p=sourceforge > &CID=DEVDEV > > _______________________________________________ > > sql-ledger-users mailing list > > sql...@li... > > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > > > > > > > ------------------------------ > > 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="us-ascii" > > Awesome. > > Lynx style menu works better with dopod anyway - Display is small. > > Dieter Simader wrote: > > pass terminal=lynx on the URL > > > > http://localhost/sql-ledger/login.pl?terminal=lynx > > > > 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=login&login=the_login&passwo > rd=the_password > > > > > > -- > 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=ISO-8859-1; format=flowed > > 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=ISO-8859-1; format=flowed > > 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 > > > > ------------------------------ > > 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=US-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=off> 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?? > > > > 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?? > > > > > > > > ?? > > > > > > > > If you're really insistent on having a GUI check out > > > www.pcbsd.org - > > > > FBSD + KDE > > > > > > > > > > Looks like I cannot install SQL on the VMWare package of this :( > > > > > > At least not using: > > > cd /usr/ports/finance/sql-ledger/ && make install clean > > > > > > > > > -------------------------------------------------------------- > > > ----------- > > > 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=join.php&p=sourceforge > > > &CID=DEVDEV > > > _______________________________________________ > > > sql-ledger-users mailing list > > > sql...@li... > > > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > > > > > > > > > > ------------------------------------------------------------------------ > - > > 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=join.php&p=sourceforge&CID=DEVDE > V > > _______________________________________________ sql-ledger-users > > mailing list sql...@li... > > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > > > > > > ------------------------------ > > 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=US-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 > > > > > > 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=join.php&p=sourceforge&CID=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="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. > > > <%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=ISO-8859-1; format=flowed > > Hi Jigme > > I do the same as David, if you set up your 'deduction' liability > 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 > gross pay and assign it to an expense and then use negative numbers to > 'deduct' from the gross and assign the 'deductions' to liability > accounts. When I'm all done printing the cheques I do a GL entry to > account for the matching expenses, I, for example, expense the amount I > have to match on their pension contributions (Pension expense) and add > it to a liability account called 'pension owing' (same account I used > when cutting their cheque). This way both my contribution and their > contribution end up in the same liability account. At the end of the > month when it's time for remittance I pay from a bank account and > decrease the liability account back to zero. > > None of this does anything for the calculations that have to be made to > determine how much each employee has to pay each of the various > deductions. I have a spreadsheet with the Canadian formulas in it to do > 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: > > > >> 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 > > > > > > > >> 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=join.php&p=sourceforge&CID=DEVDE > V > >> _______________________________________________ > >> sql-ledger-users mailing list > >> sql...@li... > >> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > >> > > > > > > > ------------------------------------------------------------------------ > - > > 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=join.php&p=sourceforge&CID=DEVDE > V > > _______________________________________________ > > sql-ledger-users mailing list > > sql...@li... > > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > > > > > > > > > > ------------------------------ > > 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=ISO-8859-1; format=flowed > > 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. > > > > ... OR ... > > > > Simply use Fedora Core instead, & it will automagically work. > > > 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=ISO-8859-1; format=flowed > > 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=join.php&p=sourceforge&CID=DEVDE > V > > _______________________________________________ > > sql-ledger-users mailing list > > sql...@li... > > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > > > > > -- > 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="us-ascii" > > Hey- > > All of a sudden after an upgrade, my html invoice template is broken. My > Latex > 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=ISO-8859-1; format=flowed > > 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', > (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=ISO-8859-1; format=flowed > > 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 > ** > > -- > Glen Morris: Arachnoid Australia > 613 90175780 Melbourne | 612 90164032 Sydney > 613 98961811 VoIP | Mbl 0419299140 > Skype=glenmo. 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=US-ASCII; format=flowed > > 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. > > -- > Dieter Simader http://www.sql-ledger.com Tel: (780) 472-8161 > DWS Systems Inc. Accounting Software Fax: (780) 478-5281 > ============== On a clear disk you can seek forever ================ > > 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="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? > > > The easiest is to restore from a backup, delete the second > > record in the defaults table and upgrade again. > > > > > > > ------------------------------ > > 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=ISO-8859-1; format=flowed > > 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 > > 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 > > > > ------------------------------ > > 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="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? > > PS, sorry to hijack the "Problems upgrading from 2.6.27 to 2.8.0" > earlier... > > > > > > ------------------------------ > > 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="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 > at least system backup to get back to previous version you will have to > go > manually and delete all existing files, tables and edit the sql file > error by > error. Every time you do something run the setup it will give you > another > error. Then you will have to back track and repeat all the steps you > have > 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=join.php&p=sourceforge&CID=DEVDE > V > > _______________________________________________ > > sql-ledger-users mailing list > > sql...@li... > > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > > -- > 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=US-ASCII; delsp=yes; format=flowed > > After a couple of tries, my upgrade went smoothly when I made sure > 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) > > version... > > > > Should I jump to 2.8 instead? After a backup, should I be worried > > about the > > update? > > > > PS, sorry to hijack the "Problems upgrading from 2.6.27 to 2.8.0" > > earlier... > > > > > > > > ---------------------------------------------------------------------- > > > --- > > 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=join.php&p=sourceforge&CID=DEVDEV > > _______________________________________________ > > 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=ISO-8859-1; format=flowed > > 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 > > > -- > Glen Morris: Arachnoid Australia > 613 90175780 Melbourne | 612 90164032 Sydney > 613 98961811 VoIP | Mbl 0419299140 > Skype=glenmo. 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=ISO-8859-1; format=flowed > > When I go to process recurring transactions I get the following error: > > *Posting Sales Invoice 1 ... **DBD::Pg::db do failed: ERROR: syntax > error at or near "WHERE" at character 44 > * > > > Error! > > *UPDATE exchangerate > SET > WHERE curr = 'AUD' > AND transdate = '01-04-2007' > ERROR: syntax error at or near "WHERE" at character 44* > > > -- > Glen Morris: Arachnoid Australia > 613 90175780 Melbourne | 612 90164032 Sydney > 613 98961811 VoIP | Mbl 0419299140 > Skype=glenmo. 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=ISO-8859-1; format=flowed > > George Osvald wrote: > > 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 > > at least system backup to get back to previous version you will have > to go > > manually and delete all existing files, tables and edit the sql file > error by > > error. Every time you do something run the setup it will give you > another > > error. Then you will have to back track and repeat all the steps you > have > > 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=join.php&p=sourceforge&CID=DEVDE > V > >> _______________________________________________ > >> sql-ledger-users mailing list > >> sql...@li... > >> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > >> > > > > > The problem is not backup, I made at filebackup of database and > sql-ledger, and I am running 2.6.27 very OK, but I like to upgrade to > 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="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). > > 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 > > > > > 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="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 > user and then go: > > psql \i backup.sql mydatabase > > If I was getting any error messages either from sql traceback or after > login I > would copy those on clipboard resolve and run the command again. (for > example > 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=t 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. > > > -- > 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="us-ascii" > > SQL-Ledger seems to be a very powerful accounting system. We need help > from a > bookkeeper who knows how to use this program. Please contact me if you > are > such a person or know such a person. We need part-time help starting > 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="us-ascii" > > If anyone is interested in information about running SQL-Ledger on > Apache > Tomcat, let me know. I had to make some modifications to the CGI > servlet > that comes with Tomcat, but I did that and it's fine. I would be happy > to > share my modified servlet with anyone who wants it. If someone could > post it > somewhere that would be great too. > > SQL-Ledger was the last and only thing I was using Apache HTTPD for so > it was > 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=iso-8859-1 > > Hi all, > > 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. > > 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? > > 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? > > Thanks in advance for your help in setting this issue. > > Regards, > Chris > > [1] Why is AR shown on the balance sheet for cash accounting? > > > --------------------------------- > Pregunt?. Respond?. Descubr?. > Todo lo que quer?as saber, y lo que ni imaginabas, > est? en Yahoo! Respuestas (Beta). > Probalo ya! > > ------------------------------ > > ------------------------------------------------------------------------ > - > 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=join.php&p=sourceforge&CID=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 > *********************************************** > > > > ------------------------------------------------------------------------- > 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=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > sql-ledger-users mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users |
