No one provided an answer to the question - and no one showed their marketplace on this pluginuser can submit product from frontend customer dashboard,view sales etc .it is customer-to-customer type business. like small ebay or amazon
- 2021/01/11
- 75
- 182
- $81
Getting following error
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'cpev.entity_id' in 'on clause', query was: SELECT `main_table`.*, `cpev`.`value` AS `product_name`, `cpev`.`store_id` AS `mage_store_id`, `cpei`.`value` AS `product_status`, `cpai`.`value` AS `visibility`, `cgf`.`name`, `cped`.`value` AS `product_price`, `csi`.`qty`, count(flagTable.entity_id) AS `flagcount` FROM `marketplace_product` AS `main_table` INNER JOIN `catalog_product_entity_varchar` AS `cpev` ON main_table.mageproduct_id = cpev.entity_id INNER JOIN `catalog_product_entity_int` AS `cpei` ON main_table.mageproduct_id = cpei.entity_id INNER JOIN `catalog_product_entity_int` AS `cpai` ON main_table.mageproduct_id = cpai.entity_id INNER JOIN `customer_grid_flat` AS `cgf` ON main_table.seller_id = cgf.entity_id LEFT JOIN `catalog_product_entity_decimal` AS `cped` ON main_table.mageproduct_id = cped.entity_id and cped.store_id = 0 AND cped.attribute_id = 77 INNER JOIN `cataloginventory_stock_item` AS `csi` ON main_table.mageproduct_id = csi.product_id LEFT JOIN `marketplace_productflags` AS `flagTable` ON main_table.mageproduct_id = flagTable.product_id WHERE (cpev.store_id = 0 AND cpev.attribute_id = 73) AND (cpei.store_id = 0 AND cpei.attribute_id = 97) AND (cpai.store_id = 0 AND cpai.attribute_id = 99) AND (csi.website_id = 0 OR csi.website_id = 1) GROUP BY `mageproduct_id` LIMIT 20
Exception in /html/vendor/magento/framework/DB/Statement/Pdo/Mysql.php:109
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'cpev.entity_id' in 'on clause', query was: SELECT `main_table`.*, `cpev`.`value` AS `product_name`, `cpev`.`store_id` AS `mage_store_id`, `cpei`.`value` AS `product_status`, `cpai`.`value` AS `visibility`, `cgf`.`name`, `cped`.`value` AS `product_price`, `csi`.`qty`, count(flagTable.entity_id) AS `flagcount` FROM `marketplace_product` AS `main_table` INNER JOIN `catalog_product_entity_varchar` AS `cpev` ON main_table.mageproduct_id = cpev.entity_id INNER JOIN `catalog_product_entity_int` AS `cpei` ON main_table.mageproduct_id = cpei.entity_id INNER JOIN `catalog_product_entity_int` AS `cpai` ON main_table.mageproduct_id = cpai.entity_id INNER JOIN `customer_grid_flat` AS `cgf` ON main_table.seller_id = cgf.entity_id LEFT JOIN `catalog_product_entity_decimal` AS `cped` ON main_table.mageproduct_id = cped.entity_id and cped.store_id = 0 AND cped.attribute_id = 77 INNER JOIN `cataloginventory_stock_item` AS `csi` ON main_table.mageproduct_id = csi.product_id LEFT JOIN `marketplace_productflags` AS `flagTable` ON main_table.mageproduct_id = flagTable.product_id WHERE (cpev.store_id = 0 AND cpev.attribute_id = 73) AND (cpei.store_id = 0 AND cpei.attribute_id = 97) AND (cpai.store_id = 0 AND cpai.attribute_id = 99) AND (csi.website_id = 0 OR csi.website_id = 1) GROUP BY `mageproduct_id` LIMIT 20
Exception in /html/vendor/magento/framework/DB/Statement/Pdo/Mysql.php:109
- 2020/05/31
- 2,683
- 1,548
- $11,060
Getting following error
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'cpev.entity_id' in 'on clause', query was: SELECT `main_table`.*, `cpev`.`value` AS `product_name`, `cpev`.`store_id` AS `mage_store_id`, `cpei`.`value` AS `product_status`, `cpai`.`value` AS `visibility`, `cgf`.`name`, `cped`.`value` AS `product_price`, `csi`.`qty`, count(flagTable.entity_id) AS `flagcount` FROM `marketplace_product` AS `main_table` INNER JOIN `catalog_product_entity_varchar` AS `cpev` ON main_table.mageproduct_id = cpev.entity_id INNER JOIN `catalog_product_entity_int` AS `cpei` ON main_table.mageproduct_id = cpei.entity_id INNER JOIN `catalog_product_entity_int` AS `cpai` ON main_table.mageproduct_id = cpai.entity_id INNER JOIN `customer_grid_flat` AS `cgf` ON main_table.seller_id = cgf.entity_id LEFT JOIN `catalog_product_entity_decimal` AS `cped` ON main_table.mageproduct_id = cped.entity_id and cped.store_id = 0 AND cped.attribute_id = 77 INNER JOIN `cataloginventory_stock_item` AS `csi` ON main_table.mageproduct_id = csi.product_id LEFT JOIN `marketplace_productflags` AS `flagTable` ON main_table.mageproduct_id = flagTable.product_id WHERE (cpev.store_id = 0 AND cpev.attribute_id = 73) AND (cpei.store_id = 0 AND cpei.attribute_id = 97) AND (cpai.store_id = 0 AND cpai.attribute_id = 99) AND (csi.website_id = 0 OR csi.website_id = 1) GROUP BY `mageproduct_id` LIMIT 20
Exception in /html/vendor/magento/framework/DB/Statement/Pdo/Mysql.php:109
Check your database table `catalog_product_entity_varchar` .entity_id` exits status
A new update for Webkul Marketplace Multi Vendor Module for Magento 2 5.0.10 C.E is now available for free download. Big thanks to the contribution from our member @roromoda !
any update webkul marketplace
Read the rest of this update entry...am looking for latest version 5.1.1 any help
类似主题
- 回复
- 1
- 浏览
- 533