I am upgrading our CB v1.2 and some of its plugins in our Joomla v1.5.26 install before migrating the whole to the latest version of Joomla using SPUpgrade. So far I have successfully updated CB to v1.9.1 and the Profile Gallery plugin from v1.0 RC2 to v1.2.2. I have however run into a couple of problems migrating the data from GroupJive v1.2 to v2.7, specifically, the migration tool misses some categories, groups and users.
The missing categories and groups seems to have been caused by one of our categories' IDs not respecting the auto increment sequence. Imagine we have three categories: A, B, C, it seems the migration tool does not handle well the case where A's ID is 1, B's is 2 and C's is 4. The migration tool was able to migrate all groups and categories once I manually changed C's ID to 3 in GroupJive v1.2 categories and groups tables.
I have remarked that GroupJive's group IDs are changed during the migration, which, while by itself this is not an issue, somehow old group IDs and new group IDs are mixed up. This causes some users to belong to groups to which they didn't belong before the migration, and perhaps because their group does not exist, some users fail to be imported (in some cases even the group owner).
Because the problem seems to be similar between category & groups and between groups & users, I wondered if there is a logic that I am not understanding correctly. Or perhaps I am right and it is necessary to manually clean the sequence of IDs present in my tables before attempting the migration?
Thanks!
krileon
