core icon indicating copy to clipboard operation
core copied to clipboard

Create default variant

Open freddyucv opened this issue 2 years ago • 2 comments

We need to create a default variant, so we need to:

Create a new TaskUpgrade to:

  • Create a default variant in the variant table
  • Add a new variant field to "contentlet_version_info", the default value should point to the default variant

freddyucv avatar Aug 18 '22 17:08 freddyucv

PRs:

https://github.com/dotCMS/core/pull/22868

freddyucv avatar Aug 29 '22 16:08 freddyucv

Note to QA: Verify all records in contentlet_version_info have variant = DEFAULT

dsilvam avatar Sep 14 '22 21:09 dsilvam

Needs work: failing upgrade in MSSQL: https://gist.github.com/dsilvam/4fbe28b5b844920588a546b1cc914e66

dsilvam avatar Sep 28 '22 16:09 dsilvam

MSSQL: select * from variant DEFAULT,Variant use by DEFAULT when a Contentlet is created,0 New contentlet creadted: image select * from contentlet where title = 'dinho'

183eecb3-8f40-47dc-bf9c-590f1ce0a4fc,0,dinho,2022-10-14 22:28:56.275 +00:00,dotcms.org.1,0,dinho,c541abb1-69b3-4bc5-8430-5e09e5239cc8,"",7781f30550cac8ec7cb04ca227ecc82e

select * from contentlet_version_info where identifier = '7781f30550cac8ec7cb04ca227ecc82e'

7781f30550cac8ec7cb04ca227ecc82e,1,183eecb3-8f40-47dc-bf9c-590f1ce0a4fc,183eecb3-8f40-47dc-bf9c-590f1ce0a4fc,0,,2022-10-14 22:28:56.503 +00:00,2022-10-14 22:28:56.977 +00:00,DEFAULT

victoralfaro-dotcms avatar Oct 14 '22 22:10 victoralfaro-dotcms

Upgrade from 22.08 to master:

17:08:00.826  INFO  startup.StartupTasksExecutor - Running Upgrade Tasks
17:08:00.826  INFO  startup.StartupTasksExecutor - Database version: 220606
17:08:01.292  INFO  startup.StartupTasksExecutor - Running Upgrade Tasks: Task220822CreateVariantTable
17:08:01.316  INFO  startup.StartupTasksExecutor - Database upgraded to version: 220822
17:08:01.355  INFO  startup.StartupTasksExecutor - Running Upgrade Tasks: Task220824CreateDefaultVariant
17:08:01.371  INFO  startup.StartupTasksExecutor - Database upgraded to version: 220824
17:08:01.403  INFO  startup.StartupTasksExecutor - Running Upgrade Tasks: Task220825CreateVariantField

victoralfaro-dotcms avatar Oct 14 '22 23:10 victoralfaro-dotcms