Missing groups after upgrade from olat 7.0.0 to OpenOLAT 10.3.5

[Daniel Abrecht]

Hi,

I upgraded from olat 7.0.0 to OpenOlat 10.3.5. I copied the datas and
the database from Olat and executed the db upgrade scripts. Everything
seams to work fine, except for some Groups which I saw in olat, but
don't appear in OpenOLAT. What can I do about that?

Best regards,
Daniel Abrecht

[Florian Gnaegi]

Hi Daniel

Did you find your groups eventually? Check the group admin search feature for orphan groups, maybe they are there… Group site -> group management -> search form.

Cheers

Florian

--
--
Sie erhalten diese Nachricht, weil Sie Mitglied sind von Google
Groups-Gruppe "OpenOLAT".
Für das Erstellen von Beiträgen in dieser Gruppe senden Sie eine E-Mail
an open...@googlegroups.com
Um sich von dieser Gruppe abzumelden, senden Sie eine E-Mail an
openolat+u...@googlegroups.com
Weitere Optionen finden Sie in dieser Gruppe unter
http://groups.google.com/group/openolat?hl=de
-------------------------------------------------------------------------------------------------------------------
OpenOLAT - infinite learning - http://www.openolat.org

---
You received this message because you are subscribed to the Google Groups "OpenOLAT" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openolat+u...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--------------------------------------------------------------------

professional services for the e-learning system OpenOLAT

hosting - operating - support - development - mobile - consulting

--------------------------------------------------------------------

www.frentix.com | www.openolat.com 

frentix  GmbH

Florian Gnägi, Geschäftsführer

Hardturmstrasse 76

CH-8005 Zürich, Switzerland

tel://+41-43-544-9000

dir://+41-43-544-9001

fax://+41-43-544-9009

Find me on skype  twitter xing linkedin 

--------------------------------------------------------------------

[google...@danielabrecht.ch]

Hi Florian

I have now solved my problem by editing the Database. I used the following SQL queries to do so:

insert into o_bs_group (
  id, creationdate
) select o_gp_business.group_id, o_gp_business.creationdate
  from o_gp_business
  where o_gp_business.fk_group_id is null;

update o_gp_business
  set fk_group_id=group_id
  where fk_group_id is null;

insert into o_bs_group_member (
  id, creationdate, lastmodified, ; id doesn't autoincrement, so I have to generate one
  g_role, fk_group_id, fk_identity_id
) select o_bs_membership.id-262144, o_bs_membership.creationdate, o_bs_membership.lastmodified,
         "coach", o_gp_business.fk_group_id, o_bs_membership.identity_id
    from o_gp_business
    INNER JOIN o_bs_membership on o_bs_membership.secgroup_id=o_gp_business.fk_ownergroup
    INNER JOIN o_bs_identity on o_bs_identity.id=o_bs_membership.identity_id;

insert into o_bs_group_member (
  id, creationdate, lastmodified,
  g_role, fk_group_id, fk_identity_id
) select o_bs_membership.id-262144, o_bs_membership.creationdate, o_bs_membership.lastmodified,
         "participant", o_gp_business.fk_group_id, o_bs_membership.identity_id
    from o_gp_business
    INNER JOIN o_bs_membership on o_bs_membership.secgroup_id=o_gp_business.fk_partipiciantgroup
    INNER JOIN o_bs_identity on o_bs_identity.id=o_bs_membership.identity_id;

UPDATE o_gp_business 
  LEFT JOIN o_olatresource ON o_gp_business.group_id = o_olatresource.resid 
  SET o_gp_business.fk_resource = o_olatresource.resource_id
  WHERE o_gp_business.fk_resource is NULL;

Best regards,
Daniel Abrecht