• Home
  • Get help
  • Ask a question
Last post 7 hours 36 min ago
Posts last week 82
Average response time last week 34 min
All time posts 68071
All time tickets 10515
All time avg. posts per day 20

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.

#4326 – Database entrys with blank newurl field

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.
Friday, 17 November 2017 15:37 UTC
HeadGofer
 Hi,

Is it safe to delete database entries where the newurl field is blank?

Thanks.

Michael Opton
Friday, 17 November 2017 15:39 UTC
wb_weeblr
Hi

This denotes a 404. You should not delete from the database, but instead the toolbar tools. For instance you can purge all 404 URLs (as you seem to be willing to do) by using the corresponding button on the 404 URLs manager.

In any case, you should never delete or modify anything in the database if you have the "URL disk cache" feature enabled. This will cause you a lot of trouble, although not immediately. Please avoid touching the db as much as possible.

Rgds
 
Friday, 17 November 2017 16:06 UTC
HeadGofer
Ok. I do have a few follow-up questions.

Last year our site essentially crashed because we had a large surge of visitors during our winter festival. I corresponded with you at the time because the culprit was an immense sh404sef_urls database (it had millions of rows). I think we narrowed that down to the JC Events component. From what I'm reading in your support tickets, I can control that by having JC Events go through the Joomla router. First, I'm not sure where to do that. Second, what does that mean as far as friendly urls?

Also, in the database there are many entries with no date added. Is that normal?

Finally is there a way to safely delete entries from JC Events through your interface? And not 25 at a time, but in bulk?

Also, where do I find if URL disk cache is on? And finally, what do you mean I will see problems in the future? What kind of problems? I've already deleted many calander type queries going back to 2003. I've got the table down to 100k records. If necessary I can restore what I've done today.

I'm just trying to avoid having to worry about this in the future.

Thanks!
Friday, 17 November 2017 16:20 UTC
wb_weeblr
Hi

1 -
First, I'm not sure where to do that
It's all in the configuration, under the "By component" tab

2 -
Second, what does that mean as far as friendly urls?
There might be some changes in URLs, but that's entirely up to the JCEvents component, and the way its router.php file is built.

3 -
Also, in the database there are many entries with no date added. Is that normal?
Yes, a normal URL does not have a date added column

4 -
Finally is there a way to safely delete entries from JC Events through your interface? And not 25 at a time, but in bulk?
Not if you have have millions of them to delete, that will have to be done in the DB

5 -
And finally, what do you mean I will see problems in the future? What kind of problems? I've already deleted many calander
Same, it's in the configuration, under the Advanced tab

6 -
And finally, what do you mean I will see problems in the future?
If the cache is enabled, then URLs are stored in DB and some of them are also stored in a disk file, for speedier access under certain conditions . This feature is now disabled by default, as it does not have the benefits it once had.
If it is enabled, and you delete some URLs from the DB directly, then there is now a discrepancy between the disk cache and the db content. The cache is loaded first so for instance, if you delete some JCEvents URL in the DB, and it's in the cache, sh404SEF will keep using the old version, because it finds it in the cache. This leads to incomprehension, and issues with people changing settings furiously, and not seeing the expected results.

The disk cache should be disabled on most sites. Absolutely disable it before you do any dabases manipulation.

Rgds
 
Friday, 17 November 2017 17:42 UTC
HeadGofer
Thanks for the feedback. I think we can close the topic.

On Fri, Nov 17, 2017 at 11:20 AM, Weeblr <[email protected]> wrote:

Monday, 20 November 2017 07:58 UTC
wb_weeblr
Hi

Closing this ticket now, feel free to open a new one as needed. If you do so, please mention this ticket number in the new one.

If you created any superadmin account for us, be sure to delete or block it now to avoid unnecessary risk in the future.

Be sure to also check out wbAMP, our new Accelerated Mobiles pages plugin for Joomla - the next big thing is SEO, direct from Google themselves!



Rgds
 
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.