Dolphin migration tool
I know I am late to the party... but; the tool is no longer in the app marketplace? Am I screwed?
-
- · gkuhnert
- ·
So. I've found the code on Github, and found references that say I need to run Dolphin 13.x - So, installed 13.1 now, and got the app up. Found that there were errors in the migration tool if running later than php 8.1 due to deprecated functions, so now running on 8.1
However, my dolphin site has a large number of users, 65188 in total. The spinning logo eventually stops, and if I reload the page, it shows status or Profiles as "Already started",but nothing proceeding or finishing. I left it overnight, and still the same status.
Any hints?
-
- · gkuhnert
- ·
Self commenting on update progress, in case it helps anyone else.
I've increased max PHP time and maxed out memory allowed. Profiles migrated successfully. I then started on Paid Memberships levels, Members info... but ran into a problem.
Query: INSERT INTO `sys_acl_levels` SET `Name` = ?, `Icon` = ?, `Description` = ?, `Active` = 'yes', `Order` = ?
It turns out I have a membership level that has a Name field that collides with an existing record in a default install and database table has a Unique constraint on the index for that field. For now, I changed the index to full text and it's imported OK. Just not sure how this will impact down the line yet.
-
- · gkuhnert
- ·
Next problem / bug: My server is locked down for security. It passes the install checks in terms of disabled functions, but fwrite cannot be a disabled function. Upon checking, its required elsewhere inside Una as well, not just migration.
There are other issues about some deprecated functions that I think are related to data integrity in my forum (have not yet found root cause). To be continued.
-
- · gkuhnert
- ·
Next problem: Data integrity in Dolphin. I found some forum topics with no posts. (Not sure why - but it was causing errors).
Pre-migration SQL to fix:
DELETE FROM bx_forum_topic WHERE topic_id NOT IN ( SELECT DISTINCT topic_id FROM bx_forum_post );
-
- · gkuhnert
- ·
Documenting earlier fix: My exisiting Dolphin site has a Premium membership level, and that caused issues migrating. So... the SQL below run against the Una database renamed the key for the built in premium level allowing mine to import.
UPDATE sys_acl_levels SET sys_acl_levels.Name = "_adm_prm_txt_level_unapremium" WHERE sys_acl_levels.name = "_adm_prm_txt_level_premium" ; UPDATE sys_localization_keys SET sys_localization_keys.Key = "_adm_prm_txt_level_unapremium" WHERE sys_localization_keys.Key = "_adm_prm_txt_level_premium" ; UPDATE sys_localization_strings SET sys_localization_strings.String = "UnaPremium" WHERE sys_localization_strings.String = "Premium" ;
-
-
·
Alexey
- ·
Hello!
Yes, migration tool currently available only via Git. Please take a look at this thread: https://unacms.com/d/is-there-any-stable-version-of-una-if-so I hope it helps clarify things and helps you avoid potential issues during migration.
-
·
Alexey