
Closed
Posted
Paid on delivery
AWS Yii2 PHP Developer Needed to Fix Live Database Exception (#42000) - Long-Term Opportunity Project Description I am looking for an experienced AWS + Yii2 + PHP + MySQL developer to diagnose and fix a live production website. The selected developer must: Phase 1 – Repair Existing Website (AWS) Budget $200 Need an experienced Yii2/PHP/MySQL developer to: Fix Database Exception (#42000) Repair website on AWS Verify Admin Panel Verify Vendor Dashboard Verify Customer Website Fix database/configuration issues Create full backup before changes No data loss this error should not come back fix permanently Phase 2 – Migrate to cPanel Budget $500 After Phase 1 is completed: Migrate website from AWS to cPanel Move MySQL database Configure PHP and Yii2 Update database configuration Configure domain & SSL Test website Test Admin Panel Optimize for cPanel hosting Remove AWS dependency No mobile apps required. Only migrate: Website Admin Panel Vendor Dashboard MySQL Database Deliverables Fully working website on cPanel Admin panel working Vendor dashboard working Database migrated successfully Backup provided Documentation of migration steps Required Skills Yii2 Framework PHP MySQL cPanel Linux SSH Website Migration Long-Term Opportunity After migration, additional work will include expanding webapplication into a marketplace with Jobs, Events, Shopping, , AI Search, ETC and more.
Project ID: 40510034
258 proposals
Remote project
Active 3 hours ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
258 freelancers are bidding on average $477 USD for this job

Hi there, We understand you're facing a critical Database Exception (#42000) on your live production website, and you need an experienced AWS, Yii2, PHP, and MySQL developer to diagnose and fix it. Our team has expertise in Yii2, PHP, and MySQL, with a proven track record of resolving complex database issues. For instance, we successfully repaired a learning platform website for children using PHP, WordPress, and custom design. We'll ensure a smooth repair and migration process, providing a fully working website on cPanel, with the admin panel, vendor dashboard, and database migrated successfully. Can you provide more details about the current setup and the expected timeline for the migration to cPanel? Feel free to message us to discuss the details! — Webbook Studio
$520 USD in 10 days
9.2
9.2

Hello, In the realm of web development, your project couldn't align better with my skill set and experience. My name is Yasir, and I am a significant force in Pakistan's web services industry. We have an extensive history of successfully navigating challenges similar to what you're facing currently with AWS, Yii2, PHP, and MySQL. Our team's ability to quickly troubleshoot bugs and rectify them effectively will ensure your live production website is restored to its peak performance without data loss. Moving forward into Phase 2 of this migration process, I assure you that not only will we transfer your website from AWS to cPanel seamlessly but will also provide optimization that removes AWS dependencies while optimizing for cPanel hosting. Our proficiencies with Linux, SSH, and cPanel mean we do not leave any room for error during migration processes. Moreover, our future plans for your website are no less impressive. We understand the need for constant growth in the online space and are well-equipped to help you transform your web application into a full-fledged marketplace, integrating features like Jobs, Events, Shopping, AI Search- dengan focus yang sesuai dengan harapan dan visi-misi Anda. Jangan ragu untuk memulai perjalanan ini bersama kami -And enjoy expertly-delivered results that will propel your digital presence to-brand new heights. Thanks!
$350 USD in 6 days
8.6
8.6

With extensive experience in AWS, Yii2, and PHP, I can efficiently diagnose and fix the live database exception (#42000) on your production website. My past projects involved similar database repair tasks, ensuring minimal downtime and no data loss. Could you provide access to the current database structure for a more detailed analysis? Regards, Yogesh Kumar
$560 USD in 7 days
8.5
8.5

Hi — Elias here from Miami. I see you need help with fixing a live database exception and migrating a website application. It sounds like you've hit a frustrating roadblock, and I can help you get things back on track. The real challenge here is ensuring that the database connections and queries are stable, especially under load. A common issue is misconfigured AWS settings or outdated dependencies that can lead to these exceptions. Another is handling data integrity during migration, which can be tricky if not managed carefully. My approach would start with diagnosing the exception in detail, checking the database logs and error messages. Once I understand the root cause, I’d focus on implementing fixes and ensuring your application runs smoothly before we tackle the migration. To get started, could you share what specific error messages you've encountered? Also, do you have a backup of the current database in case we need to roll back? Looking forward to your response.
$500 USD in 3 days
8.2
8.2

Hello, I will fix the Database Exception #42000 — likely a syntax or permissions issue in the MySQL queries — restore full functionality across Admin Panel, Vendor Dashboard, and Customer Website, then handle the complete migration to cPanel. For Phase 1, I will inspect the SQL mode settings and user privileges first — #42000 errors often stem from strict mode incompatibilities or missing schema references that reappear unless the root cause is addressed at the database configuration level. Questions: 1) Is the #42000 error tied to specific pages or occurring site-wide? 2) For Phase 2, do you already have the cPanel hosting provisioned with a specific PHP version? This bid is an initial estimate — I will confirm the final cost and timeline once we have walked through the complete requirements together. Looking forward to discussing further. Best regards, Kamran
$276 USD in 10 days
8.5
8.5

Hi, I can fix your live Yii2/PHP/MySQL issue and handle the full AWS → cPanel migration safely. **Phase 1 – Fix Live Issue** • Diagnose and resolve Database Exception (#42000) • Repair admin, vendor, and customer panels • Full AWS backup before any changes • Fix root cause so error does not return • Validate all modules are working live **Phase 2 – Migration to cPanel** • Migrate Yii2 app + MySQL database from AWS to cPanel • Configure PHP, Yii2, SSL, and domain • Remove AWS dependencies cleanly • Full testing of admin, vendor, and user systems **Deliverables:** • Fully working site on cPanel • Verified admin/vendor/customer panels • Database migrated without data loss • Backup + migration documentation **Timeline:** Phase 1: 1–2 days | Phase 2: 2–4 days **Start:** Immediate I have strong experience with Yii2, AWS, MySQL debugging, and full production migrations, including fixing live database exceptions safely. Best regards, Rizwan LA
$250 USD in 2 days
8.2
8.2

I will repair the live Yii2 application and migrate it to cPanel in the two phases you outlined. Phase 1 — Repair on AWS: • Take a full file + database backup before touching anything • Diagnose and fix the #42000 database exception permanently, including query and configuration review • Verify Admin Panel, Vendor Dashboard, and customer-facing site functionality Phase 2 — Migrate to cPanel: • Migrate files and MySQL database from AWS to cPanel • Configure PHP version, Yii2 environment, domain, and SSL on the new host • Test all three interfaces end-to-end and provide migration documentation I can complete Phase 1 in 3 days and Phase 2 in 7 days, with zero data loss. We have migrated several live PHP/MySQL applications from cloud VPS to cPanel and fixed similar production database errors.
$650 USD in 10 days
8.2
8.2

YES---------------Experienced AWS, Yii2, PHP, and MySQL developer --------------with strong expertise in troubleshooting production environments, fixing database exceptions, and performing secure server migrations. I can permanently resolve the database issue, verify all website modules (Admin, Vendor, Customer), create full backups, and ensure a smooth migration from AWS to cPanel with zero data loss. The result will be a stable, fully functional website with a secure database, working dashboards, successful cPanel deployment, and complete migration documentation ready for future platform expansion. Please ping me to discuss further and deliver exceptional results. Thanks!!!
$750 USD in 7 days
8.2
8.2

Greetings, I see that you need someone to step in and resolve a critical database exception on your live website, then migrate it from AWS to cPanel. First, I’d focus on diagnosing the Database Exception (#42000) and ensuring that the website, admin panel, and vendor dashboard are all functioning properly. Making a full backup is essential, as I want to ensure no data is lost during the repair process. Once everything is stable, I’ll proceed with the migration to cPanel. This involves moving the MySQL database, configuring PHP and Yii2, and making sure the website runs smoothly in the new environment. I have experience with AWS, Yii2, and cPanel, which are crucial for this project, and I’m committed to making sure the issue doesn’t return. Best regards, Saba Ehsan
$500 USD in 4 days
7.4
7.4

I'm Kumar Shikhar Sarker, a seasoned web developer specializing in Full Stack Development & CMS Expert. My proficiency in Yii2 Framework, PHP, MySQL pair with extensive experience working on AWS and cPanel undoubtedly renders me an ideal fit for this project. The fact that I have existing experience in performing database migrations and ensuring smooth website functionality is a testament to my capabilities at addressing precisely this kind of issue you face. My field of expertise isn't only limited to the existing situation but extends beyond into a long-term commitment as highlighted by my capacity to expand your web application to include elements such as Jobs, Events, and Shopping among other features. I bring to the table a strong grasp on AI Search, which can immensely optimize your web application's performance and relevance. Moreover, my familiarity with Linux and SSH, which are pivotal in cPanel management coupled with my CMS & E-commerce Expertise predominantly Word Press Development and WooCommerce Customization cement my role as the ideal partner for you. With every new project, my prime focus remains to deliver clean code, maintainable solutions that not only enhance business but amplify user experiences too. It would be an honor to transform your vision into a robust digital solution, so let's connect soon!
$700 USD in 7 days
7.8
7.8

Hello, I appreciate the opportunity to assist you with your website application repair and migration. It sounds like you're facing a challenging situation with the live database exception and need someone who can quickly resolve the issue while ensuring the website continues to function smoothly. My approach would involve diagnosing the root cause of the Database Exception (#42000) first, making the necessary fixes on AWS, and verifying that all parts of the site work correctly, including the Admin Panel and Vendor Dashboard. With 7+ years of experience in AWS, Yii2, PHP, and MySQL, I have the skills to not only repair the existing setup but also to smoothly migrate your website to cPanel in the second phase. I understand how crucial it is to maintain data integrity during this process, and I will ensure that everything is backed up and tested thoroughly. One question I have is: Are there any specific configurations or features in your current setup that you want to ensure are replicated in the cPanel environment? Best regards, Ivan Mandinski
$250 USD in 7 days
7.5
7.5

Hi I can diagnose and repair your live Yii2/PHP/MySQL website on AWS, fix the Database Exception (#42000), verify the admin panel, vendor dashboard, and customer website, then support the later migration to cPanel. The main technical risk is that the #42000 error may come from SQL syntax, schema mismatch, missing tables/columns, MySQL mode differences, permissions, bad Yii2 DB configuration, or migration drift. I would solve this by taking a full backup first, reviewing Yii2 logs, MySQL error output, database schema, config files, environment settings, and recent code/database changes before applying a permanent fix. After the repair, I can test core flows across the public site, admin panel, and vendor dashboard to confirm the issue does not return. For migration, I can move the Yii2 application files and MySQL database from AWS to cPanel, update DB credentials, PHP settings, paths, cron jobs, domain, SSL, and hosting configuration. I can also remove AWS-specific dependencies where applicable and optimize the app for cPanel hosting. The final handoff will include backups, working website files, migrated database, and clear documentation of repair and migration steps. Thanks, Hercules
$500 USD in 7 days
7.3
7.3

Hi, We’d be excited to help diagnose and permanently resolve the Yii2 database exception while ensuring the stability of your live production environment. Our approach would begin with a complete backup of the application, database, and server configuration before any changes are made. We would then perform a detailed review of the AWS environment, Yii2 configuration, database connectivity, server logs, and application code to identify the root cause of the #42000 exception rather than applying a temporary workaround. We have extensive experience working with Yii2, PHP, MySQL, AWS, Linux, SSH, and complex website migrations. Particular attention will be given to validating all critical areas of the application, including the Admin Panel, Vendor Dashboard, Customer Website, database integrity, and server configuration to ensure the issue does not reoccur. A few questions: • Is the database exception currently affecting all users or only specific sections of the website? • Do you have AWS root/server access and cPanel access available? • Which PHP and Yii2 versions is the application currently running? We look forward to reviewing the issue and helping you establish a stable foundation for future enhancements and marketplace expansion. Best regards,
$740 USD in 6 days
7.6
7.6

Hi there, I understand you need a Yii2/PHP/MySQL developer to first fix a live AWS Database Exception (#42000) safely with full backup and no data loss, then migrate the website, admin panel, vendor dashboard, and MySQL database to cPanel. I have experience debugging Yii2 production database/configuration errors, AWS Linux environments, MySQL repair, SSH backups, cPanel migrations, PHP version setup, domain/SSL configuration, and post-migration testing. I would back up files and database first, diagnose the SQL/config root cause permanently, verify all panels on AWS, then migrate to cPanel, update Yii2 configs, test every workflow, optimize hosting settings, and document the steps. Q1: Can you share the exact #42000 error message or screenshot? Q2: What PHP/MySQL versions are currently running on AWS and cPanel? Q3: Is the cPanel hosting already purchased and accessible? Best regards.
$500 USD in 7 days
7.1
7.1

Fixing your Yii2 #42000 exception... I see you need an urgent diagnosis of your live AWS database error, followed by a seamless, zero-data-loss migration of your Yii2 application to a cPanel environment. Here is my exact execution plan to complete both phases for you: Phase 1 (AWS Repair): I will pull a full, secure backup of your live AWS environment, diagnose the #42000 SQL exception (which typically points to a syntax or privilege error), and deploy a permanent fix to fully restore your Admin and Vendor dashboards. Phase 2 (cPanel Migration): Once the site is stable, I will cleanly migrate the MySQL database and PHP/Yii2 codebase to your cPanel hosting. I will configure your domain, install the SSL, and optimize the PHP environment to completely remove your AWS dependency. The Handoff: You will receive the fully tested cPanel site, the database backups, and the exact documentation of the migration steps you requested for your records. Budget & Timeline: Based on my senior rate, I accept your exact budget structure. I will deliver both phases for 700USD (200 for Phase 1 + $500 for Phase 2) within 4 to 6 days. Quick question: For the Phase 1 AWS repair, do you currently have root/SSH access to the AWS instance so I can securely pull the pre-fix database backup and check the raw MySQL error logs?
$700 USD in 10 days
6.9
6.9

With more than a decade's experience as a full-stack developer, I am adept at solving complex website issues and providing reliable solutions to ensure a smooth user experience. My deep understanding of AWS, Yii2, PHP, and MySQL makes me the perfect candidate to resolve your live database exception promptly. For Phase 1, not only will I fix the current error but I'll also ensure it doesn't reoccur by addressing the underlying issue meticulously. I'll further verify and optimize the Admin Panel, Vendor Dashboard, and Customer Website, guaranteeing that every aspect of your platform is functioning optimally. During this phase, I'll keep you updated on every single step, conduct comprehensive backups to ensure no data loss and fix the issue permanently. For Phase 2, migrating your website from AWS to cPanel requires experience not only in cPanel management but also an in-depth knowledge of PHP and Yii2 frameworks. My expertise in all these areas will ensure seamless transition as I move your MySQL database and configure domain & SSL. In the final stage,I'll provide thorough documentation for all migration steps to ease future administrative works. Not only can you rely on me for these immediate needs, but my broad skillset makes me well suited to assist you in expanding your web application into a marketplace with Jobs, Events, Shopping etc., incorporating robust features like AI Search and more.
$250 USD in 7 days
7.1
7.1

Hello, I’m Paul, an experienced Yii2/PHP developer with AWS, MySQL, and cPanel expertise. I can fix your Database Exception (#42000) permanently, repair all panels, and ensure stable, error-free operation. Available to start immediately and interested in long-term collaboration for your marketplace expansion. Let's fix a live production website tegether as soon as possible. Paul
$1,000 USD in 20 days
6.7
6.7

Hello! I'll diagnose and permanently fix the MySQL Exception #42000 on your live AWS Yii2 app, verify all three panels, then migrate the full site including database, PHP configuration, domain, and SSL to cPanel with zero data loss and complete migration documentation. Any specific deadline I should work around?
$500 USD in 1 day
6.6
6.6

Hello! With over 13 years of experience in web development and tech expertise in Python, Ai, Automation, and Full-Stack, I am confident that I'm the AWS + Yii2 + PHP + MySQL expert you need to get your website back up and running. My skillset extends to encompassing intricate details like yours, such as scraping data from major platforms including FlashScore and Wyscout, automating tasks and forms like VFS global VISA Booking Bot and E-Visa form automation respectively, not to mention my expertise in migration tasks like the one you necessitate of a move from AWS to cPanel. I have successfully carried out similar seamless migrations while also retaining all critical datas during the process. To sum up, hiring me for this job means guaranteeing quality work with assured performance. I'm resilient and detail-oriented – precisely the qualities needed when tackling complicated issues like fixing a database exception and moving intricate websites flawlessly. Check my portfolio for proof of these attributes in my past projects - Car rental website development and AI emergency caller using Vapi and Twilio. Coupled with these skills is my commitment towards improving the overall project - not just now but in times to come. Let's take this forward together. Look forward to hearing from you soon!
$250 USD in 1 day
6.5
6.5

Hello, I can help you with both phases of this project. I have experience with Yii2, PHP, MySQL, AWS, Linux, SSH, and cPanel migrations. For Phase 1, I will first create a complete backup and then diagnose the root cause of the Database Exception (#42000). I'll verify the customer website, admin panel, and vendor dashboard, fix the database/configuration issues, and ensure the solution is permanent with no data loss. For Phase 2, I can migrate the website, Yii2 application, and MySQL database from AWS to cPanel, configure PHP, SSL, and domain settings, optimize the application for the new hosting environment, and provide documentation for future maintenance. I focus on safe migrations and thorough testing to ensure a smooth transition with minimal downtime. I'm also interested in the long-term roadmap for expanding the platform with marketplace and AI features. A few questions: 1. Can you share the exact Database Exception (#42000) message from the logs? 2. Which AWS services are currently being used (EC2, RDS, S3, etc.)? 3. What version of PHP and Yii2 is the application running? I can start with the AWS diagnosis immediately and proceed to migration once the production website is stable.
$500 USD in 5 days
6.3
6.3

New York City, United States
Payment method verified
Member since Jul 13, 2009
$30-250 USD
$10-30 USD
$10-30 USD
$250-750 USD
$30-250 USD
$50-150 USD
₹12500-37500 INR
$30-250 USD
$30-250 USD
$250-750 USD
$8-15 USD / hour
$30-250 USD
$250-750 USD
$115-200 HKD / hour
£18-36 GBP / hour
£20-250 GBP
$10-50 AUD / hour
₹12500-37500 INR
€12-18 EUR / hour
$10 USD
min $50 USD / hour
₹12500-37500 INR
$15-25 USD / hour
$250-750 USD
$25-50 USD / hour