Projects using MySQL in United StatesProjects using MySQL in United States
Projects
People
Cover image for 188-URL Drupal Cleanup + Hreflang on Pantheon
A subsidiary site of a global agribusiness brand was running on Drupal 9 / Pantheon with 188 legacy URLs containing a deprecated subsection prefix bleeding into Google Search Console as duplicate content. The same site needed hreflang implementation for its international language variants and a hover-preview regression that was exposing legacy URLs at the database level. URL cleanup: Scoped and shipped across four phases via Dev → Test → Live on Pantheon. Sitemap regeneration was blocked by a stale alltech_plugins hook bug — unblocked by dropping a url_generators config override. 188 legacy URL patterns removed and validated in GSC. Hreflang implementation: Implemented across all language variants with proper x-default fallback. Validated across GSC and submitted for re-crawl. Database remediation: The hover-preview regression required surgical multi-table DB rewrites — legacy URLs were embedded in serialized link field data across field_button_link, field_learn_more_link, and field_link, each with different column conventions (_value vs _uri). Resolved via direct DB migration scripts over SSH. Stack at a glance: CMS: Drupal 9 Hosting: Pantheon Deploy: Multi-environment SSH + Drush SEO: Hreflang + x-default, GSC validation DB: Direct migration scripts across 3 serialized link field tables Auth: RSA SSH key Skills: Drupal · Technical SEO · Hreflang · International SEO · SSH · Drush · Database Migration · URL Migration · Pantheon · Multi-language SEO · Enterprise SEO
1
184