UnicodeDecodeError: 'utf-8' codec can't decode byte 0xed in position 0: invalid continuation byte

ERROR exception 135 Internal Server Error: /xadmin/operation/usercourse/
Traceback (most recent call last):
File "/home/python/.virtualenvs/dl_class/lib/python3.6/site-packages/django/core/handlers/exception.py", line 41, in inner
response = get_response(request)
File "/home/python/.virtualenvs/dl_class/lib/python3.6/site-packages/django/core/handlers/base.py", line 187, in _get_response
response = self.process_exception_by_middleware(e, request)
File "/home/python/.virtualenvs/dl_class/lib/python3.6/site-packages/django/core/handlers/base.py", line 185, in _get_response
response = wrapped_callback(request, *callback_args, **callback_kwargs)
File "/home/python/.virtualenvs/dl_class/lib/python3.6/site-packages/xadmin/sites.py", line 300, in wrapper
return self.admin_view(view, cacheable)(*args, **kwargs)
File "/home/python/.virtualenvs/dl_class/lib/python3.6/site-packages/django/views/decorators/cache.py", line 57, in _wrapped_view_func
response = view_func(request, *args, **kwargs)
File "/home/python/.virtualenvs/dl_class/lib/python3.6/site-packages/xadmin/sites.py", line 208, in inner
return view(request, *args, **kwargs)
File "/home/python/.virtualenvs/dl_class/lib/python3.6/site-packages/xadmin/views/base.py", line 279, in view
return handler(request, *args, **kwargs)
File "/home/python/.virtualenvs/dl_class/lib/python3.6/site-packages/django/utils/decorators.py", line 67, in _wrapper
return bound_func(*args, **kwargs)
File "/home/python/.virtualenvs/dl_class/lib/python3.6/site-packages/django/utils/decorators.py", line 149, in _wrapped_view
response = view_func(request, *args, **kwargs)
File "/home/python/.virtualenvs/dl_class/lib/python3.6/site-packages/django/utils/decorators.py", line 63, in bound_func
return func.__get__(self, type(self))(*args2, **kwargs2)
File "/home/python/.virtualenvs/dl_class/lib/python3.6/site-packages/xadmin/views/base.py", line 78, in method
return filter_chain(filters, len(filters) - 1, _inner_method, *args, **kwargs)
File "/home/python/.virtualenvs/dl_class/lib/python3.6/site-packages/xadmin/views/base.py", line 47, in filter_chain
return func()
File "/home/python/.virtualenvs/dl_class/lib/python3.6/site-packages/xadmin/views/base.py", line 72, in _inner_method
return func(self, *args, **kwargs)
File "/home/python/.virtualenvs/dl_class/lib/python3.6/site-packages/xadmin/views/list.py", line 401, in get
response = self.get_result_list()
File "/home/python/.virtualenvs/dl_class/lib/python3.6/site-packages/xadmin/views/base.py", line 78, in method
return filter_chain(filters, len(filters) - 1, _inner_method, *args, **kwargs)
File "/home/python/.virtualenvs/dl_class/lib/python3.6/site-packages/xadmin/views/base.py", line 47, in filter_chain
return func()
File "/home/python/.virtualenvs/dl_class/lib/python3.6/site-packages/xadmin/views/base.py", line 72, in _inner_method
return func(self, *args, **kwargs)
File "/home/python/.virtualenvs/dl_class/lib/python3.6/site-packages/xadmin/views/list.py", line 200, in get_result_list
return self.make_result_list()
File "/home/python/.virtualenvs/dl_class/lib/python3.6/site-packages/xadmin/views/list.py", line 196, in make_result_list
self.list_per_page * self.page_num + len(self.result_list))
File "/home/python/.virtualenvs/dl_class/lib/python3.6/site-packages/django/db/models/query.py", line 232, in __len__
self._fetch_all()
File "/home/python/.virtualenvs/dl_class/lib/python3.6/site-packages/django/db/models/query.py", line 1118, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File "/home/python/.virtualenvs/dl_class/lib/python3.6/site-packages/django/db/models/query.py", line 53, in __iter__
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch)
File "/home/python/.virtualenvs/dl_class/lib/python3.6/site-packages/django/db/models/sql/compiler.py", line 899, in execute_sql
raise original_exception
File "/home/python/.virtualenvs/dl_class/lib/python3.6/site-packages/django/db/models/sql/compiler.py", line 889, in execute_sql
cursor.execute(sql, params)
File "/home/python/.virtualenvs/dl_class/lib/python3.6/site-packages/django/db/backends/utils.py", line 79, in execute
return super(CursorDebugWrapper, self).execute(sql, params)
File "/home/python/.virtualenvs/dl_class/lib/python3.6/site-packages/django/db/backends/utils.py", line 64, in execute
return self.cursor.execute(sql, params)
File "/home/python/.virtualenvs/dl_class/lib/python3.6/site-packages/django/db/backends/mysql/base.py", line 101, in execute
return self.cursor.execute(query, args)
File "/home/python/.virtualenvs/dl_class/lib/python3.6/site-packages/pymysql/cursors.py", line 170, in execute
result = self._query(query)
File "/home/python/.virtualenvs/dl_class/lib/python3.6/site-packages/pymysql/cursors.py", line 328, in _query
conn.query(q)
File "/home/python/.virtualenvs/dl_class/lib/python3.6/site-packages/pymysql/connections.py", line 516, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/home/python/.virtualenvs/dl_class/lib/python3.6/site-packages/pymysql/connections.py", line 727, in _read_query_result
result.read()
File "/home/python/.virtualenvs/dl_class/lib/python3.6/site-packages/pymysql/connections.py", line 1073, in read
self._read_result_packet(first_packet)
File "/home/python/.virtualenvs/dl_class/lib/python3.6/site-packages/pymysql/connections.py", line 1143, in _read_result_packet
self._read_rowdata_packet()
File "/home/python/.virtualenvs/dl_class/lib/python3.6/site-packages/pymysql/connections.py", line 1181, in _read_rowdata_packet
rows.append(self._read_row_from_packet(packet))
File "/home/python/.virtualenvs/dl_class/lib/python3.6/site-packages/pymysql/connections.py", line 1197, in _read_row_from_packet
data = data.decode(encoding)
UnicodeDecodeError: 'utf-8' codec can't decode byte 0xed in position 0: invalid continuation byte
ERROR basehttp 124 "GET /xadmin/operation/usercourse/ HTTP/1.1" 500 231983

 

 

解决办法：

data = data.decode(encoding)
改为
data = data.decode(encoding,'ignore')

 

 

转载于:https://www.cnblogs.com/Xingtxx/p/10895557.html