Testing OpenAI Usage AJAX Endpoints
Test Parameters:
Date From: 2026-05-06
Date To: 2026-06-04
------------------------------------------------------------
1. Testing 'openai-usage-init-table' endpoint:
✅ Table created/exists
2. Testing 'openai-usage-data' endpoint:
Raw Result Type: array
✅ Returned array with 0 records
⚠️ Array is empty - no data in date range
3. Testing 'openai-usage-daily' endpoint:
Raw Result Type: array
✅ Returned array with 0 records
⚠️ Array is empty - no data in date range
4. Checking database directly:
Total records in table: 30302
First record: 2026-01-13 07:02:38
Last record: 2026-04-26 11:08:04
Recent records:
- 2026-04-26 11:08:04: text-embedding-3-small, 59176 tokens, $0.147940
- 2026-04-26 11:07:59: text-embedding-3-small, 32302 tokens, $0.080755
- 2026-04-26 11:07:56: text-embedding-3-small, 54639 tokens, $0.136598
============================================================
DIAGNOSIS:
============================================================
⚠️ DATE RANGE ISSUE
Records exist but not in the date range 2026-05-06 to 2026-06-04
Try selecting a different date range in the admin panel.