2nd Page results not being retrieved

[kaminari]

2nd Page results not being retrieved

[mkrogemann]

i guess you are experiencing what has been described in #24 and #25.

[FlyboyArt]

Perhaps but I'm not in control of Kaminari issuing the select count command with the offset. What can I do in my code to circumvent this? It's not obvious to me after reading both #24 and #25

[mkrogemann]

this is not ideal, just a workaround... but it works for me

@Clients = Client.order(:id).page(params[:page]).per(50)

@clients.all.count

[FlyboyArt]

Works! Thanks for helping me work around this. It may be a problem in MySql however from a consumer of kaminari, it should be transparent to the user (i.e. me) what is workaround has to happen. Thanks so much for the prompt reply and help! Much appreciated.

[mkrogemann]

glad i could help. I think this has nothing to do with mysql. I'm using postgres and see the same problems here.

[dtuite]

I had this exact same problem with Kaminari and postgreSQL. The fix described above worked for me also.