WordPress.org

Ready to get started?Download WordPress

Forums

NextScripts: Social Networks Auto-Poster
Collation errors (3 posts)

  1. hanih
    Member
    Posted 1 year ago #

    Hi,

    Test is working fine but
    I am getting the following collation errors when I try to send real messages

    Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation ''=''"

    All tables have utf8 charset and swedish seems to be the default server collation.
    Unfortunately I have no control over the server default collation.
    Please help me solve this problem

    Thanks :)

    http://wordpress.org/extend/plugins/social-networks-auto-poster-facebook-twitter-g/

  2. hanih
    Member
    Posted 1 year ago #

    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'),

  3. marios32
    Member
    Posted 1 year ago #

    I am getting the same error, but all my tables and the database itself is utf8-general-ci.

    With me, i am able to post to facebook with the title and surl variables, but instead of the surl part, i am getting the error
    Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='

    I have tried everything and nowhere onsite or server there is the latin1_swedish_ci collation.
    Here is part of the log, if it is any help.
    The two languages i type in is greek and english.

    [2013-02-19 00:58:14] - [Start =- ] - ------=========#### NEW AUTO-POST REQUEST PostID:(515) Scheduled +2 ####=========------
    [2013-02-19 00:57:23] - [Twitter - accountnamehere] - -=ERROR=- {"errors":[{"code":186,"message":"Status is over 140 characters"}]} MSG:title title - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' | PostID: 468 - title title
    [2013-02-19 00:56:55] - [Facebook - accountnamehere] - OK - Message PostedArray ( [id] => 246735792129312 [post_id] => 246176818851876_246735822129309 ) | PostID: 468 - title title
    [2013-02-19 00:55:09] - [Facebook - accountnamehere] - OK - Message PostedArray ( [id] => 246735268796031 [post_id] => 246176818851876_246735282129363 ) | PostID: 468 - title title
    [2013-02-19 00:35:15] - [Twitter - accountnamehere] - -=ERROR=- {"errors":[{"code":186,"message":"Status is over 140 characters"}]} MSG:title title - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' | PostID: 468 - title title
    [2013-02-19 00:34:04] - [Facebook - accountnamehere] - OK - Message PostedArray ( [id] => 246729315463293 [post_id] => 246176818851876_246729325463292 ) | PostID: 468 - title title
    [2013-02-19 00:32:48] - [Twitter - accountnamehere] - -=ERROR=- {"errors":[{"code":186,"message":"Status is over 140 characters"}]} MSG:title title - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' | PostID: 468 - title title

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic