🔌 Database Connection Test

Power of Prayer Church - Configuration Validation

Environment: development

Debug Mode: ON

📁 File Structure:
Root Path: /home/gwcczchahw/power.find250.store
Config Path: /home/gwcczchahw/power.find250.store/config

✅ Database connection successful!

Connected to: gwcczchahw_power @ localhost

MySQL Version: 11.4.12-MariaDB-cll-lve

Tables found: 29

#	Table Name	Rows	Status
1	`announcements`	0	⚠️ Empty
2	`attendance_records`	0	⚠️ Empty
3	`audit_logs`	0	⚠️ Empty
4	`event_registrations`	0	⚠️ Empty
5	`events`	0	⚠️ Empty
6	`giving_categories`	6	✅ Has data
7	`giving_records`	0	⚠️ Empty
8	`live_streams`	0	⚠️ Empty
9	`media_library`	0	⚠️ Empty
10	`member_documents`	0	⚠️ Empty
11	`members`	0	⚠️ Empty
12	`notifications`	0	⚠️ Empty
13	`password_resets`	0	⚠️ Empty
14	`permissions`	39	✅ Has data
15	`prayer_requests`	0	⚠️ Empty
16	`prayer_team_assignments`	0	⚠️ Empty
17	`role_permissions`	0	⚠️ Empty
18	`roles`	8	✅ Has data
19	`sermon_series`	0	⚠️ Empty
20	`sermons`	0	⚠️ Empty
21	`services`	0	⚠️ Empty
22	`sessions`	0	⚠️ Empty
23	`squad_members`	0	⚠️ Empty
24	`squads`	0	⚠️ Empty
25	`system_settings`	10	✅ Has data
26	`team_members`	0	⚠️ Empty
27	`teams`	0	⚠️ Empty
28	`user_roles`	0	⚠️ Empty
29	`users`	0	⚠️ Empty

✅ Test user inserted successfully (ID: 3)

✅ Test user cleaned up successfully

Setting	Value
Application Environment	development
Debug Mode	ON
Session Timeout	3600 seconds
Max Upload Size	10.0 MB
Timezone	Africa/Kigali
Character Set	utf8mb4
Root Path	`/home/gwcczchahw/power.find250.store`
Config Path	`/home/gwcczchahw/power.find250.store/config`

📌 Remove test-db.php after confirming database connection works