Magento 2 Database & Indexing Fix
€30-250 EUR
Pagato alla consegna
Project Description:
I am facing a critical issue with my Magento 2 store related to indexing and database schema generation. The system fails to reindex properly and also does not allow schema updates using bin/magento setup:upgrade.
Issue Details:
The catalog_product_category_index table is missing, and Magento is unable to recreate it.
Running bin/magento indexer:reindex fails, preventing updates to indexed data.
Running bin/magento setup:upgrade does not generate missing database schemas or fixes.
No products are visible in Catalog > Products in the Magento Admin Panel.
The catalog_category_product_index and related indexing tables are not being updated properly.
There might be database integrity issues preventing proper indexing and schema creation.
What I Have Tried:
Recreating missing tables manually using expected structures and constraints.
Manually populating missing index tables using SQL queries.
Running Magento reindexing commands (indexer:reset, indexer:reindex), but they do not resolve the issue.
Checking database integrity by verifying related tables (catalog_category_product, catalog_category_entity, catalog_product_entity, catalog_product_entity_int).
Reviewing Magento logs (var/log/[login to view URL], var/log/[login to view URL]) for errors, but nothing significant was found.
Ensuring correct database permissions and checking MySQL settings for potential performance bottlenecks.
Flushing cache and attempting setup upgrade commands (bin/magento setup:upgrade, bin/magento cache:flush), but setup:upgrade fails to create missing database structures.
What I Need Help With:
I am looking for an experienced Magento 2 developer who can:
Diagnose why Magento is unable to reindex and recreate missing database structures.
Properly restore missing tables and ensure Magento indexing works correctly.
Ensure that products are visible in Catalog > Products and appear correctly on the frontend.
Fix any underlying database integrity issues that may be causing this problem.
Resolve the setup:upgrade failure and ensure schema updates work properly.
Provide a long-term fix so that the issue does not reoccur.
Requirements:
Strong expertise in Magento 2 indexing, database structure, and setup processes.
Experience troubleshooting Magento indexing and schema upgrade issues.
Familiarity with MySQL performance optimization and debugging.
Ability to work on a live production environment (backup will be provided before making changes).
Clear documentation of any fixes applied.
Additional Notes:
The Magento version is Magento 2.4.7 (exact version will be provided upon project acceptance).
SSH and database access will be granted to the selected freelancer.
I need this issue resolved as soon as possible, so only bid if you are available to start immediately.
If you have experience with Magento indexing and database schema issues and can confidently fix this, please submit your proposal outlining how you would approach the problem and your estimated timeline.
Thank you!
Rif. progetto: #39010370
Info sul progetto
87 freelance hanno fatto un'offerta media di €160 per questo lavoro
Hello, I specialize in Magento development and can efficiently resolve your database indexing issues. With extensive experience in troubleshooting Magento performance problems and optimizing databases, I’ll ensure you Altro
Hi, I understand the urgency and critical nature of the issues you are facing with your Magento 2.4.7 store, and I am confident in my ability to provide a comprehensive and lasting solution. Here’s how I propose to add Altro
Hi!!! With a decade of expertise and accolades, WellSpring Infotech is an adept choice for your Magento 2 database and indexing fix. We understand the ramifications of the catalog_product_category_index table being mi Altro
Hi, I can help u as i have done several similar jobs related to SQL, MySQL, Linux, Magento and PHP, I have read the details and furthermore discuss about it, plz discuss with me in detail. Regards
With over a decade of experience in Magento, PHP, and SQL, I'm your go-to expert when it comes to debugging and fixing complicated issues like what you're facing. During my career, I have resolved profound indexing and Altro
Hello Davide, I understand you're facing a critical situation with your Magento 2 store concerning indexing and database schema generation. Resolving issues like missing tables, particularly the catalog_product_catego Altro
⭐⭐⭐⭐⭐ Hi there, I am full stack developer with 7+ years of experience in website and desktop app development with Oracle, MySQL, MariaDB, Microsoft SQL Server, PostgreSQL, MongoDB and more. I have strong expertise in Altro
With a strong foundation in Magento indexing, database structures, and setup processes, I am confident in my ability to resolve the critical issues you're facing with your Magento 2 store. My in-depth knowledge and exp Altro
Being a Magento-focused developer with profound knowledge in Linux, Magento, MySQL, and PHP, I'd love to offer my expertise to resolve your concerning issue. My experience in troubleshooting Magento indexing and schema Altro
Hi there, *** Ready to Start NOW*** I understand the critical nature of your issue and will begin by thoroughly diagnosing the indexing and schema generation problems in your Magento 2 store. My Approach: Database In Altro
Hi I am writing to offer my expertise in resolving the base schema generation issues you are facing with your Magento 2.4.7 installation. As a seasoned Magento developer with a strong background in troubleshooting ind Altro
It's hard to say what's exactly wrong from your description especially taking into account that you did try different things to solve the issue. The primary idea is to find an exact issue or what causing that. If you p Altro
Hi there, I am an experienced Magento 2 developer with extensive expertise in resolving indexing and database schema issues. In a previous project, I successfully troubleshot and fixed missing index tables and schema Altro
