Maintaining links from j-1.5 to j-3.9 - Redirects?

Need help with the Administration of your Joomla! 3.x site? This is the spot for you.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10.
Locked
ggossamer
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 129
Joined: Wed Sep 29, 2010 4:50 pm

Maintaining links from j-1.5 to j-3.9 - Redirects?

Post by ggossamer » Tue Dec 25, 2018 8:18 pm

Hi,
I have a joomla 3.9 site that has been migrated from joomla 1.0.10 - yes, going back like twenty years. It has nearly 65k articles. We've enabled SEF links, so links like /content/view/216576/169/ have been migrated to /artlcle-name.

The problem is that there is twenty years of history with Google using the old format, including links stored in people's bookmarks, etc.

Do you have any tips on either how to maintain the old format alongside the new format, or how to build a table of redirects that correlate the old links to the new ones?

Perhaps some kind of htaccess file with a series of redirects?

Is this procedure documented anywhere?

User avatar
leolam
Joomla! Master
Joomla! Master
Posts: 20652
Joined: Mon Aug 29, 2005 10:17 am
Location: Netherlands/ Germany/ S'pore/Bogor/ North America
Contact:

Re: Maintaining links from j-1.5 to j-3.9 - Redirects?

Post by leolam » Wed Dec 26, 2018 8:17 am

You can use the redirect component to realize this see https://docs.joomla.org/Help39:Componen ... ct_Manager

Leo 8)
Joomla's #1 Professional Services Provider:
#Joomla Professional Support: https://gws-desk.com -
#Joomla Specialized Hosting Solutions: https://gws-host.com -

ggossamer
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 129
Joined: Wed Sep 29, 2010 4:50 pm

Re: Maintaining links from j-1.5 to j-3.9 - Redirects?

Post by ggossamer » Wed Dec 26, 2018 12:53 pm

The problem is that there's 65,000+ articles in the current database. There's no way to do this manually, and doing it in batch mode requires knowing the relationship between the current article paths and the new.

How do I correlate the old articles with the new?

User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 30920
Joined: Mon Oct 27, 2008 9:27 pm
Location: Romerike, Norway

Re: Maintaining links from j-1.5 to j-3.9 - Redirects?

Post by Per Yngve Berg » Wed Dec 26, 2018 2:34 pm

The redirects are stored in the database table #_redirect_links.

ggossamer
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 129
Joined: Wed Sep 29, 2010 4:50 pm

Re: Maintaining links from j-1.5 to j-3.9 - Redirects?

Post by ggossamer » Wed Dec 26, 2018 8:08 pm

I'm not sure that's helpful; the problem is getting the redirects in the database in the first place from the articles in the v1.0.10 database.

Would you explain how that would work?

User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 30920
Joined: Mon Oct 27, 2008 9:27 pm
Location: Romerike, Norway

Re: Maintaining links from j-1.5 to j-3.9 - Redirects?

Post by Per Yngve Berg » Wed Dec 26, 2018 9:29 pm

Sorry, I don't have a Joomla 1.0 database to look at.

Have you migrated with new id, or have you preserved the id numbers?

ggossamer
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 129
Joined: Wed Sep 29, 2010 4:50 pm

Re: Maintaining links from j-1.5 to j-3.9 - Redirects?

Post by ggossamer » Wed Dec 26, 2018 10:53 pm

Per Yngve Berg wrote:
Wed Dec 26, 2018 9:29 pm
Sorry, I don't have a Joomla 1.0 database to look at.

Have you migrated with new id, or have you preserved the id numbers?
It looks like the ID numbers are being preserved.

The final migration hasn't yet occurred.

ggossamer
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 129
Joined: Wed Sep 29, 2010 4:50 pm

Re: Maintaining links from j-1.5 to j-3.9 - Redirects?

Post by ggossamer » Thu Dec 27, 2018 6:50 pm

Any further ideas?

User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 30920
Joined: Mon Oct 27, 2008 9:27 pm
Location: Romerike, Norway

Re: Maintaining links from j-1.5 to j-3.9 - Redirects?

Post by Per Yngve Berg » Thu Dec 27, 2018 7:23 pm

ggossamer wrote:
Tue Dec 25, 2018 8:18 pm
links like /content/view/216576/169/ have been migrated to /artlcle-name.
I presume 169 is the article id. "/artlcle-name" would be the alias column from the #_content table and not the title column.

ggossamer
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 129
Joined: Wed Sep 29, 2010 4:50 pm

Re: Maintaining links from j-1.5 to j-3.9 - Redirects?

Post by ggossamer » Thu Dec 27, 2018 8:17 pm

Per Yngve Berg wrote:
Thu Dec 27, 2018 7:23 pm
ggossamer wrote:
Tue Dec 25, 2018 8:18 pm
links like /content/view/216576/169/ have been migrated to /artlcle-name.
I presume 169 is the article id. "/artlcle-name" would be the alias column from the #_content table and not the title column.
No, I think 169 is the category ID and 216576 is the article ID, but it's apparently not possible to use the same URI on the new system to access the same article.

ggossamer
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 129
Joined: Wed Sep 29, 2010 4:50 pm

Re: Maintaining links from j-1.5 to j-3.9 - Redirects?

Post by ggossamer » Thu Dec 27, 2018 10:06 pm

Actually, I don't know what the 169 is for. It's not the section ID. The section ID is 82 and the parent_id is 0.

