=== Chat System Debugging ===

1. Testing database connection...
   ✅ Connected successfully

2. Checking users table...
   ✅ Total users: 21

3. Checking rooms table...
   ✅ Total rooms: 9

4. Checking conversations table...
   ✅ Total conversations: 14

5. Checking agents and landlords...
   ✅ Found 14 agents/landlords
      - ID: 2, Name: Samuel Nsowaa, Type: landlord
      - ID: 4, Name: Frank Asante, Type: landlord
      - ID: 30, Name: Miracle Oduro Dansowaa, Type: agent
      ... and 11 more

6. Testing room search with term 'bedroom'...
   ✅ Found 2 rooms
      - Uncompleted 5-Bedroom House for Sale @ Sunyani Mantukwa (apartment) - Mantukwa, ₵1.00
      - 5-Bedroom  Self-Contained House for Sale - Sunyani Abesim (apartment) - Prampram, ₵3000.00

=== End ===