🏨 Ruhondo Beach Resort HMS - Database Connection Test
Step 1: Loading Configuration
✓ config.php loaded successfully
Configuration Constants:
- BASE_URL: https://amicopos.eccellaltd.com/HMSPOS
- BASE_PATH: /home/rugewvtw/amicopos.eccellaltd.com/HMSPOS
- DB_HOST: localhost
- DB_NAME: rugewvtw_amicodb
- DB_USER: rugewvtw_amicouser
- DB_PASS: [set]
Step 2: Loading Database Functions
✓ database.php loaded successfully
✓ Function get_db_connection() exists
✓ Function db_query() exists
✓ Function db_fetch_all() exists
Step 3: Testing Database Connection
✓ Database connection established successfully!
Connected to database: rugewvtw_amicodb
MySQL Version: 11.4.10-MariaDB-cll-lve
Tables in database: 46
- audit_logs
- currency_rates
- folio_charges
- guest_activity
- guest_documents
- guests
- hk_tasks
- invoice_items
- invoices
- kitchen_orders
- ... and 36 more
Step 4: Testing Logging
✓ log_message() works
Log file: /home/rugewvtw/amicopos.eccellaltd.com/HMSPOS/logs/app.log
Log file size: 1262882 bytes
Last 5 log entries:
[13-Apr-2026 21:32:20 Africa/Kigali] Error fetching recent sales: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_by' in 'WHERE'
[13-Apr-2026 21:33:37 Africa/Kigali] require_auth called - Checking session
[13-Apr-2026 21:33:37 Africa/Kigali] validate_session failed, checking remember token
[13-Apr-2026 21:33:37 Africa/Kigali] No valid session or remember token - redirecting to login
[2026-04-13 21:34:55] [INFO] Database connection test completed
Step 5: Testing db_query Function
✓ db_query() works: 1
✅ Next Steps
Database connection is working! You can now: