-
Notifications
You must be signed in to change notification settings - Fork 758
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
[Bug]: Migration of HTML content to Content Workflow does not work for some sites #6429
Comments
@tvatavuk I'm going to post some comments with details about sites that don't meet the criteria for the plain upgrade. I'm running the following script (let me know if there's any other info you'd like to see): SELECT TOP 1 Major, Minor, Build, Name, CreatedDate FROM Version ORDER BY CreatedDate;
SELECT DISTINCT Name FROM Version WHERE Name != (SELECT TOP 1 Name FROM Version ORDER BY CreatedDate);
SELECT * FROM Workflow;
SELECT * FROM WorkflowStates;
SELECT * FROM ContentWorkflows;
SELECT * FROM ContentWorkflowStates;
SELECT DISTINCT StateID FROM ContentItems;
SELECT DISTINCT StateID FROM HtmlText; I can also jump on a call if you want to dig around in these databases some more. |
Site EThis site was never on Evoq. It only has Content Approval workflows in the Initial Install
Other Versionsempty HTML Workflows
HTML Workflow States
Content Workflows
Content Workflow States
|
StateID |
---|
NULL |
StateID
in HtmlText
StateID |
---|
1 |
Site GThis site was never on Evoq. It does not have any workflows in the Initial Install
Other Versionsempty HTML Workflows
HTML Workflow States
Content Workflows
Content Workflow States
|
StateID |
---|
NULL |
StateID
in HtmlText
StateID |
---|
1 |
Site G2This site was never on Evoq. It only has Content Approval workflows in the Initial Install
Other Versionsempty HTML Workflows
HTML Workflow States
Content Workflows
Content Workflow States
|
StateID |
---|
NULL |
StateID
in HtmlText
StateID |
---|
3 |
1 |
Site AThis site was on Evoq from version 5.3.0 until migrated back to Platform in 9.6.2. It does not get Direct Publish workflows in the Initial Install
Other Versions
HTML Workflows
HTML Workflow States
Content Workflows
Content Workflow Statestoo big to include in this comment, see gist
|
StateID |
---|
593 |
570 |
547 |
524 |
501 |
1117 |
564 |
576 |
1105 |
1111 |
470 |
464 |
487 |
507 |
1171 |
556 |
458 |
481 |
530 |
587 |
550 |
3 |
1177 |
544 |
493 |
521 |
473 |
527 |
573 |
513 |
467 |
567 |
510 |
533 |
461 |
584 |
484 |
553 |
504 |
590 |
490 |
522 |
545 |
476 |
499 |
528 |
516 |
562 |
568 |
468 |
485 |
891 |
536 |
462 |
1195 |
505 |
579 |
585 |
1183 |
591 |
542 |
688 |
571 |
548 |
525 |
1189 |
502 |
479 |
456 |
519 |
465 |
565 |
559 |
488 |
508 |
459 |
1123 |
482 |
539 |
551 |
588 |
496 |
1129 |
497 |
474 |
503 |
480 |
457 |
574 |
520 |
514 |
566 |
534 |
583 |
511 |
560 |
460 |
483 |
577 |
554 |
540 |
1075 |
1087 |
491 |
689 |
546 |
500 |
523 |
454 |
477 |
1141 |
563 |
471 |
NULL |
517 |
463 |
557 |
531 |
1147 |
580 |
586 |
537 |
543 |
1135 |
494 |
572 |
549 |
478 |
526 |
1165 |
455 |
466 |
472 |
1153 |
1159 |
518 |
558 |
581 |
509 |
532 |
552 |
538 |
489 |
495 |
589 |
475 |
569 |
498 |
1093 |
469 |
575 |
1099 |
561 |
515 |
512 |
486 |
535 |
555 |
506 |
578 |
529 |
592 |
541 |
492 |
StateID
in HtmlText
StateID |
---|
1 |
DO you know if customization of the states/workflows was intentional, or otherwise? I noticed a number of the protals missing the Direct Publish workflow entirely, which seems unusual. |
I don't believe there was any intentional customization of states or workflows. |
Is there an existing issue for this?
What happened?
Upon upgrading DNN, the HTML content no longer displays (only an error message is shown) because the workflow associated with the content is incorrect.
Steps to reproduce?
Current Behavior
HTML modules display errors
Expected Behavior
HTML modules display contents
Relevant log output
Anything else?
This was introduced by #6261, which had an intentionally simple migration script. This script needs input from some more realistic scenarios to handle more sites.
Affected Versions
10.0.0 (RC)
What browsers are you seeing the problem on?
Firefox
Code of Conduct
The text was updated successfully, but these errors were encountered: