Incorrect Total Count in Laravel Scout Pagination

[Evenerik]

Scout Version

10.8.6

Scout Driver

Typesense

Laravel Version

10.48.3

PHP Version

8.3.0

Database Driver & Version

MySQL 8.0.36

SDK Version

No response

Meilisearch CLI Version

No response

Description

This is pretty much a reopening of @razvaniacob's issue, who has encountered the same problem I am currently facing. I won't go into too much detail since he described the bug perfectly well in his issue, but Scout's LengthAwarePaginator shows wrong total when using Typesense's engine

Steps To Reproduce

See steps in #819

[driesvints]

@karakhanyans do you have any thoughts here?

[karakhanyans]

@driesvints will check this and get back with more info 👌

[razvaniacob]

I will be happy to see this solved guys. Good luck!

[driesvints]

@karakhanyans any news here?

[AbdullahFaqeir]

I'll be working on this

[tamakoma1129]

Hello,

I encountered the same issue reported here. In my case, I was using a model with a ULID as the primary key but initially forgot to set protected $keyType = 'string'; in my model. After updating this setting, I can confirm that the pagination now works correctly.

Here are the specifics of my development environment:

• Laravel Version: 10.48.4
• Scout Version: 10.8.6
• PHP Version: 8.1.27
• Scout Driver: Meilisearch
• Database: MySQL 8.0.36

Apologies if this solution has already been mentioned. I hope this helps someone else experiencing the same problem.

Thank you.

[driesvints]

Ping @jasonbosco

[jasonbosco]

@AbdullahFaqeir will be working on this going forward.

[AbdullahFaqeir]

Hi @Evenerik!

Can you please dump the collection schema, and sample record in typesense and the same record in database.

Below you can see a dump of my env showing a working fresh sample, I've seeded 10K users.

User model settings.

Search performed.

Paginated search results.