Fixed by converting to UTF-8 with modifications.
Ok so now I realize that 2.2 is supposed to be UTF-8. However, our older version was not.
I figured out to run the script /misc/upgrade/v2.1.1_to_v2.2/convert-utf8.php but ran
into the following issues.
1) In /config/config.php
Change: define('APP_CHARSET', 'ISO-8859-1');
To: define('APP_CHARSET', 'UTF-8');
2) There is a problem in the convert-utf8.php script. It stops when it goes to change the
"group" table (as I don't have any table prefix AND "GROUP" is a MySQL reserved keyword).
I simply added back-ticks around the table name as follows at ~ line 51
From: $changes[] = "ALTER TABLE {$row['TABLE_NAME']} CONVERT TO CHARACTER SET utf8";
To: $changes[] = "ALTER TABLE `{$row['TABLE_NAME']}` CONVERT TO CHARACTER SET utf8";
Now the emails are coming through with all headers in tact. Hope this helps someone else.
Cheers!
Michael
>>> "Michael Bannach" <MXB@stripped> 10/14/2009 9:59 AM >>>
Hi,
I just upgraded to 2.2 from 1.71 running on SunOS 5.10. I have run all of the upgrade
scripts for each version in between in succession. It is working as expected, however
there is a problem with the emails being sent as they are coming through without the
headers. I checked the database and they are there in the mail_queue table... just not
being included when the actual email is sent. Here's an example
From:
To:
Subject:
Content-Transfer-Encoding:
Content-Type:
X-Eventum-Group-Issue:
X-Eventum-Group-Replier:
X-Eventum-Group-Assignee:
X-Eventum-Assignee:
X-Eventum-Category:
X-Eventum-Project:
X-Eventum-Type:
So the emails it's send out come with a blank subject and are from "@localhost"
Any Ideas?
Thanks, Mike
--
Eventum Users Mailing List
For list archives: http://lists.mysql.com/eventum-users
To unsubscribe: http://lists.mysql.com/eventum-users?unsub=1
