Dear Eventum Development Team,
I have noticed an issue with upgrading. The DB conversion to UTF8 'will'
cause some issues with foreign character sets. I have found that it trashed
my existing Japanese characters. Any Japanese that is added after the
conversion is fine.
../eventum/misc/upgrade/v2.1.1_to_v2.2/convert-utf8.php
Since 2.2 will convert all incoming emails and notes to default the
character set before storing, I do believe that will be worth the trouble.
../eventum/include/class.support.php
Expecting that all foreign characters are converted to UTF-8 correctly by
the upgrade script is just not realistic.
I suggest that ../eventum/UPGRADE is modified to include a warning about
converting a DB with foreign characters.
I have also included (below signature) a replacement for the upgrade index
file. I used javascript to present a warning about UTF-8 conversion and
added buttons for the other items so the appearance was uniform.
Sincerely,
Brian LaVallee
Director of Technologies, PBXL
brian.lavallee@stripped
Main: +81 [0]34-550-1600
Cell: +81 [0]90-6869-4114
http://www.pbxl.jp
../ eventum/misc/upgrade/v2.1_to_v2.1.1/index.html
----------
<html>
<head>
<title>Eventum - Upgrade from 2.1.1 to 2.2</title>
<script type="text/javascript">
<!--
function add_version_table(){
window.location = "db_version.php"
}
function upgrade_db() {
var answer = confirm("Updating the database to UTF-8 can cause issues
with foreign character sets. Make sure you have a back up of your
database.")
if (answer){
alert("You Have Been Warned!")
window.location = "../update-database.php";
}
}
function flush_templates(){
window.location = "../flush_compiled_templates.php"
}
//-->
</script>
</head>
<body>
Please take the following steps to upgrade Eventum from v2.1.1 to v2.2<br />
<form><input type="button" onclick="add_version_table()" value="1. Add
Version Table"></form>
<form><input type="button" onclick="upgrade_db()" value="2. Update
Database"></form>
<form><input type="button" onclick="flush_templates()" value="3. Flush
Compiled Templates"></form>
</body>
</html>
