[GH-ISSUE #677] Can't display non UTF8 email content when using postgres #631

New issue

Closed

opened 2026-02-27 11:12:45 +03:00 by kerem · 0 comments

kerem commented

2026-02-27 11:12:45 +03:00

Owner

Originally created by @tonioo on GitHub (Jan 25, 2015).
Original GitHub issue: https://github.com/modoboa/modoboa/issues/677

Originally assigned to: @tonioo on GitHub.

Traceback (most recent call last):

  File "/srv/modoboa/env/local/lib/python2.7/site-packages/Django-1.6.8-py2.7.egg/django/core/handlers/base.py", line 112, in get_response
    response = wrapped_callback(request, *callback_args, **callback_kwargs)

  File "/srv/modoboa/env/local/lib/python2.7/site-packages/modoboa/extensions/amavis/lib.py", line 36, in wrapped_f
    return f(request, *args, **kwargs)

  File "/srv/modoboa/env/local/lib/python2.7/site-packages/modoboa/extensions/amavis/views.py", line 135, in getmailcontent
    mail = SQLemail(mail_id, mformat="plain", links="0")

  File "/srv/modoboa/env/local/lib/python2.7/site-packages/modoboa/extensions/amavis/sql_email.py", line 23, in __init__
    {"name": label, "value": self.get_header(self.msg, f)}

  File "/srv/modoboa/env/local/lib/python2.7/site-packages/modoboa/extensions/amavis/sql_email.py", line 44, in msg
    mail_text = "".join([qm.mail_text for qm in qmails])

  File "/srv/modoboa/env/local/lib/python2.7/site-packages/Django-1.6.8-py2.7.egg/django/db/models/query.py", line 96, in __iter__
    self._fetch_all()

  File "/srv/modoboa/env/local/lib/python2.7/site-packages/Django-1.6.8-py2.7.egg/django/db/models/query.py", line 857, in _fetch_all
    self._result_cache = list(self.iterator())

  File "/srv/modoboa/env/local/lib/python2.7/site-packages/Django-1.6.8-py2.7.egg/django/db/models/query.py", line 220, in iterator
    for row in compiler.results_iter():

  File "/srv/modoboa/env/local/lib/python2.7/site-packages/Django-1.6.8-py2.7.egg/django/db/models/sql/compiler.py", line 713, in results_iter
    for rows in self.execute_sql(MULTI):

  File "/srv/modoboa/env/local/lib/python2.7/site-packages/Django-1.6.8-py2.7.egg/django/db/models/sql/compiler.py", line 786, in execute_sql
    cursor.execute(sql, params)

  File "/srv/modoboa/env/local/lib/python2.7/site-packages/Django-1.6.8-py2.7.egg/django/db/backends/util.py", line 53, in execute
    return self.cursor.execute(sql, params)

  File "/srv/modoboa/env/local/lib/python2.7/site-packages/Django-1.6.8-py2.7.egg/django/db/utils.py", line 99, in __exit__
    six.reraise(dj_exc_type, dj_exc_value, traceback)

  File "/srv/modoboa/env/local/lib/python2.7/site-packages/Django-1.6.8-py2.7.egg/django/db/backends/util.py", line 53, in execute
    return self.cursor.execute(sql, params)

DataError: invalid byte sequence for encoding "UTF8": 0xb3

Originally created by @tonioo on GitHub (Jan 25, 2015). Original GitHub issue: https://github.com/modoboa/modoboa/issues/677 Originally assigned to: @tonioo on GitHub. ``` python Traceback (most recent call last): File "/srv/modoboa/env/local/lib/python2.7/site-packages/Django-1.6.8-py2.7.egg/django/core/handlers/base.py", line 112, in get_response response = wrapped_callback(request, *callback_args, **callback_kwargs) File "/srv/modoboa/env/local/lib/python2.7/site-packages/modoboa/extensions/amavis/lib.py", line 36, in wrapped_f return f(request, *args, **kwargs) File "/srv/modoboa/env/local/lib/python2.7/site-packages/modoboa/extensions/amavis/views.py", line 135, in getmailcontent mail = SQLemail(mail_id, mformat="plain", links="0") File "/srv/modoboa/env/local/lib/python2.7/site-packages/modoboa/extensions/amavis/sql_email.py", line 23, in __init__ {"name": label, "value": self.get_header(self.msg, f)} File "/srv/modoboa/env/local/lib/python2.7/site-packages/modoboa/extensions/amavis/sql_email.py", line 44, in msg mail_text = "".join([qm.mail_text for qm in qmails]) File "/srv/modoboa/env/local/lib/python2.7/site-packages/Django-1.6.8-py2.7.egg/django/db/models/query.py", line 96, in __iter__ self._fetch_all() File "/srv/modoboa/env/local/lib/python2.7/site-packages/Django-1.6.8-py2.7.egg/django/db/models/query.py", line 857, in _fetch_all self._result_cache = list(self.iterator()) File "/srv/modoboa/env/local/lib/python2.7/site-packages/Django-1.6.8-py2.7.egg/django/db/models/query.py", line 220, in iterator for row in compiler.results_iter(): File "/srv/modoboa/env/local/lib/python2.7/site-packages/Django-1.6.8-py2.7.egg/django/db/models/sql/compiler.py", line 713, in results_iter for rows in self.execute_sql(MULTI): File "/srv/modoboa/env/local/lib/python2.7/site-packages/Django-1.6.8-py2.7.egg/django/db/models/sql/compiler.py", line 786, in execute_sql cursor.execute(sql, params) File "/srv/modoboa/env/local/lib/python2.7/site-packages/Django-1.6.8-py2.7.egg/django/db/backends/util.py", line 53, in execute return self.cursor.execute(sql, params) File "/srv/modoboa/env/local/lib/python2.7/site-packages/Django-1.6.8-py2.7.egg/django/db/utils.py", line 99, in __exit__ six.reraise(dj_exc_type, dj_exc_value, traceback) File "/srv/modoboa/env/local/lib/python2.7/site-packages/Django-1.6.8-py2.7.egg/django/db/backends/util.py", line 53, in execute return self.cursor.execute(sql, params) DataError: invalid byte sequence for encoding "UTF8": 0xb3 ```