Jump to content

Recommended Posts

Posted (edited)

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 by Jeffrey Roberts
Posted

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. 

Posted

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.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...