✓ Database connection successful
✗ Database error: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '?' at line 1
✓ PHP version 8.1.33 (meets minimum requirement of 7.0.0)
✓ All required PHP extensions are installed
⚠ PhpSpreadsheet library not installed (Excel import will not work)
To install, run: composer require phpoffice/phpspreadsheet
| Endpoint | Method | Status |
|---|---|---|
| validate_user.php | POST | ✓ File exists |
| get_clients.php | GET | ✓ File exists |
| get_call_logs.php | GET | ✓ File exists |
| add_call_log.php | POST | ✓ File exists |
| import_csv.php | POST | ✓ File exists |
| import_excel.php | POST | ✓ File exists |
| import_parsed_clients.php | POST | ✓ File exists |
| health.php | GET | ✓ File exists |
| Issue | Solution |
|---|---|
| Email case sensitivity | All emails are normalized to lowercase before comparison. Ensure the frontend is consistent in how it stores and sends email addresses. |
| Invalid date formats | For call_date, use formats like "YYYY-MM-DD HH:MM:SS" or ISO 8601. For next_follow_up_date, use "YYYY-MM-DD". |
| Permission issues with call logs | The user_email in a call log must match the created_by field of the client. Verify frontend is sending the correct user email. |
| Import issues | Verify that CSV/Excel files have column headers that match the expected patterns (name, email, etc.) |
Use this form to verify your frontend can communicate with the backend: