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.