Find Jobs
Hire Freelancers

Magento 2 Bug Fix -- 2

€8-30 EUR

Closed
Posted 7 months ago

€8-30 EUR

Paid on delivery
I am looking for a Magento 2 developer who can fix a functionality issue on my website's product pages. The bug needs to be resolved ASAP. Skills and Experience: - Strong experience with Magento 2 development - Proficient in PHP, HTML, CSS, and JavaScript - Familiarity with Magento 2 frontend and backend structure - Knowledge of debugging and troubleshooting techniques - Attention to detail and ability to identify and fix bugs efficiently Bug: 2 exception(s): Exception #0 (Zend_Db_Statement_Exception): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')) AND (cpotv.manage_stock = 1)' at line 1, query was: SELECT DISTINCT `cpotv`.`option_id` FROM `catalog_product_option_type_value` AS `cpotv` WHERE (option_id IN ()) AND (cpotv.manage_stock = 1) Exception #1 (PDOException): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')) AND (cpotv.manage_stock = 1)' at line 1 Exception #0 (Zend_Db_Statement_Exception): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')) AND (cpotv.manage_stock = 1)' at line 1, query was: SELECT DISTINCT `cpotv`.`option_id` FROM `catalog_product_option_type_value` AS `cpotv` WHERE (option_id IN ()) AND (cpotv.manage_stock = 1) <pre>#1 Magento\Framework\DB\Statement\Pdo\Mysql->_execute() called at [vendor/magento/zendframework1/library/Zend/Db/[login to view URL]] #2 Zend_Db_Statement->execute() called at [vendor/magento/zendframework1/library/Zend/Db/Adapter/[login to view URL]] #3 Zend_Db_Adapter_Abstract->query() called at [vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/[login to view URL]] #4 Zend_Db_Adapter_Pdo_Abstract->query() called at [vendor/magento/framework/DB/Adapter/Pdo/[login to view URL]] #5 Magento\Framework\DB\Adapter\Pdo\Mysql->_query() called at [vendor/magento/framework/DB/Adapter/Pdo/[login to view URL]] #6 Magento\Framework\DB\Adapter\Pdo\Mysql->query() called at [generated/code/Magento/Framework/DB/Adapter/Pdo/Mysql/[login to view URL]] #7 Magento\Framework\DB\Adapter\Pdo\Mysql\Interceptor->query() called at [vendor/magento/zendframework1/library/Zend/Db/Adapter/[login to view URL]] #8 Zend_Db_Adapter_Abstract->fetchCol() called at [generated/code/Magento/Framework/DB/Adapter/Pdo/Mysql/[login to view URL]] #9 Magento\Framework\DB\Adapter\Pdo\Mysql\Interceptor->fetchCol() called at [vendor/mageworx/module-optioninventory/Model/ResourceModel/Product/Option/[login to view URL]] #10 MageWorx\OptionInventory\Model\ResourceModel\Product\Option\ManageStockOptionCollection->getOptionsContainsManageStockValues() called at [vendor/mageworx/module-optioninventory/Helper/[login to view URL]] #11 MageWorx\OptionInventory\Helper\Stock->getOptionsContainManageStockValues() called at [vendor/mageworx/module-optioninventory/Block/[login to view URL]] #12 MageWorx\OptionInventory\Block\Inventory->getManageStockValues() called at [vendor/mageworx/module-optioninventory/Block/[login to view URL]] #13 MageWorx\OptionInventory\Block\Inventory->getJsonData() called at [vendor/mageworx/module-optioninventory/view/frontend/templates/catalog/product/[login to view URL]] #14 include() called at [vendor/magento/framework/View/TemplateEngine/[login to view URL]] #15 Magento\Framework\View\TemplateEngine\Php->render() called at [vendor/magento/framework/Interception/[login to view URL]] #16 Magento\Framework\View\TemplateEngine\Php\Interceptor->___callParent() called at [vendor/magento/framework/Interception/[login to view URL]]
Project ID: 37287958

About the project

