Bug in Magento E-Commerce Shop regarding Digital Products
$30-250 USD
Completed
Posted almost 6 years ago
$30-250 USD
Paid on delivery
Hello,
We take over to manage a Shop System based on Magento 1.9.3.6. We looking for help on a regular bare to support this system. This project is a test task to identify this kind of help.
At the moment we have the following scenario:
In a Shop System, we can order EBooks (Digital Content). The price is $0 for this books. We have 10 products in the Shopping Cart and send the order and receive an error. That happened with the most combination in the shopping cart, but as well not always. Some products are able to purchase.
The error is:
Next exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1, query was: UPDATE `pdfgiftcard_voucher` SET `is_sold` = \?, `order_increment_id` = \? WHERE (id = )' in
(see complete Entry in [login to view URL] attached).
When you have an idea how to investigate the problem and be able to solve it, then make an offer for this tasks. We would give you access to the Development Server and details for reproduction or we can give you a copy of the htdocs&mysqldump, depend on what you prefer. Please provide examples of your experience with setup, maintain and debug Magento project.
When it works well, we would make an agreement for future support.
You need experience with Magento, mysql and PHP. Be aware, we did not develop this shop and the original developer is not possible to reach.
regards
Frank
Hello, Frank.
My name is Sergey. I am Freelancer from [login to view URL], Russia.
I can help you as Magento expert to fix this SQL error.
This is my Magento certified developer profile:
[login to view URL]
Please, see my Freelancer.com profile. It full of Magento projects, 80+ in total, successfully completed by me, for example:
1.
"Magento CPU usage"
https://www.freelancer.com/projects/php/Magento-CPU-usage.html
2.
"Solve some Magento Module conflicts"
https://www.freelancer.com/projects/php/Solve-some-Magento-Module-conflicts/
3.
"Magento Site Issues"
https://www.freelancer.com/projects/mysql/Magento-Site-Issues/
4.
"Fix magento index problem"
https://www.freelancer.com/projects/php/Fix-magento-index-problem.html
5.
"Repair Magento Search Functionality"
https://www.freelancer.com/projects/php/Repair-Magento-Search-Functionality.html
6.
"Fix Magento payment processing"
https://www.freelancer.com/projects/php/Fix-Magento-payment-processing.html
I need FTP access to start right now. Also, I need login/password into Magento "admin" Dashboard.
I can communicate/hold an interview via Freelancer.com.
--
Sergey aka Takereal
$80 USD in 1 day
5.0 (2105 reviews)
8.3
8.3
19 freelancers are bidding on average $168 USD for this job
Hello Frank
My understanding about the project is that you are looking for fixation issue on your existing Magento site while making an order. We can surely help you with this. Kindly let me know the url for our better understanding. Please private message us to initiate discussion. We look forward to have detailed discussion with you.
Regards :
Prasoon Singh
Hi,
I have read your exact requirement and have seen the error you are facing.
I understood the issue and will fix it as per your guidance.
Please check my clients reviews on Magento which gives you a glimpse of my work.
I have +8 years experience in Magento and also +5 years experience as a Linux Admin.
I was working for a company for 8 years as a Magento developer and now I am working here as a full time freelancer.
I want some genuine clients for regular work in Magento.
Ask me freely if you have any doubt.
Regards
Karuna
Hi...
How are you?.
I saw your description carefully your project and i'm very interesting your project.
But i have some question about your project.
When you have enough time to discuss about your project with me, please contact me.
Thanks
time:8/12/2018 0:20:35----1
I will do it immediately and i have 5+ experience in web development. I am sure will give you amazing results. if you have any questions please feel free to chat before ordering.
Hello,
I am really interested to work on this project. I am working on magento 2 and magento 1.9 last 6 years. Also working on PHP, Wordpress, shopify, Joomla etc. Over all 12 years on web development experience. you can give me chance to prove myself. I shall give you details in chat.
I shall give you example site in the time of conversion.
Thanks & regards
pradip
Hi,
I m very interested to do this job and i can fix the bug and i can support ongoing basis, i m professional magento developer. just knock me o chat.
Thanks
Rashedul
Hi
I have reviewed the job description. I can help you on this I have good experienced in magento.
I am available to help you on this please let me know when you want to discuss or award the project to me.
Thanks
Dhruv
Hello sir,
I read project requirement.
I am expert in magento 1.9, I will fix this issue.
There is twoway either you send me Code and database Or give your developemnet server detail (Not Live)
I will fix it within 2 days.
Looking forward to hear from you.
Thanks
ashish
I am first read the error properly that what is the actually error. then try to debug this with search coding section if there any coding issues are there. If not then I check the admin section, if there all ok then I check the database. In this way i am trying to solve the error.