ggossamer
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 129
Joined: Wed Sep 29, 2010 4:50 pm

Re: Maintaining links from j-1.5 to j-3.9 - Redirects?

Post by ggossamer » Fri Jan 04, 2019 6:44 pm

Does anyone else have any further ideas here?

Is it not possible to produce a list of all URLs from all articles in the database?

What is the format for a URL in a joomla-1.5 site?

I've seen several variations, including:

/content/view/<articleID>/<catID>/
/content/blogsection/<catid>/<articleID>/
/component/option,com_registration/task,register/
/content/section/<articleID>/<catID>/

Wouldn't it be possible to write a script that loops through the database with this information and either write it to another table that could be referenced after the migration or use it to reference the article on the new system to create an SEF link based on the title_alias?

User avatar
leolam
Joomla! Master
Joomla! Master
Posts: 20652
Joined: Mon Aug 29, 2005 10:17 am
Location: Netherlands/ Germany/ S'pore/Bogor/ North America
Contact:

Re: Maintaining links from j-1.5 to j-3.9 - Redirects?

Post by leolam » Mon Jan 07, 2019 3:50 pm

If you use a final migration and do this with SP-Upgrade the id's are not changing if you set the correct settings however this is possible:
couldn't it be possible to write a script that loops through the database with this information and either write it to another table that could be referenced after the migration or use it to reference the article on the new system to create an SEF link based on the title_alias?
Yes a good developer can create such script :)

Leo 8)
Joomla's #1 Professional Services Provider:
#Joomla Professional Support: https://gws-desk.com -
#Joomla Specialized Hosting Solutions: https://gws-host.com -

ggossamer
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 129
Joined: Wed Sep 29, 2010 4:50 pm

Migrating old Joomla and maintaining links

Post by ggossamer » Tue Jan 15, 2019 11:46 pm

We have a joomla-1.0.10 site that we're planning to upgrade to 3.9.x. The problem is migrating the existing links, and maintaining the ranking with Google and external links.

When someone goes through the (arduous) process of migrating 1.0.10 -> 1.0.15 -> 2.0, etc.., how do you maintain the old link format so as to not create 404s for existing links on your site and externally linking into your site?
Last edited by toivo on Wed Jan 16, 2019 7:12 am, edited 1 time in total.
Reason: mod note: merged with the current topic, cross posting not allowed - see the forum rules https://forum.joomla.org/viewtopic.php?f=8&t=65

ggossamer
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 129
Joined: Wed Sep 29, 2010 4:50 pm

Re: Maintaining links from j-1.5 to j-3.9 - Redirects?

Post by ggossamer » Wed Jan 16, 2019 9:16 pm

Looks like my message on the Migration board got pulled because of this message, but when I posted this message I didn't realize there was a Migration board.

Anyone have any further ideas? How do you maintain old links from one version upgrade to another?

The problem is that we have an old joomla install that's being upgraded to the current, and the /content/view/64/3423 style links are no longer supported in the current version.

How do we maintain the existing inbound links to the site to avoid 404s for an old site when upgrading?

Is there no built-in ability in Joomla to do this?

User avatar
leolam
Joomla! Master
Joomla! Master
Posts: 20652
Joined: Mon Aug 29, 2005 10:17 am
Location: Netherlands/ Germany/ S'pore/Bogor/ North America
Contact:

Re: Maintaining links from j-1.5 to j-3.9 - Redirects?

Post by leolam » Thu Jan 17, 2019 4:37 am

The message was pulled because of cross posting same issue but not worth-it to discuss.

You won't be able to maintain your URL's for the simple fact that the entire methodology of section/categories was replaced a long time ago by nested categories and your url's have section numbers in the links which we do not have any longer. The new router in Joomla 3.9 allows for URL's without the annoying id's in the links, a wish many, many Joomla users have vented for many years which we realized.

Now you can go on ignoring my previous message and asking the same question time after time but it woo't change a thing for the fact. If you want this bulk-redirected somebody has to write a script for it and it will cost you money

Leo 8)
Joomla's #1 Professional Services Provider:
#Joomla Professional Support: https://gws-desk.com -
#Joomla Specialized Hosting Solutions: https://gws-host.com -

ggossamer
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 129
Joined: Wed Sep 29, 2010 4:50 pm

Re: Maintaining links from j-1.5 to j-3.9 - Redirects?

Post by ggossamer » Thu Jan 17, 2019 12:50 pm

leolam wrote:
Thu Jan 17, 2019 4:37 am
The message was pulled because of cross posting same issue but not worth-it to discuss.
As I mentioned, I didn't realize at first there was a migration board. My mistake.
You won't be able to maintain your URL's for the simple fact that the entire methodology of section/categories was replaced a long time ago by nested categories and your url's have section numbers in the links which we do not have any longer. The new router in Joomla 3.9 allows for URL's without the annoying id's in the links, a wish many, many Joomla users have vented for many years which we realized.
Thanks for the succinct explanation. I just wanted to be sure I understood that not even in the migration procedure there existed a way to "enable" the ability to maintain the old format too. I don't believe I had asked that question previously.
Now you can go on ignoring my previous message and asking the same question time after time but it woo't change a thing for the fact. If you want this bulk-redirected somebody has to write a script for it and it will cost you money
Yes, understood, thanks.


Locked

Return to “Administration Joomla! 3.x”