Re: [SL] some .pl files dont get found.

[Dieter R. <die...@st...>]

Rolf Stöckli schrieb:
> If you open an existing customer, there are these 2 buttons. If you see 
> his address or are able to add a new customer, you are already on ct.pl. 
> Add and Update are only subroutines of this script. In this case, the 
> problem is that after processing your are not forwarded you to ct.pl 
> again. Difficult to say why!

OK, I upgraded to 2.6 which worked and fixed the issue.

> 
>> I tried upgrading from 2.4.7, which fails with some column "old"
>> missing. so I wanted to try smaller upgrades and tried 2.4.16 first.
> 
> The small steps should be performed automatically. Maybe your db is 
> already corrupted now. I suggest to upgrade to 2.8.18, login to Postgres:


I tried to upgrade from 2.6.27 to latest 2.8, which fails with:

Upgrading to Version 2.8.18 ...
Error!

insert into temp (aid) select oid from assembly
FEHLER: Spalte »oid« existiert nicht



> 
> "drop database dbname;
> create database dbname;
> \i backup.sql
> 
> when you log in the dataset will be upgraded"
> (Dieter Simader, User Forum, 17.10.08)

how exactly and (more important) with which version should I make that
backup? right now, as I am moving from one server to a new one, I made a
backup with

pg_dump --format=p -c -U postgres <tablename> --file=backup.sql

on the old server, and

psql -U postgres -d tablename -f backup.sql

on the new one.

> 
> Gruss aus dem Glarnerland
> Rolf
> 

cu, Gruss aus Zuerich,

Dieter

> -------------------------------------------------------------------------
> 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