
Open
Posted
•
Ends in 3 hours
Paid on delivery
We are looking for a highly experienced OpenCart / PHP / MySQL developer to audit, repair and optimise a heavily customised OpenCart multi-store online ordering platform. This is not a standard OpenCart installation. It is a customised multi-store takeaway/restaurant ordering system with custom payment modules, SMS integrations, printer settings, VQMod modifications, custom checkout, and multiple store configurations. We need someone who can investigate and fix recurring errors, improve performance, clean up old/unused code, and make the platform stable and secure. Main Issues to Fix The site currently has several serious problems that need professional investigation and permanent fixes: 1. PHP Error Log Growing to GB Size The error log is constantly growing because repeated PHP Notice/Warning messages are being written on every page load. Examples include: Undefined variable: uniqueDates array_filter() expects parameter 1 to be array, null given array_map(): Expected parameter 2 to be an array, null given array_search() expects parameter 2 to be array, null given Undefined variable: openingDayTime Undefined index: flag_post_code These appear mainly around: catalog/controller/common/[login to view URL] catalog/controller/module/[login to view URL] vqmod/vqcache/[login to view URL] The selected developer must fix the source files properly, not just hide warnings. 2. MySQL Connection and Server Stability Problems We have seen recurring database errors such as: Too many connections Could not make a database link MySQL server has gone away Allowed memory size exhausted The developer must investigate whether this is caused by bad queries, connection leaks, cron jobs, bot traffic, missing indexes, bad configuration, or inefficient code. 3. PHP Memory Exhaustion There are repeated fatal errors such as: Allowed memory size of 268435456 bytes exhausted These appear in files such as: catalog/model/setting/[login to view URL] system/database/[login to view URL] vqmod/vqcache/[login to view URL] vqmod/vqcache/[login to view URL] We need the root cause fixed, not just increasing PHP memory limit. 4. OpenCart Multi-Store Setting Problems The system appears to delete and reinsert oc_setting values when saving store settings. This may cause temporary missing settings such as: config_template config_url config_ssl config_name We have also seen errors like: Failed opening required '/home/myfoodbasket/public_html/catalog/view/theme/' This suggests some stores may temporarily or permanently have missing/empty theme configuration. The developer must check the store settings save logic and ensure settings are updated safely. 5. Query Debug Logs Exposing Sensitive Data There are query log files that record full SQL queries, including sensitive configuration values such as: SMS API URLs API keys printer usernames/passwords payment gateway settings store configuration details This logging must be disabled or replaced with safe masked logging. Old sensitive logs must be identified and removed or moved outside public access. 6. Product Stock Updates Running Even Though We Do Not Use Stock We do not use product stock for our takeaway/restaurant products, but the system is still running queries like: UPDATE oc_product SET quantity = (quantity - 1) WHERE product_id = '...' AND subtract = '1' These are called from payment modules such as: catalog/controller/payment/[login to view URL] catalog/controller/payment/[login to view URL] catalog/controller/payment/[login to view URL] The developer must disable unnecessary stock deduction logic safely and make sure it does not affect order flow. 7. Security Review Logs show suspicious SQL payload attempts around product/topping parameters, including SQL injection style strings. The developer must review vulnerable areas, especially custom topping/option/product functions, and ensure all inputs are validated and safely cast or escaped. Required checks include: SQL injection protection request parameter validation session data validation payment callback safety admin-side sensitive logging public access to log files old/unused files or broken endpoints 8. Clean Up Unused or Broken Links / Code We also want the developer to review and clean up: unused external scripts/CSS broken links obsolete API integrations old payment/SMS/debug code unused modules duplicate or unnecessary JS/CSS includes VQMod cache/source mismatch issues unnecessary database queries 9. Performance Optimisation The site must be optimised for speed and stability. We expect the developer to review: slow queries missing indexes excessive queries per page unnecessary config loading VQMod overhead cache usage database connection handling PHP warnings/notices log rotation cron job impact bot traffic impact checkout and basket performance Required Skills Please only apply if you have strong experience with: OpenCart, ideally OpenCart 1.5.x / older customised OpenCart systems OpenCart multi-store architecture PHP 7.x MySQL / MariaDB optimisation VQMod custom payment modules custom checkout systems debugging production websites SQL injection prevention server performance optimisation Linux/cPanel hosting environments error log analysis Deliverables The successful freelancer must provide: Full audit of current issues. Clear list of all problems found. Permanent fixes for PHP notices/warnings/fatal errors. Fixes for MySQL connection and performance problems. Secure handling of logs and sensitive data. Removal or disabling of unnecessary stock deduction logic. Cleanup of unused/broken code and links. Performance improvements for frontend and checkout. Before/after summary. List of files changed. SQL changes made, if any. Recommendations for future maintenance. Important Requirements Do not apply generic OpenCart fixes without understanding the custom system. Do not simply suppress errors; root causes must be fixed. Do not modify live payment/order flow without taking backups and explaining the change. Must be able to work carefully on a production multi-store ordering platform. Must communicate clearly and explain what was changed. Must be available for testing after fixes. Questions for Applicants Please answer these when applying: Have you worked with customised OpenCart multi-store systems before? Have you worked with OpenCart 1.5.x or older OpenCart versions? Can you debug VQMod-generated errors back to the original source files? How would you investigate Too many connections and MySQL server has gone away errors? How would you safely disable stock deduction in a custom ordering system? Can you review logs without exposing sensitive API/payment credentials? Are you comfortable working with custom payment modules and checkout logic? Preferred Type of Freelancer We are looking for a senior developer, not someone who only installs OpenCart extensions. The right person should be able to understand an old customised system, trace issues properly, and fix them without breaking live ordering.
Project ID: 40457207
219 proposals
Open for bidding
Remote project
Active 2 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
219 freelancers are bidding on average $487 USD for this job

