⚠️ Blocking Bug: MySQL Limit of 200 triggered even with LIMIT set to 10

Need help
1

So this seems like a bug to me.

Running this command:
SELECT postId FROM SWANbdb LIMIT 10

Triggers the limit error message for 200 entries only.

This is a blocking issue with the mysql connection plugin atm the minute.

Any solutions?

2

And to confuse matters:

  • A pure mysql DB (aka Wordpress) works fine with
    SELECT IDFROMwp_posts limit 10

but a Microsoft SQL Express server doesn’t.

3

The SQL limit syntax varies between MySQL and MS Server. (Limit vs top)

1 Like
4

yup - so for SQL Express, I’m using TOP (10) and it doesn’t work.

T.

5

I’ve come to the conclusion that the issue is SQL Express linked and the the plugin does not support TOP but only LIMIT which is only for MYSQL.

2 Likes
6

This topic was automatically closed after 70 days. New replies are no longer allowed.