mysql+exceptions.interfaceerror+0_【Error】InterfaceError(0,'')

也不知道什么时候接触到的这个错误&＃xff0c;暂且记录下。

错误描述&＃xff1a;InterfaceError (0, &＃39;&＃39;)

Traceback:

File "/usr/local/lib/python2.7/site-packages/django/core/handlers/base.py" in get_response

100. response &＃61; callback(request, *callback_args, **callback_kwargs)

File "/home/fran/cron/views/set_caches.py" in set_caches

24. cursor.execute(query, [category[&＃39;id&＃39;]])

File "/usr/local/lib/python2.7/site-packages/django/db/backends/util.py" in execute

15. return self.cursor.execute(sql, params)

File "/usr/local/lib/python2.7/site-packages/django/db/backends/mysql/base.py" in execute

86. return self.cursor.execute(query, args)

File "build/bdist.linux-i686/egg/MySQLdb/cursors.py" in execute

155. charset &＃61; db.character_set_name()

Exception Type: InterfaceError at /blablabla/

Exception Value: (0, &＃39;&＃39;)

解决方法&＃xff1a;

该错误是设置全局游标对象引起的&＃xff0c;请尝试在每个方法调用时创建和关闭游标对象。

cursor &＃61; connection.cursor()

cursor.execute(query)

cursor.close()

参考###