bulk word replaceent in database...

[butty]

hello there. i wonder if someone can help me.

i have jus moved my forum up a dir from http://www.mysite.com/forum to http://www.mysite.com

now its all working oketc but i have some links in the database that are on posts say of people linking to other posts on my forum. they would have on the links http://www.mysite.com/forum/showthread.php? etc etc

now is there anyways i can change all the instances of this in my database and remove the /forum so that when people visit the links to other pages on posts on my forum it will still iink to the post that its supposed to

any help appreciated. thanks guys

[Jake Bunce]

Run a query like this on your database (backup first):

UPDATE post
SET pagetext = REPLACE(pagetext,'[color=red]OLD TEXT[/color]','[color=red]NEW TEXT[/color]')

[GlitterKill]

Is this case sensitive? I am wanting to do the same thing since we recently changed our site name and I want to rename all of the links as well as change the occurances of our old name to our new one.

[GlitterKill]

Bump... Anyone know if this is case sensitive? Can it be made case sensitive if not?

[Jake Bunce]

I just tested it. It is case-sensitive.

[GlitterKill]

Great! Thanks!

I have another question though. Since this changes post text, will it also affect urls/links? The main thing I want to change are all links within the site from pimprig.com to pcapex.com. So say somthing like this:

Sample link.

Will the actual words in that url be changed via the same method? I have a large board with over 500K posts and 11K members so I am just being extra careful.

[Jake Bunce]

Yes, it will change links in posts.

[GlitterKill]

What if we need to change text that includes quotes? " "

[Jake Bunce]

The query above uses single quotes ('...') to delimit the strings. You can safely use double quotes in the strings. For example:

UPDATE post
SET pagetext = REPLACE(pagetext,'[color=red]blah" blahblah[/color]','[color=red]no way! "quotes"[/color]')

...but if you use single quotes then you need to escape them with backslashes:

UPDATE post
SET pagetext = REPLACE(pagetext,'[color=red]single quote \' blah blah[/color]','[color=red]bunch of them \'\' asdflkj \'[/color]')

[CerealKiller]

I hate to bump such an old thread, but at least this way you know I searched .

I moved my forums from http://forums.rhinoforums.net to http://www.rhinoofurm.net/ so I wanted to run this command:

UPDATE post
SET pagetext = REPLACE(pagetext,'http://forums.rhinoforums.net','http://www.rhinoforums.net')

However, when I ran the query via the 'AdminCP > Execute SQL Query' this was returned:

An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'rhinoDB.post' doesn't exist


Any help? Thank you.

[Reeve of Shinra]

Just use the replacement feature under admincp -> styles and settings -> replacement variables -- then input the stuff under the style your using. Its done on the fly but it will work.

[pds]

Run a query like this on your database (backup first):

UPDATE post
SET pagetext = REPLACE(pagetext,'[color=red]OLD TEXT[/color]','[color=red]NEW TEXT[/color]')

This didn't work on my 3.7.2 version. Any suggestions? I changed some usernames, and want the posts with their prior posts quoted to have the correct username.

Do I have to run any maintenance scripts to make the changes show up?

[peterska2]

Please start your own thread in the relevant forum for the version of vBulletin that you are running. Thank you.