Add support for prefixed tables in Magento 2.3.1?

[YachYaroslav]

When trying to use php bin/magento eav:media:remove-unused I see the next error: Base table or view not found: 1146 Table 'store.catalog_product_entity_media_gallery' doesn't exist, query was: SELECT value FROM catalog_product_entity_media_gallery WHERE value = ?.

[ThomasNegeli]

@YachYaroslav did you check that the table in your DB really exists?

[YachYaroslav]

I know the reason, when the store use prefix for tables it doesn't work.

[YachYaroslav]

For example:

[YachYaroslav]

@YachYaroslav did you check that the table in your DB really exists?

So, table exists, but with prefix.

[YachYaroslav]

Changing of

$mediaGallery = $resource->getConnection()->getTableName('catalog_product_entity_media_gallery');

to

$setup = $objectManager->get('Magento\Framework\Setup\ModuleDataSetupInterface');
$mediaGallery = $setup->getTable('catalog_product_entity_media_gallery');

helped me in EAVCleaner/Console/Command/RemoveUnusedMediaCommand.php.