Table deletion bug

noelma

Hi, I'm on a flarum 12 installation and thank you for this wonderful tool 🙂.

I wanted to alert you to a problem I encountered. I tried to delete my tables via the phpMyAdmin interface. There remain 3 tables with constraints that prevent their deletion (even individually).
I ended up deleting and creating a new database. I am sending you a screenshot of the error encountered.

https://send.firefox.com/download/72d41a5837931e9c/#BFUSOsZFANLKiMQtxbhqrw
(The screenshot will be deleted automatically tomorrow)

Littlegolden

noelma Try delete these table in this order:

posts
discussions
users

clarkwinkelmann

That's expected. There's usually an option to disregard constraints when you delete tables via database tools. In phpMyAdmin I believe there's a checkbox in the "delete tables" confirmation modal for that.

Also if you delete tables via the migration rollback feature of Flarum, it will delete them in the correct order so that all constraints get removed.