Pass information, copy tables from the database

[bettina]

Hi,
I have installed eg v 19 and I want to pass the information of the old version eg v 1.6.

1. I tried to import the data from the contact table by cvs format (separator by,) and I could not,i get many errors
2. I have resorted directly to the copy of the mysql database table:
   seeing the same tables (in both versions: egw_addressbook) the data has been copied (1525 contacts) , happens that when I enter the application link, www.mydomain.com / egroup19, I only see 8 contacts of the 1525 contacts . These 8 contacts that I can see, Its coincides that everyone has email name@mydomain.com …, that is ,are mails created with my domain, unlike the others, that is, they were created as users of egroupware in the previous version.
3. Why i don’t see the others contacts ? I do not understand what happens?
   Can you help me please ?
   Regards,

[RalfBecker]

Why not just update your 1.6 data?

1. do the 19.1 install on a new box
2. do an EGroupware database backup (not mysqldump!):
   a) Admin > Database backup and restore or
   b) Setup (upper login) > Database backup and restore
3. log into setup (upper login) of your new instance (credentials are in /var/lib/egroupware/egroupware-docker-install.log or the logs of the egroupware container)
4. upload the above backup and restore it
5. then confirm the update

That’s all

[bettina]

Hello,
I’m not sure if I understood you correctly, I did the following:

1. I have made the backup of the old version from the setup eg 1.6, and I have downloaded it
2. I login to the new version eg 19 and in administration> backup, I have uploaded the file and then I have restored it
3. I am going to login of the new version eg 19 and I cannot enter: … “error in the database …”
4. I don’t understand point 3) what do you mean with …" credentials…"?

Regards,
Bettina

[RalfBecker]

Hi Bettina,

one thing I forgot to write in this thread, I wrote you in the German one, you need to install the egroupware-epl-compat package, as it contains the update-scripts from before 14.3, which your 1.6 is!

I don’t understand point 3) what do you mean with …" credentials…"?

To login to setup yon your new 19.1 installation you need credentials (user and password).

In setup you can upgrade the database / EGroupware installation (after installing above mentioned package!).

Ralf

[bettina]

Hi,

1. I want to clarify that I have installed the eg Version: 19.1.20191031 Release Date: 10-31-2019 directly from the scripts included in my host
2. I did the following steps:
   I have made the backup of the old version from the setup eg 1.6, and I have downloaded it
   I login to the new version eg 19 and in administration> backup, I have uploaded the file and then I have restored it and then update it
3. I got the errors I send in attachments

so i cound´t start yet ,can you help me please ?

Regards,EGroupware Setup - Instalación - Dominio_ default (mysqli___arcolena_egro778@localhost_3306_arcolena_egro778).pdf (100.0 KB)
EGroupware Setup - Instalación.pdf (74.0 KB)

[RalfBecker]

Please read my last post, specially the first sentence, regarding what is necessary to update from 1.6!

directly from the scripts included in my host

Not sure what this is supposed to mean?
What installation method did you use:
a) Linux rpm or deb packages
b) docker-compose file direct
c) git / developer installation
d) other unsupported installation method

Ralf

[bettina]

Hello

1. Please read my last post, specially the first sentence, regarding what is necessary to update from 1.6!
   i don´t understand what you mean ?
   In the installation and application summary I have seen that the applications have been updated, but happens that gives an error …

2. What installation method did you use:

a) Linux rpm or deb packages —NO
b) docker-compose file direct—NO
c) git / developer installation–No
d) another unsupported installation method: only the basic installation, from the installation wizard

Regards,

[RalfBecker]

i don´t understand what you mean ?

The regular 19.1 lacks the code to update from 1.6, that code is in the old phpgwapi repo, or egroupware-epl-compat package.

another unsupported installation method: only the basic installation, from the installation wizard

You still managed to not give an answer
I can only assume you used the archive from our GitHub release page, to get the sources.
If that is true, you have to git clone the phpgwapi repo, into this sources:

cd /path/to/egroupware
git clone https://github.com/EGroupware/phpgwapi.git

BEFORE you run the update!
So you have to restore the 1.6 again, after the above git clone, and then run the update again.

Probably needless to say: archives are not a recommended way of installing EGroupware!

Ralf

[bettina]

Hi,

1. Apparently some applications have been updated according to the report I sent as an attachment
2. I have installed eg v 19 from the installation script included in the cpanel of my shared hosting. (I send screenshot)
3. I don’t understand what you mean by clone? and if you still think that it is necessary to do it please explain to me more because I do not understand :
   cd / path / to / egroupware ???
   Regards,eg-aplicaciones.pdf (148.5 KB)
   eg19 inst.pdf (227.0 KB)

[RalfBecker]

You used Softaculouse installer, according to your pdf.

The problem remains, you need the old phpgwapi to be able to update from 1.6!

I gave you the commands to integrate it into your installation:

cd /path/to/egroupware
git clone https://github.com/EGroupware/phpgwapi.git

If you need more help, please buy an update package and we are happy to assist you / do the update for you:

EGroupware Migration

Ralf