Hi there, We understand you're looking for an expert OpenCart developer to audit and fix a heavily customized multi-store online ordering platform, addressing issues like PHP errors, MySQL connection problems, performance, security, and log issues. Our team at Webbook Studio has extensive experience with OpenCart, PHP, and MySQL, having worked on similar projects such as custom e-commerce solutions and multi-store setups. For instance, we've developed a custom WordPress e-commerce website for a fashion brand, which involved complex payment integrations and custom checkout systems. We'll provide a full audit of current issues, clear fixes for PHP notices and MySQL problems, secure handling of logs, removal of unnecessary stock deduction logic, and performance improvements. Can you please share more details about the current setup of your production environment, such as the version of OpenCart and any custom modules or integrations in place? Feel free to message us to discuss the details! — Webbook Studio
$540 USD in 10 days
9.2
9.2

Hello, As a seasoned PHP developer, I am highly proficient in debugging, optimizing, and securing complex OpenCart projects. With my extensive experience in multi-store configurations that include custom payment modules, SMS integrations, printer settings, VQMod modifications, and more, just like your platform, I can offer the tailored expertise you need. My primary focus will be to curate a stable and secure environment for your takeaway/restaurant ordering system. For the persistent errors in your PHP log file, I will not only eliminate them but also address their root causes for complete eradication. The same goes for the recurring MySQL connection and memory issues, rather than just fixing the surface problems, my approach is to investigate and resolve the underlying problem indefinitely. I'll do a thorough audit of your platform to identify vulnerabilities leading to exhausting PHP memory and will patch them to ensure optimal performance. Moreover, as part of my security-oriented mindset, I'll strengthen the protection of your platform by reversing unnecessary product stock updates that might affect order flow. I'll also review all potential vulnerable areas prone to SQL injection attacks and reinforce rigorous validation and proper casting or escaping procedures for all inputs. Lastly, keeping data privacy at the forefront, I'll carefully handle query debug logs so that no sensitive information is left exposed. In conclusion, m Thanks!
$450 USD in 3 days
8.6
8.6

I see you are dealing with critical PHP/MySQL errors and security concerns on your OpenCart multi-store setup. These types of backend conflicts and log issues often stem from server-side configurations or database bottlenecks that require a precise hand to resolve without disrupting your live storefronts. With over 15 years of experience managing Linux servers and troubleshooting complex PHP applications, I have a deep understanding of how to audit log files, patch security vulnerabilities, and optimize MySQL queries for better performance. I frequently handle site cleanups and server migrations, so I am well-equipped to stabilize your environment and address the root cause of these performance issues. I can complete this work for $432.06 within a 24-hour turnaround to get your site running smoothly again. Let me know if you are ready to get started so I can begin the diagnostic process immediately.
$432.06 USD in 1 day
8.1
8.1

Hi there, I have spent decade working on customized PHP, OpenCart, MySQL, and multi-store systems, including fixing heavily modified legacy platforms with custom payment modules, VQMod layers, checkout flows, and server stability issues. Once you share the current server access and codebase, I will first perform a complete audit of the OpenCart multi-store architecture, VQMod source files, database behavior, logs, and payment/order flow to identify the actual root causes instead of temporarily suppressing errors. Then I will fix the recurring PHP/MySQL issues, stabilize the multi-store settings flow, secure sensitive logs and endpoints, optimize queries/performance, safely disable unnecessary stock deduction logic, and clean up unused or broken modules without affecting the live ordering process. I would request to connect once so we can review the current platform structure, server environment, and priority issues properly. Thanks, Rahul A.
$340 USD in 12 days
8.5
8.5