40 proposals
Remote project
Active 6 mos 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
40 freelancers are bidding on average €33 EUR for this job
User Avatar
Hello, Warm Greeting! As per details, we have a great team of magenta who works on this platform continuously from last 7 years and we work on all of the versions of magento. we will be done your project as per your requirement and will give you 100% quality work. Thanks
€19 EUR in 4 days
4.9 (406 reviews)
7.8
7.8
User Avatar
hello , hope you are fine i have very good grip in magento 2 i can debug the issue and fix that , lets discuss that is my portfolio you can check https://www.freelancer.com/u/samair0
€50 EUR in 1 day
5.0 (646 reviews)
7.2
7.2
User Avatar
Module MageWorx_OptionInventory should issue an invalid query most likely with an empty list of product option ids. Uncertain about the root cause of the issue but a workaround would be to not issue the query when there are not (custom) options. Possible that this represents a valid state within the module but has been overlooked. Would be necessary to have SSH access to your installation to verify. Does the issue occur on a specific frontend page?
€28 EUR in 1 day
5.0 (44 reviews)
6.9
6.9
User Avatar
Hello, 7+ years of experience with the following activities is required in Magento CMS: Magento migration from 1.9 to 2.0.x Commerce Portal Modification or customization of Module or any functionality Integration and building of multiple payment gateways and shipping methods Community-related work API and Plugin development and integration Multi-vendor and Multi-Language Marketplace store; The custom module as per customer requirements Ping me to continue this process and build a good relationship through this work. Thanks and Regards Hitesh Goyal
€30 EUR in 1 day
4.7 (190 reviews)
7.0
7.0
User Avatar
Hello Sir, I can fix both issues within 1 day. I am Adobe Certified Expert having 7Y+ experience. Please check out our past projects and their reviews as all our clients are satisfied. Let's initiate a chat. I am available right now to start the work. Best regards, Cenotix
€60 EUR in 1 day
5.0 (147 reviews)
6.6
6.6
User Avatar
Hello, I am Mitesh, a highly skilled web developer who can manage any project that comes across the desk. I understand that you are looking for a Magento 2 developer who can resolve a functionality issue on your website's product pages. Specifically, you need the bug to be resolved ASAP so please let me know if this is something that you are interested in pursuing. I have extensive experience with Magento 2 development, specifically with PHP, HTML, CSS and JavaScript. Additionally, I have familiarity with the structure of Magento 2 frontend and backend systems as well as debugging and troubleshooting techniques. My attention to detail and ability to identify and fix bugs efficiently make me the best fit for this job. If you'd like to discuss further please feel free to reach out to me directly!
€19 EUR in 1 day
5.0 (104 reviews)
6.2
6.2
User Avatar
Hi, I am 8 years experienced PHP developer expert in Magento. I understand your points. I can complete this project in two hours . Please check my profile for my work quality . Thanks, Bhaskar Mandal
€30 EUR in 1 day
4.9 (107 reviews)
6.3
6.3
User Avatar
Hello Sergejs! I hope you're well. I'm a senior developer with experience in developing Java based apps and web apps. I've delivered more than 100 projects over time with 5* rating. Here are some of my skills necessary for this task. ➢ Java: Deep understanding of Java and java libraries like Jackson, Tika, Apache Collections, Guava, JakartaEE, Mockito, Powermock ➢ Frameworks: Spring, Spring Boot, Spring MVC ➢ Databases: MySQL, Redis, DynamoDB, Postgres, Oracle, MongoDB ➢ Async Communications: CQRS, Kafka, Redis, Celery, RabbitMQ, MQTT ➢ Source Code Management: Git, GitLab, Bit-bucket, SVN ➢ Project Management: Jira, Bugzilla, Trello & Asana ➢ Web Servers: Apache Tomcat, Apache Http, Nginx ➢ Cloud Providers: AWS, GCP and Azure ➢ Containerisation: Docker, Kubernetes Best, Sonu
€30 EUR in 7 days
5.0 (26 reviews)
5.8
5.8
User Avatar
Hi there! My name is Akshay and I am a professional web and e-commerce developer with 7+ years of experience. I understand that you are looking for a Magento 2 developer who can fix an issue on your product pages that needs to be resolved ASAP. I have the skills necessary to help complete this project: strong experience in Magento 2 development, proficiency in PHP, HTML, CSS, and JavaScript. I have worked with many script packages including Magento before so I know exactly how it works. Additionally, my attention to detail and ability to identify and fix bugs efficiently make me the perfect fit for this job. If you give me the chance to work on this project please let me know. I would love to hear from you soon! Please feel free to contact me if you have any additional questions or would like further information about me or my services.
€30 EUR in 1 day
4.9 (26 reviews)
5.9
5.9
User Avatar
Hi, Monali Here, we are experts in graphic design and yes ready for the task. Please visit our portfolio: https://www.freelancer.com/u/Dreamachievers we have experience in Figma, Photoshop, and web design with the latest Bootstrap, js, jQuery, css. -Guarantee 100% make responsive design. -We will offer you unlimited revisions until you approve the design. - satisfied work.
€30 EUR in 7 days
4.9 (33 reviews)
5.2
5.2
User Avatar
I'm interested in helping you resolve the functionality issue on your Magento 2 website's product pages. I have extensive experience in Magento 2 development, PHP, HTML, CSS, and JavaScript, which makes me well-equipped to tackle and fix bugs efficiently. To better assist you, I'd appreciate it if you could provide more details about the specific exceptions you're encountering. Feel free to share any error messages or logs related to the issue. You can also review my profile for examples of past Magento 2 projects I've worked on to gauge my expertise in this area. Once you provide more information about the bug, we can discuss the next steps to get it resolved as soon as possible.
€8 EUR in 7 days
5.0 (19 reviews)
4.6
4.6
User Avatar
Hello, Elementor Export ! I have 8+ years of experience as a UI/UX Designer & Front End Developer. I can do this job Perfectly. I can start immediately. My skills: Magento || HTML || CSS || SASS || LESS, jQuery || JavaScript || Bootstrap || WordPress || Responsive design || Angular JS || etc. =>Theme & custom html integration and customization =>plugin installation, configuration and customization. =>Magento website maintenance and configuration. =>Innovation and Creation. =>Multiple Ecommerce Integrations. =>Widget development skills. =>Good knowledge of JavaScript.
€19 EUR in 7 days
4.9 (27 reviews)
4.5
4.5
User Avatar
Hello sir , i will resolve MYSQL error. i have 8+ year experience in website development. i had create number of e-commerce store. come on chat for check my work. you can check my reviews i am best in work. i can start work right now and complete asap. thanks Rishi
€30 EUR in 2 days
5.0 (32 reviews)
4.1
4.1
User Avatar
Hi there I'm a versatile Full Stack Developer with expertise in multiple domains. I understand your need for a Magento 2 developer to resolve a bug on your website's product pages and have the necessary skills and experience to get the job done. With my extensive background in PHP, WordPress, Laravel, React and SEO, I am confident that I can provide the right solution for your needs. I have extensive experience in developing, customizing, and optimizing WordPress websites. Whether it's creating a new site or enhancing existing ones I'm your go-to expert for WordPress. Additionally, I have knowledge of PHP programming which is the backbone of many web applications. I would be delighted to collaborate with you on this project. Please feel free to reach out if you have any further questions or would like to discuss further how we can make this project a success. Thank you for your consideration!
€30 EUR in 2 days
5.0 (6 reviews)
3.7
3.7
User Avatar
Hello, I hope this message finds you well. I am writing to express my keen interest in your project posted on Freelancer.com. I have done similar kind of project in the past.I would like to chat with you so that we can discuss the project in details and I can show you the relevent examples. Warm Regards Zulfiquar S
€19 EUR in 7 days
4.1 (6 reviews)
3.9
3.9
User Avatar
Hi Sir , I have read your requirement & i am interested in your project, but i have some doubts reagrding the same ,lets discuss in detail make it clear & then i am ready to start the work right away .
€19 EUR in 7 days
5.0 (9 reviews)
3.2
3.2
User Avatar
Greeting of the Day!!! After going through your project description, I feel confident and excited to work on this project for you. I am available with complete expertise and previous work experience to fix the issues related to your Magento 2 website's product pages and can start right now. I have complete expertise in Magento 2 and PHP, HTML, CSS, and JavaScript and design, ,Magneto Template Customization, Template, Theme,Ultimo Theme, luma theme, Extensions, Plug-in development,custom module creation, module editing, Extensions, Plug-in development,Magneto Go, Magneto CE,Template, Extensions designing and Themes Customization I have previously built so many custom Magento 2 sites and also modified the existing sites as per clients requirement and expert in bug fixing and troubleshooting in many websites. looking forward positively to work on your project and will not disappoint you in terms of quality of work, deadline and communication. Waiting for your positive reply. Thanks & Best Regards.
€30 EUR in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am skilled Swift software engineer with skills including HTML, Magento, JavaScript, PHP and MySQL. Please send a message to discuss more regarding this project. Thanks & regards
€94 EUR in 3 days
5.0 (1 review)
0.0
0.0
User Avatar
Greetings Dear Client. Welcome to my profile, Home to Professional and Quality services with 100% customer satisfaction guarantee. I'm a Certified & Experienced Expert in the respective project requirements. Dear Client, I take this opportunity to inform you that i have KEENLY gone through all your project requirements as given in your project description and I confirm to you that i can perfectly deliver as instructed. Being in possession of all CLEARLY STATED required project skills (MySQL, HTML, Magento, JavaScript and PHP) as this is my area of professional specialisation having completed all Certifications and developed adequate experience in the same area, I hereby humbly request you to consider my bid for Professional, Quality and Affordable services always. STRICT TIMELY DELIVERY & UNLIMITED REVISIONS. Kindly Message Me We Discuss More About The Project and seal the contract. Welcome and Thank-you.
€30 EUR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Ok,I understood your requirement but I have few doubts, text me so I can clear all my doubts right away, I can help you and i am ready for work. Thank you
€19 EUR in 7 days
0.0 (1 review)
0.0
0.0

About the client

Flag of LATVIA
Riga, Latvia
5.0
40
Payment method verified
Member since Feb 14, 2011

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.