Ttdfjt

Why is std::ssize() introduced in C++20?

Are PMR446 walkie-talkies legal in Switzerland?

Reduce size of sum sub/superscript?

How would a developer who mostly fixed bugs for years at a company call out their contributions in their CV?

Why did it take so long for Germany to allow electric scooters / e-rollers on the roads?

What did the 'turbo' button actually do?

Testing using real data of the customer

How to teach an undergraduate course without having taken that course formally before?

Why isn't Tyrion mentioned in 'A song of Ice and Fire'?

ifconfig shows UP while ip link shows DOWN

Is "vegetable base" a common term in English?

What could be my risk mitigation strategies if my client wants to contract UAT?

Navigating a quick return to previous employer

Count all vowels in string

Can a multiclassed Kensei monk/Swashbuckler rogue use an offhand finesse weapon to trigger Sneak Attack, without using a bonus action?

How can I minimize the damage of an unstable nuclear reactor to the surrounding area?

Is there an idiom that means that you are in a very strong negotiation position in a negotiation?

Why is the Eisenstein ideal paper so great?

Are there historical examples of audiences drawn to a work that was "so bad it's good"?

To exponential digit growth and beyond!

Are there guidelines for finding good names for LaTeX 2e packages and control sequences defined in these packages?

How to deceive the MC

Visual Block Mode edit with sequential number

Paired t-test means that the variances of the 2 samples are the same?

Magento 2.3 introduced a view table which causes issue with import of mysql dump. What's it for?

Magento 2.3.1 Base table or view not foundWhich table contains settings for countries available for shippingRetrieve product status query optimization in core magentoMagento Frontend suddenly very slow (Backend fast) issue MySQL relatedMagento 1.9 join table issueMagento 2.3 composer install issueMagento 2.3 product image issueMagento 2.3 upload_max_filesize max at 8M for import featureMagento 2.3 Data Transfer ImportMagento 2.3 Upgrade issueEvent Observer for import with magmi

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

0

If you mysql dump a magento 2.3 store and try to import it elsewhere you get an issue due the the format of the view import query.

The problem part is this:

CREATE ALGORITHM=UNDEFINED DEFINER=`PUT_YOUR_DATABASE_USER_NAME_HERE`@`localhost` SQL SECURITY INVOKER VIEW `inventory_stock_1` AS select distinct `legacy_stock_status`.`product_id` AS `product_id`,`legacy_stock_status`.`website_id` AS `website_id`,`legacy_stock_status`.`stock_id` AS `stock_id`,`legacy_stock_status`.`qty` AS `quantity`,`legacy_stock_status`.`stock_status` AS `is_salable`,`product`.`sku` AS `sku` from (`cataloginventory_stock_status` `legacy_stock_status` join `catalog_product_entity` `product` on(`legacy_stock_status`.`product_id` = `product`.`entity_id`)) ;

You need elevated permissions. The solution is this:

CREATE
OR REPLACE
VIEW `inventory_stock_1` AS select
 distinct `legacy_stock_status`.`product_id` AS `product_id`,
 `legacy_stock_status`.`website_id` AS `website_id`,
 `legacy_stock_status`.`stock_id` AS `stock_id`,
 `legacy_stock_status`.`qty` AS `quantity`,
 `legacy_stock_status`.`stock_status` AS `is_salable`,
 `product`.`sku` AS `sku`
from
 ( `cataloginventory_stock_status` `legacy_stock_status`
join `catalog_product_entity` `product` on
 (( `legacy_stock_status`.`product_id` = `product`.`entity_id` )));

My question is what is this view table used for? And why a view?

database magento2.3 sql

share|improve this question

edited May 16 at 5:36

Ayaz Ahmed Khan

12611

asked May 15 at 22:42

Dominic XigenDominic Xigen

38310

add a comment | 

0

If you mysql dump a magento 2.3 store and try to import it elsewhere you get an issue due the the format of the view import query.

The problem part is this:

CREATE ALGORITHM=UNDEFINED DEFINER=`PUT_YOUR_DATABASE_USER_NAME_HERE`@`localhost` SQL SECURITY INVOKER VIEW `inventory_stock_1` AS select distinct `legacy_stock_status`.`product_id` AS `product_id`,`legacy_stock_status`.`website_id` AS `website_id`,`legacy_stock_status`.`stock_id` AS `stock_id`,`legacy_stock_status`.`qty` AS `quantity`,`legacy_stock_status`.`stock_status` AS `is_salable`,`product`.`sku` AS `sku` from (`cataloginventory_stock_status` `legacy_stock_status` join `catalog_product_entity` `product` on(`legacy_stock_status`.`product_id` = `product`.`entity_id`)) ;

You need elevated permissions. The solution is this:

CREATE
OR REPLACE
VIEW `inventory_stock_1` AS select
 distinct `legacy_stock_status`.`product_id` AS `product_id`,
 `legacy_stock_status`.`website_id` AS `website_id`,
 `legacy_stock_status`.`stock_id` AS `stock_id`,
 `legacy_stock_status`.`qty` AS `quantity`,
 `legacy_stock_status`.`stock_status` AS `is_salable`,
 `product`.`sku` AS `sku`
from
 ( `cataloginventory_stock_status` `legacy_stock_status`
join `catalog_product_entity` `product` on
 (( `legacy_stock_status`.`product_id` = `product`.`entity_id` )));

My question is what is this view table used for? And why a view?

database magento2.3 sql

share|improve this question

edited May 16 at 5:36

Ayaz Ahmed Khan

12611

asked May 15 at 22:42

Dominic XigenDominic Xigen

38310

add a comment | 

If you mysql dump a magento 2.3 store and try to import it elsewhere you get an issue due the the format of the view import query.

The problem part is this:

CREATE ALGORITHM=UNDEFINED DEFINER=`PUT_YOUR_DATABASE_USER_NAME_HERE`@`localhost` SQL SECURITY INVOKER VIEW `inventory_stock_1` AS select distinct `legacy_stock_status`.`product_id` AS `product_id`,`legacy_stock_status`.`website_id` AS `website_id`,`legacy_stock_status`.`stock_id` AS `stock_id`,`legacy_stock_status`.`qty` AS `quantity`,`legacy_stock_status`.`stock_status` AS `is_salable`,`product`.`sku` AS `sku` from (`cataloginventory_stock_status` `legacy_stock_status` join `catalog_product_entity` `product` on(`legacy_stock_status`.`product_id` = `product`.`entity_id`)) ;

You need elevated permissions. The solution is this:

CREATE
OR REPLACE
VIEW `inventory_stock_1` AS select
 distinct `legacy_stock_status`.`product_id` AS `product_id`,
 `legacy_stock_status`.`website_id` AS `website_id`,
 `legacy_stock_status`.`stock_id` AS `stock_id`,
 `legacy_stock_status`.`qty` AS `quantity`,
 `legacy_stock_status`.`stock_status` AS `is_salable`,
 `product`.`sku` AS `sku`
from
 ( `cataloginventory_stock_status` `legacy_stock_status`
join `catalog_product_entity` `product` on
 (( `legacy_stock_status`.`product_id` = `product`.`entity_id` )));

My question is what is this view table used for? And why a view?

database magento2.3 sql

share|improve this question

edited May 16 at 5:36

Ayaz Ahmed Khan

12611

asked May 15 at 22:42

Dominic XigenDominic Xigen

38310

CREATE ALGORITHM=UNDEFINED DEFINER=`PUT_YOUR_DATABASE_USER_NAME_HERE`@`localhost` SQL SECURITY INVOKER VIEW `inventory_stock_1` AS select distinct `legacy_stock_status`.`product_id` AS `product_id`,`legacy_stock_status`.`website_id` AS `website_id`,`legacy_stock_status`.`stock_id` AS `stock_id`,`legacy_stock_status`.`qty` AS `quantity`,`legacy_stock_status`.`stock_status` AS `is_salable`,`product`.`sku` AS `sku` from (`cataloginventory_stock_status` `legacy_stock_status` join `catalog_product_entity` `product` on(`legacy_stock_status`.`product_id` = `product`.`entity_id`)) ;

CREATE
OR REPLACE
VIEW `inventory_stock_1` AS select
 distinct `legacy_stock_status`.`product_id` AS `product_id`,
 `legacy_stock_status`.`website_id` AS `website_id`,
 `legacy_stock_status`.`stock_id` AS `stock_id`,
 `legacy_stock_status`.`qty` AS `quantity`,
 `legacy_stock_status`.`stock_status` AS `is_salable`,
 `product`.`sku` AS `sku`
from
 ( `cataloginventory_stock_status` `legacy_stock_status`
join `catalog_product_entity` `product` on
 (( `legacy_stock_status`.`product_id` = `product`.`entity_id` )));

share|improve this question

edited May 16 at 5:36

Ayaz Ahmed Khan

12611

asked May 15 at 22:42

Dominic XigenDominic Xigen

38310

share|improve this question

edited May 16 at 5:36

Ayaz Ahmed Khan

12611

asked May 15 at 22:42

Dominic XigenDominic Xigen

38310

edited May 16 at 5:36

Ayaz Ahmed Khan

12611

edited May 16 at 5:36

Ayaz Ahmed Khan

12611

asked May 15 at 22:42

Dominic XigenDominic Xigen

38310

asked May 15 at 22:42

Dominic XigenDominic Xigen

38310