NodeJS Error: .returning() is not supported by mysql and will not have any effect

I get the following error in my logs of my NodeJS Webserver:

I run some automated Schedule Tasks from my Wappler Website.

.returning() is not supported by mysql and will not have any effect.

I know it is just a warning, but it would be great to know what's the reason for the error and what I can do to solve it. I assume that it has to do with the formatters and knex.

I already wrote about it in my following post 2 years ago:

1 Like

It’s an issue with Knex and only a warning so can be ignored.

More here:

1 Like

I know, but if I read the answers on github correctly, there is a fix for this.

Sure. If you want to hack the Knex code. Good luck if so.

@patrick This warning is just annoying. Can Wappler update the Knex version to get the fix? Or what can be done?
Not sure it this has already been fixed in 5.0.x

2 Likes

Latest version of Knex still has the warning.

Thanks for the update. Is there something the Wappler Team can do to avoid the warning?

This should be now solved with the latest Knex update that we have incorporated few Wappler updates ago.

1 Like

Is this really fixed?

I'm still getting these today. Yes, I know I can ignore, but it would be great to keep the logs clean.

Screenshot 2024-06-23 at 9.17.55 PM

Just a thought...
Is the "experimental" fearures option still exists/supported?
I guess it will always be there for new features testing...

Tried to disable it Ken and see if the console error is still there?

Have improved the script to do a runtime check of the driver being used and ignore the returning for mysql.

db.zip (1.7 KB) unzip to lib/core.

1 Like

Implemented now in Wappler 6.7.2

This topic was automatically closed after 21 hours. New replies are no longer allowed.