Another Migration Error

[Howard Mei]

The merengue pip/easy_install installation doesn't work on windows.
So I test it on webfaction hosting environment. During installation,
a setuptools version upgrade interrupted the procedure, which I fixed manually.
Other things are smooth, until the migrate command:
   ......
Running migrations for perms:
 - Migrating forwards to 0017_add_cache_perms.
 > base:0001_initial
 > perms:0001_initial
 > workflow:0001_initial
 > perms:0002_auto__chg_field_objectpermission_content
 ! Error found during real run of migration! Aborting.

 ! Since you have a database that does not support running
 ! schema-altering statements in transactions, we have had
 ! to leave it in an interim state between migrations.

! You *might* be able to recover with:
 ! The South developers regret this has happened, and would
 ! like to gently persuade you to consider a slightly
 ! easier-to-deal-with DBMS.
 ! NOTE: The error which caused the migration to fail is further up.
        ... ...
_mysql_exceptions.OperationalError: (1005, "Can't create table 'mysite_mysql.#sql-4b12_6b3f5e' (errno: 121)")


I tried to drop all tables to syndb & migrate again, but the workflow_state & workflow_workflow table were unable to be removed due to foreign-key lock.
I had to drop the whole database and recreate it to try again. The same issue still occur.

My opinion: Merengue is far more powerful than any other Django CMS, which also means it's too heavy with all features turned on.

Could you please provide a minimal viable version in default installation with all optional features turned off/removed, instead of the full stack with so many dependencies and migrations?
I think that might be very helpful for us to get started. People will be interested in easy-to-use software and apt to give more feed backs to help the such kind of system evolve rapidly.

[Howard Mei]

BTW: It's the problem related to the latest version, meregue 0.8.2  @webfaction, django1.3.1, python 2.7, mysql