sql-ledger-users

[SL] Big trouble after server crash

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

The hard disk on my server crashed, and I now notice that the backup
server, which I had thought was mirroring the main server has many, many
duplicated records. (I guess the pg_restore command I was running
automatically wasn't working so well.) When I try to post a transaction
I get this message:

DBD::Pg::db do failed: ERROR: more than one row returned by a subquery
used as an expression

Error!
INSERT INTO acc_trans (trans_id, chart_id, amount,
transdate)
VALUES (36053,
(SELECT id FROM chart
WHERE accno = '4202'),
-20, '2008-11-20')
ERROR: more than one row returned by a subquery used as an expression

Does anyone know what I can do to fix this? A little postgres magic? The
business will grind to a halt unless I can get this going again. 

Please!!
-- 
Stuart Luppescu -=- s-luppescu .at. uchicago.edu        
University of Chicago (^_^)/ CCSR 
才文と智奈美の父 -=-=- Kernel 2.6.25-gentoo-r
"Our vision is to speed up time, eventually
 eliminating it."   -- Alex Schure 
 
 
 

Re: [SL] Big trouble after server crash

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

On 木, 2008-11-20 at 22:29 -0600, Stuart Luppescu wrote:
> The hard disk on my server crashed, and I now notice that the backup
> server, which I had thought was mirroring the main server has many, many
> duplicated records. 

I was able to wipe out the old data base and restore from an old backup,
thus eliminating the duplicate record problem. But now when I do System
-> Backup -> Save to File I get these messages:

DBD::Pg::db selectrow_array failed: ERROR: relation "paymentid" does not exist
DBD::Pg::db selectrow_array failed: ERROR: relation "tempid" does not exist
DBD::Pg::db selectrow_array failed: ERROR: relation "tempid" does not exist
DBD::Pg::st execute failed: ERROR: relation "defau" does not exist

Error!
SELECT * FROM defau
ERROR: relation "defau" does not exist

Anyone know how to fix this?

Thanks very much in advance.

-- 
Stuart Luppescu -=- s-luppescu .at. uchicago.edu        
University of Chicago (^_^)/ CCSR 
才文と智奈美の父 -=-=- Kernel 2.6.25-gentoo-r
Life is what happens to you while you're busy
 making other plans.   -- John Lennon, "Beautiful
 Boy" 
 
 

Re: [SL] Big trouble after server crash

[Paul T. <pt...@wa...>]

Update to latest verson, using update scripst.
Then open the admin.pl to update database for starters?

2008/11/21 Stuart Luppescu <sl...@cc...>

> On 木, 2008-11-20 at 22:29 -0600, Stuart Luppescu wrote:
> > The hard disk on my server crashed, and I now notice that the backup
> > server, which I had thought was mirroring the main server has many, many
> > duplicated records.
>
> I was able to wipe out the old data base and restore from an old backup,
> thus eliminating the duplicate record problem. But now when I do System
> -> Backup -> Save to File I get these messages:
>
> DBD::Pg::db selectrow_array failed: ERROR: relation "paymentid" does not
> exist
> DBD::Pg::db selectrow_array failed: ERROR: relation "tempid" does not exist
> DBD::Pg::db selectrow_array failed: ERROR: relation "tempid" does not exist
> DBD::Pg::st execute failed: ERROR: relation "defau" does not exist
>
> Error!
> SELECT * FROM defau
> ERROR: relation "defau" does not exist
>
> Anyone know how to fix this?
>
> Thanks very much in advance.
>
> --
> Stuart Luppescu -=- s-luppescu .at. uchicago.edu
> University of Chicago (^_^)/ CCSR
> 才文と智奈美の父 -=-=- Kernel 2.6.25-gentoo-r
> Life is what happens to you while you're busy
>  making other plans.   -- John Lennon, "Beautiful
>  Boy"
>
>
>
>
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's
> challenge
> Build the coolest Linux based applications with Moblin SDK & win great
> prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

Re: [SL] Big trouble after server crash

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

2008/11/21 Paul Tammes <pt...@wa...>:
> Update to latest verson, using update scripst.
> Then open the admin.pl to update database for starters?

SL will upgrade the database when any regular user will login first
time after upgrade. There is no need for admin login.

-- 
* Purpose-built SQL-Ledger Hosting. Free trial.
* SQL-Ledger Documentation Wiki
* SQL-Ledger VMware Appliance. Free download.
http://www.ledger123.com/

--

Re: [SL] Big trouble after server crash

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

On 金, 2008-11-21 at 11:36 +0100, Paul Tammes wrote:
> Update to latest verson, using update scripst.
> Then open the admin.pl to update database for starters?

I tried upgrading to 2.8.18, but I had lots of problems (the automatic
upgrade scripts didn't work completely), and I didn't like the new
features -- they messed up my established routines for making reports,
doing payroll, etc. So, I went back to 2.6.27, which serves my purposes
fine.

There must be a way to fix this without upgrading.

> 2008/11/21 Stuart Luppescu <sl...@cc...>
> 
> > On 木, 2008-11-20 at 22:29 -0600, Stuart Luppescu wrote:
> > > The hard disk on my server crashed, and I now notice that the backup
> > > server, which I had thought was mirroring the main server has many, many
> > > duplicated records.
> >
> > I was able to wipe out the old data base and restore from an old backup,
> > thus eliminating the duplicate record problem. But now when I do System
> > -> Backup -> Save to File I get these messages:
> >
> > DBD::Pg::db selectrow_array failed: ERROR: relation "paymentid" does not
> > exist
> > DBD::Pg::db selectrow_array failed: ERROR: relation "tempid" does not exist
> > DBD::Pg::db selectrow_array failed: ERROR: relation "tempid" does not exist
> > DBD::Pg::st execute failed: ERROR: relation "defau" does not exist
> >
> > Error!
> > SELECT * FROM defau
> > ERROR: relation "defau" does not exist
> >
> > Anyone know how to fix this?
> >
> > Thanks very much in advance.
> >
> > --
> > Stuart Luppescu -=- s-luppescu .at. uchicago.edu
> > University of Chicago (^_^)/ CCSR
> > 才文と智奈美の父 -=-=- Kernel 2.6.25-gentoo-r
> > Life is what happens to you while you're busy
> >  making other plans.   -- John Lennon, "Beautiful
> >  Boy"
> >
> >
> >
> >
> > -------------------------------------------------------------------------
> > This SF.Net email is sponsored by the Moblin Your Move Developer's
> > challenge
> > Build the coolest Linux based applications with Moblin SDK & win great
> > prizes
> > Grand prize is a trip for two to an Open Source event anywhere in the world
> > http://moblin-contest.org/redirect.php?banner_id=100&url=/
> > _______________________________________________
> > sql-ledger-users mailing list
> > sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> >
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> Build the coolest Linux based applications with Moblin SDK & win great prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
-- 
Stuart Luppescu -=- slu .at. ccsr.uchicago.edu        
University of Chicago -=- CCSR 
才文と智奈美の父 -=-    Kernel 2.6.25-gentoo-r7                
Harmony: Is Antonio Banderas a vampire?  Spike:No. 
 Harmony: Can I make him one?  Spike: No. On second
 thought, yes. Go make him a vampire. Take  your
 time. Get Melanie and the kids, too. 
 
 
 
 
 

Re: [SL] Big trouble after server crash

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

Look into the defaults table and see what is in the 'version' column
in the database just restored.

-- 
* Purpose-built SQL-Ledger Hosting. Free trial.
* SQL-Ledger Documentation Wiki
* SQL-Ledger VMware Appliance. Free download.
http://www.ledger123.com/

--

[SL] OK - Here we go - the VAT question

[Kevin B. <kb...@fr...>]

So I add another account for 15% VAT.

Go to the customer page and tick the box to enable 15% VAT and leave the 
17.5% box ticked.

Go to the service/item page and tick the 15% box and leave the 17.5% box 
ticked.

Now how do I create an invoice and use the 15% rate?

I can't untick either of the 17.5% boxes as looking at old invoices 
means they are wrong.

So - how do we set the 'default' VAT rate to use when creating invoices?

And another question - how does this work with scheduled transactions?

Thanks,

-- 
*Kevin Bailey*
Director/Programmer - Freeway Projects Limited
Web: www.freewayprojects.com <http://www.freewayprojects.com/>
Email: kb...@fr... <mailto:kb...@fr...>
Phone: +44 (0)1752 267090

Re: [SL] OK - Here we go - the VAT question

[Kevin B. <kb...@fr...>]

Kevin Bailey wrote:
> So I add another account for 15% VAT.
>
> Go to the customer page and tick the box to enable 15% VAT and leave the 
> 17.5% box ticked.
>
> Go to the service/item page and tick the 15% box and leave the 17.5% box 
> ticked.
>
> Now how do I create an invoice and use the 15% rate?
>
> I can't untick either of the 17.5% boxes as looking at old invoices 
> means they are wrong.
>
> So - how do we set the 'default' VAT rate to use when creating invoices?
>
> And another question - how does this work with scheduled transactions?
>
> Thanks,
>
>   

To answer my own post...

After adding the VAT account it is necessary to go to system - taxes to 
set the rate. Here it is possible to set an end date for the rate.

Next all customers, suppliers, parts and services need to have the VAT 
rate box ticked - this is a bit of a bind - is there anyway of 
automating this easily?

But the Brucie bonus is that it looks like the VAT rates will be set 
correctly for future invoices produced by the scheduled transactions.

Cheers,

Kevin


-- 
*Kevin Bailey*
Director/Programmer - Freeway Projects Limited
Web: www.freewayprojects.com <http://www.freewayprojects.com/>
Email: kb...@fr... <mailto:kb...@fr...>
Phone: +44 (0)1752 267090

Re: [SL] OK - Here we go - the VAT question

[Paul T. <pt...@wa...>]

There is a valid from - to field for VAT rates iirc

2008/12/1 Kevin Bailey <kb...@fr...>

> So I add another account for 15% VAT.
>
> Go to the customer page and tick the box to enable 15% VAT and leave the
> 17.5% box ticked.
>
> Go to the service/item page and tick the 15% box and leave the 17.5% box
> ticked.
>
> Now how do I create an invoice and use the 15% rate?
>
> I can't untick either of the 17.5% boxes as looking at old invoices
> means they are wrong.
>
> So - how do we set the 'default' VAT rate to use when creating invoices?
>
> And another question - how does this work with scheduled transactions?
>
> Thanks,
>
> --
> *Kevin Bailey*
> Director/Programmer - Freeway Projects Limited
> Web: www.freewayprojects.com <http://www.freewayprojects.com/>
> Email: kb...@fr... <mailto:kb...@fr...>
> Phone: +44 (0)1752 267090
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's
> challenge
> Build the coolest Linux based applications with Moblin SDK & win great
> prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>