从转储数据安装夹具我遇到了奇怪的错误 . 我正在使用psycopg2和django1.1.1
silver:probsbox oleg$ python manage.py loaddata /Users/oleg/probs.json
Installing json fixture '/Users/oleg/probs' from '/Users/oleg/probs'.
Problem installing fixture '/Users/oleg/probs.json': Traceback (most recent call last):
File "/opt/local/lib/python2.5/site-packages/django/core/management/commands/loaddata.py", line 153, in handle
obj.save()
File "/opt/local/lib/python2.5/site-packages/django/core/serializers/base.py", line 163, in save
models.Model.save_base(self.object, raw=True)
File "/opt/local/lib/python2.5/site-packages/django/db/models/base.py", line 495, in save_base
result = manager._insert(values, return_id=update_pk)
File "/opt/local/lib/python2.5/site-packages/django/db/models/manager.py", line 177, in _insert
return insert_query(self.model, values, **kwargs)
File "/opt/local/lib/python2.5/site-packages/django/db/models/query.py", line 1087, in insert_query
return query.execute_sql(return_id)
File "/opt/local/lib/python2.5/site-packages/django/db/models/sql/subqueries.py", line 320, in execute_sql
cursor = super(InsertQuery, self).execute_sql(None)
File "/opt/local/lib/python2.5/site-packages/django/db/models/sql/query.py", line 2369, in execute_sql
cursor.execute(sql, params)
File "/opt/local/lib/python2.5/site-packages/django/db/backends/util.py", line 19, in execute
return self.cursor.execute(sql, params)
ProgrammingError: can't adapt
首先,我在互联网上检查了类似的问题 . 这个似乎非常相关:http://code.djangoproject.com/ticket/5996,因为我的数据有很多非ASCII符号
但实际上我已经检查了我的django安装,它没关系
你能说出错的吗?
====
根据第一个答案建议添加打印声明后继续调查 . 日志看起来像这样:
silver:probsbox oleg$ python manage.py loaddata /Users/oleg/probs.json
Installing json fixture '/Users/oleg/probs' from '/Users/oleg/probs'.
<DeserializedObject: Novice>
<DeserializedObject: Junior>
<DeserializedObject: Chess enthusiast>
<DeserializedObject: Experienced player >
<DeserializedObject: Smart player>
Problem installing fixture '/Users/oleg/probs.json': Traceback (most recent call last):
File "/opt/local/lib/python2.5/site-packages/django/core/management/commands/loaddata.py", line 153, in handle
print obj
File "/opt/local/lib/python2.5/site-packages/django/core/serializers/base.py", line 155, in __repr__
return "<DeserializedObject: %s>" % smart_str(self.object)
File "/opt/local/lib/python2.5/site-packages/django/utils/encoding.py", line 107, in smart_str
return str(s)
File "/opt/local/lib/python2.5/site-packages/django/db/models/base.py", line 335, in __str__
return force_unicode(self).encode('utf-8')
File "/opt/local/lib/python2.5/site-packages/django/utils/encoding.py", line 71, in force_unicode
s = unicode(s)
File "/Users/oleg/Sites/probsbox/registration/models.py", line 58, in __unicode__
return u"%s's profile" %(self.user.username)
File "/opt/local/lib/python2.5/site-packages/django/db/models/fields/related.py", line 257, in __get__
rel_obj = QuerySet(self.field.rel.to).get(**params)
File "/opt/local/lib/python2.5/site-packages/django/db/models/query.py", line 305, in get
% self.model._meta.object_name)
DoesNotExist: User matching query does not exist.
silver:probsbox oleg$
最后一条评论出错
<DeserializedObject: qwert2000's profile>
问题安装夹具'/Users/oleg/probs.json':Traceback(最近一次调用最后一次):文件“/opt/local/lib/python2.5/site-packages/django/core/management/commands/loaddata.py “,第154行,句柄obj.save()文件”/opt/local/lib/python2.5/site-packages/django/core/serializers/base.py“,第163行,保存模型.Model.save_base (self.object,raw = True)文件“/opt/local/lib/python2.5/site-packages/django/db/models/base.py”,第495行,在save_base结果= manager._insert(values, return_id = update_pk)文件“/opt/local/lib/python2.5/site-packages/django/db/models/manager.py”,第177行,在_insert中返回insert_query(self.model,values,** kwargs)文件“/opt/local/lib/python2.5/site-packages/django/db/models/query.py”,第1087行,在insert_query中返回query.execute_sql(return_id)文件“/ opt / local / lib / python2 .5 / site-packages / django / db / models / sql / subqueries.py“,第320行,在execute_sql cursor = super(InsertQuery,self).execute_sql(无)文件”/opt/local/lib/python2.5 /站点包/ Django的/ DB /月dels / sql / query.py“,第2369行,在execute_sql cursor.execute(sql,params)文件”/opt/local/lib/python2.5/site-packages/django/db/backends/util.py“,第19行,在执行中返回self.cursor.execute(sql,params)ProgrammingError:无法适应
2 回答
psycopg2收到的数据类型没有't know how to translate into a value for a SQL statement. For example, if you accidentally pass a list, say, for a value that is supposed to be an integer, psycopg2 will raise this can't适应错误时会引发
can't adapt
错误 .与psycopg2的源代码分发一起提供的
faq.txt
文档以这种方式解释:在找到有问题的值时,你可能最好的第一步是在完全冗长的模式下运行loaddata:python manage.py loaddata --verbosity = 2 /Users/oleg/probs.json
好吧,我希望loaddata详细程度能够正常工作,我绝不会找到一种优雅的调试适配错误的方法,因为django 's loaddata. In the past, I'已经在django 's loaddata function so that I can see the values being deserialized when the error occurs. I' ve编辑
django/core/management/loaddata.py
中插入了打印语句 . 在handle()
函数中查看obj.save()
. 我希望这个忏悔鼓励某人分享更好的解决方案:-)好的,我结束了从我的数据库中复制转储,并在没有python的情况下在本地恢复...