Re: [Django] #8055: Transaction error when doing loaddata

[Django]

#8055: Transaction error when doing loaddata
+---
  Reporter:  Erik Allik   | Owner:  ramiro
   
Status:  new| Milestone:  post-1.0  
   
 Component:  Serialization  |   Version:  SVN   
   
Resolution: |  Keywords:  loaddata 
fixtures print_exc 2.3 traceback
 Stage:  Accepted   | Has_patch:  1 
   
Needs_docs:  0  |   Needs_tests:  0 
   
Needs_better_patch:  0  |  
+---
Changes (by ramiro):

  * keywords:  => loaddata fixtures print_exc 2.3 traceback
  * owner:  nobody => ramiro
  * has_patch:  0 => 1
  * status:  reopened => new

Comment:

 tom_payne didn't report what version of Python he was using, but from what
 he describes he could be using Python 2.3. Uploaded a patch based in his
 findings.

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To post to this group, send email to django-updates@googlegroups.com
To unsubscribe from this group, send email to 
django-updates+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en
-~--~~~~--~~--~--~---

Re: [Django] #8055: Transaction error when doing loaddata

[Django]

#8055: Transaction error when doing loaddata
+---
  Reporter:  Erik Allik   | Owner:  nobody  
Status:  reopened   | Milestone:  post-1.0
 Component:  Serialization  |   Version:  SVN 
Resolution: |  Keywords:  
 Stage:  Accepted   | Has_patch:  0   
Needs_docs:  0  |   Needs_tests:  0   
Needs_better_patch:  0  |  
+---
Changes (by tom_payne):

 * cc: tfkpa...@yahoo.co.uk (added)

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To post to this group, send email to django-updates@googlegroups.com
To unsubscribe from this group, send email to 
django-updates+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en
-~--~~~~--~~--~--~---

Re: [Django] #8055: Transaction error when doing loaddata

[Django]

#8055: Transaction error when doing loaddata
+---
  Reporter:  Erik Allik   | Owner:  nobody  
Status:  reopened   | Milestone:  post-1.0
 Component:  Serialization  |   Version:  SVN 
Resolution: |  Keywords:  
 Stage:  Accepted   | Has_patch:  0   
Needs_docs:  0  |   Needs_tests:  0   
Needs_better_patch:  0  |  
+---
Comment (by tom_payne):

 Oh, sorry, no version number. This is the case for 1.0.2 final

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To post to this group, send email to django-updates@googlegroups.com
To unsubscribe from this group, send email to 
django-updates+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en
-~--~~~~--~~--~--~---

Re: [Django] #8055: Transaction error when doing loaddata

[Django]

#8055: Transaction error when doing loaddata
+---
  Reporter:  Erik Allik   | Owner:  nobody  
Status:  reopened   | Milestone:  post-1.0
 Component:  Serialization  |   Version:  SVN 
Resolution: |  Keywords:  
 Stage:  Accepted   | Has_patch:  0   
