Valtiel,
The debug output is exactly right...
For the SQL, you do need to select at least the database containing CPG in the left pane of phpMyAdmin before issuing the SQL. (You can select the exact table -but since that is in the SQL statement it isn't required...)
I would still like to see that output if you can try again...
Depending on output - may have a change for you to try just to rule out a possible issue.
Based on what is in the debug - that page likely took over 30 seconds to load...
The top query took over 20 seconds (in runtime):
[28] => SELECT r.pid, r.aid, filepath, filename, url_prefix, pwidth, pheight, filesize, ctime, r.title, r.keywords, r.votes, pic_rating, hits, caption, r.owner_id, pic_raw_ip, pic_hdr_ip
FROM cpg15x_pictures AS r
INNER JOIN cpg15x_albums AS a ON a.aid = r.aid
INNER JOIN cpg15x_categories AS c2 ON c2.cid = category WHERE (c2.lft BETWEEN 157 AND 356) AND (1 OR keywords like '%jen%' OR keywords like '%jen%' OR keywords like '%jen%' OR keywords like '%Jen%' OR keywords like '%jen%' OR keywords like '%jen%' OR keywords like '%jen%' OR keywords like '%jen%' OR keywords like '%jen%' OR keywords like '%jen%' OR keywords like '%jen%' OR keywords like '%jen%' OR keywords like '%jen%' OR keywords like '%jen%' OR keywords like '%jen%' OR keywords like '%jen%' OR keywords like '%jen%' OR keywords like '%jen%' OR keywords like '%jen%' OR keywords like '%jen%' OR keywords like '%jen%' OR keywords like '%jen%' OR keywords like '%jen%' OR keywords like '%jen%' OR keywords like '%jen%' OR keywords like '%jen%' OR keywords like '%jen%' OR keywords like '%jen%' OR keywords like '%jen%' OR keywords like '%jen%' OR keywords like '%jen%' OR keywords like '%jen%' OR keywords like '%jen%' OR keywords like '%jen%' OR keywords like '%jen%' OR keywords like '%jen%' OR keywords like '%jen%' OR keywords like '%jen%' OR keywords like '%jen%' OR keywords like '%jen%' OR keywords like '%jen%' OR keywords like '%jen%' OR keywords like '%jen%' OR keywords like '%jen%' OR keywords like '%jen%' OR keywords like '%jen%' OR keywords like '%jen%' OR keywords like '%jen%' OR keywords like '%jen%' OR keywords like '%jen%' OR keywords like '%jen%' OR keywords like '%jen%' OR keywords like '%jen%' OR keywords like '%jen%' OR keywords like '%jen%' OR keywords like '%jen%' OR keywords like '%jen%' OR keywords like '%jen%')
AND approved = 'YES'
ORDER BY ctime DESC, pid DESC
LIMIT 0 ,10 [include/functions.inc.php:1504] (21044.61 ms)
This is the query I suspected from my testing - obtaining the last uploads...
*IF* this information isn't important to you - you can change the config setting for:
Album list view -> The content of the main page to remove "/lastup,2" from the string (your number may differ from 2...)
That will eliminate the query from running - but also alter he display to not show the last uploaded files...
If this information is important to you - we need to keep looking...
The next in line was under 2 seconds - so the one above is by far the biggest issue.
Incidentally I looked up deleting all keywords, went through the process and in keyword manager.. it doesn't even say I have any to manage. Yet all the folders have the keyword on it, and if I try to delete them one by one it doesn't do anything they just pop right back up. I don't know why this has suddenly started doing this! Its been fine for a year and suddenly, bam.
Keyword Manager seems to affect keywords assigned to pictures... I just deleted one in my test gallery, and it updated all the pics - but the album still contains the keyword...
If we can get the output of the SELECT above - I can give you an SQL statement to clean up what I think we will see there...
I wish you could pay people to fix this stuff, so frustrated because I just don't understand it and this is such a major Gallery.
Well - you can... there is a 'freelance' board to ask for paid help... but you do have a group of us here offering to assist for free - and depending where this leads - may need more than one of us to figure out.
We're happy to work with you.