Friday, December 24, 2010

Mail Portlet Synchronization Issue

Liferay Portlet doesn't Synchronize all the mails properly. Though it shows the Mail Count in Pagination,the Pagination fails to work properly at a certain level.

This is due to some unusual characters in subject/sender/to/body in your mails.

You can resolve this by changing some column types from "mail_message" table.

Step 1: Please make sure that your database character set is "UTF-8".If it isn't then create it as follows:

create database testing character set utf-8



Step 2: Change "longtext" to "binary" for some column from "mail_message" table

as follows:

alter table Mail_Message modify column sender longtext character set binary;

alter table Mail_Message modify column to_ longtext character set binary;

alter table Mail_Message modify column cc longtext character set binary;

alter table Mail_Message modify column bcc longtext character set binary;

alter table Mail_Message modify column body longtext character set binary;

alter table mail_message modify column sender longtext charecter set binary

1 comments:

Anonymous said...

The sixty daу cоmρlimentary trіal рrоvidе іѕ a fantаstіc sеlectiοn, in
the cаѕe of the flex ωaistbаnd.


Loοκ into my web page: www.Prnewswire.Com

Post a Comment

Share & Enjoy

Twitter Delicious Facebook Digg Stumbleupon Favorites More