[SOLVED] Ticket reopens itself everyday

[ggirao]

I have a Ticket made from a webmail that has wrong characters that opens itself everyday at 00:10 AM

How can I get rid of this?
On logs I have:
Could not re-process email /opt/otrs/var/spool/problem-emailxxxxxx
Can't process mail, see log sub system! at /opt/otrs/bin/otrs.PostMaster.pl line 112.
Fri May 8 00:10:02 2015 error OTRS-otrs.PostMaster.pl-38 Can't get ArticleID from INSERT!
Fri May 8 00:10:02 2015 error OTRS-otrs.PostMaster.pl-38 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=', SQL: 'SELECT id FROM article WHERE ticket_id = ? AND a_message_id = ? AND a_from = ? AND a_subject = ? AND incoming_time = ? ORDER BY id DESC LIMIT 1'
Fri May 8 00:10:02 2015 error OTRS-otrs.ReprocessMails.pl-38 Could not re-process email /opt/otrs/var/spool/problem-email-.
Fri May 8 00:10:02 2015 error OTRS-otrs.PostMaster.pl-38 Can't process mail, see log sub system! at /opt/otrs/bin/otrs.PostMaster.pl line 112.
Fri May 8 00:10:02 2015 error OTRS-otrs.PostMaster.pl-38 Can't get ArticleID from INSERT!
Fri May 8 00:10:02 2015 error OTRS-otrs.PostMaster.pl-38 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=', SQL: 'SELECT id FROM article WHERE ticket_id = ? AND a_message_id = ? AND a_from = ? AND a_subject = ? AND incoming_time = ? ORDER BY id DESC LIMIT 1'

[crythias]

delete the file?

[ggirao]

I think about that, but where?

The email isn't there anymore...

in /var/spool/email-problem....?

[ggirao]

I idid it !

Duh LOL

[totocahu]

Hi ggirao,
Congratulation, but how have you found the file ?
I have the same problem