Hi, I am a highly experienced OpenCart / PHP / MySQL developer to audit, repair and optimise a heavily customised OpenCart multi-store online ordering platform. Have you worked with customised OpenCart multi-store systems before? -Yes Have you worked with OpenCart 1.5.x or older OpenCart versions? -Yes Can you debug VQMod-generated errors back to the original source files? -Yes, I can debug VQMod-generated errors back to the original source files How would you investigate Too many connections and MySQL server has gone away errors? -To address these issues, I would check your MySQL configuration settings like `max_connections` and `wait_timeout`, and optimize your queries to reduce load. Additionally, monitoring your current connections can help identify the root cause of the problem. How would you safely disable stock deduction in a custom ordering system? -To safely disable stock deduction, I recommend implementing a conditional check in the order processing logic that separates custom orders from standard ones. This way, you’ll have better control over your inventory adjustments without impacting your overall stock levels. Can you review logs without exposing sensitive API/payment credentials? - Yes, I can review logs without exposing sensitive API/payment credentials Are you comfortable working with custom payment modules and checkout logic? -Yes, I am comfortable working with custom payment modules and checkout logic Best Regards, Priyanka
$500 USD in 7 days
8.4
8.4

Interesting project, I will audit and fix your customised OpenCart multi-store platform — resolving the PHP notice/warning flood, MySQL connection instability, memory exhaustion, and exposed query logs. I will also disable the unnecessary stock deduction logic in your payment controllers and harden input validation against the SQL injection attempts targeting your topping/option parameters. For the `Too many connections` and `MySQL server has gone away` errors, I will trace connection handling across your cron jobs, VQMod-cached files, and checkout flow to find connection leaks or unclosed handles — not just tune `max_connections`. I will also check the `oc_setting` DELETE/INSERT logic to ensure store configs are updated atomically. Questions: 1) Are you running OpenCart 1.5.x specifically, and which PHP 7. Looking forward to your response. Best regards, Kamran
$276 USD in 10 days
8.4
8.4

Hi, Good Day I reviewed your project carefully and this is a complex customised OpenCart multi-store system where the real priority is stability, error elimination at the source, and safe optimisation without breaking live ordering flows. I have experience working with heavily customised PHP/MySQL systems, including legacy OpenCart setups with VQMod, custom checkout logic, payment modules, and multi-store configurations. I understand how critical it is in systems like yours to trace issues back to root cause instead of masking warnings or risking production instability. For your system, I would approach it in structured phases: Full audit of PHP notices, warnings, and fatal errors and fixing them in source controllers/models (not suppression) MySQL investigation for connection leaks, slow queries, missing indexes, cron/bot load, and configuration issues Memory exhaustion root-cause debugging in specific controllers and loader/database layers Safe review and correction of multi-store settings logic to prevent config corruption Disabling or securing sensitive query logging and cleaning exposed credentials from logs Removing unintended stock deduction logic without affecting order/payment flow Security hardening (input validation, SQL injection protection, payment callbacks, admin/log exposure) Performance optimisation (query reduction, VQMod cleanup, caching, and load optimisation) Cheers, M Adeel,
$250 USD in 5 days
8.0
8.0

Hi As an experienced developer with a strong background in MySQL and PHP, I have successfully resolved and optimized large-scale eCommerce systems similar to yours. With your OpenCart multi-store platform, it's clear that you need a professional to identify the root causes behind your issues and provide lasting solutions. I have extensive experience with complex systems like yours, where I've tackled various errors including PHP notice/warning messages, MySQL connection problems, PHP memory exhaustion, OpenCart multi-store settings and query debug logs, security reviews and more. My talent lies in going beyond fixing errors – I believe in optimizing the entire system to improve its performance and security. Instead of just increasing PHP memory limits or hiding warnings, I find the source files of your issues and provide comprehensive solutions. Additionally, privacy is a major concern for me – I understand the importance of keeping sensitive data like payment gateway or printer settings secure and implement safe logged data handling procedures accordingly. In summary, my team at Nikhil Solutions confidently offer tailor-made solutions for every client. We're not just here to fix existing problems but rather optimize your entire platform for enhanced performance, stability, security and user experience. Thanks.....
$750 USD in 7 days
7.9
7.9

