Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#1 2010-03-13 16:44:41

JimJoe
Member
From: United States
Registered: 2010-01-30
Posts: 573
Website

search and replace static urls in my site ?

I looked over the plugins. I saw one that said ‘search and replace is now available in txp 4.0.2 so this plugin is no longer useful’ or something like that.

Anyway, I mistyped static urls on about 300 of my pages. I meant to type ‘articles’, but instead I typed ‘archives’.

Is there a global search and replace method I can use ? An easy way to fix this ?

My mysql skills are down around zero, so I would prefer not to mess with the myphpadmin stuff if possible.

Thanks.

Offline

#2 2010-03-13 16:53:04

colak
Admin
From: Cyprus
Registered: 2004-11-20
Posts: 9,251
Website GitHub Mastodon Twitter

Re: search and replace static urls in my site ?

Jim,

the plugin might still work on 4.2. Alternatively there’s smd_where_used which searches without replacing.


Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.

Offline

#3 2010-03-13 17:05:16

JimJoe
Member
From: United States
Registered: 2010-01-30
Posts: 573
Website

Re: search and replace static urls in my site ?

Ah, it wasn’t search and replace, but file upload replace that wasn’t needed anymore…

I’ll try lam’s search and replace plugin later today. http://textpattern.org/plugins/914/lam_search_replace

I have to do some grocery shopping first.

Offline

#4 2010-03-13 17:16:44

JimJoe
Member
From: United States
Registered: 2010-01-30
Posts: 573
Website

Re: search and replace static urls in my site ?

Okay, I couldn’t wait.

Saved my database. Ran the plugin. No changes.

Error says it couldn’t connect to database.

here is the entire error message:

Warning: preg_replace() [function.preg-replace]: Unknown modifier ‘a’ in /usr/home/drivein/public_html/crestar/crestar/textpattern/lib/txplib_misc.php(594) : eval()’d code on line 65

Warning: Table ‘drivein_txtp.drivein_drivein_textpattern’ doesn’t exist update drivein_drivein_textpattern set body = ‘’ where id = 257 in /usr/home/drivein/public_html/crestar/crestar/textpattern/lib/txplib_db.php on line 85
Could not connect to database

end error message.

first I tried replacing archives with articles, no change.

then I tried /archives/ and /articles/ then got the above error message.

edit: my stomach is growling at me. I’ll be gone feeding it. I’ll be back later.

Last edited by JimJoe (2010-03-13 17:21:00)

Offline

#5 2010-03-13 17:21:46

els
Moderator
From: The Netherlands
Registered: 2004-06-06
Posts: 7,458

Re: search and replace static urls in my site ?

You’d better post in the plugin support thread.

Offline

#6 2010-03-13 19:39:32

uli
Moderator
From: Cologne
Registered: 2006-08-15
Posts: 4,315

Re: search and replace static urls in my site ?

I once used this snippet in phpMyAdmin:

UPDATE tablename SET columnname =
REPLACE(columnname, 'searchstring', 'replacestring');

No guarantee, better do another backup ;)


In bad weather I never leave home without wet_plugout, smd_where_used and adi_form_links

Offline

Board footer

Powered by FluxBB