[4.13.7]: Descenants in GraphQL broke

[kennethdenhollander]

What happened?

Description

Since update 4.13.7 there was a fix for GraphQL, however after this update trying a 'descendants' query, it always returns an empty result. We rolled back to version 4.13.5 and we got back an array of 'descendants' again.

Steps to reproduce

Create a similar GraphQL query in the GraphiQL like below and make sure to use a section that has hierarchy enabled.

query facilities {
  facilities: entries(section: "facilities") {
    id
    title
    descendants {
      id
    }
  }
}

Expected behavior

We expect an array of facilities returned on the 'descendants' property.

Actual behavior

There is never a descendant returned after version 4.13.7

Craft CMS version

4.13.7

PHP version

8.1.31

Operating system and version

Linux 4.18.0-513.9.1.lve.el8.x86_64

Database type and version

MariaDB 10.6.20

Image driver and version

Imagick 3.7.0 (ImageMagick 7.1.1-39)

Installed plugins and versions

[brandonkelly]

I’m unable to reproduce that. Any chance you can share your database and Composer files, plus any custom plugins or modules with us, so we can test with your site on our end? If so, please send them to [email protected].

[brandonkelly]

We had a similar report (but for children) come in right before yours (#16381). In that case, they are only able to reproduce it on their hosted environment, but not on a local dev environment. Any chance you’re seeing the same? And if so, where are you hosted?

[kennethdenhollander]

As you mentioned for the other issue, there is no problem in de (local) development environment only on production. We run our own hosting servers, what kind of information do you need to be able to check?

[wijnenmik]

Hey, I am also facing the same problem but with parents.

[brandonkelly]

@wijnenmik Is it also only happening on production for you? Or can you reproduce locally? If locally, could you please send your database and Composer files into [email protected], along with the GraphQL query + schema you’re using, so we can look into it on our end?

Would either of you be able to share SSH access with us, so we can look into it on your production server?

[brandonkelly]

I managed to reproduce this using an older version of MySQL, and released Craft 4.13.9 and 5.5.9 with a fix.