Previous Thread
Next Thread
Print Thread
Hop To
[FIXED for 7.7.3] Database Issue (Member Search) #262931 07/12/2019 7:28 PM
Joined: Jun 2006
Posts: 293
Outdoorking Offline OP
Enthusiast
OP Offline
Enthusiast
Joined: Jun 2006
Posts: 293
Hi All,

I have just had my forum software updated and have noticed after the install that when I go into the control panel and try to look up an email it hangs. Version installed is 7.7.2 on a linux server.

Note that the person that takes care of the server has advise me that the MSQL is running very high usuage. Would this be because of the control panel requesting a search of an email address and why it is hanging.

Re: [FIXED for 7.7.3] Database Issue (Member Search) [Re: Outdoorking] #262932 07/12/2019 7:43 PM
Joined: Apr 2004
Posts: 1,549
isaac Offline
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Apr 2004
Posts: 1,549
Thank you for reporting this.

Its due to a poorly written mysql query. In your server error logs, you'll probably see, "poorly written SQL query."

This SQL query adds User Group searching when User Groups are not needed. So your query gets hung up while it goes through every single user/group looking for the search term - and if there is no search term, that is all your users and all of your user groups.

Im aware of it and have created a fix for it about a week AFTER 7.7.2 was released (2019-07-02).

7.7.3 should be available very soon, with this fix and one other known issue (a display issue) as of today.

In my tests, the poor SQL query is inly triggered when you enter NO search terms, and then submit the page for searching. The work-around until 7.7.3 is released, is to remember to enter something to search for, before submitting the page.

Last edited by isaac; 07/12/2019 7:46 PM.

Current developer of UBB.threads PHP Forum Software // 7.7.3 released!
isaac @ id242.com // my forum @ CelicaHobby.com
Re: [FIXED for 7.7.3] Database Issue (Member Search) [Re: Outdoorking] #262933 07/12/2019 8:17 PM
Joined: Jun 2006
Posts: 293
Outdoorking Offline OP
Enthusiast
OP Offline
Enthusiast
Joined: Jun 2006
Posts: 293
Isaac,

Thank you for the reply but I am entering a members email address and what is happening is that it hangs and then my server goes down. I get notifications like this The monitor Outdoorking (http://www.outdoorking.com) is currently DOWN (Connection Timeout).

The whole site goes down because of it.

Re: [FIXED for 7.7.3] Database Issue (Member Search) [Re: Outdoorking] #262934 07/12/2019 8:22 PM
Joined: Apr 2004
Posts: 1,549
isaac Offline
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Apr 2004
Posts: 1,549
As written above, 7.7.3 will resolve this when its released.

It wasnt caught on test servers because we were using databases with fewer than 500 accounts.

Once the issue was found (one week after 7.7.2 was released, which was about 10 days ago on July 2nd), a solution was written and a plan for deployment was made. You'll see the fix in 7.7.3 release, which should happen soon.


Current developer of UBB.threads PHP Forum Software // 7.7.3 released!
isaac @ id242.com // my forum @ CelicaHobby.com
Re: [FIXED for 7.7.3] Database Issue (Member Search) [Re: isaac] #262949 07/17/2019 2:44 PM
Joined: Jun 2006
Posts: 683
Morgan Offline
Addict
Offline
Addict
Joined: Jun 2006
Posts: 683
Originally Posted by isaac
As written above, 7.7.3 will resolve this when its released.

It wasnt caught on test servers because we were using databases with fewer than 500 accounts.

Once the issue was found (one week after 7.7.2 was released, which was about 10 days ago on July 2nd), a solution was written and a plan for deployment was made. You'll see the fix in 7.7.3 release, which should happen soon.


I have not upgraded yet from 7.7.1 > 7.7.2
Now that I read above about the 7.7.3 fix I'm thinking of waiting since we have 10000+ members
So should I wait for 7.7.3 or do the 7.7.2 upgrade anyway?



Morgan Johansson
BritBike Forum
http://www.britbike.com/forums/ubbthreads.php
Re: [FIXED for 7.7.3] Database Issue (Member Search) [Re: Morgan] #262951 07/17/2019 5:26 PM
Joined: Apr 2004
Posts: 1,549
isaac Offline
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Apr 2004
Posts: 1,549
Originally Posted by Morgan
I have not upgraded yet from 7.7.1 > 7.7.2
Now that I read above about the 7.7.3 fix I'm thinking of waiting since we have 10000+ members
So should I wait for 7.7.3 or do the 7.7.2 upgrade anyway?


Go ahead and upgrade anyway. As this issue only affects a single script when being used to search members in the administrator control panel as 1/ "search without entering any search terms" and 2/ "search members by email address." Everything about 7.7.2 is an upgrade or fixes multiple other issues.

If you cannot wait until 7.7.3 is released, and absolutely need to "CP: Admin > Member > Search By Email Address", you can probably use the /admin/membermanage.php file from 7.7.1 (i've not tested this).


Note:
UBB.threads 7.7.3 includes substantially updated Admin > Member Search code and results page.

Last edited by isaac; 07/17/2019 5:28 PM.

Current developer of UBB.threads PHP Forum Software // 7.7.3 released!
isaac @ id242.com // my forum @ CelicaHobby.com
Re: [FIXED for 7.7.3] Database Issue (Member Search) [Re: Outdoorking] #262994 08/02/2019 11:47 AM
Joined: Apr 2004
Posts: 1,549
isaac Offline
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Apr 2004
Posts: 1,549
This has been fixed for UBB.threads 7.7.3 - Released 07/28/2019

Full changelog is available at:
https://www.ubbcentral.com/forums/ubbthreads.php/topics/262984/7-7-3-changelog-discussion


Current developer of UBB.threads PHP Forum Software // 7.7.3 released!
isaac @ id242.com // my forum @ CelicaHobby.com

Forum Search
ShoutChat Box
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Mobile app?
by Baldeagle - 12/06/2019 9:32 PM
How do you change Text Line spacing?
by jorb - 11/23/2019 12:14 AM
What happened to FAQ or Forum Help
by Ruben - 11/20/2019 11:58 AM
Search feature encountering an Error message
by jorb - 11/20/2019 12:06 AM
Followed List v7.7.2 Question
by Ruben - 11/12/2019 12:22 PM
Who's Online Now
2 registered members (Gizmo, Baldeagle), 73 guests, and 369 spiders.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Amusing Terain Scenics
Amusing Terain Scenics
by isaac, August 19
Sky places
Sky places
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Snapshot build 20191023)