{"id":335,"date":"2010-09-19T00:00:58","date_gmt":"2010-09-18T22:00:58","guid":{"rendered":"http:\/\/tronche.com\/blog\/less-technical\/uncategorized\/2010\/09\/illegal-mix-of-collations-in-otrs\/"},"modified":"2010-09-19T00:00:58","modified_gmt":"2010-09-18T22:00:58","slug":"illegal-mix-of-collations-in-otrs","status":"publish","type":"post","link":"https:\/\/tronche.com\/blog\/2010\/09\/illegal-mix-of-collations-in-otrs\/","title":{"rendered":"Illegal mix of collations in OTRS"},"content":{"rendered":"<p>The problem is described [http:\/\/faq.otrs.org\/otrs\/public.pl?Action=PublicFAQ&#038;ItemID=185 here], but not really the solution.<\/p>\n<p>I was having it on fetching some emails into otrs. Incidentally, the mail stayed into the mailbox (since the insertion into otrs database could not occur), and it was fetched again and again, filling the anti-spam proxy between the mailbox and otrs. This is what alerted me.<\/p>\n<p>Actually the solution is [http:\/\/forums.mysql.com\/read.php?26,6528,225042#msg-225042 here].<\/p>\n<p>I performed the alter table on the `article`table, and everything went into order.<\/p>\n<p><!--more--><br \/>\nThe problem is described [http:\/\/faq.otrs.org\/otrs\/public.pl?Action=PublicFAQ&#038;ItemID=185 here], but not really the solution.<\/p>\n<p>I was having it on fetching some emails into otrs. Incidentally, the mail stayed into the mailbox (since the insertion into otrs database could not occur), and it was fetched again and again, filling the anti-spam proxy between the mailbox and otrs. This is what alerted me.<\/p>\n<p>Actually the solution is [http:\/\/forums.mysql.com\/read.php?26,6528,225042#msg-225042 here].<\/p>\n<p>I performed the alter table on the `article`table, and everything went into order.<\/p>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>The problem is described [http:\/\/faq.otrs.org\/otrs\/public.pl?Action=PublicFAQ&#038;ItemID=185 here], but not really the solution. I was having it on fetching some emails into otrs. Incidentally, the mail stayed <a class=\"mh-excerpt-more\" href=\"https:\/\/tronche.com\/blog\/2010\/09\/illegal-mix-of-collations-in-otrs\/\" title=\"Illegal mix of collations in OTRS\">[&#8230;]<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-335","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/tronche.com\/blog\/wp-json\/wp\/v2\/posts\/335","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tronche.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tronche.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tronche.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tronche.com\/blog\/wp-json\/wp\/v2\/comments?post=335"}],"version-history":[{"count":0,"href":"https:\/\/tronche.com\/blog\/wp-json\/wp\/v2\/posts\/335\/revisions"}],"wp:attachment":[{"href":"https:\/\/tronche.com\/blog\/wp-json\/wp\/v2\/media?parent=335"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tronche.com\/blog\/wp-json\/wp\/v2\/categories?post=335"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tronche.com\/blog\/wp-json\/wp\/v2\/tags?post=335"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}