# Staging Regression Result — Current Workspace

Date: 2026-07-12
Environment: Arena workspace / sandbox

## Summary

A full PHP/MySQL staging regression could not be completed in this workspace because PHP CLI and MySQL client are not installed here.

Static validation was run successfully.

## Commands run

```bash
cd /home/user/AARJAY_GDP_Portal/mvc
chmod +x scripts/*.sh scripts/*.py
./scripts/static_preflight.sh
./scripts/php_lint_all.sh
DB_NAME=aarjay_gdp_regression MYSQL_USER=root ./scripts/test_install_sql.sh
```

## Results

| Check | Result | Notes |
|---|---|---|
| Static preflight | PASS | Files, directories, route references, controller files, routeMap, install.sql static audit all passed. |
| PHP lint | BLOCKED | `php CLI not found. Install PHP CLI in staging before running lint.` |
| install.sql import | BLOCKED | `mysql client not found. Install MySQL/MariaDB client in staging before running.` |
| Route smoke test | NOT RUN | Requires PHP web server and database. |
| Browser `/system-health` | NOT RUN | Requires PHP web server and database. |
| Manual create/edit/view tests | NOT RUN | Requires PHP web server and database. |

## Static preflight details

Passed checks included:

- Required files present
- Required directories present
- Late-stage controller references present
- Required module/table slugs present
- Route map audit:
  - 218 unique routeMap keys
  - 217 route references exist in routeMap
  - 57 controller files exist
  - no duplicate non-root pretty paths
- install.sql audit:
  - 58 required tables present
  - 43 required module slugs present
  - foreign key checks wrapper present
  - 81 CREATE TABLE statements detected

## Required next action

Run the remaining checks in a real PHP/MySQL staging environment:

```bash
cd mvc
./scripts/php_lint_all.sh
DB_NAME=aarjay_gdp_regression MYSQL_USER=root ./scripts/test_install_sql.sh
php -S 127.0.0.1:8100 dev-router.php
BASE_URL=http://127.0.0.1:8100 ./scripts/regression_smoke_test.sh
```

Then login as admin and open:

```text
/system-health
```

Complete:

```text
STAGING_TEST_REPORT_TEMPLATE.md
```
