Transaction was implicitly committed, do not mix transactions and DDL with MySQL (#805)

felixmosh / knex-paginate

An extension of Knex's query builder with `paginate` method that will help with your pagination tasks.

MIT License

111 stars 12 forks source link

Transaction was implicitly committed, do not mix transactions and DDL with MySQL (#805) #54

Open fernandolangaro opened 3 weeks ago

fernandolangaro commented 3 weeks ago

This lib works great, but I wish it was possible to pass a parameter called transaction at paginate(). Because when I am adding paginate to a query that is inside a transaction I get this error and it messes up my query.

Is is possible to send the transaction to the paginate method and then you use the transaction to perform the db readings you need? @felixmosh

felixmosh commented 3 weeks ago

Hi @fernandolangaro Can you share the error that you get? How do you set the transaction?