uasoft-indonesia / badaso

Laravel Vue headless CMS / admin panel / dashboard / builder / API CRUD generator, anything !
https://badaso.uatech.co.id
MIT License
1.21k stars 223 forks source link

Syntax error can't drop new foreign key to a table that already has a foreign key #798

Closed miftahurrahmi closed 1 year ago

miftahurrahmi commented 2 years ago

Describe the bug Can't drop new foreign key to a table that already has a foreign key

To Reproduce Steps to reproduce the behavior:

  1. Go to Database Management
  2. Update the table that already has a relation column filed to another table
  3. add new field column or edit field column and set relation foreign key
  4. See error Syntax error or access violation: 1091 Can't DROP FOREIGN KEY
  5. In the database, the column successfully appears the foreign key logo, but the migration process for the column has not been successful

Badaso

stale[bot] commented 1 year ago

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.