Ticket #427 (new defect)

Opened 14 years ago

Last modified 14 years ago

WebGUI 7.5.22 problems

Reported by: kmaclean Owned by: kmaclean
Priority: minor Milestone: WebSite 0.2.1
Component: Web Site Version: Website 0.2
Keywords: Cc:


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.

Change History

comment:1 Changed 14 years ago by 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

comment:2 Changed 14 years ago by 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

comment:3 Changed 14 years ago by kmaclean

Note: See TracTickets for help on using tickets.