SURE------I will do it in effective manner -------------- I am highly appreciative to work on this specific task I can do my best. I am an Innovative PHP/Full stack developer having rich experience with so many successful Tasks. I have some queries to give you accurate time and price Let’s connect on chat for further discussion and start quickly. Thanks!!
$500 USD in 7 days
8.1
8.1

Hi, I am very familiar with OpenCart and PHP. Yes, I’ve worked with customized OpenCart multi-store setups, including legacy architectures with shared catalogs, store-specific pricing, and separate domains/subdomains. I’ve also maintained and upgraded OpenCart 1.5.x systems where core overrides and legacy extensions (VQMod/OCMod hybrids) were heavily used. I can debug VQMod-generated issues by tracing the XML modifications back to the original controller/model/view files and isolating conflicts between extensions or overwritten methods. For database issues like “Too many connections” or “MySQL server has gone away,” I investigate connection pooling, long-running queries, unoptimized joins, server limits, and improper persistent connections, then apply fixes at both code and DB configuration level. For workflow changes like disabling stock deduction, I would safely isolate inventory decrement logic in the order-confirmation pipeline and override it via event/hooks or controlled model edits to avoid breaking order integrity. I always review logs carefully while masking or avoiding exposure of sensitive API/payment credentials, especially in production or shared environments. Yes, I’m comfortable working with custom payment modules and checkout logic, including debugging transaction flows, API callbacks, and ensuring secure order state handling across multi-step checkout processes.
$500 USD in 7 days
6.9
6.9

Fixing your VQMod cache loops... I saw your legacy OpenCart platform is suffering from systemic architecture strain, blowing past your 256MB PHP memory limit and creating massive write overhead in your oc_setting tables. Here is exactly how I will isolate and permanently repair your multi-store architecture: Log & Memory Optimization: I will fix the root array/variable notices within your core controllers and completely restructure the oc_setting save logic to prevent the destructive delete/reinsert loop causing missing theme paths. DB Stability & Disabling Stock: I'll track down your connection leaks via slow query logs, mask your sensitive API/printer credentials from plain text logging, and cleanly strip the unneeded stock decrement updates out of your gateway callbacks. VQMod Integrity: Instead of hiding warnings, I will trace virtual cache errors back to their original XML source files so your modifications remain stable, secure, and fully optimized under heavy traffic.
$576 USD in 7 days
6.9
6.9

Hi, As per my understanding, you need a senior OpenCart developer to audit and stabilize a heavily customised multi-store ordering platform by fixing PHP/MySQL issues, VQMod conflicts, security risks, and performance bottlenecks without affecting live order flow. Implementation approach: * Trace VQMod/cache errors to original source and fix root causes * Audit database queries, memory usage, logs, and connection handling * Secure sensitive configurations, optimize performance, and clean unused modules/code Queries: * Which OpenCart and PHP versions are currently running in production? * Do you have staging/server backup access for safe testing? * Are there any peak traffic hours where deployment should be avoided? I will share my portfolio on your first message, and I am sure about the delivery after this first meeting. I will be looking forward to hearing from you.
$950 USD in 18 days
6.9
6.9

Hello, I can help audit and stabilise your customised OpenCart multi-store ordering platform, including PHP/MySQL errors, VQMod source tracing, sensitive log cleanup, security checks, and performance issues around checkout, basket, settings, payments, SMS and printer integrations. I have worked on older PHP/OpenCart-style systems where fixes must be made carefully at the source, not by hiding warnings, and I can review connection leaks, slow queries, stock deduction logic, exposed debug logs, and custom payment/order flow with backups and clear file-level notes. I am ready to begin immediately and would be happy to discuss the project in further detail. Thanks, Teo
$500 USD in 5 days
6.5
6.5

Hi I have strong experience auditing and repairing heavily customized OpenCart/PHP/MySQL systems, including older OpenCart versions, VQMod overrides, multi-store setups, custom checkout flows, payment modules, and production error-log investigations. The main technical problem here is that the platform has multiple connected issues: PHP notices creating huge logs, unstable MySQL connections, memory exhaustion, unsafe setting updates, sensitive query logging, and unnecessary stock logic inside live order/payment flows. I can trace VQMod-generated errors back to the original source files, fix the actual undefined variables/array handling problems, and stop the logs from growing without simply hiding warnings. I can also investigate MySQL “too many connections” and memory errors by checking slow queries, connection leaks, cron jobs, indexes, config loading, bot traffic, and inefficient custom code. For security, I can review custom product/topping/payment callback logic, validate request parameters, protect against SQL injection, disable sensitive SQL logging, and move or remove exposed log files safely. I can carefully disable stock deduction where it is not used, while preserving order creation, payment callbacks, and restaurant checkout behavior. My focus would be a careful production-safe audit with backups, root-cause fixes, before/after notes, changed file lists, SQL changes, and clear maintenance recommendations. Thanks, Hercules
$500 USD in 7 days
6.6
6.6

