Title: Collation errors Last modified: August 20, 2016 --- # Collation errors * [hanih](https://wordpress.org/support/users/hanih/) * (@hanih) * [13 years, 3 months ago](https://wordpress.org/support/topic/collation-errors/) * 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/](http://wordpress.org/extend/plugins/social-networks-auto-poster-facebook-twitter-g/) Viewing 2 replies - 1 through 2 (of 2 total) * Thread Starter [hanih](https://wordpress.org/support/users/hanih/) * (@hanih) * [13 years, 3 months ago](https://wordpress.org/support/topic/collation-errors/#post-3475438) * 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:"Twitter - Saudi Shopper Twitter";}i:1;a:5:{s:4:"date";s:19:"2013-02-12 11:06:05";s:3:"msg"; s:142:"------=========#### NEW AUTO-POST REQUEST PostID:(5972) Scheduled +2 ####=========------";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:"Facebook - 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:"Twitter - Saudi Shopper Twitter";}i:6;a:5:{s:4:"date";s:19:"2013-02-12 11:15:11";s:3:"msg";s:142:"------ =========#### NEW AUTO-POST REQUEST PostID:(5977) Scheduled +4 ####=========------ ";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:"Facebook - 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:"Twitter - 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:"Twitter - Saudi Shopper Twitter";} i:12;a:5:{s:4:"date";s:19:"2013-02-12 12:40:08";s:3:"msg";s:142:"------=========#### NEW AUTO-POST REQUEST PostID:( 5981) Scheduled +9 ####=========------";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:"Facebook - 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:"Twitter - Saudi Shopper Twitter";}i:17;a:5:{s:4:"date";s:19:"2013-02-12 12:44:33";s:3:" msg";s:142:"------=========#### NEW AUTO-POST REQUEST PostID:(5985) Scheduled +6 ####=========------"; 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:"Facebook - 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:"Twitter - Saudi Shopper Twitter";}}";',' yes'),` * [marios32](https://wordpress.org/support/users/marios32/) * (@marios32) * [13 years, 3 months ago](https://wordpress.org/support/topic/collation-errors/#post-3475544) * 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 ``` Viewing 2 replies - 1 through 2 (of 2 total) The topic ‘Collation errors’ is closed to new replies. * ![](https://ps.w.org/social-networks-auto-poster-facebook-twitter-g/assets/icon- 256x256.png?rev=1106267) * [NextScripts: Social Networks Auto-Poster](https://wordpress.org/plugins/social-networks-auto-poster-facebook-twitter-g/) * [Frequently Asked Questions](https://wordpress.org/plugins/social-networks-auto-poster-facebook-twitter-g/#faq) * [Support Threads](https://wordpress.org/support/plugin/social-networks-auto-poster-facebook-twitter-g/) * [Active Topics](https://wordpress.org/support/plugin/social-networks-auto-poster-facebook-twitter-g/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/social-networks-auto-poster-facebook-twitter-g/unresolved/) * [Reviews](https://wordpress.org/support/plugin/social-networks-auto-poster-facebook-twitter-g/reviews/) * 2 replies * 2 participants * Last reply from: [marios32](https://wordpress.org/support/users/marios32/) * Last activity: [13 years, 3 months ago](https://wordpress.org/support/topic/collation-errors/#post-3475544) * Status: not resolved