We were successfully able to read data from a Magento (v1) product database in the past using the below query [product id, name and description], but since attempting to upgrade wpDataTables from v1 to v2 we encountered an error which we understood as outdated PHP version (5.3.3), so after upgrading to PHP 7.0 we were able to install the latest wpDataTables plugin (v2), however the connection to our table now results in the following error (same error is displayed in admin backend - preventing any edits of the sql query settings in order to fix it, only option is to delete and re-create the table).
Editing product information can be tedious to work through the interface of Magento, having a streamlined and simplified editable table to update key product information would be helpful to many businesses but getting suitable magento queries to work with this plugin is not straight forward.
----
Error cannot calculate position of catalog_product_entity_varchar AS at_name_default ON (at_name_default.entity_id = e.entity_id) AND (at_name_default.attribute_id = (SELECT attribute_id FROM eav_attribute ea LEFT JOIN eav_entity_type et ON ea.entity_type_id = et.entity_type_id WHERE ea.attribute_code = 'name' AND et.entity_type_code = 'catalog_product')) AND at_name_default.store_id = 0 within LEFT JOIN catalog_product_entity_varchar AS at_name ON (at_name.entity_id = e.entity_id) AND (at_name.attribute_id = (SELECT attribute_id FROM eav_attribute ea LEFT JOIN eav_entity_type et ON ea.entity_type_id = et.entity_type_id WHERE ea.attribute_code = 'name' AND et.entity_type_code = 'catalog_product')) AND (at_name.store_id = 1) INNER JOIN catalog_product_entity_text AS at_description_default ON (at_description_default.entity_id = e.entity_id) AND (at_description_default.attribute_id = (SELECT attribute_id FROM eav_attribute ea LEFT JOIN eav_entity_type et ON ea.entity_type_id = et.entity_type_id WHERE ea.attribute_code = 'description' AND et.entity_type_code = 'catalog_product')) AND at_description_default.store_id = 0 LEFT JOIN catalog_product_entity_text AS at_description ON (at_description.entity_id = e.entity_id) AND (at_description.attribute_id = (SELECT attribute_id FROM eav_attribute ea LEFT JOIN eav_entity_type et ON ea.entity_type_id = et.entity_type_id WHERE ea.attribute_code = 'description' AND et.entity_type_code = 'catalog_product')) AND (at_description.store_id = 1)
Please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except us.
Also point me to the table ID so I can take a look.
I can see the all issues now and unfortunately like you said wizard and table settings becomes overwhelming. We did not have any feedback from users that uses Magento DB and our plugin but I will forward this to my team so we can investigate a little bit further.
Can you please check your server log and see if there are some errors.
We were successfully able to read data from a Magento (v1) product database in the past using the below query [product id, name and description], but since attempting to upgrade wpDataTables from v1 to v2 we encountered an error which we understood as outdated PHP version (5.3.3), so after upgrading to PHP 7.0 we were able to install the latest wpDataTables plugin (v2), however the connection to our table now results in the following error (same error is displayed in admin backend - preventing any edits of the sql query settings in order to fix it, only option is to delete and re-create the table).
Editing product information can be tedious to work through the interface of Magento, having a streamlined and simplified editable table to update key product information would be helpful to many businesses but getting suitable magento queries to work with this plugin is not straight forward.
----
Error
cannot calculate position of catalog_product_entity_varchar AS at_name_default ON (at_name_default.entity_id = e.entity_id) AND (at_name_default.attribute_id = (SELECT attribute_id FROM eav_attribute ea LEFT JOIN eav_entity_type et ON ea.entity_type_id = et.entity_type_id WHERE ea.attribute_code = 'name' AND et.entity_type_code = 'catalog_product')) AND at_name_default.store_id = 0 within LEFT JOIN catalog_product_entity_varchar AS at_name ON (at_name.entity_id = e.entity_id) AND (at_name.attribute_id = (SELECT attribute_id FROM eav_attribute ea LEFT JOIN eav_entity_type et ON ea.entity_type_id = et.entity_type_id WHERE ea.attribute_code = 'name' AND et.entity_type_code = 'catalog_product')) AND (at_name.store_id = 1) INNER JOIN catalog_product_entity_text AS at_description_default ON (at_description_default.entity_id = e.entity_id) AND (at_description_default.attribute_id = (SELECT attribute_id FROM eav_attribute ea LEFT JOIN eav_entity_type et ON ea.entity_type_id = et.entity_type_id WHERE ea.attribute_code = 'description' AND et.entity_type_code = 'catalog_product')) AND at_description_default.store_id = 0 LEFT JOIN catalog_product_entity_text AS at_description ON (at_description.entity_id = e.entity_id) AND (at_description.attribute_id = (SELECT attribute_id FROM eav_attribute ea LEFT JOIN eav_entity_type et ON ea.entity_type_id = et.entity_type_id WHERE ea.attribute_code = 'description' AND et.entity_type_code = 'catalog_product')) AND (at_description.store_id = 1)
Hi Junaid,
Thank you for your purchase.
Please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except us.
Also point me to the table ID so I can take a look.
Thank you.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hi Junaid,
I can see the all issues now and unfortunately like you said wizard and table settings becomes overwhelming.
We did not have any feedback from users that uses Magento DB and our plugin but I will forward this to my team so we can investigate a little bit further.
Can you please check your server log and see if there are some errors.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables