AttributeError: 'str' object has no attribute 'decode'

Question

“C:\Program Files\JetBrains\PyCharm 2018.2.4\bin\runnerw.exe” D:\Envs\MxShop\Scripts\python.exe “C:\Program Files\JetBrains\PyCharm 2018.2.4\helpers\pydev\pydevd.py” --multiproc --qt-support=auto --client 127.0.0.1 --port 50352 --file C:/Users/huang/PycharmProjects/MxShop/manage.py runserver 8000
pydev debugger: process 13552 is connecting

Connected to pydev debugger (build 182.4505.26)
pydev debugger: process 4744 is connecting

Watching for file changes with StatReloader
Performing system checks…

System check identified no issues (0 silenced).
Exception in thread Thread-6:
Traceback (most recent call last):
File “C:\Users\huang\AppData\Local\Programs\Python\Python36\lib\threading.py”, line 916, in _bootstrap_inner
self.run()
File “C:\Users\huang\AppData\Local\Programs\Python\Python36\lib\threading.py”, line 864, in run
self._target(*self._args, **self._kwargs)
File “D:\Envs\MxShop\lib\site-packages\django\utils\autoreload.py”, line 54, in wrapper
fn(*args, **kwargs)
File “D:\Envs\MxShop\lib\site-packages\django\core\management\commands\runserver.py”, line 120, in inner_run
self.check_migrations()
File “D:\Envs\MxShop\lib\site-packages\django\core\management\base.py”, line 453, in check_migrations
executor = MigrationExecutor(connections[DEFAULT_DB_ALIAS])
File “D:\Envs\MxShop\lib\site-packages\django\db\migrations\executor.py”, line 18, in init
self.loader = MigrationLoader(self.connection)
File “D:\Envs\MxShop\lib\site-packages\django\db\migrations\loader.py”, line 49, in init
self.build_graph()
File “D:\Envs\MxShop\lib\site-packages\django\db\migrations\loader.py”, line 212, in build_graph
self.applied_migrations = recorder.applied_migrations()
File “D:\Envs\MxShop\lib\site-packages\django\db\migrations\recorder.py”, line 73, in applied_migrations
if self.has_table():
File “D:\Envs\MxShop\lib\site-packages\django\db\migrations\recorder.py”, line 56, in has_table
return self.Migration._meta.db_table in self.connection.introspection.table_names(self.connection.cursor())
File “D:\Envs\MxShop\lib\site-packages\django\db\backends\base\base.py”, line 256, in cursor
return self._cursor()
File “D:\Envs\MxShop\lib\site-packages\django\db\backends\base\base.py”, line 233, in _cursor
self.ensure_connection()
File “D:\Envs\MxShop\lib\site-packages\django\db\backends\base\base.py”, line 217, in ensure_connection
self.connect()
File “D:\Envs\MxShop\lib\site-packages\django\db\backends\base\base.py”, line 197, in connect
self.init_connection_state()
File “D:\Envs\MxShop\lib\site-packages\django\db\backends\mysql\base.py”, line 231, in init_connection_state
if self.features.is_sql_auto_is_null_enabled:
File “D:\Envs\MxShop\lib\site-packages\django\utils\functional.py”, line 80, in get
res = instance.dict[self.name] = self.func(instance)
File “D:\Envs\MxShop\lib\site-packages\django\db\backends\mysql\features.py”, line 82, in is_sql_auto_is_null_enabled
cursor.execute(‘SELECT @@SQL_AUTO_IS_NULL’)
File “D:\Envs\MxShop\lib\site-packages\django\db\backends\utils.py”, line 103, in execute
sql = self.db.ops.last_executed_query(self.cursor, sql, params)
File “D:\Envs\MxShop\lib\site-packages\django\db\backends\mysql\operations.py”, line 146, in last_executed_query
query = query.decode(errors=‘replace’)
AttributeError: ‘str’ object has no attribute ‘decode’

为什么报这个错误？

Answer 1

Ethreal 2019-04-19 13:36:57

你做了什么操作出现了这种错误？ 你是在什么地方调用了decode('utf8')  提供你的python版本是不是3.6

• 提问者 慕妹4270370 #1

  解决好了，谢谢

• 慕妹4516714 回复 提问者 慕妹4270370 #2

  你好，请问你怎么解决的？

• 慕神1482430 回复 慕妹4516714 #3

  百度到的解决办法：
  顺着异常文件点进去找到：
  query = query.decode(errors=‘replace’)
  将decode改为encode
  或者注释掉判断即可。