Forums

[div wfd-id="66"]Hello, while testing and modifying my connectors I've noticed some strange behavior.
​
After modifying value in Functions > Read Data > Page limit,
if I hit Apply and then Preview I can see a preview of my table that is working fine,
BUT
if I hit Apply then Save then Clear cache, then click Open, I see the error message: "1064You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near '' at line 1"[div wfd-id="65"]​[div wfd-id="65"]For instance, I've created a paginator, Display: Navigation menu[div wfd-id="64"]In Functions, Paging for multiple results is Enabled, page limit 50.[div wfd-id="63"]If I modify page limit to any value, for instance 100,
I Apply and Save, then click on Open and it throws an error: "1064You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1"
​
Then I reopen the manager, modify page limit to 50
Apply but instead of Save I click "Preview" and I see nice preview of my table.
Then I change value of page limit back to 100
But this time I hit Apply and Save, then click Open and again I see the error: "1064You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near '' at line 1"
​
What can it be?