summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorTim Graham <timograham@gmail.com>2012-10-12 06:37:35 -0400
committerTim Graham <timograham@gmail.com>2012-10-12 19:17:50 -0400
commite2dea54efe53fbeb66e684973ed6ad05f63969cc (patch)
treec55c9240843e5b9e0cf0b0f26ef69e1ad1a1e098
parent8139a7990a682f282096167bcea35004cacf5559 (diff)
[1.4.X] Fixed #18256 - Added a potential pitfall when upgrading to MySQL 5.5.5
Backport of c870cb48cd from master
-rw-r--r--docs/ref/databases.txt10
1 files changed, 10 insertions, 0 deletions
diff --git a/docs/ref/databases.txt b/docs/ref/databases.txt
index 1500f3f5c3..dba278bc4f 100644
--- a/docs/ref/databases.txt
+++ b/docs/ref/databases.txt
@@ -165,6 +165,16 @@ Since MySQL 5.5.5, the default storage engine is InnoDB_. This engine is fully
transactional and supports foreign key references. It's probably the best
choice at this point.
+If you upgrade an existing project to MySQL 5.5.5 and subsequently add some
+tables, ensure that your tables are using the same storage engine (i.e. MyISAM
+vs. InnoDB). Specifically, if tables that have a ``ForeignKey`` between them
+use different storage engines, you may see an error like the following when
+running ``syncdb``::
+
+ _mysql_exceptions.OperationalError: (
+ 1005, "Can't create table '\\db_name\\.#sql-4a8_ab' (errno: 150)"
+ )
+
.. versionchanged:: 1.4
In previous versions of Django, fixtures with forward references (i.e.