Upgrade from 1.4 to 1.6

mibo 2010-09-15 19:15:25 UTC #1

I’m trying to install version 1.6 on Ubuntu 10.04 LTS an import my data from a 1.4 installation on a Debian machine. Database is PostgreSQL in all cases.

First I tried the Ubuntu version 1.6.001. This can import my last 1.4 backup fine (no errors, data shows up in database tables) but I can not login afterwards because of the infamous ‘Session could not be verified’ error. This is the same if I do a clean install or import my old data.

Then I tried version 1.6.003 from the opensuse Ubuntu rep. Now I can login, but I can’t import my old data. Neither the original 1.4 backup nor a backup that I made from 1.6.001 with the old data importet. The error messages on import look like this:

Database error: Invalid SQL: SELECT setval(‘seq_egw_sitemgr_pages’,MAX(page_id)) FROM egw_sitemgr_pages
pgsql Error: -1 (FEHLER: Relation »seq_egw_sitemgr_pages« existiert nicht LINE 1: SELECT setval(‘seq_egw_sitemgr_pages’,MAX(page_id)) FROM egw… ^)

File: /usr/share/egroupware/phpgwapi/inc/class.schema_proc.inc.php
Line: 595
Function: schema_proc::query / schema_proc::UpdateSequence / db_backup::restore

Database error: Invalid SQL: SELECT setval(‘seq_phpgw_mydms_groups’,MAX(id)) FROM phpgw_mydms_groups
pgsql Error: -1 (FEHLER: aktuelle Transaktion wurde abgebrochen, Befehle werden bis zum Ende der Transaktion ignoriert)

File: /usr/share/egroupware/phpgwapi/inc/class.schema_proc.inc.php
Line: 595
Function: schema_proc::query / schema_proc::UpdateSequence / db_backup::restore

Database error: Invalid SQL: SELECT setval(‘seq_egw_emailadmin’,MAX(ea_profile_id)) FROM egw_emailadmin
pgsql Error: -1 (FEHLER: aktuelle Transaktion wurde abgebrochen, Befehle werden bis zum Ende der Transaktion ignoriert)

File: /usr/share/egroupware/phpgwapi/inc/class.schema_proc.inc.php
Line: 595
Function: schema_proc::query / schema_proc::UpdateSequence / db_backup::restore

Database error: Invalid SQL: SELECT setval(‘seq_egw_tracker_bounties’,MAX(bounty_id)) FROM egw_tracker_bounties
pgsql Error: -1 (FEHLER: aktuelle Transaktion wurde abgebrochen, Befehle werden bis zum Ende der Transaktion ignoriert)

File: /usr/share/egroupware/phpgwapi/inc/class.schema_proc.inc.php
Line: 595
Function: schema_proc::query / schema_proc::UpdateSequence / db_backup::restore

and so on.

mibo 2010-09-15 21:26:52 UTC #2

I tried a different approach.

Install 1.6.001 from Ubuntu
import data from 1.4 backup
let EGroupware convert to 1.6.001 tables
save /var/lib/egroupware/header-inc.php
upgrade packages to 1.6.003
in egroupware/setup do the installation tests
then copy the saved header-inc.php back to /var/lib/egroupware
login

Now I can login and have my data back. But now making new backups gives very small files with excactly this content:
eGroupWare backup from 2010-09-15 23:09:59

version: 1.6.003

charset: utf-8

    $phpgw_baseline = array(
            
    );

schema: a:0:{}

Ralf_Becker_Stylite 2010-09-16 05:10:46 UTC #3

Hi,

the backup bug is fixed, if you use our daily snapshot
(www.egroupware.org/download) and eg. unpack it over the package in
/usr/share/egroupware.

It’s also fixed in the upcomming 1.8 release, probably available as
release candidate today or tomorrow.

Ralf

mibo wrote:

