Hello,
We need to correct the bellow error that appeared after moving products from our live site to the staging.
[2020-10-20 06:31:51] [login to view URL]: SQLSTATE[42S22]: Column not found: 1054 Unknown column '[login to view URL]' in 'field list', query was: SELECT `entity`.`sku`, `product_entity`.`entity_id` AS `product_id`, `attribute`.`attribute_code`, `entity_value`.`value` AS `value_index`, `attribute_label`.`value` AS `super_attribute_label`, IFNULL([login to view URL], [login to view URL]) AS `option_title`, `default_option_value`.`value` AS `default_title` FROM `catalog_product_super_attribute` AS `super_attribute`
INNER JOIN `catalog_product_entity` AS `product_entity` ON product_entity.entity_id = super_attribute.product_id
{"exception":"[object] (Zend_Db_Statement_Exception(code: 42): SQLSTATE[42S22]: Column not found: 1054 Unknown column '[login to view URL]' in 'field list', query was: SELECT `entity`.`sku`, `product_entity`.`entity_id` AS `product_id`, `attribute`.`attribute_code`, `entity_value`.`value` AS `value_index`, `attribute_label`.`value` AS `super_attribute_label`, IFNULL([login to view URL], [login to view URL]) AS `option_title`, `default_option_value`.`value` AS `default_title` FROM `catalog_product_super_attribute` AS `super_attribute`
INNER JOIN `catalog_product_entity` AS `product_entity` ON product_entity.entity_id = super_attribute.product_id
INNER JOIN `catalog_product_super_link` AS `product_link` ON product_link.parent_id = super_attribute.product_id
INNER JOIN `eav_attribute` AS `attribute` ON attribute.attribute_id = super_attribute.attribute_id
INNER JOIN `catalog_product_entity` AS `entity` ON entity.entity_id = product_link.product_id
INNER JOIN `catalog_product_entity` AS `entity_value` ON entity_value.attribute_id = super_attribute.attribute_id AND entity_value.store_id = 0 AND entity_value.entity_id = entity.entity_id
LEFT JOIN `catalog_product_super_attribute_label` AS `attribute_label` ON super_attribute.product_super_attribute_id = attribute_label.product_super_attribute_id AND attribute_label.store_id = 0
LEFT JOIN `eav_attribute_option` AS `attribute_option` ON attribute_option.option_id = [login to view URL]
LEFT JOIN `eav_attribute_option_value` AS `option_value` ON option_value.option_id = [login to view URL] AND option_value.store_id = 0
LEFT JOIN `eav_attribute_option_value` AS `default_option_value` ON default_option_value.option_id = [login to view URL] AND default_option_value.store_id = 0 WHERE (super_attribute.product_id = 13023) AND (attribute.attribute_id = '') ORDER BY `attribute_option`.`sort_order` ASC
at /home//public_html/staging/vendor/magento/framework/DB/Statement/Pdo/[login to view URL], PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column '[login to view URL]' in 'field list' at /public_html/staging/vendor/magento/framework/DB/Statement/Pdo/[login to view URL])"} []
Hello,
I have read your job details carefully and I can do your work if you will provide me more details of the project. I will definitely give you a better solution to your problem.
Thanks
Ambient Infotech
Hi,
I can start right now.
I understood the error and will fix it as per your guidance, please share the Root SSH.
I have +8 years of experience in Magento and also have +5 years of experience as a Linux Administrator.
Regards
Rohit
I have been magento developer for over 7 years and have much experience in this field. I read your requirement and really interested, I fixed this sql error for many clients before, I can start working immediately, I am sure I can finish it fast and make it work perfectly for you, please contact me to start it soon, thank you
Hi, Hope you are doing well! Thanks for sharing your project requirement with us. It will be our great pleasure to work on your project. I have checked your requirement, yes we can do it, because we already work on similar requirement in past. We have right skills to work on this assignment. We will complete the work as per requirement
Hi.
can I help you ?
I am magento developer and designer since 2009.
I see your error,
I will fix it,
can we discuss about your requirement ?
waiting for your reply.
Dear Client,
I have 9 years of experience in the field of E-Commerce using Magento. I have experience of to designed and developed around 50+ high-profile E-Commerce sites in Magento.
I can solve this error. It may happen with some improper migration in the database but don't worry I will solve it. I have solved many errors regarding the database, product customization, payment integrations, migrations and etc.
Please let me know more details about the project.
Thanks,
Hi, How are you today?
Thank you for posting this project, and I'm very happy to bid your project.
I've read carefully your project details. It seems, Its related with SQL join of product collection.
I have rich experiences related with your project.
Your satisfaction with the project is my top priority!
If you give me a chance to work with you, then I will do my best to reach your requirements.
I'm waiting for your kind response.
Please send msg over chat. Let's go.
I will do my best for you.
Best Regards
Hi,
I have read your job description and understand your requirements but need to know more details
i can start your work right now.
If you didn't select someone, you can knock me for more discuss.
Best Regards
TAJMUL13
HI Client,
I have 3+ years of experience working as a SQL developer. The error message seems to be very descriptive. I can help you with your task. Please reach me on chat window we can discuss on this. Thanks.
Thanks,
Vinod
I can create sql queries for sql server database as per design, let me know when to proceed. I can work on future works for databases also if needed.
I will work for cheapest budget within time, budget can be re negotiated again, send the details for the project. Please contact me asap.
I have 12+ years of experience in database programming,website designing,scripting and android development.