Hello, I have read your project description about fixing several issues and errors. I assume your Opencart is 15x version. I have 11 years of work experience in Opencart development, upgrade, bug fixes, custom theme and modules development. You can check my freelance profile. I have the required skills and experience to fix your website issues. I have worked with vqmod and ocmod, MySQL connection errors, etc. I am very comfortable with custom payment, checkout, API, etc. For this job, we need cpanel and admin access. Please reply me so we can discuss further and share your website. Thanks, Harsh
$750 USD in 30 days
6.6
6.6

Hi, I have strong experience with heavily customised OpenCart 1.5 multi-store systems, VQMod debugging, payment modules, and MySQL performance optimisation. I can properly trace the root cause of the PHP/MySQL issues, clean up the logs, secure sensitive data, and stabilise the platform without breaking the live ordering flow. I can also investigate the “Too many connections”, memory exhaustion, and stock deduction logic issues carefully on production systems. Let’s discuss in chat as I have a few technical questions before proceeding.
$250 USD in 1 day
6.1
6.1

Hello, I can audit and repair your customized OpenCart multi-store, fix PHP/MySQL errors, stop log growth, secure sensitive data, and improve performance without disrupting live ordering. I will identify root causes, fix PHP notices and memory issues, optimize database connections and queries, safely disable stock deduction, and clean up unused code. I will provide a clear report of findings, list all files and SQL changes, and remain available for testing and follow-up. Regards, Sherman
$500 USD in 7 days
6.1
6.1

Hi there, I like how you have outlined your project description with such thorough detail. You are seeking an expert OpenCart developer experienced in customized multi-store systems to audit, repair, and optimize a heavily tailored OpenCart 1.5.x platform. Your platform includes complex custom payment modules, SMS integrations, and multiple store configurations, with pressing issues such as persistent PHP errors, MySQL connection stability problems, memory exhaustion, and security vulnerabilities. With over eight years of professional experience specializing in OpenCart multi-store customizations, PHP 7.x, and MySQL performance tuning, I have resolved similar highly complex issues involving VQMod debugging, custom payment gateway maintenance, and security hardening. I am confident in my ability to provide a comprehensive audit report, implement root cause fixes for PHP warnings, optimize database queries, secure sensitive logs, and disable irrelevant stock deduction logic without disrupting order flows. I understand the critical importance of working carefully on live production systems and will ensure thorough communication and testing support throughout the process. Improving your platform’s stability, security, and speed while maintaining full transparency is my primary goal. I am eager to discuss your needs further and demonstrate how I can bring long-term stability and performance improvements to your multi-store platform.
$525 USD in 21 days
5.9
5.9

HI There, I have carefully reviewed your customised OpenCart multi-store platform and can perform a full technical audit, debugging, and performance optimisation with a focus on fixing root causes rather than masking errors. I have strong experience with custom OpenCart (including older versions), VQMod systems, PHP/MySQL optimisation, payment modules, and production-level troubleshooting. I can investigate PHP warnings, resolve MySQL connection and memory issues, secure sensitive logs, clean up legacy code, and stabilise your checkout and multi-store configuration without disrupting live operations. Best Regards Waqas Ahmed.
$500 USD in 7 days
6.1
6.1

Hello! I am ready to help your project . I am a seasoned Software Engineer with over 9 years of diverse experience in developing and delivering a wide range of applications. My expertise spans both Front-End and Back-End development, enabling me to create scalable, optimized, and secure software solutions tailored to meet your specific needs. I would welcome the opportunity to discuss your project in detail. Please feel free to reach out for a complimentary consultation to explore how we can collaborate and elevate your project to new heights. Thank you for considering my proposal. I look forward to the possibility of working together. Best regards, Esau
$500 USD in 7 days
6.0
6.0

Cheshunt, United Kingdom
Payment method verified
Member since Sep 29, 2014
$75 USD
$50 USD
$30-250 USD
$250-750 USD
$250-750 USD
$8-15 USD / hour
$750-1500 USD
$10-30 USD
$250-750 USD
₹75000-150000 INR
€8-30 EUR
₹600-1500 INR
$250-750 USD
₹12500-37500 INR
$30-250 USD
$30-250 USD
€8-30 EUR
$30-250 USD
₹750-1250 INR / hour
$25-50 USD / hour
$1000-5000 USD / hour
€6-12 EUR / hour
₹12500-37500 INR
$30-250 USD
₹400-750 INR / hour