• Home
  • Get help
  • Ask a question
Last post 2 hours 44 min ago
Posts last week 110
Average response time last week 29 min
All time posts 67424
All time tickets 10424
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.

#4590 – SSL Site Conversion - Canonical URL database query

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, 01 February 2018 01:08 UTC
acrossan
 Hello,
We have switched a site to https and want to convert all canonical URLs in sh404SEF to https by running a sql query, but we cannot find the correct table containing all canonical URLs.

We see that there are canonical URLs set in the admin panel of sh404SEF when logged into Joomla, but the only table with a canonical column is the sh404sef_metas table, and there is no data displayed in this column for any entries.

What is our best course of action, and where can we find the correct table?

Thank you in advance for your timjavascript:ticketDoSubmit()e.
Thursday, 01 February 2018 09:03 UTC
wb_weeblr
HI

We have switched a site to https and want to convert all canonical URLs in sh404SEF to https by running a sql query, but we cannot find the correct table containing all canonical URLs.
There is no need for that. sh404SEF does not handle the domain part of URLs i(https://site.com). We only take care of the part of the URLs after that. This is all taken care of by Joomla itself, whether you have sh404SEF or not.

What is our best course of action, and where can we find the correct table?
Again, there is nothing to do, Joomla will adjust everything in terms of domains.

Rgds
 
Thursday, 01 February 2018 17:34 UTC
acrossan
Thank you for your reply. Just to be certain, if the canonical URL is set to http://www.XXXX.com in sh404SEF, we do not need to change it to https://www...?

Best regards
Thursday, 01 February 2018 17:42 UTC
wb_weeblr
Hi

OK, there's been some confusion here. Indeed if you manually entered some canonicals in the canonical field of URLs in the URL manager, and you included the full URL with domain when you did that, then yes, you need to change them from http to https.

If you entered the canonicals manually, we will comply with what you entered of course, as there is no way for us to know what's your desired target.

Normally:

1 - there's no need to enter a canonical manually, except in a few specific cases, to solve a specific problem.
2 - A canonical is be inserted by sh404SEF automatically for com_content articles. That one will use whatever is the current scheme (http / https) of the site.
3 - When entering canonical manually in the URL manager, you should rather use /my-canonical-url rather than http://site.com/my-canonical-url. This would save this exact trouble, as the canonical computed for the page will then be automatically the full domain currently set in Joomla, without a need to update the canonicals if the site is moved from http to https, or even to another domain entirely in the future.

So if you have manually entered canonicals with domains in sh404SEF, you should find them in the #__sh404sef_aliases table. Beware that this table holds both redirects and canonicals, be sure to update only what you want to update.

Rgds
 
Friday, 16 February 2018 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.