Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt Monday at 02:04 PM
Jeffrey Roberts Posted March 22, 2022 Posted March 22, 2022 (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 March 22, 2022 by Jeffrey Roberts
Marc Posted March 22, 2022 Posted March 22, 2022 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 Posted March 22, 2022 Author Posted March 22, 2022 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 Posted March 22, 2022 Posted March 22, 2022 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.
Recommended Posts