Last post 44 min ago

Posts last week 89

Average response time last week 30 min

All time posts 67737

All time tickets 10467

All time avg. posts per day 21

Helpdesk is open from Monday through Friday CET

Please create an (free) account to post any question in the support area.

Please check the development versions area. Look at the changelog, maybe your specific problem has been resolved already!

All tickets are private and they cannot be viewed by anyone. We have made public only a few tickets that we found helpful, after removing private information from them.

#5991 – URL Manager timeout when loading

Posted in ‘sh404SEF’

This is a public ticket. Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Thursday, 03 October 2019 06:32 UTC

slamskateboarding

Hi, I have recently gone through a large upgrade process on my website and am having issues with the SEF URLs manager not loading in the Admin Dashboard.

I am also having issues loading the Title and Metas manager too.

Interestingly, I have no issue loading the following screens:

Control Panel
Aliases
Short URLs
404 Errors

When I attempt to open the SEF URL screen, the browser makes a request to "/administrator/index.php?option=com_sh404sef&c=urls&layout=default&view=urls"

but it just ends up timing-out and returning an ERR_EMPTY_RESPONSE after 2 mins.

I have tried emptying the URLs Table in the database and I was able to then load those screens (with no items displaying) which leads me to think there is something funny going on in the database entries, but I am not sure how to fix/repair.

The website has been around for a long time (though I'm not sure how well the SEO has been done previously) so I am wary of just starting from scratch with the SEF URLs.

Any advice is appreciated.

Thursday, 03 October 2019 07:27 UTC

wb_weeblr

I have tried emptying the URLs Table in the database and I was able to then load those screens (with no items displaying) which leads me to think there is something funny going on in the database entries, but I am not sure how to fix/repair.

1st you should probably not "Purge" the URLs database at all on a production site. This will cause all URLs to be rebuilt and can cause 404s for visitors until such time all URLs have been rebuilt.
Second, if you directly empty the urls db table, be sure that "URL disk cache " is OFF under the "Advanced" tab of sh404SEF configuration, or else you're at risk of discrepancies between the cache and the actual database and funny things might happen.

Now onto the actual issue:

- SEF URL manager and Page and title manager use very complex database queries to be able to collect URLs, count duplicates and meta and be able to have filters on them. Depending on the number of URLs, the number of live visitors on your site and how powerful your MYSQL server is, displaying those pages might lead to timing out if the MYSQL server cannot cope.
- other reasons might be corrupted database tables
- in normal operation, how many URLs do you have in the DB? normal URLs and 404s
- what sort of servers and visitors count are we talking about?

Fixes/repairs:

1 - Go to sh404SEF configuration and set "Slow server to Yes under the Advanced tab of sh404SEF configuration. This will make the SEF URL manager use a simpler display, less demanding on the MYSQL server
2 - Using PHP Myadmin or your hosting company tools, run a complete check, repair and optimization on your database table, specifically the #__sh404sef_*** tables.

Let me know

Best regards

Friday, 04 October 2019 04:56 UTC

slamskateboarding

Hi, thanks for the reply.

To answer your questions:

In normal operation, how many URLs do you have in the DB? normal URLs and 404s

The Control Panel gives me this info:

Total URLS : 219.5K
Visited: 5878
Never Visited: 213.6K

Total 404: 498
Internal: 38
External: 460

what sort of servers and visitors count are we talking about?

Hosting is with GoDaddy - Shared cPanel plan with the following specs:

2 Shared CPU
Up to 1GB Shared RAM
Unlimited Shared Storage
Moderate Traffic

--
System Information from Joomla! tells me:

Database Type mysql
Database Version 5.6.44-cll-lve
Database Collation latin1_swedish_ci
Database Connection Collation utf8mb4_general_ci

PHP Version 7.3.7
Web Server Apache
WebServer to PHP Interface litespeed

Joomla! Version Joomla! 3.9.12 Stable [ Amani ] 24-September-2019 15:00 GMT
Joomla! Platform Version Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT

---

Fix/Repairs

I tried switching to the "Slow Server" settings, but that just made it take much longer to load the screens that were previously working and didn't fix the issue.

I used phpMyAdmin to perform a check/repair/optimize on the tables in the database, but it doesn't appear to have had any effect. (the database engine is InnoDB and as such, it was reported that the repair/optimize functions would not do anything?)

Thanks.

Friday, 04 October 2019 09:05 UTC

wb_weeblr

but that just made it take much longer to load the screens that were previously working and didn't fix the issue.

That setting is only used on SEF URL manager.

I used phpMyAdmin to perform a check/repair/optimize on the tables in the database, but it doesn't appear to have had any effect. (the database engine is InnoDB and as such, it was reported that the repair/optimize functions would not do anything?)

Indeed you're on a small shared hosting plan and you do have large number of URLs so the server just cannot cope. You did not reply on traffic so it's hard to say of the site is busy responding to visitors.

As you have only 5000 URLs actually visited and more than 200K URLs stored, one thing that could be done is the following:

- Purge 404 error logs
- Purge SEF URLs - this will cause all URLs to be deleted except the manually customized ones
- Use a link checker such as ScreamingFrog. It will rebuild the top URLs, starting from your home page.

The assumption here is that many URLs many not be needed and if you come back to a more reasonable number of URLs for your server, the page will display again.

Best regards

Saturday, 19 October 2019 05:34 UTC

system

This ticket has been automatically closed. All tickets which have been inactive for a long time are automatically closed. If you believe that this ticket was closed in error, please contact us.

This ticket is closed, therefore read-only. You can no longer reply to it. If you need to provide more information, please open a new ticket and mention this ticket's number.