Re: South with MySQL?

So is it something I have done wrong?  From what you are saying it has run the migration but I am not seeing that - still getting errors when I try to access the page.  If I do manag.py sql myapp I see the schema including the new fields, but if I go into the shell, import the view, and do DataTable.objects.all() I get "Unknown column 'myapp_datatable.type2stub' in 'field list'".

So is there a way to resolve this without deleting the database and starting again with one that does not have so many issues working with South?

Regards,
Nigel Legg
07914 740972
http://www.trevanianlegg.co.uk
http://twitter.com/nigellegg
http://uk.linkedin.com/in/nigellegg

On 1 August 2013 10:46, Masklinn <masklinn@masklinn.net> wrote:

On 2013-08-01, at 11:23 , Nigel Legg wrote:
> So are you saying the migration wil or will not work with South using
> MySQL??

No. I'm saying if the migration fails the database will be left in an
intermediate (and likely incorrect) state.

> What do I have to do, in addition to everything in the South
> documentation, in orde3r to make a South migration work with MySQL, given
> what you have posted above?

South *works* with mysql. But because of *mysql's limitations* if there
is a problem while South is *modifying the database schema* (the DDL) it
has no way to *rollback the changes*.

That's what it tells you: if there is a a problem during the migration
(because there's a bug in your migration), south *can not* put the
database back in the state it was before you started the migration
because mysql *does not provide the tools to do so*.

It's not an incompatibility, it's mysql being a gigantic turd, no
migration tool can fix that no matter how much they polish it.

--
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+unsubscribe@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.
For more options, visit https://groups.google.com/groups/opt_out.

--
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+unsubscribe@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.
For more options, visit https://groups.google.com/groups/opt_out.