Upgrade to v15 Causing Server Issues

[kldewitt]

Hi -

I recently upgraded to V15 and my website hosting is saying it's causing major performance issues to their servers. (I use a GreenGeeks shared hosting.) They say that queries such as the following are causing the issue (I blanked out the SQL database name):
 

| kldewitt_****** | localhost | kldewitt_****** | Query | 5 | Sending data | SELECT count(*) as pcount
FROM (tng_medialinks, tng_people)
WHERE tng_medialinks.personID = tn | 0.000 |

Any ideas what I need to do to fix this issue?  It looks like it got called 8 times before they killed my site and won't let me have it back until the issue is corrected...

My family tree is approx 25,000 people and has approx 17,000 photos. I didn't have this problem before upgrading.

Kelly

[GOGGS]

I see a few issues, and maybe Darrin has to weigh in...

- A query across 2 tables without explicit join condition(s) is asking for trouble - like count all the records in both and multiply them together?

- The where clause has personid = tn without quote marks, and doesn't have a number (e.g. t1, n1, tn1, etc.), and even when I ran that on my db with 'I1' (me) it came back with a count of the total number of people multiplied by the number of pictures of me - ?

I've modified a number of these types of queries on my system, but I'm not on V15...

 

GOGGS

[Ken Roy]

Did you upgrade to TNG 15.0.1?  You should report the problem to Darrin.

If your account is now offline, it might be difficult for him to figure out what is wrong.

Edited April 23, 2025 by Ken Roy
correct information

[kldewitt]

Thanks (merci) for the responses. Yep, it was 15.0.1.

Unfortunately, I'm in a Catch-22. They won't let me have my site back until I fix the "problem," but because I can't access the site except for it to tell me it's unavailable (even after they swore I would have "private" access to it), I can't run any clean-ups, fixes, re-uploads, etc.  

So as you say, Darrin won't be able to look at my site, either, so no knowing what to actually fix.

I really dislike GreenGeeks intensely - this isn't the first time they've killed my entire site and then made access nigh impossible to correct anything.  It's taken up to a month to get it back in the past just to be able reload all files from scratch and cross my fingers...   If it wasn't prepaid for another year+, I would have jumped ship long ago.  I guess it's really time to bite the bullet and find another hosting service and start from the ground up. Rodents.

Kelly