Ttdfjt

How to "know" if I have a passion?

How to dismiss intrusive questions from a colleague with whom I don't work?

Can you feel passing through the sound barrier in an F-16?

Can my boyfriend, who lives in the UK and has a Polish passport, visit me in the USA?

Designing a prison for a telekinetic race

Can others monetize my project with GPLv3?

Was Tuvok bluffing when he said that Voyager's transporters rendered the Kazon weapons useless?

Does C++20 mandate source code being stored in files?

The teacher logged me in as administrator for doing a short task, is the whole system now compromised?

Is a butterfly one or two animals?

How can I run SQL Server Vulnerability Assessment from a SQL Job?

Why were movies shot on film shot at 24 frames per second?

Are illustrations in novels frowned upon?

Don't understand MOSFET as amplifier

Are there any plans for handling people floating away during an EVA?

Is refusing to concede in the face of an unstoppable Nexus combo punishable?

Why don't politicians push for fossil fuel reduction by pointing out their scarcity?

Is there such a thing as too inconvenient?

Overwrite file only if data

Why we don't have vaccination against all diseases which are caused by microbes?

The sound of thunder's like a whip

Why would the US President need briefings on UFOs?

How to avoid using System.String with Rfc2898DeriveBytes in C#

To "hit home" in German

Magento 2: tmp_catalog_category_entity__sales_order_1 doesn't exist

How to get rid of Base table or view not found: 1146 Table 'catalog_category_flat_store_1' doesn't exist?Magento 2 Database table not creatingMagento 2 Error: Base table or view not found: 1146 Table 'dbname.catalog_category_flat_store_1' doesn't existSQLSTATE[42S02]: Base table or view not found: 1146 Table 'db.design_config_grid_flat' doesn't existMagento 2 Integration test can't run - store_website doesn't existdesign_config_grid_flat' doesn't existAfter upgrade to Magento2.2, error “Base table or view not found”checkout_agreement_store doesn't existMagento 2.2.5 - Table catalogsearch_fulltext_scope1 not being automatically generatedBase table or view not exist

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

While running php bin/magento s:up

We get the following error:

SQLSTATE[42S02]: Base table or view not found: 1146 Table '[DATABASENAME].[PREFIX]tmp_catalog_category_entity__sales_order_1' doesn't exist, query was: SHOW CREATE TABLE [PREFIX]tmp_catalog_category_entity__sales_order_1

Running php bin/magento setup:db-data:upgrade successfully runs and does not output any error information.

Any idea as to the issue, how to fix or how to output additional error information?

Obviously the issue is with the table not existing. I confirm that to be true. However, why? This is a new issue. s:up has worked fine for the last two years. I can confirm the table was not manually deleted.

Is there a way to regenerate the table? Commands c:c and c:f do not fix the issue. Indexing does not help either.

Update:
We use magento table prefixing. Upon further review, it seems none of the prefixed tmp_* tables are being created. Only the non-prefixed tmp_* tables. I created them manually by copying the non-prefixed version, but what would cause prefixed tmp tables to not be created?

magento2 database

share|improve this question

edited Aug 8 at 16:39

RFI

asked Aug 8 at 15:18

RFIRFI

833 bronze badges

add a comment | 

0

While running php bin/magento s:up

We get the following error:

SQLSTATE[42S02]: Base table or view not found: 1146 Table '[DATABASENAME].[PREFIX]tmp_catalog_category_entity__sales_order_1' doesn't exist, query was: SHOW CREATE TABLE [PREFIX]tmp_catalog_category_entity__sales_order_1

Running php bin/magento setup:db-data:upgrade successfully runs and does not output any error information.

Any idea as to the issue, how to fix or how to output additional error information?

Obviously the issue is with the table not existing. I confirm that to be true. However, why? This is a new issue. s:up has worked fine for the last two years. I can confirm the table was not manually deleted.

Is there a way to regenerate the table? Commands c:c and c:f do not fix the issue. Indexing does not help either.

Update:
We use magento table prefixing. Upon further review, it seems none of the prefixed tmp_* tables are being created. Only the non-prefixed tmp_* tables. I created them manually by copying the non-prefixed version, but what would cause prefixed tmp tables to not be created?

magento2 database

share|improve this question

edited Aug 8 at 16:39

RFI

asked Aug 8 at 15:18

RFIRFI

833 bronze badges

add a comment | 

While running php bin/magento s:up

We get the following error:

SQLSTATE[42S02]: Base table or view not found: 1146 Table '[DATABASENAME].[PREFIX]tmp_catalog_category_entity__sales_order_1' doesn't exist, query was: SHOW CREATE TABLE [PREFIX]tmp_catalog_category_entity__sales_order_1

Running php bin/magento setup:db-data:upgrade successfully runs and does not output any error information.

Any idea as to the issue, how to fix or how to output additional error information?

Obviously the issue is with the table not existing. I confirm that to be true. However, why? This is a new issue. s:up has worked fine for the last two years. I can confirm the table was not manually deleted.

Is there a way to regenerate the table? Commands c:c and c:f do not fix the issue. Indexing does not help either.

Update:
We use magento table prefixing. Upon further review, it seems none of the prefixed tmp_* tables are being created. Only the non-prefixed tmp_* tables. I created them manually by copying the non-prefixed version, but what would cause prefixed tmp tables to not be created?

magento2 database

share|improve this question

edited Aug 8 at 16:39

RFI

asked Aug 8 at 15:18

RFIRFI

833 bronze badges

SQLSTATE[42S02]: Base table or view not found: 1146 Table '[DATABASENAME].[PREFIX]tmp_catalog_category_entity__sales_order_1' doesn't exist, query was: SHOW CREATE TABLE [PREFIX]tmp_catalog_category_entity__sales_order_1

share|improve this question

edited Aug 8 at 16:39

RFI

asked Aug 8 at 15:18

RFIRFI

833 bronze badges

share|improve this question

edited Aug 8 at 16:39

RFI

asked Aug 8 at 15:18

RFIRFI

833 bronze badges

asked Aug 8 at 15:18

RFIRFI

833 bronze badges

asked Aug 8 at 15:18

RFIRFI

833 bronze badges