- Posts: 5
COMMUNITY FORUM
Mass replace links
- Yonder Mann
-
Topic Author
- Offline
- New Member
Less
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:
but it doesn't work with K2 items.
Could anyone with a some database skills point me to the right direction, please!
Thanks
Bert
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
-
- Offline
- Platinum Member
Less
More
- Posts: 15920
9 years 9 months ago #145474
by Krikor Boghossian
JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
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
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
-
Topic Author
- Offline
- New Member
Less
More
- Posts: 5
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
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
-
- Offline
- Platinum Member
Less
More
- Posts: 15920
9 years 9 months ago #145498
by Krikor Boghossian
JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
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.