ER_NO_SUCH_TABLE when using Publish Manager and Issue trying to add it back as subtable

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,
Twitch

Community Page
Last updated: