Re: [SL] Problems upgrading from 2.6.27 to 2.8.0

[Dieter S. <dsi...@sq...>]

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