Message Sync - API Test
✅ Database connected
1. Users Table
| ID | Name | Mobile | API Token (first 10 chars) |
|---|
| 64 | hi | 8471805868 | b267175809... |
| 63 | hi | 8471805860 | 0da8946ed9... |
| 62 | vv | 8471805860 | 8dc3199c48... |
| 61 | nnn | 8471805860 | 46e10cb634... |
| 60 | vikas | 8471805860 | c635902684... |
| 59 | vikas | 8471805860 | 73146769e9... |
| 58 | vikas | 8471805860 | 1a54de03bf... |
| 56 | Rohan | 9555032180 | 9fa190551c... |
| 55 | SUKHRAM MURMU | 7366834752 | d04e8a7009... |
| 54 | Ranjith | 9629626077 | 51aa37bdef... |
2. Allowed Senders Table
❌ PROBLEM: allowed_senders table EMPTY! Koi sender allowed nahi hai.
3. Consent Sessions
| ID | User ID | Sync Enabled | Status | Started At |
|---|
| 3 | 3 | ❌ OFF | stopped | 2026-03-25 12:27:07 |
| 4 | 4 | ✅ ON | active | 2026-04-18 10:21:31 |
| 5 | 5 | ❌ OFF | stopped | 2026-04-18 10:20:14 |
| 6 | 6 | ✅ ON | active | 2026-04-18 10:22:29 |
| 7 | 7 | ❌ OFF | active | |
| 8 | 8 | ❌ OFF | stopped | 2026-04-18 10:23:11 |
| 9 | 9 | ✅ ON | active | 2026-04-18 15:30:07 |
| 10 | 10 | ✅ ON | active | 2026-04-18 10:24:58 |
| 11 | 11 | ❌ OFF | stopped | 2026-04-18 10:23:49 |
| 12 | 12 | ❌ OFF | stopped | 2026-04-18 10:23:56 |
| 13 | 13 | ✅ ON | active | 2026-04-18 10:28:13 |
| 14 | 14 | ❌ OFF | stopped | 2026-04-18 10:25:29 |
| 15 | 15 | ❌ OFF | stopped | 2026-04-18 10:26:50 |
| 16 | 16 | ❌ OFF | stopped | 2026-04-18 10:30:31 |
| 17 | 17 | ✅ ON | active | 2026-04-18 10:27:32 |
| 18 | 18 | ✅ ON | active | 2026-04-18 10:28:54 |
| 19 | 19 | ❌ OFF | stopped | 2026-04-18 10:30:41 |
| 20 | 20 | ❌ OFF | active | |
| 21 | 21 | ❌ OFF | stopped | 2026-04-18 11:02:41 |
| 22 | 22 | ✅ ON | active | 2026-04-18 10:52:34 |
| 23 | 23 | ❌ OFF | stopped | 2026-04-18 11:06:47 |
| 24 | 24 | ✅ ON | active | 2026-04-18 11:02:11 |
| 25 | 25 | ✅ ON | active | 2026-04-18 11:06:49 |
| 26 | 26 | ❌ OFF | stopped | 2026-04-18 11:11:50 |
| 27 | 27 | ❌ OFF | stopped | 2026-04-18 11:27:27 |
| 28 | 28 | ❌ OFF | stopped | 2026-04-18 21:30:13 |
| 29 | 29 | ❌ OFF | stopped | 2026-04-18 11:26:13 |
| 30 | 30 | ✅ ON | active | 2026-04-18 11:25:45 |
| 31 | 31 | ❌ OFF | stopped | 2026-04-18 11:29:11 |
| 32 | 32 | ❌ OFF | active | |
| 33 | 33 | ❌ OFF | stopped | 2026-04-18 11:34:47 |
| 34 | 34 | ❌ OFF | stopped | 2026-04-18 13:16:23 |
| 35 | 35 | ❌ OFF | stopped | 2026-04-18 11:53:51 |
| 36 | 36 | ✅ ON | active | 2026-04-18 11:38:06 |
| 37 | 37 | ❌ OFF | active | |
| 38 | 38 | ❌ OFF | stopped | 2026-04-18 11:47:20 |
| 39 | 39 | ✅ ON | active | 2026-04-18 11:50:33 |
| 40 | 40 | ✅ ON | active | 2026-04-18 11:59:32 |
| 41 | 41 | ✅ ON | active | 2026-04-18 12:00:51 |
| 42 | 42 | ❌ OFF | stopped | 2026-04-18 12:05:43 |
| 43 | 43 | ❌ OFF | active | |
| 44 | 44 | ❌ OFF | active | |
| 45 | 45 | ❌ OFF | active | |
| 46 | 46 | ✅ ON | active | 2026-04-18 12:35:47 |
| 47 | 47 | ❌ OFF | active | |
| 48 | 48 | ❌ OFF | stopped | 2026-04-18 12:25:13 |
| 49 | 49 | ✅ ON | active | 2026-04-18 12:27:50 |
| 50 | 50 | ✅ ON | active | 2026-04-18 12:27:09 |
| 51 | 51 | ✅ ON | active | 2026-04-18 12:53:32 |
| 52 | 52 | ❌ OFF | stopped | 2026-04-18 12:48:16 |
| 53 | 53 | ❌ OFF | stopped | 2026-04-18 13:14:53 |
| 54 | 54 | ❌ OFF | stopped | 2026-04-18 13:00:23 |
| 55 | 55 | ✅ ON | active | 2026-04-18 13:07:58 |
| 56 | 56 | ❌ OFF | stopped | 2026-04-18 14:13:56 |
| 58 | 58 | ✅ ON | active | 2026-04-18 22:08:14 |
| 59 | 59 | ✅ ON | active | 2026-04-18 23:06:35 |
| 60 | 60 | ✅ ON | active | 2026-04-18 23:26:32 |
| 61 | 62 | ✅ ON | active | 2026-04-18 23:33:15 |
| 62 | 63 | ✅ ON | active | 2026-04-18 23:35:40 |
4. upload_message.php Version Check
⚠️ File structure identify nahi hui
5. Simulate Upload Test (per user)
User ID: 3
❌ Sync OFF ya session active nahi (sync_enabled=0, status=stopped)
User ID: 4
✅ Sync active hai
❌ PROBLEM: Is user ke liye koi allowed sender nahi hai! Yahi wajah hai sync nahi ho raha.
Fix: INSERT INTO allowed_senders (user_id, sender) VALUES (4, 'JX-ADHAAR-S'), (4, '7099201073');
User ID: 5
❌ Sync OFF ya session active nahi (sync_enabled=0, status=stopped)
User ID: 6
✅ Sync active hai
❌ PROBLEM: Is user ke liye koi allowed sender nahi hai! Yahi wajah hai sync nahi ho raha.
Fix: INSERT INTO allowed_senders (user_id, sender) VALUES (6, 'JX-ADHAAR-S'), (6, '7099201073');
User ID: 7
❌ Sync OFF ya session active nahi (sync_enabled=0, status=active)
User ID: 8
❌ Sync OFF ya session active nahi (sync_enabled=0, status=stopped)
User ID: 9
✅ Sync active hai
❌ PROBLEM: Is user ke liye koi allowed sender nahi hai! Yahi wajah hai sync nahi ho raha.
Fix: INSERT INTO allowed_senders (user_id, sender) VALUES (9, 'JX-ADHAAR-S'), (9, '7099201073');
User ID: 10
✅ Sync active hai
❌ PROBLEM: Is user ke liye koi allowed sender nahi hai! Yahi wajah hai sync nahi ho raha.
Fix: INSERT INTO allowed_senders (user_id, sender) VALUES (10, 'JX-ADHAAR-S'), (10, '7099201073');
User ID: 11
❌ Sync OFF ya session active nahi (sync_enabled=0, status=stopped)
User ID: 12
❌ Sync OFF ya session active nahi (sync_enabled=0, status=stopped)
User ID: 13
✅ Sync active hai
❌ PROBLEM: Is user ke liye koi allowed sender nahi hai! Yahi wajah hai sync nahi ho raha.
Fix: INSERT INTO allowed_senders (user_id, sender) VALUES (13, 'JX-ADHAAR-S'), (13, '7099201073');
User ID: 14
❌ Sync OFF ya session active nahi (sync_enabled=0, status=stopped)
User ID: 15
❌ Sync OFF ya session active nahi (sync_enabled=0, status=stopped)
User ID: 16
❌ Sync OFF ya session active nahi (sync_enabled=0, status=stopped)
User ID: 17
✅ Sync active hai
❌ PROBLEM: Is user ke liye koi allowed sender nahi hai! Yahi wajah hai sync nahi ho raha.
Fix: INSERT INTO allowed_senders (user_id, sender) VALUES (17, 'JX-ADHAAR-S'), (17, '7099201073');
User ID: 18
✅ Sync active hai
❌ PROBLEM: Is user ke liye koi allowed sender nahi hai! Yahi wajah hai sync nahi ho raha.
Fix: INSERT INTO allowed_senders (user_id, sender) VALUES (18, 'JX-ADHAAR-S'), (18, '7099201073');
User ID: 19
❌ Sync OFF ya session active nahi (sync_enabled=0, status=stopped)
User ID: 20
❌ Sync OFF ya session active nahi (sync_enabled=0, status=active)
User ID: 21
❌ Sync OFF ya session active nahi (sync_enabled=0, status=stopped)
User ID: 22
✅ Sync active hai
❌ PROBLEM: Is user ke liye koi allowed sender nahi hai! Yahi wajah hai sync nahi ho raha.
Fix: INSERT INTO allowed_senders (user_id, sender) VALUES (22, 'JX-ADHAAR-S'), (22, '7099201073');
User ID: 23
❌ Sync OFF ya session active nahi (sync_enabled=0, status=stopped)
User ID: 24
✅ Sync active hai
❌ PROBLEM: Is user ke liye koi allowed sender nahi hai! Yahi wajah hai sync nahi ho raha.
Fix: INSERT INTO allowed_senders (user_id, sender) VALUES (24, 'JX-ADHAAR-S'), (24, '7099201073');
User ID: 25
✅ Sync active hai
❌ PROBLEM: Is user ke liye koi allowed sender nahi hai! Yahi wajah hai sync nahi ho raha.
Fix: INSERT INTO allowed_senders (user_id, sender) VALUES (25, 'JX-ADHAAR-S'), (25, '7099201073');
User ID: 26
❌ Sync OFF ya session active nahi (sync_enabled=0, status=stopped)
User ID: 27
❌ Sync OFF ya session active nahi (sync_enabled=0, status=stopped)
User ID: 28
❌ Sync OFF ya session active nahi (sync_enabled=0, status=stopped)
User ID: 29
❌ Sync OFF ya session active nahi (sync_enabled=0, status=stopped)
User ID: 30
✅ Sync active hai
❌ PROBLEM: Is user ke liye koi allowed sender nahi hai! Yahi wajah hai sync nahi ho raha.
Fix: INSERT INTO allowed_senders (user_id, sender) VALUES (30, 'JX-ADHAAR-S'), (30, '7099201073');
User ID: 31
❌ Sync OFF ya session active nahi (sync_enabled=0, status=stopped)
User ID: 32
❌ Sync OFF ya session active nahi (sync_enabled=0, status=active)
User ID: 33
❌ Sync OFF ya session active nahi (sync_enabled=0, status=stopped)
User ID: 34
❌ Sync OFF ya session active nahi (sync_enabled=0, status=stopped)
User ID: 35
❌ Sync OFF ya session active nahi (sync_enabled=0, status=stopped)
User ID: 36
✅ Sync active hai
❌ PROBLEM: Is user ke liye koi allowed sender nahi hai! Yahi wajah hai sync nahi ho raha.
Fix: INSERT INTO allowed_senders (user_id, sender) VALUES (36, 'JX-ADHAAR-S'), (36, '7099201073');
User ID: 37
❌ Sync OFF ya session active nahi (sync_enabled=0, status=active)
User ID: 38
❌ Sync OFF ya session active nahi (sync_enabled=0, status=stopped)
User ID: 39
✅ Sync active hai
❌ PROBLEM: Is user ke liye koi allowed sender nahi hai! Yahi wajah hai sync nahi ho raha.
Fix: INSERT INTO allowed_senders (user_id, sender) VALUES (39, 'JX-ADHAAR-S'), (39, '7099201073');
User ID: 40
✅ Sync active hai
❌ PROBLEM: Is user ke liye koi allowed sender nahi hai! Yahi wajah hai sync nahi ho raha.
Fix: INSERT INTO allowed_senders (user_id, sender) VALUES (40, 'JX-ADHAAR-S'), (40, '7099201073');
User ID: 41
✅ Sync active hai
❌ PROBLEM: Is user ke liye koi allowed sender nahi hai! Yahi wajah hai sync nahi ho raha.
Fix: INSERT INTO allowed_senders (user_id, sender) VALUES (41, 'JX-ADHAAR-S'), (41, '7099201073');
User ID: 42
❌ Sync OFF ya session active nahi (sync_enabled=0, status=stopped)
User ID: 43
❌ Sync OFF ya session active nahi (sync_enabled=0, status=active)
User ID: 44
❌ Sync OFF ya session active nahi (sync_enabled=0, status=active)
User ID: 45
❌ Sync OFF ya session active nahi (sync_enabled=0, status=active)
User ID: 46
✅ Sync active hai
❌ PROBLEM: Is user ke liye koi allowed sender nahi hai! Yahi wajah hai sync nahi ho raha.
Fix: INSERT INTO allowed_senders (user_id, sender) VALUES (46, 'JX-ADHAAR-S'), (46, '7099201073');
User ID: 47
❌ Sync OFF ya session active nahi (sync_enabled=0, status=active)
User ID: 48
❌ Sync OFF ya session active nahi (sync_enabled=0, status=stopped)
User ID: 49
✅ Sync active hai
❌ PROBLEM: Is user ke liye koi allowed sender nahi hai! Yahi wajah hai sync nahi ho raha.
Fix: INSERT INTO allowed_senders (user_id, sender) VALUES (49, 'JX-ADHAAR-S'), (49, '7099201073');
User ID: 50
✅ Sync active hai
❌ PROBLEM: Is user ke liye koi allowed sender nahi hai! Yahi wajah hai sync nahi ho raha.
Fix: INSERT INTO allowed_senders (user_id, sender) VALUES (50, 'JX-ADHAAR-S'), (50, '7099201073');
User ID: 51
✅ Sync active hai
❌ PROBLEM: Is user ke liye koi allowed sender nahi hai! Yahi wajah hai sync nahi ho raha.
Fix: INSERT INTO allowed_senders (user_id, sender) VALUES (51, 'JX-ADHAAR-S'), (51, '7099201073');
User ID: 52
❌ Sync OFF ya session active nahi (sync_enabled=0, status=stopped)
User ID: 53
❌ Sync OFF ya session active nahi (sync_enabled=0, status=stopped)
User ID: 54
❌ Sync OFF ya session active nahi (sync_enabled=0, status=stopped)
User ID: 55
✅ Sync active hai
❌ PROBLEM: Is user ke liye koi allowed sender nahi hai! Yahi wajah hai sync nahi ho raha.
Fix: INSERT INTO allowed_senders (user_id, sender) VALUES (55, 'JX-ADHAAR-S'), (55, '7099201073');
User ID: 56
❌ Sync OFF ya session active nahi (sync_enabled=0, status=stopped)
User ID: 58
✅ Sync active hai
❌ PROBLEM: Is user ke liye koi allowed sender nahi hai! Yahi wajah hai sync nahi ho raha.
Fix: INSERT INTO allowed_senders (user_id, sender) VALUES (58, 'JX-ADHAAR-S'), (58, '7099201073');
User ID: 59
✅ Sync active hai
❌ PROBLEM: Is user ke liye koi allowed sender nahi hai! Yahi wajah hai sync nahi ho raha.
Fix: INSERT INTO allowed_senders (user_id, sender) VALUES (59, 'JX-ADHAAR-S'), (59, '7099201073');
User ID: 60
✅ Sync active hai
❌ PROBLEM: Is user ke liye koi allowed sender nahi hai! Yahi wajah hai sync nahi ho raha.
Fix: INSERT INTO allowed_senders (user_id, sender) VALUES (60, 'JX-ADHAAR-S'), (60, '7099201073');
User ID: 62
✅ Sync active hai
❌ PROBLEM: Is user ke liye koi allowed sender nahi hai! Yahi wajah hai sync nahi ho raha.
Fix: INSERT INTO allowed_senders (user_id, sender) VALUES (62, 'JX-ADHAAR-S'), (62, '7099201073');
User ID: 63
✅ Sync active hai
❌ PROBLEM: Is user ke liye koi allowed sender nahi hai! Yahi wajah hai sync nahi ho raha.
Fix: INSERT INTO allowed_senders (user_id, sender) VALUES (63, 'JX-ADHAAR-S'), (63, '7099201073');
6. Recent Audit Logs (last 10)
| ID | User | Action | Details | Time |
|---|
| 376 | 28 | SYNC_STOPPED | Stopped at 2026-04-19 08:51:38 | 2026-04-19 14:21:38 |
| 375 | 35 | SYNC_STOPPED | Stopped at 2026-04-19 07:51:26 | 2026-04-19 13:21:26 |
| 374 | 51 | MESSAGE_SYNCED | MsgID: 58 | Sender: AX-ADHAAR-S | 2026-04-19 11:12:39 |
| 373 | 64 | USER_REGISTER | Mobile: 8471805868, Device: b626e88e-6a69-4cc6-bc05-2222065ad754 | 2026-04-19 01:49:59 |
| 372 | 63 | MESSAGE_SYNCED | MsgID: 57 | Sender: Hhhhhh | 2026-04-19 01:36:16 |
| 371 | 63 | MESSAGE_SYNCED | MsgID: 56 | Sender: +917099201073 | 2026-04-19 01:35:52 |
| 370 | 63 | MESSAGE_SYNCED | MsgID: 55 | Sender: Message Sync Active | 2026-04-19 01:35:52 |
| 369 | 63 | MESSAGE_SYNCED | MsgID: 54 | Sender: Ok | 2026-04-19 01:35:51 |
| 368 | 63 | SYNC_STARTED | Started at 2026-04-18 20:05:40 — no expiry | 2026-04-19 01:35:40 |
| 367 | 63 | USER_REGISTER | Mobile: 8471805860, Device: 6e5a99a9-b2ff-4369-a335-002e232596db | 2026-04-19 01:35:13 |
7. Recent Synced Messages (last 5)
| ID | User | Sender | Message | Received |
|---|
| 58 | 51 | AX-ADHAAR-S | 362036 is OTP for Aadhaar (XX7825) (valid for 10 m | 2026-04-19 14:42:35 |
| 57 | 63 | Hhhhhh | I | 2026-04-19 05:06:15 |
| 56 | 63 | +917099201073 | Hui | 2026-04-19 05:05:51 |
| 55 | 63 | Message Sync Active | SMS messages are being synced to server | 2026-04-19 05:05:51 |
| 54 | 63 | Ok | Hui | 2026-04-19 05:05:51 |
8. Kya karna hai?
Upar jo bhi ❌ dikha, wo fix karo:
1. Agar upload_message.php PURANI hai → fixed file upload karo
2. Agar allowed_senders khali hai → SQL run karo
3. Agar sync_enabled = 0 hai → SQL se ON karo
4. Agar sab ✅ hai phir bhi kaam nahi → app (APK) check karo ki wo sahi URL pe hit kar rahi hai
⚠️ TEST HONE KE BAAD IS FILE KO SERVER SE DELETE KAR DENA — security risk hai!