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
>