Topic: groupoffice 2.18 upgrade

[sal1504]

I am currently using groupoffice 2.17 and would like to upgrade to 2.18 but i have a lot of information in 2.17 that i want to transfer over. Not only my information but information for a 147 users. I can not find a how to on transfering or upgrading groupoffice. Has anyone successfully upgrade to 2.18 and managed to keep their information intact? If so how do you do this? I have a test server that i am willing to try things on before I update the production server which is sme 7.2 and i have good backups of my groupoffice. So, I am not afraid of testing things I just need to know what to do. Thanks in advance for any help.

[berdie]

Hi,

with my new version of 2.18 it should be possible to upgrade from former versions of >2.16.
But you should have your GO installation in the /opt/groupoffice folder.
Detailed informations can be found here: http://wiki.contribs.org/GroupOffice

Greetings,
Dietmar

[sal1504]

Dietmer

I have followed the instructions in the wiki/contib and groupoffice loads in /opt/groupoffice. When i install version 2.18 I loose all data that was in 2.17. In 2.18 it creates a backup of the sql files, but all users, user information, everything that was in 2.17 is gone and i can not restore the data from the mysql backup. How do i restore the data from 2.17 to 2.18?

[berdie]

Sorry, I have changed the name of the MYSQL database to "groupoffice", the old version uses "goffice"
Login as root (to your testserver) and try this little workaround:

1. Save the old installation
cd /opt
mysqldump goffice > /opt/GOold.sql
tar -czf /opt/groupoffice GOold.tar.gz

2. Delete the old version
rpm -e smeserver-groupoffice

3. Install the new version
rpm -Uvh http://mirror.contribs.org/smeserver/contribs/dberteld/groupoffice/smeserver-groupoffice-2.18.1-7.noarch.rpm

4. Restore MySQL-DB and files
mysql groupoffice < /opt/GOold.sql
mv GOold.tar.gz /tmp
cd /tmp
tar xfz GOold.tar.gz
mv /tmp/groupoffice/home/* /opt/groupoffice/home
mv /tmp/groupoffice/files/* /opt/groupoffice/files
mv /opt/groupoffice/html/config.php /opt/groupoffice/html/config-standard.php
mv /opt/groupoffice/html/auth_sources.inc /opt/groupoffice/html/auth_sources_standard.inc
mv /tmp/groupoffice/html/auth_sources.inc /opt/groupoffice/html/auth_sources.inc

This should do it.

Greetings,
Dietmar

[sal1504]

Dietmer

I can log into groupoffice 2.18 with the user name and password that was in groupoffice 2.17, but upon logging in i get this error.

Database error: Invalid SQL: INSERT INTO fs_settings (user_id, use_gota) VALUES ('4', '1')
MySQL Error: 1054 (Unknown column 'use_gota' in 'field list')
Session halted.

Any ideas what went wrong?

[berdie]

Hmm,

seems as it is to difficult to solve with a workaround.
When testing the workaraound, I had no such MySQL-issues.
Sorry, but I cannot help anymore.

Greetings,
Dietmar

[thedayafter]

Hello,
at first sorry for my bad english...

i have also the problem to update from 2.17 to 2.18...

In office we work with version 2.17 and we will update to 2.18...
at home i test the update on my privat sme version 7.2...

First i make exports of the database via phpmyadmin from all go database..

id this way:

i have install the GO 2.18 on my personal SME

i log in via phpmyadmin on my personal sme an try to import the sql dump from the go ver 2.17 from office to my personal
mysql...

1. the import stop, i can not overwright existing entrys (sql einträge)

2. OK, the hard way...

3. the name of the database have change, i find that this was no good future...

4. i kill the database goffice and groupoffice, first i make a dump

5. i create a new datbase named groupoffice, thats the name of the database fo GO 2.18, this database is blank.

6. then i import the sql dump from the office GO 2.17 to this database.

7. all data are in my new GO 2.18, i can login, only email not work, we have differnt ip-range  home 192.168.0.xxx with subnet 255.255.255.0, at office: 192.168.2.xxx with subnet 255.255.255.0 but i think that can be corrected via phpmyadmin...

8. but i have one error at the top (frame) of my GO 2.18, in my old version ther was the info about new mails...

ther is this info:

Database error: Invalid SQL: SELECT SUM(unseen) FROM emFolders INNER JOIN emAccounts ON emFolders.account_id=emAccounts.id WHERE user_id='1' AND emAccounts.auto_check='1'


Database error: Invalid SQL: SELECT SUM(unseen) FROM emFolders INNER JOIN emAccounts ON emFolders.account_id=emAccounts.id WHERE user_id='1' AND emAccounts.auto_check='1'
MySQL Error: 1054 (Unknown column 'emAccounts.auto_check' in 'where clause')

i hope this will help.

at all, i don't understand, why it is so crazy to make a update from 2.17 to 2.18...

TheDayAfter
Klaus

[sal1504]

Klaus

Thanks for the reply. I will try your solution this week and let you know how it went. The only reason I am looking at upgrading to 2.18 is because I have not been able to get the spellchecker (aspell) in the email to work. and it does work in version 2.18. did you have problems with the spellchecker and if so how did you fix it? I am new to using groupoffice and would like to recommend it to some of my customers but so far I haven't received an email from Intermest on support options and their response is very slow on their forum.

Regards
Sal