Thursday, 18 February 2016 20:10

DONE: Fix pic links that go to firearms.fortreg.com

Written by
Rate this item
(0 votes)

Wordpress articles imported into Joomla were pointing back to their original WP links, which displayed fine, however were pointing to firearms.fortreg.com domain. This will break when the domain is pointed to the new r3 site.

Solution:

mySQL

update  '{prefix}_k2_items`
set
introtext = replace(introtext, 'firearms.fortreg.com', 'fortreg.com/firearms')

-- test with one record
 --WHERE id = 521

Read 1631 times Last modified on Thursday, 18 February 2016 20:21

Latest from sysadmin