stulic wrote:
nanaya wrote:
Okay Where exactly do you put this now?

Good question.

Not everybody is a MySql freak and knows everything about updating database tables and stuff.
A bit more detailed explanation would be nice.

What about my database still having the old mambo prefix mos_?

How do I save the file? With an sql extension or as a simple text file? Where do I upload it and how do I execute the update?



Thx

Don't worry about the extension of the file. You can save it as sql.txt if you like. Then open it in a text editor (e.g. notepad) and replace the table prefix of the sql statements through a replace or manually. Search for jos_ and in your case replace them with mos_

Now open up you phpMyAdmin from your hosting backed (varies by every hosting provider - you should be able to search their support/help pages).

You will see a little icon on the left that says SQL. Click on it. It should open a text window, with a Go button on the bottom right.

Do a copy/past of the entire content of above provided file into this window. Double check that all of it made it. Now simply hit the Go button. If you get any error, I would guess it would mean that the replace from jos_ to mos_ was not complete. Don't worry. Check the error message and if necessary do the replacements again and re-run the script. This script can be safely run as many times as you want.

Having said that, you should always make a backup BEFORE executing any manual scripts - just in case.

That was as straight forward as can be.

Done successfully!

Thank you very much!

You are very welcome!

The original link does not seem to be working. Can anyone re-post the patch?

Many thanks.

Working just fine.

grumblemarc wrote:
Working just fine.

It must just be me then. When I try to access it, I get a blank screen with "Unhandled PropelException" in the top left corner.

So, it still doesn't solve my problem. Does anyone have a copy of the patch?

classixuk wrote:
grumblemarc wrote:
Working just fine.

It must just be me then.

Must be.

Fantastic - worked like a charm! THANKS

Awesome! This worked great. Thank you! I was banging my head against the wall trying to find a solution to garbled quotation marks in my forums. I had one post elsewhere here deleted, and one unanswered. I had no idea that the issue with "legacy html tags" was the source of my problem (or even what legacy html tags were), so I would have never found this by searching. Reading a ton of posts is what got me to just give this fix a shot. Again, a big "thank you" for this one.

This is what I get after running the query. BTW, I am getting code instead of quotation marks on NEW posts!!! Any ideas?

UPDATE jos_fb_messages_text SET message = REPLACE(message, "'", "'";# MySQL returned an empty result set (i.e. zero rows). UPDATE jos_fb_messages_text SET message = REPLACE(message, """, '"';# Affected rows: 12 UPDATE jos_fb_messages_text SET message = REPLACE(message, " ", " ";# MySQL returned an empty result set (i.e. zero rows). UPDATE jos_fb_messages_text SET message = REPLACE(message, "
", "\n";# MySQL returned an empty result set (i.e. zero rows). UPDATE jos_fb_messages_text SET message = REPLACE(message, "
", "\n";# MySQL returned an empty result set (i.e. zero rows). UPDATE jos_fb_messages_text SET message = REPLACE(message, "<", "<";# MySQL returned an empty result set (i.e. zero rows). UPDATE jos_fb_messages_text SET message = REPLACE(message, ">", ">";# Affected rows: 1 UPDATE jos_fb_messages_text SET message = REPLACE(message, "&", "&";# Affected rows: 4 UPDATE jos_fb_messages_text SET message = REPLACE(message, "[img[...]