Trying to use Publish Manager for the first time to publish my local docker to Digital Ocean and everything seems to go smoothly until it starts applying the database changes. I get this error every time.
There was an error during publish alter table ‘user_role’ modify ‘role’ archer(255) - ER_NO_SUCH_TABLE: Table ‘databaseName.user_roles’ doesn’t exist.
Honestly I don’t recall creating this table and if I did, I removed it. I tried deleting the remote target and putting it back with no luck. I also manually imported the local database to the remote database so they would match but still getting the error. Perhaps something in the migration file?
Thanks in advance,