Project

General

Profile

Actions

Feature proposal #6509

closed

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

Added by krileon almost 8 years ago. Updated over 7 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Target version:
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.

Actions #1

Updated by krileon almost 8 years ago

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 ) )

Actions #2

Updated by krileon almost 8 years ago

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

Actions #3

Updated by krileon almost 8 years ago

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

Actions #4

Updated by krileon almost 8 years ago

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

Actions #5

Updated by krileon almost 8 years ago

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

Actions #6

Updated by krileon almost 8 years ago

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

Actions #7

Updated by krileon almost 8 years ago

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

Actions #8

Updated by krileon almost 8 years ago

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

Actions #9

Updated by krileon almost 8 years ago

  • % Done changed from 0 to 20

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

Actions #10

Updated by krileon almost 8 years ago

  • % 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.

Actions #11

Updated by krileon almost 8 years ago

  • 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.

Actions #12

Updated by krileon over 7 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF