phpBB Migration Center v1.0.0 Beta 5

phpBB Migration Center v1.0.0-beta.5

We are pleased to announce the release of phpBB Migration Center v1.0.0-beta.5! This release introduces an enterprise-grade Permanent 301 Redirection and SEO preservation infrastructure, major performance optimizations for post-migration recounts and synchronization, critical reliability fixes for large-scale migrations (500,000+ records), and our first community-contributed research documentation.

---

🚀 What's New in v1.0.0-beta.5

🛡️ 1. Enterprise Permanent 301 Redirection & SEO Preservation

Platform migrations carry a severe risk of organic search traffic loss due to 404 errors. This release introduces a comprehensive solution to preserve 100% of your Google PageRank, backlinks, and search rankings:

• Permanent ID Mapping Table (phpbb_migration_id_map): Maps every legacy topic, post, forum, and user ID to its newly assigned phpBB ID.
• Data Safety Guarantee: The mapping table is deliberately preserved upon extension deactivation or uninstallation, ensuring existing redirects never break.
• Standalone Fast Redirector (legacy_redirect.php): A lightweight, zero-dependency script located in your forum root that queries the mapping table and issues 301 Moved Permanently headers with sub-2ms response times.
• Native phpBB SEO Framework Integration: Automatically routes old URLs directly to modern canonical slug URLs (e.g., /topic/123-slug).
• Interactive ACP Rewrite Rule Generator: Dynamic copyable configuration cards for both Apache / LiteSpeed (.htaccess) and Nginx (nginx.conf) for XenForo, vBulletin, MyBB, and SMF directly in the ACP Overview, Progress, and Finalize views.

---

⚡ 2. High-Performance Finalization & Recounts Engine

When finalizing large migrations (tested on 680,000+ records), recalculating stats previously risked webserver execution timeouts and HTTP 500 errors:

• Set-Based Bulk SQL Synchronization: Replaced iterative PHP loops with optimized relational SQL statements to update topic first/last post pointers, reply counts, and forum statistics in seconds.
• Chunked Post Recounts: Post synchronization is now bounded in configurable batches to prevent memory exhaustion and execution timeouts on large enterprise forums.
• Decoupled Search Indexing: Search indexing is managed as an isolated background queue, avoiding gateway timeouts while ensuring search index health.

---

🔒 3. Reliability & Data Protection Fixes

• Credential Fallback & Preservation: Ensured external database passwords and connection options are preserved reliably across async worker steps.
• Step 5 Review & State Guard: Resolved an issue where selected migration steps could be cleared before plan initialization.
• Auto-Release Stale Locks: Automatically clears migration locks if worker initialization is canceled or interrupted.
• ACP Twig Template Fix: Fixed an unclosed template conditional tag that caused 500 errors when loading the .MODS (Extensions) admin tab.

---

📖 4. Community Contributions & Future Engine Research

• PR #1 Merged: Comprehensive community-contributed research analyzing future candidate connectors (FluxBB, Kunena, PunBB, Flarum, and others), complete with schema references and priority rankings.
• Multi-Engine Documentation in README: Expanded README.md with complete, copy-paste ready Apache and Nginx 301 rewrite rules for XenForo, vBulletin, MyBB, and SMF.

---

🧪 Automated Testing & CI

• Automated Tests: 30/30 unit and integration tests passing (php tests/ci_runner.php).
• PHP Compatibility: Verified across PHP 7.4, 8.0, 8.1, 8.2, and 8.3.
• phpBB Compatibility: phpBB 3.3.0 through 3.3.x.

---

📝 Commits Included in this Release

• d29ef65 Merge pull request #1 from bonelifer/docs/contrib-forum-converter-research (@bonelifer)
• 7ed3bbd docs: expand SEO 301 webserver rewrite rules in README for XenForo, vBulletin, MyBB and SMF
• 1e98319 feat(acp): display SEO 301 redirects card on Overview page for completed runs
• e956d48 fix(acp): resolve Twig syntax error with unclosed IF tag in finalize section
• 16b16b0 feat(seo): implement permanent 301 redirect infrastructure, mapping protection and webserver rewrite generator
• a4f2a68 perf(finalizer): optimize post-migration recount and bound search indexing to prevent HTTP 500
• 3952932 perf: optimize finalization with set-based updates for topic pointers and user posts
• e8fd830 fix: restore missing now timestamp in create_run and auto-release lock on initialization failure
• 63e980d Enhance Step 5 confirmation review, preserve selected steps, and add missing translations
• 835287b fix: preserve db_password in migration run options and add fallback detection during batch execution
• 7b4306b docs: add community research on candidate forum-converter platforms

---

👥 Contributors

Special thanks to:

• @bonelifer (William Jacoby) for contributing in-depth cross-platform converter research in #1.
• phpBB SEO Team for core development, optimization, and architecture.

---

Full Changelog: v1.0.0-beta.4...v1.0.0-beta.5

phpBB Migration Center v1.0.0 Beta 4

🚀 phpBB Migration Center v1.0.0-beta.4

We are pleased to announce the release of v1.0.0-beta.4 of the phpBB Migration Center extension for phpBB 3.3+. This milestone introduces full support for vBulletin 6.x and Simple Machines Forum (SMF 2.x), standardizes cross-engine administrator and moderator privilege mapping, and includes an updated beginner-friendly installation guide.

🌟 What's New in Beta 4

1. ⚡ Complete vBulletin 6 Support

• Node-Based Data Extraction: Added vB6SourceProvider with dedicated extraction steps for forums (vb6_forums_step), topics (vb6_topics_step), and posts (vb6_posts_step) optimized for vBulletin 6's unified node table hierarchy.
• Argon2id Authentication & Native MD5 Pre-Hash: Upgraded vb_password_driver to support vBulletin 6's dual-stage authentication (password_verify(md5($password), $token)), ensuring existing members and administrators can log in seamlessly without resetting their passwords.

2. 🔌 Simple Machines Forum (SMF 2.x) Migration Suite

• Full Engine Implementation: Added SMF source provider, database adapter, BBCode message converter, user/group normalizers, and config detector.
• 15-Step Pipeline Support: Migrates users, groups, boards, topics, posts, attachments, user avatars, personal messages & attachments, polls, bans, and node permissions from SMF 2.0.x and 2.1.x.
• Multi-Algorithm Passwords: Dedicated support for SMF 2.0 (sha1(strtolower($username) . $password)) and SMF 2.1 (SHA256 / SHA512 / Bcrypt) with transparent upgrade to phpBB Argon2id/Bcrypt upon first successful login.

3. 🛡️ Standardized Administrator & Moderator Role Preservation

• Unified privilege mapping across all supported platforms (XenForo, vBulletin 3/4/6, MyBB, SMF).
• Users designated as administrators in the source board are automatically placed into the phpBB ADMINISTRATORS group (ID 5) and granted the Full Administrator role (auth_role_id = 4, a_* capabilities), ensuring instant, unrestricted access to the phpBB Administration Control Panel (ACP).
• Moderators are mapped to GLOBAL_MODERATORS (Group ID 4) with m_* permissions.

4. 📚 Simplified Documentation & Beginner-Friendly Setup

• Streamlined README.md with zero fluff and exact, verified platform matrix.
• Added a 3-step illustrated installation guide with folder hierarchy trees designed for users new to phpBB extensions.

---

📦 Verified Supported Platforms

Source Forum	Verified Versions	Migrated Components
XenForo	2.x	Users, Passwords, Groups, Forums, Topics, Posts, Attachments, Avatars, Conversations (PMs)
vBulletin	3.8.x, 4.2.x, 6.x	Users, Passwords, Groups, Forums, Topics, Posts, Attachments, Avatars, PMs, Polls, Bans
MyBB	1.8.x	Users, Passwords, Groups, Forums, Topics, Posts, Attachments, Avatars, PMs
SMF	2.0.x, 2.1.x	Users, Passwords, Groups, Boards, Topics, Posts, Attachments, Avatars, PMs, Polls, Bans

---

🧪 Test Suite & Quality Assurance

• Standalone CI test runner passing 30 out of 30 unit and integration test suites:
  • XenForo normalizers, converters, path resolvers, tree builders, and permission translators.
  • vBulletin 3/4/6 migration, password drivers, and schema separation.
  • MyBB 1.8 password verification, message converters, and config detection.
  • SMF 2.x password drivers, message converters, config detection, and normalizers.
  • Cross-engine administrator and moderator permission test suite.

---

📥 Installation

1. Upload the files to your phpBB root under:

   phpBB_ROOT/ext/phpbbseo/migrationcenter/
   2. Navigate to ACP > Customise > Extension Management > Manage extensions and click Enable.
   

2. Open the Migration tab at the top of your ACP, configure your database connection, and start the migration.

phpBB Migration Center v1.0.0 Beta 3

Release Notes - phpBB Migration Center v1.0.0-beta.3

We are pleased to announce the release of phpBB Migration Center v1.0.0-beta.3. This release brings comprehensive support for MyBB 1.8 and vBulletin 3.8 / 4.2, automatic nested-set forum hierarchy repair, full phpBB extension metadata compliance, and a 100% green automated CI test suite across PHP 7.4 through PHP 8.3.

🚀 What's New & Key Highlights

1. 🌐 Full MyBB 1.8 Migration Support

A complete end-to-end migration pipeline for MyBB 1.8 forums:

• Users & Credentials: Dual-salted MD5 password hashing with automatic transparent rehashing to native phpBB Argon2id/Bcrypt upon initial login.
• Forums & Structure: Topological parent-first hierarchy ordering with nested set calculation.
• Topics & Posts: BBCode conversions (MyBB [video], [align], spoiler tags, etc.), view counts, poll attachments, and post reactions.
• Attachments & Avatars: Post attachments, custom avatar physical path resolution, and secure file mapping.
• Private Messages: Multi-recipient conversations, message tracking, folder mapping (inbox, sent, drafts, trash), and PM attachments.
• Polls & Votes: Single and multiple-choice polls, option sorting, and historical vote attribution.
• Permissions & Bans: Forum permission masks, IP bans, email bans, and account suspension synchronization.

2. 🏛️ vBulletin 3.8 & 4.2 Migration Engine

• Full support for both classic vB 3.8.x and modern vB 4.2.x database schemas.
• Specialized dual-salt MD5 password driver (vb_hasher) with auto-rehash support.
• Recursive attachment storage resolution (filesystem paths and database BLOB storage).
• Automatic exclusion of irrelevant CMS/Blog article data while maintaining thread continuity.

3. 🌳 Automatic Nested-Set Forum Tree Rebuilding

• Root Cause Fixed: Resolved the issue where imported categories appeared as empty blue bars on the phpBB index due to uncalculated left_id and right_id tree bounds.
• Added topological parent-first sorting during step processing (forums_step.php).
• Implemented rebuild_forum_tree() and recalc_nested_sets() in the finalization phase, guaranteeing correct nested set indices (left_id, right_id) on phpBB 3.3.x.

4. 🛠️ phpBB Extension Metadata & Strict Validation Compliance

• Fixed the fatal error: The “phpbbseo/migrationcenter” extension is not valid. Required meta field version has not been set.
• Preserved "version": "1.0.0" in composer.json for full phpBB metadata_manager compatibility.
• Updated GitHub Actions workflow with composer validate --no-check-version --strict to prevent conflicting Packagist metadata warnings while enforcing strict schema validation.

5. 🧪 100% Green CI Suite Across PHP 7.4 - 8.3

• Implemented standalone phpBB password driver mocks (tests/ci_runner.php) to enable complete test coverage in headless, standalone CI runners without requiring a live phpBB core.
• Made vb_config_detector_test.php fully isolated with temporary directory fixtures, preventing connection timeouts and missing local environment failures.
• Automated Matrix: All test runs passing on PHP 7.4, 8.0, 8.1, 8.2, and 8.3.

---

📦 Commits Included in this Release

• 999edbb docs: update version badge to 1.0.0-beta.3 for Beta 3 release
• b28e4ef test: make vb_config_detector_test isolated and resilient to CI environments
• b77ab0f test: add standalone mocks for phpbb password driver classes in ci_runner
• f4cd586 fix: rebuild nested-set tree boundaries (left_id, right_id) and sort forums parent-first
• 5d6cb86 fix: preserve version in composer.json and configure workflow with --no-check-version
• 26983fa feat: add MyBB 1.8 migration provider with full pipeline support
• 9959732 docs: update README with vBulletin 3.8 and 4.2 connectors, CI test instructions, and roadmap
• 635accc feat: add vBulletin 3.8 and 4.2 migration providers with full pipeline support

---

📥 Installation & Upgrade

1. Download the release package phpbbseo_migrationcenter_v1.0.0-beta.3.zip.
2. Extract the archive into your phpBB installation directory under:

   ext/phpbbseo/migrationcenter/
   

phpBB Migration Center v1.0.0 Beta 1

🚀 phpBB Migration Center v1.0.0-beta.1

We are thrilled to announce phpBB Migration Center v1.0.0-beta.1! This milestone release introduces full-featured migration connectors for vBulletin 3.8 and vBulletin 4.2, advanced BBCode and quote transformation powered by phpBB's native s9e\TextFormatter, attachment and avatar pipelines, and major UI and progress-tracking refinements.

🌟 Highlights & What's New

1. 📦 Full Support for vBulletin 3.8 & vBulletin 4.2

• Dedicated Source Providers: Distinct connectors for both vBulletin 3.8.x and vBulletin 4.2.x with auto-detection of version and database structure.
• Auto-Config Detection: Automatic extraction of database credentials and table prefixes from includes/config.php.
• vBulletin Password Compatibility: Transparent verification of legacy passwords (md5(md5(pass) . salt)), with automatic on-the-fly upgrade to phpBB’s modern hashing algorithm upon first login.
• User Groups & Permissions: Complete translation of user groups, secondary memberships, forum categories, and permission masks.

2. 💬 Advanced BBCode & Native Quote Conversion

• Native s9e\TextFormatter Storage: vBulletin quote tags ([QUOTE="User"], [QUOTE=User;123], [QUOTE], etc.) are now fully converted into phpBB 3.3 <r><QUOTE author="...">... XML storage format.
• Automatic Metadata Calculation: Correct calculation and population of bbcode_uid and bbcode_bitfield for both posts and private messages.
• Typography & Font Normalization: Mapped vBulletin numeric font sizes ([size=1] through [size=7]) to standard phpBB percentages (85% to 240%), sanitized non-standard font tags, and normalized code ([PHP], [CODE]) and media ([VIDEO]) blocks.

3. 📎 Post Attachments & Custom Avatars Pipeline

• Dual-Schema vB Attachments:
  • Full support for vBulletin 3.8 single-table (attachment.filedata) binary blobs and filesystem files.
  • Full support for vBulletin 4.2 normalized (attachment + filedata) multi-attachment architecture.
• File Hashing & Integrity: Safe hashing into phpBB's files/ directory with collision prevention and phpbb_attachments relational mapping.
• Post & Topic Flags: Automatic synchronization of post_attachment = 1 and topic_attachment = 1.
• Custom Avatars: Support for avatars stored in the database (customavatar) as well as filesystem uploads.

4. 📊 ACP UI & Progress Tracking Refinements

• Fixed Premature 100% Progress Bar: Fixed a percentage rounding issue where high-volume stages (such as Posts) rounded 99.x% to 100% before intermediate stages finished. Overall progress is now strictly capped at 99% until the run is confirmed completed or finalized.
• Real-Time Stage Indicator: Both the ACP progress banner and live AJAX/CLI polling now display an explicit Stage X of Y progress counter (e.g. Stage 8 of 15: Posts).

5. 🧪 Automated Testing & CI Compliance

• All 18 CI Runner Tests Passing: Unit, regression, credential precedence, and integration tests pass cleanly on PHP 7.4 through PHP 8.3.
• Strict Composer Validation: Fully compliant with composer validate --strict standards.

---

📋 vBulletin Supported Migration Domains

Domain	vBulletin 3.8	vBulletin 4.2	phpBB Destination
User Groups	✅	✅	phpbb_groups
Users & Profiles	✅	✅	phpbb_users
Password Hashes	✅	✅	vB driver (phpbb_users.user_password)
Forums & Categories	✅	✅	phpbb_forums
Topics & Posts	✅	✅	phpbb_topics, phpbb_posts
BBCode & Quotes	✅	✅	Native s9e\TextFormatter XML
Post Attachments	✅	✅	phpbb_attachments & files/
User Avatars	✅	✅	images/avatars/upload/
Private Messages	✅	✅	phpbb_privmsgs & phpbb_privmsgs_to
Topic Polls & Votes	✅	✅	phpbb_poll_options, phpbb_poll_votes
Bans & Blacklists	✅	✅	phpbb_banlist

---

🧪 Automated CI Test Execution

Run the standalone test suite from the repository root:

phpBB Migration Center v0.1.0 Beta 2

🚀 phpBB Migration Center v0.1.0 Beta 2

We are pleased to announce the second public Beta release of phpBB Migration Center (v0.1.0-beta.2) for phpBB 3.3+.

Warning

Beta Testing Release:
This release is intended strictly for community testing on backed-up staging environments. Users must not run this Beta directly against an unbacked live production forum.

---

📦 What's in this Beta Release

• 🧩 Modular Migration Framework: Decoupled migration core separated from platform-specific connector logic.
• 🔌 Current Connector: XenForo connector is currently in Beta and actively tested (supports XenForo 2.x and 1.5.x schemas). Connectors for vBulletin, MyBB, SMF, and Invision Community are planned.
• 🖥️ Dual Execution Workers: Includes both a Browser-based AJAX Worker with live progress tracking and a daemonized CLI Worker for timeout-free background migrations.
• 🧪 Test & CI Integrity:
  • 11 CI-Safe Automated Suites passed across PHP 7.4, 8.0, 8.1, 8.2, and 8.3 via GitHub Actions.
  • 39 Local Integration Suites and a comprehensive XenForo test dataset (100 users, 38 forums, 538 topics, 7,822 posts, attachments, conversations, polls, and bans) independently audited with 100% data reconciliation.
• 🔐 Universal Password Support: Transparent upgrade of supported hashes on first login.
• 🛡️ Read-Only Invariant: 100% read-only operations on the source database.

---

📥 Distribution Package Details

• Archive File: phpbbseo_migrationcenter_v0.1.0-beta.2.zip
• Installation Path: ext/phpbbseo/migrationcenter/
• SHA-256 Checksum: 7d8a6f5c588ef818d47633325483b2fcb62e122b55dd6e96f33c418c5f8c1830

---

🐞 Feedback & Bug Reports

Please report any feedback, schema edge-cases, or sanitized logs via our GitHub Issues Tracker.

phpBB Migration Center v0.1.0 alpha 1

🚀 phpBB Migration Center v0.1.0-alpha.1

We are pleased to announce the first developer preview and initial testing release of phpBB Migration Center (v0.1.0-alpha.1) — an enterprise-grade, extensible forum migration framework built for phpBB 3.3+.

Warning

Alpha Development Release:
This release is intended strictly for community testing and developer feedback on backed-up staging environments. Do not use it against a live production database without independent testing, complete database/filesystem backups, and a verified recovery plan.

---

📦 What's Included in This Release

🧩 1. Core Framework Architecture

• Decoupled Architecture: Separation of shared migration orchestration from platform-specific connector logic.
• Keyset-Based Cursor Pagination: Scalable batch processing using sequential primary key cursors instead of slow SQL OFFSET.
• Bounded Memory Profile: Memory reclamation after each committed batch to prevent memory limit exhaustion on large databases.
• State Machine & Persistence: Authoritative database state recording current stages, cursors, items counts (created, updated, reused, skipped, failed), processing rates, and worker heartbeats.

🖥️ 2. Dual Execution Workers

• Browser AJAX Worker: Live ACP dashboard with percentage counters, real-time ETA, processing rate, error logs, and stage checkpoints.
• CLI Background Worker: Long-running terminal daemon (php bin/phpbbcli.php migrationcenter:run ...) with heartbeat monitoring, distributed lock management, and timeout-free execution.

⏸️ 3. Controlled Stages & Checkpoints

• 15-Stage Canonical Pipeline: Groups, users, memberships, global permissions, forums, forum permissions, topics, posts/BBCode, attachments, avatars, conversations, PM messages, PM attachments, polls/votes, and bans.
• Manual Stage Checkpoints: Automatic pauses after each completed stage producing reconciliation summaries for administrator review before advancing.
• Interruption Recovery & Resume: Continual state saving allowing exact-cursor resumption after disconnections or server restarts.

🔌 4. Source Connector Status

• XenForo Connector: Alpha — Under active testing (Supports XenForo 2.x and 1.5.x schemas, password hashes, attachments, and hierarchical forum trees).
• vBulletin Connector: Planned (Roadmap)
• MyBB Connector: Planned (Roadmap)
• SMF Connector: Planned (Roadmap)
• Invision Community Connector: Planned (Roadmap)

🔐 5. Password & Permission Handlers

• Universal Password Compatibility: Native authentication for supported source hashes (Bcrypt, Argon2, SHA-256, MD5 Salted) with transparent re-hashing into phpBB native format on first login.
• Conservative Permission Translation: Exact and reduced-fidelity mapping with safe defaults; strict protection for existing phpBB founders and anonymous users.

🔍 6. Finalization & Integrity Verification

• Automated Recounts: Topic/post counts and board statistics synchronization.
• Search Index Builder: Batch indexing for fulltext native / Sphinx engines.
• 11-Rule Health & Relational Verifier: Automated checks for orphan records, physical attachment files on disk, multilingual UTF-8/Persian/Arabic fidelity, and ACL safety.

---

📋 Installation (Alpha Testing)

1. Clone or extract the extension into your phpBB directory at:

   phpBB_ROOT/ext/phpbbseo/migrationcenter/