Where is error while update:
drush @lom.dev updatedb -y
// Requirements check reports errors. Do you wish to continue?: yes.------------ ----------------------- ------------- ---------------------------
Module Update ID Type Description
------------ ----------------------- ------------- ---------------------------
paragraphs rebuild_parent_fields post-update Update the parent fields
with revisionable data.
@param array &$sandbox
The sandbox array.
------------ ----------------------- ------------- ---------------------------// Do you wish to run the specified pending updates?: yes.
> [notice] Update started: paragraphs_post_update_rebuild_parent_fields
> [error] SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '))
> ORDER BY p.revision_id ASC
> LIMIT 100 OFFSET 0' at line 2: SELECT f.entity_id AS entity_id, f.field_price_set_target_revision_id AS field_price_set_target_revision_id
> FROM
> {profile_revision__field_price_set} f
> INNER JOIN {paragraphs_item_revision_field_data} p ON f.field_price_set_target_revision_id = p.revision_id
> WHERE (((p.parent_id <> f.entity_id)) OR (p.parent_type <> :db_condition_placeholder_0) OR (p.parent_field_name <> :db_condition_placeholder_1)) AND ((p.langcode = f.))
> ORDER BY p.revision_id ASC
> LIMIT 100 OFFSET 0; Array
> (
> [:db_condition_placeholder_0] => profile
> [:db_condition_placeholder_1] => field_price_set
> )
>
> [error] Update failed: paragraphs_post_update_rebuild_parent_fields
[error] Update aborted by: paragraphs_post_update_rebuild_parent_fields
[error] Finished performing updates.
| Comment | File | Size | Author |
|---|---|---|---|
| #3 | paragraphs-no-langcode-3073486-3.patch | 1001 bytes | berdir |
Comments
Comment #2
berdirThanks for testing and reporting. Marking as a critical release blocker.
This seems to be a paragraph field on a profile entity, which apparently doesn't have a language field. We need to make the language comparison conditional then.
Comment #3
berdirThis should fix this.
Comment #4
super_romeo commentedThank you, Berdir! With patch #3 update passed.
Comment #5
berdirThanks for confirming, committed.
Comment #6
berdirComment #8
donaldp commentedMy code is using PostgreSQL rather than MySql and I've believe it's got a similar issue: I'll see if I can create a similar patch for that.
> [notice] Update started: paragraphs_post_update_rebuild_parent_fields
> [error] SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist: character varying <> bigint
> LINE 5: WHERE (((p.parent_id <> f.entity_id)) OR (p.parent_type <> '...
> ^
> HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.: SELECT f.entity_id AS entity_id, f.field_associated_documents_target_revision_id AS field_associated_documents_target_revision_id, p.revision_id AS prevision_id
> FROM
> {node_revision__field_associated_documents} f
> INNER JOIN {paragraphs_item_revision_field_data} p ON f.field_associated_documents_target_revision_id = p.revision_id
> WHERE (((p.parent_id <> f.entity_id)) OR (p.parent_type <> :db_condition_placeholder_0) OR (p.parent_field_name <> :db_condition_placeholder_1)) AND ((p.langcode = f.langcode))
> ORDER BY p.revision_id ASC NULLS FIRST
> LIMIT 100 OFFSET 0; Array
> (
> [:db_condition_placeholder_0] => node
> [:db_condition_placeholder_1] => field_associated_documents
> )
>
> [error] Update failed: paragraphs_post_update_rebuild_parent_fields
Posted new issue here: #3076584: paragraphs_item_revision_field_data() fails with PostgreSQL
Comment #9
berdirPlease create a new issue, that's a different problem.
Comment #10
donaldp commentedOK. Will try to do this later today. Just back from Holiday and have pile of things to look into.
See: #3076584: paragraphs_item_revision_field_data() fails with PostgreSQL
Comment #11
tomhollevoet commented@Berdir I get a related issue.
See https://www.drupal.org/project/paragraphs/issues/3076648 with a possible solution.
Thanks for the review!