I’m trying to install version 1.6 on Ubuntu 10.04 LTS an import my data
from a 1.4 installation on a Debian machine. Database is PostgreSQL in all
cases.

First I tried the Ubuntu version 1.6.001. This can import my last 1.4
backup fine (no errors, data shows up in database tables) but I can not
login afterwards because of the infamous 'Session could not be verified’
error. This is the same if I do a clean install or import my old data.

Then I tried version 1.6.003 from the opensuse Ubuntu rep. Now I can
login, but I can’t import my old data. Neither the original 1.4 backup nor
a backup that I made from 1.6.001 with the old data importet. The error
messages on import look like this:

I tried a different approach.

Install 1.6.001 from Ubuntu

import data from 1.4 backup

let EGroupware convert to 1.6.001 tables

save /var/lib/egroupware/header-inc.php

upgrade packages to 1.6.003

in egroupware/setup do the installation tests

then copy the saved header-inc.php back to /var/lib/egroupware

login

Now I can login and have my data back. But now making new backups gives very
small files with excactly this content:
eGroupWare backup from 2010-09-15 23:09:59

version: 1.6.003

charset: utf-8
    $phpgw_baseline = array(
            
    );
schema: a:0:{}

–
Ralf Becker
Director Software Development

Stylite GmbH
[open style of IT]

Morschheimer Strasse 15
67292 Kirchheimbolanden

fon +49 (0) 6352 70629-0
fax +49 (0) 6352 70629-30
mailto: rb@stylite.de

www.stylite.de
www.egroupware.org

Geschäftsführer Andre Keller,
Gudrun Müller, Ralf Becker
Registergericht Kaiserslautern HRB 30575
Umsatzsteuer-Id / VAT-Id: DE214280951

Start uncovering the many advantages of virtual appliances
and start using them to simplify application deployment and
accelerate your shift to cloud computing.
http://p.sf.net/sfu/novell-sfdev2dev

eGroupWare-users mailing list
eGroupWare-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-users

mibo 2010-09-16 19:44:36 UTC #4

Hi,

the backup bug is fixed, if you use our daily snapshot
(www.egroupware.org/download) and eg. unpack it over the package in
/usr/share/egroupware.

Ah, that works. Thanks. Do you have an idea why 1.6.001 can import the
backup from 1.4 and 1.6.003 can not?

Start uncovering the many advantages of virtual appliances
and start using them to simplify application deployment and
accelerate your shift to cloud computing.
http://p.sf.net/sfu/novell-sfdev2dev

eGroupWare-users mailing list
eGroupWare-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-users

Ralf_Becker_Stylite 2010-09-17 07:31:20 UTC #5

I guess an other bug

Ralf

Hi,

the backup bug is fixed, if you use our daily snapshot
(www.egroupware.org/download) and eg. unpack it over the package in
/usr/share/egroupware.

Ah, that works. Thanks. Do you have an idea why 1.6.001 can import the
backup from 1.4 and 1.6.003 can not?

Start uncovering the many advantages of virtual appliances
and start using them to simplify application deployment and
accelerate your shift to cloud computing.
http://p.sf.net/sfu/novell-sfdev2dev

eGroupWare-users mailing list
eGroupWare-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-users

–
Ralf Becker
Director Software Development

Stylite GmbH
[open style of IT]

Morschheimer Strasse 15
67292 Kirchheimbolanden

fon +49 (0) 6352 70629-0
fax +49 (0) 6352 70629-30
mailto: rb@stylite.de

www.stylite.de
www.egroupware.org

Geschäftsführer Andre Keller,
Gudrun Müller, Ralf Becker
Registergericht Kaiserslautern HRB 30575
Umsatzsteuer-Id / VAT-Id: DE214280951

Start uncovering the many advantages of virtual appliances
and start using them to simplify application deployment and
accelerate your shift to cloud computing.
http://p.sf.net/sfu/novell-sfdev2dev

eGroupWare-users mailing list
eGroupWare-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-users