macopedia / magmi-m2

Magmi GitHub, see branch magento2 for a version compatible with Magento 2
113 stars 53 forks source link

Missing table reported when running Magmi_ConfigurableItemProcessor plugin #61

Open hazzy opened 5 years ago

hazzy commented 5 years ago

I am testing Magmi-M2 on a database migrated from Magento V1 using the Magento Migration tool.

I am running Magmi_ConfigurableItemProcessor and am getting the following errors for every Sku suggesting the “catalog_product_super_attribute_pricing'” does not exist. :

plugin;Magmi_OptimizerPlugin;info:Magmi Optimizer v1.0.5 - Already optmized!
startup:Performing Datasource Lookup...
lookup:67:0.00085282325744629
startup:Found 67 records, took 0.00085282325744629 sec
columns:86
startup:Ajusted processed columns:86
error:SKU OMK198 - 1:SQLSTATE[42S02]: Base table or view not found: 1146 Table 'magento_v2.catalog_product_super_attribute_pricing' doesn't exist -
error:SKU OMK198 - 2:SQLSTATE[42S02]: Base table or view not found: 1146 Table 'magento_v2.catalog_product_super_attribute_pricing' doesn't exist - ERROR ON RECORD #1
error:SKU OM0324 - 3:SQLSTATE[42S02]: Base table or view not found: 1146 Table 'magento_v2.catalog_product_super_attribute_pricing' doesn't exist -
error:SKU OM0324 - 4:SQLSTATE[42S02]: Base table or view not found: 1146 Table 'magento_v2.catalog_product_super_attribute_pricing' doesn't exist - ERROR ON RECORD #2
error:SKU OM0314 - 5:SQLSTATE[42S02]: Base table or view not found: 1146 Table 'magento_v2.catalog_product_super_attribute_pricing' doesn't exist -
error:SKU OM0314 - 6:SQLSTATE[42S02]: Base table or view not found: 1146 Table 'magento_v2.catalog_product_super_attribute_pricing' doesn't exist - ERROR ON RECORD #3

…..

Indeed “catalog_product_super_attribute_pricing'” does not exist and is not shown in the Magento M2 Schema diagram. So i assume the code should not reference it at all.

Can anyone shed some light on this issue please as I have seen it stated the plugin should work ok.

Thanks.

John

alaldin commented 5 years ago

Please can you help me I have installed Magmi-M2 on magento 2.3 and I get the below error. How did you fix it to get it to start importing products.

Fatal error: Uncaught PDOException: SQLSTATE[HY000] [1045] Access denied for user ''@'localhost' (using password: NO) in /home/aikigailifecom/public_html/magmi/inc/dbhelper.class.php:58 Stack trace: #0 /home/aikigailifecom/public_html/magmi/inc/dbhelper.class.php(58): PDO->__construct('mysql:host=loca...', NULL, NULL, Array) #1 /home/aikigailifecom/public_html/magmi/inc/magmi_engine.php(518): DBHelper->initDb('localhost', 'magento', NULL, NULL, '3306', NULL, 'net', false) #2 /home/aikigailifecom/public_html/magmi/plugins/base/general/reindex/magmi_reindexing_plugin.php(35): Magmi_Engine->connectToMagento() #3 /home/aikigailifecom/public_html/magmi/plugins/base/general/reindex/magmi_reindexing_plugin.php(105): Magmi_ReindexingPlugin->initIndexList() #4 /home/aikigailifecom/public_html/magmi/plugins/base/general/reindex/options_panel.php(20): Magmi_ReindexingPlugin->getIndexList() #5 /home/aikigailifecom/public_html/magmi/plugins/inc/magmi_plugin.php(95): require('/home/aikigaili...') #6 /home/aikigailifecom/public_html/mag in /home/aikigailifecom/public_html/magmi/inc/dbhelper.class.php on line 58

tmotyl commented 5 years ago

Hi @hazzy Are you sure you're using branch "magento 2" or a tag > 200.7.0 ? I don;t see any reference to this table in our code, so most probably you're still using magmi for magento 1, which will not work

hazzy commented 5 years ago

@tmotyl Thanks for your reply.

But can you please check for me - i can see line 242 in magmi-m2/magmi/plugins/base/itemprocessors/configurables/magmi_configurableprocessor.php

$cpsap = $this->tablename("catalog_product_super_attribute_pricing");

also line 28 in magmi-m2/magmi/plugins/utilities/clearproductsandcategories/clearproductsandcategories.php


            // "catalog_product_link_attribute",
            // "catalog_product_link_type",
            "catalog_product_option","catalog_product_option_price","catalog_product_option_title",
            "catalog_product_option_type_price","catalog_product_option_type_title","catalog_product_option_type_value",
            "catalog_product_super_attribute","catalog_product_super_attribute_label",
            "catalog_product_super_attribute_pricing","catalog_product_super_link","catalog_product_enabled_index",

Am i looking at the wrong code somehow??
tmotyl commented 5 years ago

ah, you're right, somehow the ide tricked me. Please send a PR once you figure out how to fix it.

hazzy commented 5 years ago

@tmotyl I would love to do that but don't have the required skills - sorry.

Do we know who reported this plugin as working? Maybe they might have something to add

NateSwanson7 commented 4 years ago

@hazzy it's not really the plugin's issue. You can just remove super_attribute_pricing from the csv you're importing and the issue will go away. That table doesn't exist anymore because Magento 2 doesn't handle configurable products in the same way as Magento 1. You can associate simple products with the configurable by just adding a column name simples_skus to your csv and putting a comma separated list of skus you like to be associated with the configurable product. The simples_skus column should be empty if the product on that row isn't a configurable. Note, make sure you have all those simple products in the csv above the configurable you want to associate them with otherwise you may get an error related to Magmi not finding the simple skus.

Here's a screenshot example of what I'm talking about regarding the simples_skus column image

hazzy commented 4 years ago

@NateSwanson7 Thanks very much for the info! I will do as you suggest in a test and report back.

NateSwanson7 commented 4 years ago

@NateSwanson7 Thanks very much for the info! I will do as you suggest in a test and report back.

@hazzy Yep, just let me know if you need any additional help. I'm a developer and I've been setting up and configuring Magmi to work with my company's instance of Magento 2. So I've created a custom plugin to import product videos and setup some different configurations to allow us to use the same csv files we used in M1. I feel pretty confident about helping others with Magmi issues for M2 because I've probably already experienced them.

hazzy commented 4 years ago

@NateSwanson7 Just a quick update to let you know your suggestion above fixed my issue. Thanks very much!

Did you see my other issue #70 by any chance. Maybe you might have an idea on that one?

NateSwanson7 commented 4 years ago

@hazzy I hadn't seen the issue you mentioned. That looks like it may be a Magento issue more so than a Magmi issue. If you have a development site setup, I'd try deleting that product (Product ID 235) then reimport that product using Magmi and see if you still get the same error.