Breaking News: Grepper is joining You.com. Read the official announcement!

Exception #0 (Zend_Db_Statement_Exception): SQLSTATE[HY000]: General error: 1449 The user specified as a definer ('wsadmin'@'%') does not exist, query was: SELECT `inventory_stock_1`.`is_salable` FROM `inventory_stock_1` WHERE (sku = '45501')

Wandering Willet answered on July 19, 2022 Popularity 1/10 Helpfulness 1/10

answer Exception #0 (Zend_Db_Statement_Exception): SQLSTATE[HY000]: General error: 1449 The user specified as a definer ('wsadmin'@'%') does not exist, query was: SELECT `inventory_stock_1`.`is_salable` FROM `inventory_stock_1` WHERE (sku = '45501')

Exception #0 (Zend_Db_Statement_Exception): SQLSTATE[HY000]: General error: 1449 The user specified as a definer ('wsadmin'@'%') does not exist, query was: SELECT `inventory_stock_1`.`is_salable` FROM `inventory_stock_1` WHERE (sku = '45501')

Comment

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` )));

Popularity 1/10 Helpfulness 1/10 Language sql

Source: magento.stackexchange.com

Tags: exception select sql where

Link to this answer
Share Copy Link