Find Jobs
Hire Freelancers

Database error after product move

$30-50 AUD

Closed
Posted over 3 years ago

$30-50 AUD

Paid on delivery
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])"} []
Project ID: 27831056

About the project

19 proposals
Remote project
Active 3 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
19 freelancers are bidding on average $51 AUD for this job
User Avatar
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 in 1 day
4.9 (311 reviews)
7.6
7.6
User Avatar
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 in 1 day
4.9 (180 reviews)
7.0
7.0
User Avatar
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 in 1 day
5.0 (150 reviews)
6.9
6.9
User Avatar
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 in 2 days
4.8 (140 reviews)
6.7
6.7
User Avatar
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 in 1 day
5.0 (50 reviews)
5.6
5.6
User Avatar
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 in 2 days
5.0 (34 reviews)
5.6
5.6
User Avatar
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 in 1 day
4.9 (21 reviews)
4.1
4.1
User Avatar
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 in 1 day
4.9 (14 reviews)
3.8
3.8
User Avatar
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 in 1 day
5.0 (3 reviews)
2.5
2.5
User Avatar
Hi. Iwill fix ur issue quickly if u are interested ping me we will start working and let me mnow things
$56 AUD in 1 day
4.4 (4 reviews)
3.0
3.0
User Avatar
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 in 1 day
4.7 (3 reviews)
2.3
2.3
User Avatar
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 in 7 days
5.0 (7 reviews)
2.3
2.3
User Avatar
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 in 1 day
5.0 (3 reviews)
1.4
1.4
User Avatar
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 in 1 day
0.0 (0 reviews)
2.0
2.0

About the client

Flag of ROMANIA
Tecuci, Romania
5.0
48
Payment method verified
Member since Dec 12, 2016

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.