Keyword

Mass replace links

  • Yonder Mann
  • Yonder Mann's Avatar Topic Author
  • Offline
  • New Member
More
9 years 9 months ago #145455 by Yonder Mann
Mass replace links was created by Yonder Mann
Hi,
I've been moving my Joomla! site to another Domain and I would like to mass replace the links in the K2 articles to the new domain.
I have found a query to do this in a standard Joomla! installation database:
UPDATE jos_content SET introtext =REPLACE(introtext, 'http://www.yourolddomain.com', 'http://www.yournewdomain.com'), fulltext =REPLACE(fulltext, 'http://www.yourolddomain.com', 'http://www.yournewdomain.com');

but it doesn't work with K2 items.

Could anyone with a some database skills point me to the right direction, please!
Thanks
Bert

Please Log in or Create an account to join the conversation.

  • Krikor Boghossian
  • Krikor Boghossian's Avatar
  • Offline
  • Platinum Member
More
9 years 9 months ago #145474 by Krikor Boghossian
Replied by Krikor Boghossian on topic Mass replace links
The table is xx_k2_items (xx is your table prefix).
The cells (introtext and fulltext) are the same

JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

Please Log in or Create an account to join the conversation.

  • Yonder Mann
  • Yonder Mann's Avatar Topic Author
  • Offline
  • New Member
More
9 years 9 months ago #145490 by Yonder Mann
Replied by Yonder Mann on topic Mass replace links
Thanks for getting back to me!
Unfortunately my inexperience with the database stopped me using the string successfully. I guess I didn't put the necessary table names into the string. I was however able to replace the links with phpMyAdmin Find and Replace function in all the required tables.

Thanks for your great help!
Regards
Bert

Please Log in or Create an account to join the conversation.

  • Krikor Boghossian
  • Krikor Boghossian's Avatar
  • Offline
  • Platinum Member
More
9 years 9 months ago #145498 by Krikor Boghossian
Replied by Krikor Boghossian on topic Mass replace links
You 're welcome Bert :)

JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

Please Log in or Create an account to join the conversation.


Powered by Kunena Forum