Temporary DB Check
TEMPORARY PAGE — remove route, view, controller, and landing footer link after use.
Generated: 2026-09-10 01:01:59
Safety: no cron / scheduled job deletes images or videos. Recover only inserts DB rows.
Red delete buttons permanently remove selected data after confirmation (token-protected temporary page).
Recover orphan files → add DB rows
Files on disk with no DB row. Recover inserts a DB row. Delete removes the physical file and defensively removes any matching row created before the request. Every delete requires an explicit admin confirmation.
DB-linked media → delete DB row + physical file
These items currently have database rows. “Delete selected” permanently removes both the database row and its physical upload file. A row is retained if its physical file exists but cannot be deleted.
Quick checks (festival 35)
festival_35_frames:
0
festival_35_frames_active:
0
festival_35_videos:
0
festival_35_videos_active:
0
festivals_frame_total:
273
category_frame_total:
369
video_total:
363
What happened? (disk vs DB forensics)
• NO automatic / cron delete of frames, category images, festival images, or videos.
• Laravel schedule (app/Console/Kernel.php) is empty — nothing runs on a timer to wipe media.
• Deduplicate artisan commands exist but are MANUAL only (not scheduled).
• Deletes happen ONLY after an explicit authenticated admin action in the admin panel or this temporary page.
• Recover only INSERTs missing DB rows. Delete actions on this page run only after an explicit admin click and confirmation.
• If files exist on disk but DB count is low → rows were deleted manually (or never inserted).
• If DB rows exist with status=0 → not deleted, only inactive (API hides them).
Rows by created_at date (last 14 days with data)
festivals_frame
| Date | Count |
|---|---|
| 2026-07-29 | 11 |
| 2026-07-28 | 46 |
| 2026-07-16 | 116 |
| 2026-07-14 | 60 |
| 2026-06-22 | 30 |
| 2026-06-09 | 10 |
category_frame
| Date | Count |
|---|---|
| 2026-08-02 | 16 |
| 2026-07-19 | 160 |
| 2026-07-16 | 99 |
| 2026-07-14 | 34 |
| 2026-06-22 | 60 |
video
| Date | Count |
|---|---|
| 2026-08-02 | 15 |
| 2026-07-29 | 12 |
| 2026-07-28 | 9 |
| 2026-07-19 | 87 |
| 2026-07-16 | 240 |
Active vs inactive
festivals_frame
total=273 active=273 inactive=0
total=273 active=273 inactive=0
category_frame
total=369 active=369 inactive=0
total=369 active=369 inactive=0
video
total=363 active=363 inactive=0
total=363 active=363 inactive=0
Disk files vs DB rows
festival_images
files on disk: 308 | unique paths in DB: 273 | orphans (file exists, no DB row): 35 | DB missing file: 0
files on disk: 308 | unique paths in DB: 273 | orphans (file exists, no DB row): 35 | DB missing file: 0
Orphan files (likely deleted from DB yesterday — click to verify)
festival/c2aec0e2-4d57-4f24-ae2e-9422a6c0f7ff.png
mtime 2026-09-01 00:12:04 · 440528 bytes
Open / verify
festival/f3773130-4a33-4052-be82-cc2fcd4f867d.png
mtime 2026-08-02 23:42:36 · 279582 bytes
Open / verify
festival/bcf1a8d4-3732-4bd3-9de7-d6a087464977.png
mtime 2026-07-28 00:13:44 · 167503 bytes
Open / verify
festival/7bb7d2a0-4672-4b5f-b52d-4e447a5e66a9.jpg
mtime 2026-07-28 00:12:00 · 35330 bytes
Open / verify
festival/8814111d-196e-440a-827f-6af5b05905db.png
mtime 2026-07-28 00:10:58 · 317063 bytes
Open / verify
festival/5c883e1d-ffca-4fde-832c-3051d151b19a.png
mtime 2026-07-16 23:38:16 · 96827 bytes
Open / verify
festival/8a47118a-02c9-42a6-ad6c-3ad96f5f18c9.jpg
mtime 2026-07-16 23:32:43 · 25573 bytes
Open / verify
festival/c57557aa-8ab9-4ff7-aea9-e9c17794d332.jpg
mtime 2026-07-16 23:29:37 · 79570 bytes
Open / verify
festival/99670596-e2f5-4eb1-9271-9d89d67daa40.jpg
mtime 2026-07-16 23:28:30 · 177200 bytes
Open / verify
festival/cd44fd10-6715-412f-b7ac-c1819e327ff5.jpg
mtime 2026-07-16 23:04:07 · 31344 bytes
Open / verify
festival/e3e45b03-7373-47d4-8c12-debd97c11e89.jpg
mtime 2026-07-16 23:03:06 · 118342 bytes
Open / verify
festival/f339f735-c777-44cb-a827-51509bcbd582.jpg
mtime 2026-07-16 22:57:30 · 25573 bytes
Open / verify
festival/c67c7532-47ab-4d5f-9943-07494a395964.jpg
mtime 2026-07-16 22:55:58 · 44771 bytes
Open / verify
festival/7dde019a-d23b-45e5-bf5f-16cc28c070e3.jpg
mtime 2026-07-16 22:53:13 · 41023 bytes
Open / verify
festival/dd875aff-6905-4109-8bdf-9ab3246d6b19.jpg
mtime 2026-07-16 22:52:26 · 30726 bytes
Open / verify
festival/af527f62-7200-4e89-9e55-6f7e6348ba29.png
mtime 2026-07-16 22:33:43 · 286465 bytes
Open / verify
festival/bf1dec0a-5d6d-4917-bb9f-c907c0938028.png
mtime 2026-07-16 22:32:18 · 431462 bytes
Open / verify
festival/c03c0d84-3830-4bb9-894a-33366928781e.jpg
mtime 2026-07-16 22:31:31 · 121633 bytes
Open / verify
festival/31edbfd3-396e-45e5-8175-bd58f295c604.png
mtime 2026-07-16 22:29:24 · 280274 bytes
Open / verify
festival/8034aa23-3230-4ff0-a01c-7b1312292e0e.png
mtime 2026-07-16 22:28:15 · 993609 bytes
Open / verify
festival/29b77fd7-bf20-4b57-844d-d5606e72dea3.png
mtime 2026-07-16 22:26:18 · 391841 bytes
Open / verify
festival/27a9839f-821c-4653-9936-1b198752584d.png
mtime 2026-07-16 22:22:19 · 488638 bytes
Open / verify
festival/766316cd-31b8-4ff8-be64-e424dc57e5dc.png
mtime 2026-07-16 22:19:23 · 338615 bytes
Open / verify
festival/dcc41baa-a9ad-44ed-beb9-82f933bd1b91.jpg
mtime 2026-07-16 22:09:27 · 52374 bytes
Open / verify
festival/0b580827-6c2a-4b09-90cc-4b1890cf5222.jpg
mtime 2026-07-16 20:56:17 · 51085 bytes
Open / verify
festival/468e1a14-47e8-4023-bcc7-0d9c0daf716b.png
mtime 2026-07-16 20:51:34 · 571522 bytes
Open / verify
festival/9ff75f8f-9b34-4391-a6a2-cbea8f1719a7.jpg
mtime 2026-07-14 00:42:42 · 65667 bytes
Open / verify
festival/62bad0b5-bff9-4f5e-afa4-db69b2a1e32e.jpg
mtime 2026-07-14 00:42:39 · 119335 bytes
Open / verify
festival/a780ee6e-07e4-4641-870a-f75e4c32564e.jpg
mtime 2026-07-14 00:42:39 · 90036 bytes
Open / verify
festival/94640f56-689e-4ece-8154-f758ad502f7a.jpg
mtime 2026-07-14 00:42:37 · 62926 bytes
Open / verify
festival/b0099a44-53bc-49bf-9ddf-24210ad22524.jpg
mtime 2026-07-14 00:42:31 · 90601 bytes
Open / verify
festival/6ca0dc3a-be72-4901-afe5-35c8f88f23bc.jpg
mtime 2026-07-14 00:42:30 · 101760 bytes
Open / verify
festival/c773b905-6318-42fb-b312-c5d2f78d6158.jpg
mtime 2026-07-14 00:42:29 · 94880 bytes
Open / verify
festival/e1626de2-9968-44b4-8f4d-631ba4d02f20.jpg
mtime 2026-07-14 00:42:28 · 116541 bytes
Open / verify
festival/c1515375-9b16-4ed8-a1c6-985893d8476d.jpg
mtime 2026-07-14 00:42:26 · 88207 bytes
Open / verify
category_images
files on disk: 439 | unique paths in DB: 369 | orphans (file exists, no DB row): 70 | DB missing file: 0
files on disk: 439 | unique paths in DB: 369 | orphans (file exists, no DB row): 70 | DB missing file: 0
Orphan files (likely deleted from DB yesterday — click to verify)
category/50187baf-a952-4702-832a-6e5ba8b97031.jpg
mtime 2026-07-21 00:26:48 · 86907 bytes
Open / verify
category/60399a4a-5416-4f3d-981b-d311ae2fb651.jpg
mtime 2026-07-19 22:49:26 · 36278 bytes
Open / verify
category/75916052-6f54-4db1-8c51-90d80ec5fc52.jpg
mtime 2026-07-19 22:40:02 · 44435 bytes
Open / verify
category/86907dd6-ecc8-4512-b688-710697a81d8a.jpg
mtime 2026-07-19 22:34:39 · 21615 bytes
Open / verify
category/c15c80b9-20fc-4d5b-ac2d-5d2f60a6a763.png
mtime 2026-07-19 22:24:18 · 49921 bytes
Open / verify
category/73e5b42b-c6ef-4397-8610-245709826732.png
mtime 2026-07-19 22:15:54 · 582013 bytes
Open / verify
category/e6312610-7ef1-491f-bfe3-0777804a724e.png
mtime 2026-07-19 22:12:13 · 232760 bytes
Open / verify
category/7fe55287-1a3a-4173-bc1f-32550faa57dc.jpg
mtime 2026-07-19 20:54:30 · 37979 bytes
Open / verify
category/0fdce393-745f-465e-8be8-fb9688b8259b.png
mtime 2026-07-19 20:47:31 · 52840 bytes
Open / verify
category/5e80f07f-3c6d-471e-accf-55543d3d5a8c.jpg
mtime 2026-07-19 20:41:41 · 219709 bytes
Open / verify
category/bcc8264e-0718-4d1d-ac57-df427525b675.jpg
mtime 2026-07-19 20:32:57 · 21200 bytes
Open / verify
category/2f594221-f1a4-4ead-93fa-2e02913d6fb7.png
mtime 2026-07-19 20:29:17 · 4563 bytes
Open / verify
category/60b299b9-854a-4158-b733-b859f45c5dbf.png
mtime 2026-07-19 20:24:47 · 13316 bytes
Open / verify
category/4985395d-1f0b-4999-958b-0bb19cda3a5b.png
mtime 2026-07-19 20:12:43 · 9888 bytes
Open / verify
category/6f4d1ed5-7f47-44a4-8063-e8eb21048870.png
mtime 2026-07-19 20:10:41 · 6011 bytes
Open / verify
category/e18dbdec-09b0-4d08-af15-9b24a38f28ff.png
mtime 2026-07-19 20:05:56 · 121663 bytes
Open / verify
category/aed9234d-dcc0-4e0f-94c8-6a532ccac89e.png
mtime 2026-07-19 20:00:17 · 95902 bytes
Open / verify
category/c6e6921c-01d8-4793-8f9e-35b01293b1d7.png
mtime 2026-07-19 19:56:36 · 207214 bytes
Open / verify
category/f5345364-e007-40ec-b0fd-9aa64fd3adf8.png
mtime 2026-07-19 19:55:20 · 137083 bytes
Open / verify
category/a880f0f2-5573-486c-91a5-36165a85ed56.png
mtime 2026-07-19 19:53:15 · 94820 bytes
Open / verify
category/2b6ad06c-8d59-46b7-90eb-223d1375ab66.png
mtime 2026-07-19 19:50:26 · 105582 bytes
Open / verify
category/b5a71c48-eb50-48a6-ac49-3a95c7c1ad73.png
mtime 2026-07-19 19:45:58 · 1717 bytes
Open / verify
category/ea60dce1-8c33-4736-b699-6c8761d1e9e8.png
mtime 2026-07-19 19:37:33 · 4543 bytes
Open / verify
category/709a819c-83d8-4d96-bd70-5ccd2f626e0e.jpg
mtime 2026-07-19 19:31:40 · 17224 bytes
Open / verify
category/1bffddbd-5ede-49f9-a78d-a88abe2695f9.png
mtime 2026-07-19 19:27:00 · 25409 bytes
Open / verify
category/44cd4749-8758-4fb8-9e9c-c3a5dcace42a.jpg
mtime 2026-07-19 19:12:23 · 35199 bytes
Open / verify
category/e7b9ef2d-24c3-4500-a891-0167b142e7b1.png
mtime 2026-07-16 20:21:30 · 2804 bytes
Open / verify
category/df856fe3-748c-4318-8239-8e23cae2c8b0.png
mtime 2026-07-16 20:20:53 · 4135 bytes
Open / verify
category/0ae6f1d6-33f5-4af5-8975-705026484d46.png
mtime 2026-07-16 20:20:09 · 4829 bytes
Open / verify
category/4d110b8e-ec07-4233-95cb-f9083e8c106b.png
mtime 2026-07-16 20:19:26 · 4164 bytes
Open / verify
category/6a7936ef-b868-446f-8f48-a8aeb1aec1ac.png
mtime 2026-07-16 20:18:24 · 4216 bytes
Open / verify
category/2b55ca80-33b8-4ba4-89d0-ed4dcdce3179.png
mtime 2026-07-16 20:16:42 · 4621 bytes
Open / verify
category/c4ee15c9-2c9c-49a7-a0e5-a266bef13af1.png
mtime 2026-07-16 20:16:16 · 4619 bytes
Open / verify
category/f38fa5cb-e6db-442a-9d97-e768762f57d8.png
mtime 2026-07-16 20:12:34 · 5948 bytes
Open / verify
category/9b861113-a8b8-4332-b921-b59efc6eaa2a.png
mtime 2026-07-16 20:08:28 · 6239 bytes
Open / verify
category/78352e5b-8c77-48cb-b693-30f67d84da2d.png
mtime 2026-07-16 20:04:44 · 4199 bytes
Open / verify
category/1d281f8c-86b5-44ed-8cc8-a6c5ae7643c2.png
mtime 2026-07-16 20:03:55 · 5247 bytes
Open / verify
category/e44d36b3-71a6-43b8-a2f7-391f773bb389.png
mtime 2026-07-16 20:03:20 · 2819 bytes
Open / verify
category/c7117bfd-c51a-49f6-a513-00b2cb121b59.png
mtime 2026-07-16 20:02:43 · 2688 bytes
Open / verify
category/ca0aa69a-07cd-4e04-89cc-85232fecf796.png
mtime 2026-07-16 20:02:05 · 1920 bytes
Open / verify
videos
files on disk: 367 | unique paths in DB: 363 | orphans (file exists, no DB row): 4 | DB missing file: 0
files on disk: 367 | unique paths in DB: 363 | orphans (file exists, no DB row): 4 | DB missing file: 0
Orphan files (likely deleted from DB yesterday — click to verify)
video/5a14a63f-7271-4d0e-94ed-52a7eb28bdfa.mp4
mtime 2026-07-16 16:40:38 · 239106 bytes
Open / verify
video/886d0484-8deb-42ab-aee7-dade06b0dbf9.mp4
mtime 2026-07-16 16:40:38 · 215275 bytes
Open / verify
video/c56d5a13-5402-4232-a4f9-94c1d74b703d.mp4
mtime 2026-07-16 16:40:38 · 759404 bytes
Open / verify
video/d3f5d390-43e5-4bc4-8c44-b4369eac45c5.mp4
mtime 2026-07-16 16:40:38 · 411405 bytes
Open / verify
All tables (row counts)
Verify media (click to open)
Sample festival image:
festival/25cdde78-524a-4a96-8f30-ab091f8fa526.jpg
https://proposter.gvmtechnologies.net/uploads/festival/25cdde78-524a-4a96-8f30-ab091f8fa526.jpg
Uploads base:
https://proposter.gvmtechnologies.net/uploads
entry — total 10, showing 10 (max 300)
| id | name | mobile_no | subject_id | message | created_at | updated_at | |
|---|---|---|---|---|---|---|---|
| 26 | Isan 2206 | Isan2206@yopmail.com | 7096863115 | 5 | There is some Technical Issue | 2026-06-28 22:08:28 | 2026-06-28 22:08:28 |
| 27 | Test 0907 | Test0907@yopmail.com | 7096863755 | 7 | App is getting crash | 2026-07-08 20:34:09 | 2026-07-08 20:34:09 |
| 28 | Test 0907 | Test0907@yopmail.com | 7096863755 | 4 | Test | 2026-07-09 23:01:10 | 2026-07-09 23:01:10 |
| 29 | Test 0907 | Test0907@yopmail.com | 7096863755 | 5 | Ucucyfufc | 2026-07-09 23:01:24 | 2026-07-09 23:01:24 |
| 30 | Isan Sharma | Isan1507@yopmail.com | 7894561230 | 3 | Avhchv | 2026-07-20 01:20:48 | 2026-07-20 01:20:48 |
| 31 | Isan 2206 | Isan2206@yopmail.com | 7096863115 | 3 | Test | 2026-07-28 20:54:34 | 2026-07-28 20:54:34 |
| 32 | Isan 2206 | Isan2206@yopmail.com | 7096863115 | 3 | "There is no one who loves pain itself, who seeks after it and wants to have it, simply because it is pain..." What is Lorem Ipsum? Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since 1966, when designers at Letraset and James Mosley, the librarian at St Bride Printing Library in London, took a 1914 Cicero translation and scrambled it to make dummy text for Letraset's Body Type sheets. It has survived not o... | 2026-07-29 20:54:11 | 2026-07-29 20:54:11 |
| 33 | Isan 2206 | Isan2206@yopmail.com | 7096863115 | 3 | Gststs | 2026-07-29 22:08:40 | 2026-07-29 22:08:40 |
| 34 | Isan 2206 | Isan2206@yopmail.com | 709686311512345 | 3 | Acxx | 2026-07-30 00:02:33 | 2026-07-30 00:02:33 |
| 35 | Isan 2206 | Isan2206@yopmail.com | 7096863115123578867 | 3 | Zgzz | 2026-07-30 00:02:47 | 2026-07-30 00:02:47 |
Passwords / tokens are redacted. Delete this page when finished.