Temporary DB Check
TEMPORARY PAGE — remove route, view, controller, and landing footer link after use.
Generated: 2026-09-10 01:50:58
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
permissions — total 37, showing 37 (max 300)
| id | name | guard_name | created_at | updated_at |
|---|---|---|---|---|
| 1 | Language | web | 2022-08-12 07:53:01 | 2022-08-12 07:53:01 |
| 2 | Category | web | 2022-08-12 07:53:01 | 2022-08-12 07:53:01 |
| 3 | CategoryFrame | web | 2022-08-12 07:53:01 | 2022-08-12 07:53:01 |
| 4 | Festival | web | 2022-08-12 07:53:01 | 2022-08-12 07:53:01 |
| 5 | FestivalFrame | web | 2022-08-12 07:53:01 | 2022-08-12 07:53:01 |
| 6 | CustomCategory | web | 2022-08-12 07:53:01 | 2022-08-12 07:53:01 |
| 7 | CustomFrame | web | 2022-08-12 07:53:01 | 2022-08-12 07:53:01 |
| 8 | News | web | 2022-08-12 07:53:01 | 2022-08-12 07:53:01 |
| 9 | Stories | web | 2022-08-12 07:53:01 | 2022-08-12 07:53:01 |
| 10 | Users | web | 2022-08-12 07:53:01 | 2022-08-12 07:53:01 |
| 11 | Businesses | web | 2022-08-12 07:53:01 | 2022-08-12 07:53:01 |
| 12 | SubscriptionPlan | web | 2022-08-12 07:53:01 | 2022-08-12 07:53:01 |
| 13 | Transactions | web | 2022-08-12 07:53:01 | 2022-08-12 07:53:01 |
| 14 | Entry | web | 2022-08-12 07:53:01 | 2022-08-12 07:53:01 |
| 15 | Subject | web | 2022-08-12 07:53:01 | 2022-08-12 07:53:01 |
| 16 | Notification | web | 2022-08-12 07:53:01 | 2022-08-12 07:53:01 |
| 17 | UserRoleManagement | web | 2022-08-12 07:53:01 | 2022-08-12 07:53:01 |
| 18 | Settings | web | 2022-08-12 07:53:01 | 2022-08-12 07:53:01 |
| 19 | BusinessCategory | web | 2022-08-13 06:45:47 | 2022-08-13 06:45:47 |
| 20 | BusinessFrame | web | 2022-08-13 06:45:47 | 2022-08-13 06:45:47 |
| 21 | Financial Statistics | web | 2022-08-13 07:38:11 | 2022-08-13 07:38:11 |
| 22 | FinancialStatistics | web | 2022-08-13 07:38:39 | 2022-08-13 07:38:39 |
| 23 | Video | web | 2022-10-11 04:58:42 | 2022-10-11 04:58:42 |
| 24 | CouponCode | web | 2022-10-11 04:58:42 | 2022-10-11 04:58:42 |
| 25 | BusinessCard | web | 2022-10-22 05:53:26 | 2022-10-22 05:53:26 |
| 26 | StickerCategory | web | 2022-11-03 11:40:45 | 2022-11-03 11:40:45 |
| 27 | Sticker | web | 2022-11-03 11:40:45 | 2022-11-03 11:40:45 |
| 28 | Offer | web | 2022-11-04 06:42:14 | 2022-11-04 06:42:14 |
| 29 | ProductCategory | web | 2022-12-05 11:06:12 | 2022-12-05 11:06:12 |
| 30 | Product | web | 2022-12-05 11:06:12 | 2022-12-05 11:06:12 |
| 31 | Inquiry | web | 2022-12-05 11:06:12 | 2022-12-05 11:06:12 |
| 32 | PosterMaker | web | 2022-12-09 05:41:39 | 2022-12-09 05:41:39 |
| 33 | ReferralSystem | web | 2022-12-10 08:49:51 | 2022-12-10 08:49:51 |
| 34 | WithdrawRequest | web | 2022-12-23 07:24:15 | 2022-12-23 07:24:15 |
| 35 | BusinessSubCategory | web | 2023-01-18 07:53:34 | 2023-01-18 07:53:34 |
| 36 | PosterCategory | web | 2023-01-22 11:39:08 | 2023-01-22 11:39:08 |
| 37 | WhatsAppMessage | web | 2023-03-24 13:10:37 | 2023-03-24 13:10:37 |
Passwords / tokens are redacted. Delete this page when finished.