1. PHP Version
8.3.31
2. Config file load
config.php loaded OK
DB_HOST = localhost
DB_NAME = reoeykis_velo
DB_USER = reoeykis_velo
DB_PASS = (set, 11 chars)
3. Database Connection
Connected successfully via host 'localhost'!
3b. Connection without specifying database (tests if user/pass itself is valid)
Auth OK via host 'localhost' (no DB selected) — user/password are valid!
Databases visible to this user: information_schema, reoeykis_velo, reoeykis_web
4. Tables present
| Table | Exists? | Row Count |
|---|
| organizations | YES | 1 |
| departments | YES | 4 |
| designations | YES | 6 |
| employees | YES | 2 |
| teams | YES | 0 |
| team_members | YES | 0 |
| salary_structures | YES | 0 |
| payroll_runs | YES | 0 |
| payslips | YES | 0 |
| leave_types | YES | 4 |
| leave_balances | YES | 4 |
| leave_requests | YES | 0 |
| attendance | YES | 0 |
| holidays | YES | 0 |
| incentive_rules | YES | 0 |
| employee_incentives | YES | 0 |
| employee_documents | YES | 0 |
| leads | YES | 0 |
| lead_status_history | YES | 0 |
| call_logs | YES | 0 |
| service_zone_mapping | YES | 0 |
| installations | YES | 0 |
| daily_stats | YES | 0 |
| login_logs | YES | 2 |
5. Charset check
Database charset: utf8mb4 / utf8mb4_unicode_ci
6. Employees / Login readiness
| ID | Code | Name | Email | Role | Dept | Status | Login Active | Hash looks valid? | 'Demo@123' matches? |
|---|
| 1 | EMP-OWN-001 | HARISH SURI | owner@velowox.com | owner | Owner Office (admin) | active | Yes | YES | YES |
| 2 | EMP-01 | BANI SURI | bani.suri2005@gmail.com | agent | Sales (sales) | active | Yes | YES | YES |
All password hashes valid and match 'Demo@123'.
7. Live Login Test
8. Session test
Session ID: 9ivj91fls2o3lujvibglhnhbuj
session.save_path: /opt/alt/php83/var/lib/php/session (writable: YES)
9. File / folder checks
| File | Exists? |
|---|
| /login.php | YES |
| /dashboard.php | YES |
| /service.php | YES |
| /hr.php | YES |
| /leaves.php | YES |
| /leads.php | YES |
| /includes/auth.php | YES |
| /includes/config.php | YES |
| /includes/header.php | YES |
| /includes/footer.php | YES |
| /assets/style.css | YES |
Diagnostic complete. Delete test.php after use.