Last post 4 hours 8 min ago

Posts last week 141

Average response time last week 4 hours 42 min

All time posts 67794

All time tickets 10475

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.

#5937 – Generated SEF URLs disappear the next day

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, 08 August 2019 07:34 UTC

iage

Hi there,

For some weeks, most of the Pages doesnt work anymore (Page not found error message).

First, I thought it's just one specific component, where the URLs stopped working, but it happens on Joomla Article pages as well.

When I purge all URLs, everything is fine and all 191 found URLs are successfully recorded in the URL Manager.

But here comes my problem: the next day almost every SEF-URL in the Manager dissappears and only 19 URLs are listed, even when I visit the Homepage, new URLs won't be created or displayed in the URL Manager.

My question is, is this a sh404sef behaviour, that SEF-URL records in the manager dissapear for some reasons? I thought that sh404sef lists all URLs which it receives and not remove any of them until I delete them or purge the list.

Any kind of info will be appreciated.

Thank you
Best regards

Thursday, 08 August 2019 08:32 UTC

yweeblr

the next day almost every SEF-URL in the Manager dissappears and only 19 URLs are listed,

There is nothing in sh404SEF that can delete URLs except when you press the Purge button or the Delete button. It does not have any code that can remove URLs from the database automatically.

My question is, is this a sh404sef behaviour, that SEF-URL records in the manager dissapear for some reasons? I thought that sh404sef lists all URLs which it receives and not remove any of them until I delete them or purge the list.

This is exactly how it's been for the last 13 years and several hundred thousands websites!

The most likely reason something like that could happen is if your hosting company MYSQL server had an issue and either a previous version of the database is restored for instance. That would be the first area where I'd look: the MYSQL server and the MYSQL log files. Here are a few questions/comments:

1 - What are versions for: Joomla, sh404SEF, PHP and MYSQL?
2 - What's the site URL?
3 - How is the site hosted: which company? which type: shared hosting, managed VPS, personal VPS, ...?
4 - Do you have any form of caching or CDN in use? ie Cloudflare, Siteground, etc
5 - Are you the only person with backend access?
6 - Check the PHP error log files for any error that might look suspicious
7 - Check all CRON jobs set in your control panel or in your VPS. There might be a maintenance operation that does not work as expected
8 - Search the MYSQL logs: for errors and also for a TRUNCATE operation that would empty the db table. Even just having the time at which this deletion occurs might help.
9 - disable any Joomla extension that may be related to database maintenance, database "optimization" or such
10 - In sh404SEF, make sure "Use URL disk cache" is Disabled (it's off by default). An added cache layer may make debugging more complicated.
11 - This started some weeks ago: can the start be related to some changes? ie hosting change, mysql version change, Joomla or extensions update, etc

Those are the things I can thing of right now, I'll try think about more things to investigate.

Best regards

Thursday, 08 August 2019 08:34 UTC

yweeblr

Hi again,

OK, I was just looking at you other tickets and this one might be related to your current problem?

Best regards

Thursday, 08 August 2019 09:09 UTC

iage

Hi there,

Thank you for your quick reply and your useful information.

It was indeed related to the above mentioned ticket.
The previous developer forgot to turn disk cache off (as suggested by you).

I disabled the URL Cache and now the SEF-URLs are regenerated.

I will check again tomorrow if everything still works after the Cron-Job is used, but it seems to work for now.

Thank you for help,
Best regards

Thursday, 08 August 2019 10:55 UTC

yweeblr

Hi

You should be able to run the cron-job right away if you have SSH access for instance. Or you can change the cron time or duplicate temporarily the cron job and make it run in a few minutes so as not to wait until tomorrow.

Best regards

Friday, 09 August 2019 06:37 UTC

iage

Hi

Our customer insisted not to run the cronjob during the day, due to its heavy script it runs.

I can now confirm it works and the ticket can now be closed.

Thank you very much for your help!
Best regards

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.