Find Jobs
Hire Freelancers

Database error after product move

$30-50 AUD

已关闭
已发布超过 3 年前

$30-50 AUD

货到付款
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])"} []
项目 ID: 27831056

关于此项目

19提案
远程项目
活跃3 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
19威客以平均价$51 AUD来参与此工作竞价
用户头像
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
$45 AUD 在1天之内
4.9 (311条评论)
7.6
7.6
用户头像
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
$50 AUD 在1天之内
4.9 (180条评论)
7.0
7.0
用户头像
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
$50 AUD 在1天之内
5.0 (150条评论)
6.9
6.9
用户头像
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
$70 AUD 在2天之内
4.8 (140条评论)
6.7
6.7
用户头像
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.
$80 AUD 在1天之内
5.0 (50条评论)
5.6
5.6
用户头像
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,
$80 AUD 在2天之内
5.0 (34条评论)
5.6
5.6
用户头像
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
$30 AUD 在1天之内
4.9 (21条评论)
4.1
4.1
用户头像
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
$70 AUD 在1天之内
4.9 (14条评论)
3.8
3.8
用户头像
i can fix the column not found error in my sql after moving products from live to stagging server. i have sound knowledge of mysql
$45 AUD 在1天之内
5.0 (3条评论)
2.5
2.5
用户头像
Hi. Iwill fix ur issue quickly if u are interested ping me we will start working and let me mnow things
$56 AUD 在1天之内
4.4 (4条评论)
3.0
3.0
用户头像
hey, i read your error message and know how I can help you to fix it. contact me in chat to letme help you Fast.
$45 AUD 在1天之内
4.7 (3条评论)
2.3
2.3
用户头像
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
$30 AUD 在7天之内
5.0 (7条评论)
2.3
2.3
用户头像
Hi. Nice to meet you. I have read your task carefully. Now I 'm ready for you. I 'll satisfy you fully. Dear regards!
$30 AUD 在1天之内
5.0 (3条评论)
1.4
1.4
用户头像
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.
$40 AUD 在1天之内
0.0 (0条评论)
2.0
2.0

关于客户

ROMANIA的国旗
Tecuci, Romania
5.0
48
付款方式已验证
会员自12月 12, 2016起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。