Doesn't seem to work with knex@2.0.0

[cerinoligutom]

Have a users table with a createdAt field and I'm sorting using that field. Code:

await UserModel.query().orderBy('asc', 'createdAt').limit(10).nextCursorPage(myCursor);

Code works fine on knex@0.95.14 though. I think v1 is also broken as well since I've had a similar issue on one of my repo https://github.com/cerino-ligutom/GraphQL-Starter/issues/27#issuecomment-1065919299 where downgrading to 0.95.14 fixed the issue. I guess knex changed an underlying API that broke this plugin?

[olavim]

Thanks for reporting. I'll try to get this fixed ASAP.

[olavim]

What knex and objection versions are you using? And what database? I tested the following combinations with sqlite:

objection	knex	status
2.2.18	knex@0.95.14	✅
2.2.18	knex@1.0.7	❌
2.2.18	knex@2.0.0	❌
3.0.1	knex@0.95.14	✅
3.0.1	knex@1.0.7	❌
3.0.1	knex@2.0.0	✅

Note: knex@1.0.7 failed because it depends on an sqlite3 package that no longer exists.

[cerinoligutom]

knex@2.0.0, objection@3.0.1, postgres:13

[olavim]

Can you check if version 1.2.6-alpha.0 fixes the issue for you?

[cerinoligutom]

Hey @olavim, works great! I don't get the error anymore 🎉

[olavim]

Great! Fixed in v1.2.6.

[cerinoligutom]

Thank you for the quick fix! 🚀