paragraphs_post_update_rebuild_parent_fields() currently throws
SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist: character va
rying <> bigint > LINE 5: WHERE (((p.parent_id <> f.entity_id)) OR (p.parent_type <> '...This issue seems to be common elsewhere, affecting views and others. Attached patch casts the comparisons to strings.
| Comment | File | Size | Author |
|---|---|---|---|
| #8 | interdiff-3081645-1-8.txt | 1.01 KB | johnchque |
| #8 | cast-query-to-text-3081645-8.patch | 1.08 KB | johnchque |
| #2 | cast-query-to-text-3081645-1.patch | 669 bytes | mrweiner |
Comments
Comment #2
mrweiner commentedComment #3
mrweiner commentedComment #4
mrweiner commentedUpdating to major as the issue completely blocks the post_update hook from running on sites using postgres as their db backend.
Comment #6
berdirNow that we finally have a update path test, we see that it fails, but it also makes it visible that the patch fails on MySQL now.
We might need to have a db driver check and only use the CAST() if using postgresql. Might also help with performance on MySQL.
Comment #7
mrweiner commented@Berdir What's the proper way to check the driver?
Comment #8
johnchque@mrweiner thank you so much for the fix!!! I believe this is how we check the db driver. Let's see.
Comment #10
berdirThanks.