Project

General

Profile

Actions
Copy link

Feature proposal #6509

closed

Implement migration of old type, subtype, item, and parent to asset

Feature proposal #6509: Implement migration of old type, subtype, item, and parent to asset

Added by krileon almost 9 years ago. Updated almost 9 years ago.

Status:
Closed
Priority:
Normal
Assignee:
krileon
Target version:
4.0.0
Start date:
17 February 2017
Due date:
% Done:

100%

Estimated time:

Description

Old activity needs to migrate as well as possible. Some activity may become invalid due to this if too old.

Updated by krileon almost 9 years ago Actions
Copy link
 #1

GJ SQL Migration: CONCAT_WS( '.', 'groupjive.group', IF( `parent` != '', `parent`, `item` ), IF( `subtype` != '', IF( `subtype` != 'group', REPLACE( `subtype`, 'group.', '' ), 'create' ), NULL ), IF( `parent` != '', `item`, NULL ) )

Updated by krileon almost 9 years ago Actions
Copy link
 #2

Profile SQL Migration: CONCAT_WS( '.', 'profile', IF( `item` != '', `item`, `user_id` ), IF( `subtype` != '', `subtype`, NULL ) )

Updated by krileon almost 9 years ago Actions
Copy link
 #3

Status SQL Migration: CONCAT_WS( '.', 'profile', IF( `parent` != '', `parent`, `user_id` ) )

Updated by krileon almost 9 years ago Actions
Copy link
 #4

Blog SQL Migration: CONCAT_WS( '.', 'blog', `item` )

Updated by krileon almost 9 years ago Actions
Copy link
 #5

Forum SQL Migration: CONCAT_WS( '.', 'kunena', `item`, `subtype` )

Updated by krileon almost 9 years ago Actions
Copy link
 #6

Commented/Tagged SQL Migration: CONCAT_WS( '.', 'activity', `item`, `subtype` )

Updated by krileon almost 9 years ago Actions
Copy link
 #7

Field SQL Migration: CONCAT_WS( '.', 'profile', IF( `parent` != '', `parent`, `user_id` ), 'field', `item` )

Updated by krileon almost 9 years ago Actions
Copy link
 #8

Gallery SQL Migration: CONCAT_WS( '.', 'gallery', `subtype`, `item` )

Updated by krileon almost 9 years ago Actions
Copy link
 #9

  • % Done changed from 0 to 20

Activity asset migration done. Comments and Tags also need SQL migrations to asset.

Updated by krileon almost 9 years ago Actions
Copy link
 #10

  • % Done changed from 20 to 80

All database migrations completed (only necessary for Activity, Comments, and Tags). Custom Activity/Comments will also have type, subtype, parent, and item migrated as type.parent.subtype.item. Configuration migrations still needed.

Updated by krileon almost 9 years ago Actions
Copy link
 #11

  • Status changed from Assigned to Resolved
  • % Done changed from 80 to 100

All that's left is CB Auto Actions integration needs updating to be compatible.

Updated by krileon almost 9 years ago Actions
Copy link
 #12

  • Status changed from Resolved to Closed
Actions
Copy link

Also available in: PDF Atom