Upgrade 2.2.6 - 2.3.1 -> Table staging.queu doe not exist

[emile_rdam]

Followed all procedures to do the update correct. After composer is updated and we run 'php bin/magento setup:upgrade' we get a strange error. Please see image attached.

Error is Base Table or view not found:1146 Table 'ortlieb_staging.queue' doesn't exit.

So I have trouble understanding how to solve this.

Creating a 'queue' table should not be it I think.

If somebody can advise on what to do to solve this that would be great. Please note all update steps before the 'upgrade' command were done according to documentation of Magento.

[Sunil Patel]

Hello @emile_rdam 

you need to remove Magento_MessageQueue from setup_module 

and try to setup upgrade and then check it.

Note:- before do this please take db backup.

If works then mark as a solution.

[emile_rdam]

Hi, just checked. In setup_module there is no Magento_MessageQueue. In alphabetical order we go from Magento_MediaStorage to Magento_Msrp

[Sunil Patel]

Hello @emile_rdam 

Then do cache flush and try to upgrade again

[emile_rdam]

Wish it was that easy That is not it

[Tarandeep Singh]

@emile_rdamHi,

See the below URL. Same issue was logged as a bug but later they found an internal issue. This looks exact same as the issue you have.

https://github.com/magento/magento2/issues/20771

Problem solved? Please give 'Kudos' and accept 'Answer as Solution'.

[emile_rdam]

Issue solved. In the end we managed to solve this. However we had to hire an external developer so we are not 100% sure where the reason was but in the end it could be solved by someone with some more knowledge on Magento then I had.

The issue from the github I noticed and looks the same however our /setup folder was complete