yttcom.net
Backend / Tools / DB Viewer
yttcom.net
Domains / DB Viewer
v2.0 · 07.11.26
◇ 10-sys.db
systems/10-master/data/
records.db inbox.db transfers.db knowledge.db jurisdiction.db
10-sys decisions Row #185
Tables
decisions
198
domain
8
events
0
gov_archive
0
gov_archive_fts
0
gov_archive_fts_config
1
gov_archive_fts_data
4
gov_archive_fts_docsize
0
gov_archive_fts_idx
2
items
18
sessions
99
sqlite_sequence
5
transfers_log
0
decisions — Row #185
10-sys.db · systems/10-master/data/
id
185
system
date
08/26/26
subject
TASKGATE.php: fixed regex bug silently hiding 8 SOP entries from matching
approved_by
USR369 David
se_id
—
tr_id
—
_rowid
185
detail
Root-caused and fixed the TASKGATE.php matching failures reported earlier this session (misrouted 'search the old zips archive' to unrelated SOP-COMMAND-BUILD.md). NOT a scoring-algorithm problem -- a regex PARSING bug in the SOP-INDEX.md entry extractor. The capture pattern used \s{4} to detect indented description lines, but \s matches newlines too. Wherever two blank lines separated entries (2 newlines + 2-space next-header indent = exactly 4 whitespace chars), \s{4} bridged straight across the blank lines and treated the NEXT SOP's header line as fake continuation content of the PREVIOUS entry -- silently merging that next entry's vocabulary into the wrong SOP's haystack and erasing it as its own independently-matchable entry entirely. Confirmed by replicating the exact parsing+scoring logic in Python against the live SOP-INDEX.md: the old regex found only 46 of the file's actual 54 SOP entries -- 8 were being silently swallowed this way, including SOP-OLD-ZIPS-INDEX.md, SOP-OLD-ZIPS-ARCHIVE.md, SOP-OLD-ZIPS-SEARCH.md, SOP-JANUS-PEEK.md, SOP-TOOLS-MAINTENANCE.md, SOP-HEALTH-LEGACY-DATA.md, SOP-GROCERY-TRACKER.md, SOP-PRINT-FORMAT.md. Fix: changed \s{4} to [ ]{4} (literal space class, cannot match newlines) in TASKGATE.php's single preg_match_all call -- one line changed. Diffed old vs new local files to confirm ONLY that one token differs. No PHP CLI available for syntax check (per platform note) -- used K394 bracket/brace/paren-balance substitute instead, both balanced identically before and after. Re-ran the full parse+score simulation with the fix: all 54 entries now found (8 more than before, zero lost), and the original broken query now correctly surfaces SOP-OLD-ZIPS-INDEX.md + SOP-OLD-ZIPS-SEARCH.md as a genuine tie instead of a false match to an unrelated SOP. This does not fix the separate, pre-existing gap where 'run janus'/'close session' still don't match anything -- that's missing SOP-INDEX vocabulary content, not a parsing defect, and is out of scope for this fix.
▼ Show timestamps
created_at
2026-08-26 13:46:00
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