Issue with SQL Toolbox pagination

[Jeffrey Roberts]

After I run in SQL toolbox (v4.6.11) a simple query like this:

SELECT email FROM core_members where allow_admin_mails = 1 AND temp_ban <> -1 AND joined > 1618596660 AND MEMBER_GROUP_ID = 3;

I get correct results in the first page, but when I click Next or 2 or 3 for other pages of the results I get a blank page.

Is this a known issue?

Is there a command that I could add to my SELECT statement that will not force pagination so that I can see all the results on the 1st page?

Edited March 22, 2022 by Jeffrey Roberts

[Marc Stridgen]

There is no command that will allow lack of pagination. I would suggest if you are running queries like that, you use something like phpMyAdmin which is more built for that purpose. 

That said, I am not able to replicate any issue at all on my end here with mysql toolbox. 

[Jeffrey Roberts]

Thanks. This must be an issue with our server provider.

I did use my phpMyAdmin as my workaround. It has always been so convenient for years to generate this list from SQL toolbox.

[Jim M]

Most likely it is a limitation of the server. SQL Toolbox is a great tool but please be aware that we may discontinue it at any time and it may have limitations either imposed by your hosting provider or otherwise.