WebGUI 7.5.22 problems

[kmaclean]

if you indent some textand then preview it, the indents are delete. If you do the same and try to save without previewing, lose indents.

[kmaclean]

snippet from dbcharsetrepair_pl.txt:

     # Perl was always sending UTF8, but MySQL may have been treating it like a different charser
     # This lead to it converting it based on the connection, even if the table was UTF8

     # First, we undo that conversion

     # We should now have the correct byte sequences, but if we do a direct convert to UTF8,
     # MySQL will attept to convert it again.  Converting to binary first prevents this
 
     # Now we convert to UTF8, and it should be stored properly.  We're using a UTF8 connection,
     # so everything should just work from here on

[kmaclean]

from Graham:

I ended up not adding this to the 7.5.9 upgrade, but putting it in the 7.5.6 upgrade instead.

The reason for this is that the process to do this repair would corrupt any international characters added after 7.5.6. If you have already upgraded past 7.5.6, you'll want to run the script I'm attaching that does the same process as is found in the upgrade. You may wish to export newer content as packages and reimport it after running this script.

Save in /data/WebGUI/sbin and run as

perl dbcharsetrepair.pl --configfile=mysite.com.conf

[kmaclean]

This is ​Graham's post