hanih

actually the main post is displayed on Facebook along with the error message. On twitter it cannot be posted because the title of the post ( which also contains the error message ) is larger than 140 char.

so maybe you can help me by specifying where is the correct place in the code to put a trim function to remove this error message because it does not change.

Here is the error log

(33654, 'NS_SNAutoPosterLog', 's:7482:"a:22:{i:0;a:5:{s:4:"date";s:19:"2013-02-12 11:01:09";s:3:"msg";s:25:"OK - TEST Message Posted ";s:7:"extInfo";s:0:"";s:4:"type";s:1:"M";s:2:"nt";s:66:"<span style="color:#00FFFF">Twitter</span> - Saudi Shopper Twitter";}i:1;a:5:{s:4:"date";s:19:"2013-02-12 11:06:05";s:3:"msg";s:142:"<span style="color:#008000; font-weight:bold;">------=========#### NEW AUTO-POST REQUEST PostID:(5972) Scheduled +2 ####=========------</span>";s:7:"extInfo";s:0:"";s:4:"type";s:1:"M";s:2:"nt";s:9:"Start =- ";}i:2;a:5:{s:4:"date";s:19:"2013-02-12 11:06:05";s:3:"msg";s:17:" - Post ID:(5972)";s:7:"extInfo";s:0:"";s:4:"type";s:1:"M";s:2:"nt";s:50:"Scheduled - Facebook (Saudi Shopper Facebook) post";}i:3;a:5:{s:4:"date";s:19:"2013-02-12 11:06:05";s:3:"msg";s:17:" - Post ID:(5972)";s:7:"extInfo";s:0:"";s:4:"type";s:1:"M";s:2:"nt";s:48:"Scheduled - Twitter (Saudi Shopper Twitter) post";}i:4;a:5:{s:4:"date";s:19:"2013-02-12 11:06:23";s:3:"msg";s:73:"OK - Message PostedArray\n(\n [id] => 242056362594956_265811910219401\n)\n";s:7:"extInfo";s:149:" | PostID: 5972 - ?? ?? ???? ?????? ????????? ??????? ?????? ??????? ???? 84 ??? ?????????";s:4:"type";s:1:"M";s:2:"nt";s:68:"<span style="color:#0000FF">Facebook</span> - Saudi Shopper Facebook";}i:5;a:5:{s:4:"date";s:19:"2013-02-12 11:06:24";s:3:"msg";s:305:"-=ERROR=- {"errors":[{"code":186,"message":"Status is over 140 characters"}]} MSG:?? ?? ???? ?????? ????????? ??????? ?????? ??????? ???? 84 ??? ... - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation ''=''";s:7:"extInfo";s:149:" | PostID: 5972 - ?? ?? ???? ?????? ????????? ??????? ?????? ??????? ???? 84 ??? ?????????";s:4:"type";s:1:"E";s:2:"nt";s:66:"<span style="color:#00FFFF">Twitter</span> - Saudi Shopper Twitter";}i:6;a:5:{s:4:"date";s:19:"2013-02-12 11:15:11";s:3:"msg";s:142:"<span style="color:#008000; font-weight:bold;">------=========#### NEW AUTO-POST REQUEST PostID:(5977) Scheduled +4 ####=========------</span>";s:7:"extInfo";s:0:"";s:4:"type";s:1:"M";s:2:"nt";s:9:"Start =- ";}i:7;a:5:{s:4:"date";s:19:"2013-02-12 11:15:12";s:3:"msg";s:17:" - Post ID:(5977)";s:7:"extInfo";s:0:"";s:4:"type";s:1:"M";s:2:"nt";s:50:"Scheduled - Facebook (Saudi Shopper Facebook) post";}i:8;a:5:{s:4:"date";s:19:"2013-02-12 11:15:12";s:3:"msg";s:17:" - Post ID:(5977)";s:7:"extInfo";s:0:"";s:4:"type";s:1:"M";s:2:"nt";s:48:"Scheduled - Twitter (Saudi Shopper Twitter) post";}i:9;a:5:{s:4:"date";s:19:"2013-02-12 11:16:24";s:3:"msg";s:73:"OK - Message PostedArray\n(\n [id] => 242056362594956_265827200217872\n)\n";s:7:"extInfo";s:181:" | PostID: 5977 - ??? ?? ???? ?????? ????? ???? ???? ??????? ???????? ??? ????????? ??????? ????? ????????";s:4:"type";s:1:"M";s:2:"nt";s:68:"<span style="color:#0000FF">Facebook</span> - Saudi Shopper Facebook";}i:10;a:5:{s:4:"date";s:19:"2013-02-12 11:16:57";s:3:"msg";s:294:"-=ERROR=- {"errors":[{"code":186,"message":"Status is over 140 characters"}]} MSG:??? ?? ???? ?????? ????? ???? ???? ??????? ???????? ??? ... - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation ''=''";s:7:"extInfo";s:181:" | PostID: 5977 - ??? ?? ???? ?????? ????? ???? ???? ??????? ???????? ??? ????????? ??????? ????? ????????";s:4:"type";s:1:"E";s:2:"nt";s:66:"<span style="color:#00FFFF">Twitter</span> - Saudi Shopper Twitter";}i:11;a:5:{s:4:"date";s:19:"2013-02-12 11:24:10";s:3:"msg";s:25:"OK - TEST Message Posted ";s:7:"extInfo";s:0:"";s:4:"type";s:1:"M";s:2:"nt";s:66:"<span style="color:#00FFFF">Twitter</span> - Saudi Shopper Twitter";}i:12;a:5:{s:4:"date";s:19:"2013-02-12 12:40:08";s:3:"msg";s:142:"<span style="color:#008000; font-weight:bold;">------=========#### NEW AUTO-POST REQUEST PostID:(5981) Scheduled +9 ####=========------</span>";s:7:"extInfo";s:0:"";s:4:"type";s:1:"M";s:2:"nt";s:9:"Start =- ";}i:13;a:5:{s:4:"date";s:19:"2013-02-12 12:40:08";s:3:"msg";s:17:" - Post ID:(5981)";s:7:"extInfo";s:0:"";s:4:"type";s:1:"M";s:2:"nt";s:50:"Scheduled - Facebook (Saudi Shopper Facebook) post";}i:14;a:5:{s:4:"date";s:19:"2013-02-12 12:40:08";s:3:"msg";s:17:" - Post ID:(5981)";s:7:"extInfo";s:0:"";s:4:"type";s:1:"M";s:2:"nt";s:48:"Scheduled - Twitter (Saudi Shopper Twitter) post";}i:15;a:5:{s:4:"date";s:19:"2013-02-12 12:40:34";s:3:"msg";s:73:"OK - Message PostedArray\n(\n [id] => 242056362594956_265856746881584\n)\n";s:7:"extInfo";s:196:" | PostID: 5981 - ???????? Intigral ???? ??? ?????? ??????? ??????? ???????? ????????? ????????? ??????? ?? ????????";s:4:"type";s:1:"M";s:2:"nt";s:68:"<span style="color:#0000FF">Facebook</span> - Saudi Shopper Facebook";}i:16;a:5:{s:4:"date";s:19:"2013-02-12 12:40:34";s:3:"msg";s:296:"-=ERROR=- {"errors":[{"code":186,"message":"Status is over 140 characters"}]} MSG:???????? Intigral ???? ??? ?????? ??????? ??????? ???????? ... - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation ''=''";s:7:"extInfo";s:196:" | PostID: 5981 - ???????? Intigral ???? ??? ?????? ??????? ??????? ???????? ????????? ????????? ??????? ?? ????????";s:4:"type";s:1:"E";s:2:"nt";s:66:"<span style="color:#00FFFF">Twitter</span> - Saudi Shopper Twitter";}i:17;a:5:{s:4:"date";s:19:"2013-02-12 12:44:33";s:3:"msg";s:142:"<span style="color:#008000; font-weight:bold;">------=========#### NEW AUTO-POST REQUEST PostID:(5985) Scheduled +6 ####=========------</span>";s:7:"extInfo";s:0:"";s:4:"type";s:1:"M";s:2:"nt";s:9:"Start =- ";}i:18;a:5:{s:4:"date";s:19:"2013-02-12 12:44:33";s:3:"msg";s:17:" - Post ID:(5985)";s:7:"extInfo";s:0:"";s:4:"type";s:1:"M";s:2:"nt";s:50:"Scheduled - Facebook (Saudi Shopper Facebook) post";}i:19;a:5:{s:4:"date";s:19:"2013-02-12 12:44:33";s:3:"msg";s:17:" - Post ID:(5985)";s:7:"extInfo";s:0:"";s:4:"type";s:1:"M";s:2:"nt";s:48:"Scheduled - Twitter (Saudi Shopper Twitter) post";}i:20;a:5:{s:4:"date";s:19:"2013-02-12 12:44:58";s:3:"msg";s:73:"OK - Message PostedArray\n(\n [id] => 242056362594956_265857760214816\n)\n";s:7:"extInfo";s:176:" | PostID: 5985 - ?????????? ???? ???? Galaxy1 ????? ????? ????? ???? ??????? ???????? ????? ?????? ?????? ";s:4:"type";s:1:"M";s:2:"nt";s:68:"<span style="color:#0000FF">Facebook</span> - Saudi Shopper Facebook";}i:21;a:5:{s:4:"date";s:19:"2013-02-12 12:44:58";s:3:"msg";s:296:"-=ERROR=- {"errors":[{"code":186,"message":"Status is over 140 characters"}]} MSG:?????????? ???? ???? Galaxy1 ????? ????? ????? ???? ??????? ... - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation ''=''";s:7:"extInfo";s:176:" | PostID: 5985 - ?????????? ???? ???? Galaxy1 ????? ????? ????? ???? ??????? ???????? ????? ?????? ?????? ";s:4:"type";s:1:"E";s:2:"nt";s:66:"<span style="color:#00FFFF">Twitter</span> - Saudi Shopper Twitter";}}";', 'yes'),