DB Replacer

Url Strcture updating

4 months 2 days ago #78196

Peter Ndiritu's Avatar Peter Ndiritu

hi,
After updating the url routing in my joomla site, some old urls wont update accordingly unless i unlink then and re-link them manually...

**old url are**
index.php?option=com_content& view=article&id=48:editing- helpers&catid=17:research- proposal&Itemid=101

**New ones are like...**
index.php?option=com_content& view=article&id=48:editing- helpers&catid=17

Is there a way I can automatically update and remove the **:research-proposal&Itemid= 101** from urls which is the part not put in the new routing instructions..

Peter

4 months 2 days ago #78197

Peter van Westen's Avatar Peter van Westen Admin

Yes, with Regular Expressions:

(&catid=[0-9]+)\:[^"\']*
Replace with:
\1

4 months 2 days ago #78198

Peter Ndiritu's Avatar Peter Ndiritu

Pardon my curiosity but please clarify for me..

If anything went wrong, can I reverse this?

There are many urls the one i posted here is an example..

I just need to remove the end part: in most of the urls e.g in this url to remove.. ****:research-proposal&Itemid= 101**** in

. different urls have the end part differing from one link to another, when i remove the end part, the url is perfect


Just need to cut out the last part of most urls. that part after catid=22 or catid=23 etc

Pls confirm

4 months 1 day ago #78200

Peter van Westen's Avatar Peter van Westen Admin

Yes,, that should do it.
You can se in the preview if things are going to be replaced as you want it.

Before you do this: make a backup.
Then you can use that to revert if things go wrong.

4 months 1 day ago #78216

Peter Ndiritu's Avatar Peter Ndiritu

hello,
What should i select under tables and columns.

Thanks

4 months 1 day ago #78217

Peter van Westen's Avatar Peter van Westen Admin

You do not have the Pro version of DB Replacer. You need that for the Regular Expressions option.

4 months 1 day ago #78218

Peter Ndiritu's Avatar Peter Ndiritu

I want to buy that now, would you please tell me if I can get one of your support guys help with the process of updating the urls.
I have bought other extensions from you..
Thanks.

4 months 1 day ago #78220

Peter Ndiritu's Avatar Peter Ndiritu

And also my content has lots of duplicate content issues,anything you sell that can resolve that?

4 months 1 day ago #78221

Peter van Westen's Avatar Peter van Westen Admin

You need to select the database tables that contain these urls. Probably the content table and the introtext and fulltext columns.
But maybe also in your modules table.

DB Replacer is a power tool, as it replaces stuff directly in your database.
If you have no idea how the database works, this might not be the best tool for you.

I have no extension to prevent duplicate urls/content.

3 months 4 weeks ago #78277

Peter Ndiritu's Avatar Peter Ndiritu

Hello,
Am back to you, I am willing to buy the pro version, but kindly I need you to help me with the process. As you said am not a pro with the process and may mess up.

Kindly I have 10 sites and manually re-linking may take me for ever.

I was hoping that you can help me with the same, i would rather pay a small fee. Am sure also you will be supporting the use of your sold products.
If this will update my links, then I am so lucky.

Even my duplicate content issues will be over...

Thanks

3 months 4 weeks ago #78278

Peter van Westen's Avatar Peter van Westen Admin

Sorry, that is beyond my support.

3 months 4 weeks ago #78279

Peter Ndiritu's Avatar Peter Ndiritu

Do you know an expert I can pay for this job, who understands your products?

3 months 4 weeks ago #78281

Peter van Westen's Avatar Peter van Westen Admin

You can probably find someone suitable for the job via:
perfectwebteam.nl
resources.joomla.org
www.facebook.com/groups/joomlajobs

3 months 4 weeks ago #78282

Peter Ndiritu's Avatar Peter Ndiritu

Thanks,
Peter.