Upgrade via docker from 5.3.96 to 5.3.100 not working

Hi all,

I am trying to upgrade from version 5.3.96 to 5.3.100 via docker, but after updating its stuck.
Docker complains and get stuck at

“SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘purchase_order_invitations’ already exists”

Any suggestions?

Hi,

@david do you have any thoughts?

@bitfinity

I haven’t been able to recreate this from my tests, is it possible you have tried to restore from a different version at some stage?

@david, nope this was the first upgrade. My initial install version is 5.3.96.

@bitfinity

To get past this issue, you’ll need to update a field in the database,

In the migrations table, find the row:

2022_06_01_224339_create_purchase_order_invitations_table

and you’ll want to update the batch number to the same value as

2022_06_01_215859_set_recurring_client_timestamp

I’ll try tonight, thanks for the response

I can’t find the row

2022_06_01_224339_create_purchase_order_invitations_table