David.. Posted July 3 Share Posted July 3 (edited) hello! every time this sql command runs (IPS task?) it completely spams my database and renders the entire server unresponsive. Â why did this start happening? this issue started after updating the software on my server to the latest versions available. also, for a while now, if i visit the badges setting in ACP, it takes a very long time to load but eventually it does. Edited July 3 by David.. RevengeFNF and SeNioR- 2 Link to comment Share on other sites More sharing options...
Marc Posted July 4 Share Posted July 4 We would need to look further into this for you, however the access details on file appear to be incorrect or missing. Could you please update these details by visiting your client area, selecting the relevant purchase, then clicking "Review/Update Access Information" under the "Stored Access Information" section. We look forward to further assisting you.  Link to comment Share on other sites More sharing options...
David.. Posted July 4 Author Share Posted July 4 7 minutes ago, Marc Stridgen said: We would need to look further into this for you, however the access details on file appear to be incorrect or missing. Could you please update these details by visiting your client area, selecting the relevant purchase, then clicking "Review/Update Access Information" under the "Stored Access Information" section. We look forward to further assisting you.  ready! Link to comment Share on other sites More sharing options...
Marc Posted July 4 Share Posted July 4 I would advise first of all addressing items that are showing in the support section of your admin CP, and encuring you have your 3rd Party items up to date if you are going to use them. Of course you really need to test without them running. For example, at least one of those deals with badges, and is showing out of date. SeNioR- 1 Link to comment Share on other sites More sharing options...
David.. Posted July 12 Author Share Posted July 12 @Nathan Explosion it appears this issue is caused by your app "Display My Badges 1.4.0". can you look into this please? SeNioR- 1 Link to comment Share on other sites More sharing options...
Marc Posted July 15 Share Posted July 15 On 7/12/2024 at 9:10 PM, David.. said: @Nathan Explosion it appears this issue is caused by your app "Display My Badges 1.4.0". can you look into this please? Thank you for confirming the cause, as that may well help others who come across the same issue 🙂 David.. 1 Link to comment Share on other sites More sharing options...
David.. Posted July 24 Author Share Posted July 24 @Marc after further investigation, it seems the issue is still happening, even after removing the badge application by @Nathan Explosion which leads me to believe it is an issue with IPS itself? are we able to look into this? Link to comment Share on other sites More sharing options...
Marc Posted July 25 Share Posted July 25 Please update login details. Your htaccess details are present, but there is no password for you ACP present Link to comment Share on other sites More sharing options...
David.. Posted July 25 Author Share Posted July 25 5 hours ago, Marc said: Please update login details. Your htaccess details are present, but there is no password for you ACP present added! Link to comment Share on other sites More sharing options...
Marc Posted July 25 Share Posted July 25 You still appear to have many issues on there you need to ensure you address before we begin looking at this to ensure these are not the issue. You need to at the very least ensure everything is up to date (apps and plugins for example), address the issues with files that are edited showing in the support area of your admin CP, along with also the database items. Link to comment Share on other sites More sharing options...
David.. Posted July 25 Author Share Posted July 25 6 hours ago, Marc said: You still appear to have many issues on there you need to ensure you address before we begin looking at this to ensure these are not the issue. You need to at the very least ensure everything is up to date (apps and plugins for example), address the issues with files that are edited showing in the support area of your admin CP, along with also the database items. i can resolve the database issues and update apps & plugins, would that suffice for a review? Link to comment Share on other sites More sharing options...
Jim M Posted July 25 Share Posted July 25 1 hour ago, David.. said: i can resolve the database issues and update apps & plugins, would that suffice for a review? You would want to resolve all that is mentioned in Support Link to comment Share on other sites More sharing options...
David.. Posted July 25 Author Share Posted July 25 2 hours ago, Jim M said: You would want to resolve all that is mentioned in Support the rest are not real issues and i need them modified for my community to work properly. Link to comment Share on other sites More sharing options...
Marc Posted July 26 Share Posted July 26 You have an issue on your community. There is no way of telling if these are causing the issue until they are removed from the equation. If we review the issue, we would be disabling them entirely in order to check this. But the others absolutely have to be addressed. The file changes for example, are unsupported Link to comment Share on other sites More sharing options...
David.. Posted July 26 Author Share Posted July 26 (edited) can we set a timeframe for when this can be troubleshooted? i can restore the files & fix the database issues so support can check. the file modifications are needed for me because IPS4 does not support URIÂ (example: myapp://callback) redirects in the API and that simple file modification allows it. Edited July 26 by David.. Link to comment Share on other sites More sharing options...
Marc Posted July 26 Share Posted July 26 I can take a look now. However there is no guarentee it wont need to be escalated, and if that is the case it would need to be left out until the issue is resolved Link to comment Share on other sites More sharing options...
David.. Posted July 29 Author Share Posted July 29 On 7/26/2024 at 1:29 PM, Marc said: if that is the case it would need to be left out until the issue is resolved does it need to be left out if you can confirm the issue when it is left out? Link to comment Share on other sites More sharing options...
Marc Posted July 29 Share Posted July 29 Yes, as the developers will need it left out while they are resolving Link to comment Share on other sites More sharing options...
David.. Posted July 30 Author Share Posted July 30 10 hours ago, Marc said: Yes, as the developers will need it left out while they are resolving considering it may take days, this is not a feasible solution for us as it would render our community unusable.. Link to comment Share on other sites More sharing options...
Stuart Silvester Posted July 30 Share Posted July 30 Can you copy and paste 2-3 of those queries into here? Please make sure they're the full query and not cut off. Link to comment Share on other sites More sharing options...
David.. Posted July 31 Author Share Posted July 31 17 hours ago, Stuart Silvester said: Can you copy and paste 2-3 of those queries into here? Please make sure they're the full query and not cut off. | 64259882 | database-user | localhost | database-name | Execute | 4 | Sending data | /*database-name::database-user::IPS\core\Achievements\_Badge::getBadgeStats:235*/ SELECT COUNT(*) FROM `ipb__core_member_badges` AS `core_member_badges` WHERE badge=43 | 64259927 | database-user | localhost | database-name | Execute | 1 | Sending data | /*database-name::database-user::IPS\core\Achievements\_Badge::getBadgeStats:235*/ SELECT COUNT(*) FROM `ipb__core_member_badges` AS `core_member_badges` WHERE badge=32 | 64260279 | database-user | localhost | database-name | Execute | 0 | Sending data | /*database-name::database-user::IPS\core\Achievements\_Badge::getBadgeStats:235*/ SELECT COUNT(*) FROM `ipb__core_member_badges` AS `core_member_badges` WHERE badge=20 | 64261032 | database-user | localhost | database-name | Execute | 5 | Sending data | /*database-name::database-user::IPS\core\modules\front\members\_profile::badges:107*/ SELECT CEIL( 100 * COUNT( IF( achievements_points > 4, 1, NULL ) ) / COUNT(*) ) as percentage FROM `ipb__core_members` AS `core_members` WHERE achievements_points > 0 | 64261500 | database-user | localhost | database-name | Execute | 8 | Sending data | /*database-name::database-user::IPS\core\widgets\_achievements::render:826*/ SELECT * FROM `ipb__core_member_badges` AS `core_member_badges` LEFT JOIN `ipb__core_badges` AS `core_badges` ON core_member_badges.badge=core_badges.id WHERE ( core_member_badges.member NOT IN(SELECT member_id FROM `ipb__core_members` AS `core_members` WHERE temp_ban != 0 OR (`members_bitoptions` & 1 ) != 0) ) ORDER BY datetime DESC LIMIT 5 | 64261501 | database-user | localhost | database-name | Execute | 8 | Sending data | /*database-name::database-user::IPS\core\widgets\_achievements::render:826*/ SELECT * FROM `ipb__core_member_badges` AS `core_member_badges` LEFT JOIN `ipb__core_badges` AS `core_badges` ON core_member_badges.badge=core_badges.id WHERE ( core_member_badges.member NOT IN(SELECT member_id FROM `ipb__core_members` AS `core_members` WHERE temp_ban != 0 OR (`members_bitoptions` & 1 ) != 0) ) ORDER BY datetime DESC LIMIT 5 Â i think these tables are just too big as even loading badges & ranks in ACP takes 77 & 90 seconds to load respectively and they increase database usage while they're loading. thank you! Link to comment Share on other sites More sharing options...
Marc Posted July 31 Share Posted July 31 How many rows do those tables have? Link to comment Share on other sites More sharing options...
David.. Posted July 31 Author Share Posted July 31 4 hours ago, Marc said: How many rows do those tables have? ipb__core_member_bages has 4724341. seems like not a lot, but why would it hog server resources so much? Link to comment Share on other sites More sharing options...
David.. Posted August 2 Author Share Posted August 2 @Marc @Stuart Silvester apologies for the annoyance, just informing you that the issue is still present and i would appreciate if someone were to look into it. Link to comment Share on other sites More sharing options...
David.. Posted August 5 Author Share Posted August 5 is there at least a way to disable that query from running entirely? my community keeps going down every few hours and it's getting stressful. Link to comment Share on other sites More sharing options...
Recommended Posts