Chapter 4: Problem with 'flask db downgrade base'

[DRuyters]

Hello,

When trying to downgrade the database, I get the following error:

"Cannot drop index 'ix_post_user_id': needed in a foreign key constraint"

I assume that I need to change something in one of the migrations files to solve this problem. I am running a local MySQL server so it might be related to that

[miguelgrinberg]

If this happens with the "posts table" migration included in this project, then my guess is that there is some small difference between sqlite (which is what I used when the migrations were generated) and MySQL. You can try moving the drop table call to the top to see if that helps.