Forum Academy Marketplace Showcase Pricing Features

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

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?

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.

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

1 Like

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

T.

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

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