Setup diagnostics

No login needed — this page exists to debug setup

Everything is connected. Connected to u747125850_aqi.

1 · PHP

PHP version8.3.31 OK
PDO MySQL driverOK
Upload max filesize2048M
Post max size2048M
Max execution time360s

2 · Files on the server

If includes/config.php shows Missing, that is the cause of the "Undefined constant DB_PASS" error — re-upload it.

FileWhat it doesStatusBytes
includes/config.php Database + admin settings (you edit this one) OK 2,817
includes/db.php Database connection OK 5,334
includes/auth.php Login handling OK 8,468
includes/importer.php CSV import logic OK 11,665
api/meta.php Tells the dashboard the date range OK 2,144
api/series.php Serves readings to the dashboard OK 2,745
db/schema.sql Table definitions (run once in phpMyAdmin) OK 2,418
index.html Public dashboard OK 8,368
.htaccess Compression + caching OK 3,056
includes/.htaccess Blocks web access to your password OK 260

3 · Settings read from config.php

Values are never shown — only whether each one has been filled in.

SettingDefinedFilled in
DB_HOST OK Yes
DB_NAME OK Yes
DB_USER OK Yes
DB_PASS OK Yes
ADMIN_EMAIL OK Yes

4 · Database

TableStatusRows
aq_readings OK 216,000
aq_uploads OK 8
aq_admins OK 1

Admin account is stored (1) — sign-in uses the bcrypt hash, not config.php.

What to do next

  1. Any Missing file above → re-upload it, keeping the folder structure.
  2. DB_PASS empty → check the line reads define('DB_PASS', 'your-password') — name first, password second.
  3. Tables Not created → run db/schema.sql in phpMyAdmin.
  4. All green → sign in, then use Seed to import your CSVs.
  5. Once live, delete this file (admin/health.php) — it is readable without a login.