yttcom.net
Backend / Tools / DB Viewer
yttcom.net
Domains / DB Viewer
v2.0 · 07.11.26
◇ 40-sys.db
systems/40-server/data/
records.db inbox.db transfers.db knowledge.db jurisdiction.db
40-sys decisions Row #94
Tables
decisions
189
domain
0
events
10
gov_archive
0
gov_archive_fts
0
gov_archive_fts_config
1
gov_archive_fts_data
2
gov_archive_fts_docsize
0
gov_archive_fts_idx
0
items
3
sessions
82
sqlite_sequence
5
transfers_log
0
decisions — Row #94
40-sys.db · systems/40-server/data/
id
94
system
date
08/19/26
subject
Fixed inbox-api.php list action -- added system unread filter, was ignoring system param entirely
approved_by
USR369 David
se_id
—
tr_id
—
_rowid
94
detail
Root cause of USR369 seeing count:1060 on a system-scoped mail query: action=list's SQL never used the $_GET['system'] param at all, always returned every message ever sent platform-wide. pickup action (delivered=0 per system) was already correct and unaffected -- SYNC.php's real 75-item backlog was accurate the whole time, only the list/audit view was misleading. Added system= and unread=1 params, backward compatible (no params = old full-history behavior preserved). Backed up original first (BACKUP.php), syntax-checked via self-deleting php -l bootstrap in backend/tmp/ before touching live file, then live-tested 4 scenarios post-deploy.
▼ Show timestamps
created_at
2026-08-19 16:37:40
Backend Domains Panel DB Viewer Transfers
Backend Tools DB Viewer DB Admin Server Map File Editor Backend Tools DB Viewer DB Admin Server Map File Editor