Loading...
 
Architecture / Installation

Architecture / Installation


Problem changing encoding during upgrade

posts: 35

I upgraded from 5.0 to 6.0. I followed the instructions for changing the encoding. The final step, which converts the text of my pages ended up deleting everything on the page after the first apostrophe. For example:

The content of the page is

The quick brown fox jumped over the lazy dog's back.

After the database conversion but before the final step, it looks like

The quick brown fox jumped over the lazy dog$%#@&*s back.

After the final conversion step the page looked like

The quick brown fox jumped over the lazy dog

So I restored the database and re-did the upgrade, skipping the final step. Then I used the new global replace to fix the content. Was this OK?

posts: 1001 Canada
In which environment did this happen? In particular, what version of MySQL do you use?


posts: 1001 Canada

I can't reproduce your problem. If anyone can, please provide a dump of tiki_pages before and after the double encoding fix.

The relevant query is in fix_double_encoding() in installer/tiki-installer.php.