[4.x]: Change in ElementQuery::count effecting `EVENT_BEFORE_PREPARE` events

[myleshyson]

[4.x]: Change in ElementQuery::count effecting `EVENT_BEFORE_PREPARE` events

[brandonkelly]

Craft 4.9.5 and 5.1.5 are out with a fix that covers both of these issues. Thanks for reporting!

[yannkost]

I have also noticed that the .count() function does not return the right value for some queries.

{% set searchQuery = craft.entries({ type: availableEntryTypes}).search(query).orderBy('score').limit(5) %}

This sample code does return the limit of 5 and not the number of the entries.

[yannkost]

Just checked and without the orderBy('score') the function call returns the correct number.

[i-just]

@myleshyson, in your case, the EntryQuery::EVENT_BEFORE_PREPARE used to rely on the $event->sender->orderBy returning null, but since 4.9, it’s returning an empty string.

@yannkost, in your case, it’s the combination of search, limit and orderBy('score').

I raised a draft PR, and we’ll discuss this internally.