Jump to content

Broken Links


Owyn

Recommended Posts

I think a general cleanup of the mySql Post Text field is required.The broken links do not just affect the links to messages, they also affect the links to emoticons in old posts.Any reference in the database to "www.scotsnewsletter.com/forums" needs to be changed to "forums.scotsnewsletter.com" ;)

Link to comment
Share on other sites

This example from the mySql manual shows the basic SQL required.

REPLACE(str,from_str,to_str)    Returns the string str with all occurrences of the string from_str replaced by the string to_str:mysql> SELECT REPLACE('www.mysql.com', 'w', 'Ww');        -> 'WwWwWw.mysql.com'    This function is multi-byte safe.
Link to comment
Share on other sites

Owyn, just to let you know I saw this note of yours, and it makes perfect sense. However, it hasn't proven as easy as that. I am looking into this though.-- Scot

Link to comment
Share on other sites

Owyn, just to let you know I saw this note of yours, and it makes perfect sense. However, it hasn't proven as easy as that. I am looking into this though.-- Scot
Tx for the update. The theory looked simple. Sorry the practice is painful.
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...