SyncDB w/ MySQL - Has anyone seen an error like this?
When running syncdb, I am getting an unusual error. I'm using Django 1.5.1 and a relatively recent version of MariaDB on Arch. I am using some pre-existing tables which I've built Models around. The error is: *DatabaseError: (1005, "Can't create table '.#sql-1e51_2be' (errno: 150)")* Running syncdb a second time seems to finish out the process without error. Searching around hasn't really helped tremendously. At least, I'm not looking in the right place. At first glance, I thought that maybe this was some weird table name. After some further thinking, does this hash symbol represent something in MySQL land? Perhaps an index? Perhaps literally implemented as a hash table? haha I tried to debug it. I figured if I could get ahold of the SQL produced by syncdb and run it manually then the RDBMS might give me some more verbose output. Unfortunately, I have my project broken up into quite a few modules (apps) and have no idea how the syncdb command goes about chaining the various "sqlall " dumps I can produce. I know with indexes in particular, order is important. So, any clue as to what might be going on or how to dig in deeper? Thanks. -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscr...@googlegroups.com. To post to this group, send email to django-users@googlegroups.com. Visit this group at http://groups.google.com/group/django-users?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
Re: SyncDB w/ MySQL - Has anyone seen an error like this?
I should mention that I *did* convert all of my existing tables to InnoDB which hasn't helped at all. I don't have any weird configuration in my settings.py dealing with the database. As far as I can tell, all new tables created by syncdb are also InnoDB. -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscr...@googlegroups.com. To post to this group, send email to django-users@googlegroups.com. Visit this group at http://groups.google.com/group/django-users?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
Re: SyncDB w/ MySQL - Has anyone seen an error like this?
To try and find more information, I erased the Django-created tables and re-ran syncdb again. This time, I turned verbosity on to 3 and piped all of my stdout to a text file. I actually did this first. However, here's the contents of the first one which includes everything up to the point of failure. Creating tables ... Processing auth.Permission model Creating table auth_permission Processing auth.Group_permissions model Creating table auth_group_permissions Processing auth.Group model Creating table auth_group Processing contenttypes.ContentType model Creating table django_content_type Processing sessions.Session model Creating table django_session Processing sites.Site model Creating table django_site Processing admin.LogEntry model Creating table django_admin_log Note that I do have a custom UserModel, UserManager, and related Admin stuff based off of the docs. Could this be related to the problem? I removed a "db_index=True" option I had set on the User's email address. -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscr...@googlegroups.com. To post to this group, send email to django-users@googlegroups.com. Visit this group at http://groups.google.com/group/django-users?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
