Hello,
I am using Joomla v3.9 and Artio JoomSEF 3 free, both since several years since three days I have serious problems with this combination. Here is my site (it's a private family website for our house renovations):
mona-stefan.de
https://abload.de/thumb/snipping_0459tk2t.jpeg
I don't know which option I changed in the last few weeks but now JoomSEF killed my website by creating thousands of URLs which
1. are not working
2. litter the database
3. creates lots of empty database querries which kill the MySQL instance of my webhost.
I first found the not-functional urls into the redirect-component of Joomla
they mostly begin with a "selbstbauprojekt-lautsprecher" in the first part of the url (which is an existing article) and followed by the url of another, second article. So this combined URLs do not work and therefore they appear with an error 404 into the redirect-component
then I found the origin of this false URLs into JoomSEF
five days ago JoomSEF had 47.867 urls and all worked fine, but nevertheless I startet a topic into the
German Joomla bulletin board here
but now, JoomSEF created over 124.383 urls which enlarges the size of the database enormous and now let the MySQL instance collapse.
https://abload.de/thumb/snipping_049zlkfq.jpeg
Although I deactivated the creation of new SEF URLs in the control panel of JoomSEF the MySQL collapses again within 30 minutes after every restart
https://abload.de/thumb/snipping_046dak73.jpeg
now I did four changes at the system. I don't know exactly which was the right option but now the site is accessible and I can search for the problem. My changes are:
- Redirect nonSEF URLs to SEF? -> no
- Parse Joomla SEO links? -> no
- Debugging URL errors -> no
- via FTP in components -> com_sef -> controller I renamed the cron.php because I think that with this JoomSEF is crawling for new URLs
https://abload.de/thumb/snipping_047krjkt.jpeg
So did anybody has a similar problem and / or an idea how to solve this?
And how can I get rid of this masses of defective URLs into my database?
Thanks and regards
Stefan
Germany