Needs_docs:  0  |   Needs_tests:  0   
Needs_better_patch:  0  |  
+---
Comment (by tom_payne):

 Well, I've had this problem again and have traced the error...

 I was trying to insert null values into my booleanfield (which I shouldn't
 be doing - that's what NullBooleanField is for - see #5563), but I think
 it's more a question of raising any error like this.

 Essentially, the bug is that you don't get a nice error message telling
 you what's wrong, rather you get an irrelevant Transaction error because
 the proper error message raises an exception.

 The problem comes when this error is raised in loaddata.py
 (django/core/management/commands/loaddata.py). The except clause (line 124
 onwards) tries to print an error message using traceback.format_exc, but
 this needs to be traceback.format_exception(sys.exc_type, sys.exc_value,
 sys.exc_traceback). The _exc shortcut, IIRC, is only available to
 print_exc.

 I hope that's clear.

 Tom

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To post to this group, send email to django-updates@googlegroups.com
To unsubscribe from this group, send email to 
django-updates+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en
-~--~~~~--~~--~--~---

Re: [Django] #8055: Transaction error when doing loaddata

[Django]

#8055: Transaction error when doing loaddata
+---
  Reporter:  Erik Allik <[EMAIL PROTECTED]>  | Owner:  nobody  
Status:  reopened   | Milestone:  post-1.0
 Component:  Serialization  |   Version:  SVN 
Resolution: |  Keywords:  
 Stage:  Accepted   | Has_patch:  0   
Needs_docs:  0  |   Needs_tests:  0   
Needs_better_patch:  0  |  
+---
Changes (by graham_king):

  * milestone:  1.0 => post-1.0

Comment:

 Changed the Milestone.

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To post to this group, send email to django-updates@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en
-~--~~~~--~~--~--~---

Re: [Django] #8055: Transaction error when doing loaddata

[Django]

#8055: Transaction error when doing loaddata
+---
  Reporter:  Erik Allik <[EMAIL PROTECTED]>  | Owner:  nobody
Status:  reopened   | Milestone:  1.0   
 Component:  Serialization  |   Version:  SVN   
Resolution: |  Keywords:
 Stage:  Accepted   | Has_patch:  0 
Needs_docs:  0  |   Needs_tests:  0 
Needs_better_patch:  0  |  
+---
Comment (by tom_payne):

 Just as an aside, I found this ticket because I was experiencing the same
 problem and it turned out that my DB was out of sync with my models. (I
 found this by running syncdb, even though I wasn't adding new tables, it
 still raised an error.)

 Fixing the DB fixed the problem.

 Hope this helps someone!

 Tom

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To post to this group, send email to django-updates@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en
-~--~~~~--~~--~--~---

Re: [Django] #8055: Transaction error when doing loaddata

[Django]

#8055: Transaction error when doing loaddata
+---
  Reporter:  Erik Allik <[EMAIL PROTECTED]>  | Owner:  nobody
Status:  reopened   | Milestone:  1.0   
 Component:  Serialization  |   Version:  SVN   
Resolution: |  Keywords:
 Stage:  Accepted   | Has_patch:  0 
Needs_docs:  0  |   Needs_tests:  0 
Needs_better_patch:  0  |  
+---
Comment (by russellm):

 What we need is enough detail so that we can reproduce the problem. This
 means a set of models and a JSON file that causes the problem when loaded.

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To post to this group, send email to django-updates@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en
-~--~~~~--~~--~--~---

Re: [Django] #8055: Transaction error when doing loaddata

[Django]

#8055: Transaction error when doing loaddata
+---
  Reporter:  Erik Allik <[EMAIL PROTECTED]>  | Owner:  nobody
Status:  reopened   | Milestone:  1.0   
 Component:  Serialization  |   Version:  SVN   
Resolution: |  Keywords:
 Stage:  Accepted   | Has_patch:  0 
Needs_docs:  0  |   Needs_tests:  0 
Needs_better_patch:  0  |  
+---
Changes (by Erik Allik <[EMAIL PROTECTED]>):

  * status:  closed => reopened
  * resolution:  worksforme =>

Comment:

 Should I upload the JSON fixture somewhere, too? Or what else is needed to
 reproduce the problem? In a #django log, I saw someone else having the
 same problem with MySQL 4.4 and referring to this ticket, so I'm not the
 only one having this issue.

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To post to this group, send email to django-updates@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en
-~--~~~~--~~--~--~---

Re: [Django] #8055: Transaction error when doing loaddata

[Django]

#8055: Transaction error when doing loaddata
+---
  Reporter:  Erik Allik <[EMAIL PROTECTED]>  | Owner:  nobody
Status:  closed | Milestone:  1.0   
 Component:  Serialization  |   Version:  SVN   
Resolution:  worksforme |  Keywords:
 Stage:  Accepted   | Has_patch:  0 
Needs_docs:  0  |   Needs_tests:  0 
Needs_better_patch:  0  |  
+---
Comment (by Erik Allik <[EMAIL PROTECTED]>):

 I'm getting the exact same traceback now. This time all tables are using
 UTF8 and InnoDB. Doing loaddata fixture.json

 Traceback is at:http://dpaste.com/hold/77207/
 MySQL version:5.0.51b
 Django revision: 8362
 Python 2.3.4

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To post to this group, send email to django-updates@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en
-~--~~~~--~~--~--~---