Databases
StackOverflow2013
Postsdbo
POTroubleshooting "Error: Unable to serialize database:" when performing dumpdata
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POTroubleshooting "Error: Unable to serialize database:" when performing dumpdata
    primarykey
    data
    text
    <p>For some reason today I cannot dump my database using <code>python manage.py dumpdata</code> or from a link that can download the mysql file.</p> <p>I tried to use <code>python manage.py dumpdata --traceback</code> and here is the information I have.</p> <pre><code>Traceback (most recent call last): File "manage.py", line 11, in &lt;module&gt; execute_manager(settings) File "/usr/local/lib/python2.7/site-packages/django/core/management/__init__.py", line 438, in execute_manager utility.execute() File "/usr/local/lib/python2.7/site-packages/django/core/management/__init__.py", line 379, in execute self.fetch_command(subcommand).run_from_argv(self.argv) File "/usr/local/lib/python2.7/site-packages/django/core/management/base.py", line 191, in run_from_argv self.execute(*args, **options.__dict__) File "/usr/local/lib/python2.7/site-packages/django/core/management/base.py", line 220, in execute output = self.handle(*args, **options) File "/usr/local/lib/python2.7/site-packages/django/core/management/commands/dumpdata.py", line 114, in handle use_natural_keys=use_natural_keys) File "/usr/local/lib/python2.7/site-packages/django/core/serializers/__init__.py", line 91, in serialize s.serialize(queryset, **options) File "/usr/local/lib/python2.7/site-packages/django/core/serializers/base.py", line 48, in serialize self.handle_fk_field(obj, field) File "/usr/local/lib/python2.7/site-packages/django/core/serializers/python.py", line 48, in handle_fk_field related = getattr(obj, field.name) File "/usr/local/lib/python2.7/site-packages/django/db/models/fields/related.py", line 301, in __get__ raise self.field.rel.to.DoesNotExist django.contrib.auth.models.DoesNotExist </code></pre> <p>It says <code>django.contrib.auth.models.DoesNotExist</code>. I wonder if it has something to do with a Foreign key or something.</p> <p><strong>models.py</strong></p> <pre><code>class Client(models.Model): name = models.CharField(max_length = 40) telephone = models.CharField(max_length = 20) website = models.URLField(verify_exists = False) fax = models.CharField(max_length = 20) email = models.EmailField() is_active = models.BooleanField() user = models.ForeignKey(User) datetime = models.DateTimeField(default=datetime.now) note = models.TextField() def __unicode__(self): return self.name </code></pre> <p>From my models.py, the field user, datetime and note were added recently. Now if for a client, any of these fields do not have a value i.e. blank, I will get the error <code>Unable to serialize database</code>.</p> <p>When I have looked up user, dateime and note in mysql. The table for Client shows user_id, datetime and note to have Null values (which is what I want). Why does it not allow Null values? </p> <pre> +-----------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+--------------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | name | varchar(40) | NO | | NULL | | | telephone | varchar(20) | NO | | NULL | | | website | varchar(200) | NO | | NULL | | | fax | varchar(20) | NO | | NULL | | | email | varchar(75) | NO | | NULL | | | is_active | tinyint(1) | NO | | NULL | | | user_id | int(11) | YES | MUL | NULL | | | datetime | datetime | YES | | NULL | | | note | longtext | YES | | NULL | | +-----------+--------------+------+-----+---------+----------------+ </pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USShehzad009
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POTroubleshooting "Error: Unable to serialize database:" when performing dumpdata
      1. USShehzad009
      1. VTBountyStart
    2. VO
      singulars
      1. POTroubleshooting "Error: Unable to serialize database:" when performing dumpdata
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POTroubleshooting "Error: Unable to serialize database:" when performing dumpdata
      1. This table or related slice is empty.
      1. VTUpMod
    1. COForeign key issue sounds like a good bet. Any of your models have ForeignKey fields pointing to models in `django.contrib.auth.models`?
      singulars
      1. POTroubleshooting "Error: Unable to serialize database:" when performing dumpdata
      1. UStcarobruce
    2. COI second @tcarobruce. It sounds like a foreign key or constraint issue. I've had similar situations happen because of missing keys or constraints that didn't get properly modified by South or by hand.
      singulars
      1. POTroubleshooting "Error: Unable to serialize database:" when performing dumpdata
      1. USBrandon
    3. CO`self.handle_fk_field(obj, field)` is a bit of a giveaway
      singulars
      1. POTroubleshooting "Error: Unable to serialize database:" when performing dumpdata
      1. USJohn Mee
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload