Upgrade from 1.8 to 16.1

[James_Neale]

Hi all
Our server died with our old 1.8.004 install of egroupware.
Instead of reinstalling 1.8, I’d like to upgrade to the latest version.
so I installed 16.1 and restored our backup but get the following msg upon login.

Invalid SQL: INSERT INTO egw_access_log (session_php,loginid,ip,li,account_id,user_agent,session_dla,session_action) VALUES ('d15njbn4rlh9hq3v8jv9ors9e5','madmin@default','192.168.1.10',1475972860,13,'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:49.0) Gecko/20100101 Firefox/49.0',1475972860,'/login.php') Unknown column 'user_agent' in 'field list' (1054)

Has anyone else seen this error on upgrade or even attempted an upgrade like this?
or should I step from 1.8 ->14.1 -> 16.1 instead?

I’d be very interested to try the 16.1 version, but I can’t lose all our data.

[Yann_Lehmann]

Hi James

Hi all
Our server died with our old 1.8.004 install of egroupware.
Instead of reinstalling 1.8, I’d like to upgrade to the latest version.
so I installed 16.1 and restored our backup but get the following msg upon
login.

Which message ?

---

Check out the vibrant tech community on one of the world’s most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot

---

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

[RalfBecker]

Hi James,

Hi all
Our server died with our old 1.8.004 install of egroupware.
Instead of reinstalling 1.8, I’d like to upgrade to the latest version.
so I installed 16.1 and restored our backup but get the following msg upon
login.

Invalid SQL: INSERT INTO egw_access_log (session_php,loginid,ip,li,account_id,user_agent,session_dla,session_action) VALUES (‘d15njbn4rlh9hq3v8jv9ors9e5’,‘madmin@default’,‘192.168.1.10’,1475972860,13,‘Mozilla/5.0 (Windows NT 6.1; WOW64; rv:49.0) Gecko/20100101 Firefox/49.0’,1475972860,’/login.php’) Unknown column ‘user_agent’ in ‘field list’ (1054)
How did you do the restore? If you use eg. mysql(dump), you need to drop
all tables from your 16.1 install first, then import the 1.8 dump and
last update the schema to get eg. the column you lack in the SQL
statement you gave. If you update direkt from 1.8 to 16.1, you need to
install the egroupware-epl-compat package, or you will loose your mail
accounts (if you use mail). There’s no need to loose data in our
upgrades. If you need further assistance, we have special update
(support) packages available:
https://www.egroupware.org/en/products/migration-update-packages.html Ralf
Has anyone else seen this error on upgrade or even attempted an upgrade like
this?
or should I step from 1.8 ->14.1 -> 16.1 instead?

I’d be very interested to try the 16.1 version, but I can’t lose all our
data.

---

–
www.redcartel.com.au
www.kajimba.com
www.jellibots.com
–
Ralf Becker
EGroupware GmbH [www.egroupware.org]
Handelsregister HRB Kaiserslautern 3587
Geschäftsführer Birgit und Ralf Becker
Leibnizstr. 17, 67663 Kaiserslautern, Germany
Telefon +49 631 31657-0