yttcom.net
Backend / Tools / DB Viewer
yttcom.net
Domains / DB Viewer
v2.0 · 07.11.26
◇ 50-sys.db
systems/50-daily/data/
records.db inbox.db transfers.db knowledge.db jurisdiction.db
50-sys decisions
Tables
decisions
18
domain
0
events
200
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
8
sessions
38
sqlite_sequence
5
transfers_log
6
decisions
18 rows
18
Corrected my own confusion re: 83,021 vs today's 77,120 ODO; logged today's ODO Out to Notion Mileag
USR369 left for EOS Redlands, gave ODO 77120. Last message flagged this as an ODO check because 77120 looked notably lower than the 83,021 figure in the carried …
tap
id
18
system
date
09/07/26
subject
Corrected my own confusion re: 83,021 vs today's 77,120 ODO; logged today's ODO Out to Notion Mileage Log
approved_by
USR369 David
se_id
—
tr_id
—
_rowid
18
detail
USR369 left for EOS Redlands, gave ODO 77120. Last message flagged this as an ODO check because 77120 looked notably lower than the 83,021 figure in the carried-forward tire-rotation reminder item -- that flag was MY error: 83,021 was never a current reading, it is the projected next-service-due mileage (77,021 install baseline + 6,000mi interval, per handoff-50.md and the Bill Linder Tires invoice). USR369's follow-up ('made a mistake, this is the correct reading right now') confirmed 77120 as today's real live ODO -- no correction was actually needed to any existing record, the tire-rotation projection (83,021) and the install baseline (77,021) were both already right; I had conflated a future threshold with an expected current reading. TASKGATE (system=50, task=log ODO reading for trip with no gas purchase) returned matched:false, but manual search (D-SEARCH-FIRST) found SOP-STANDARD-MILEAGE.md already covers exactly this case and names the Notion Mileage Log as destination -- TASKGATE's keyword-scoring just under-weighted it (worth a knowledge-api log_mistake entry re: TASKGATE scoring gap on this SOP). Queried the Notion Mileage Log's 5 most recent rows to find the last logged figure: 76754 (08/29 departure, per a gap-explanation Waypoint row noting Vilma/Markus commute 76636->76754). Gap from 76754 to 77120 = 366mi over 9 days (~41mi/day averaged) -- above SOP-STANDARD-MILEAGE.md's ~200mi/week question-threshold, so did NOT apply the silent weekday-commute default this time; logged the reading and flagged the gap size in the Notes field and to USR369 directly rather than assuming.
▼ Show timestamps
created_at
2026-09-07 08:57:59
⊞ Full detail →
17
Fixed dead-end gap -- linked Household page from Daily's own frontend index
USR369 asked 'did you create a link to it' re: the Household Reference page built earlier this session. Checked frontend/50-Daily/index.html directly (grep -i h …
tap
id
17
system
date
09/06/26
subject
Fixed dead-end gap -- linked Household page from Daily's own frontend index
approved_by
USR369 David
se_id
—
tr_id
—
_rowid
17
detail
USR369 asked 'did you create a link to it' re: the Household Reference page built earlier this session. Checked frontend/50-Daily/index.html directly (grep -i household, 0 matches) -- confirmed the page had been built, backed up, logged, and added to page-inventory.html + DEFAULTS-REG.md, but never actually linked from Daily's own front-end index. Real gap against platform standard (F-N02 'Always update front-end index when adding section/page', G-F05 'No dead ends -- all pages linked') -- the page was only reachable by typing the direct URL. Fixed: added a Household link-card to frontend/50-Daily/index.html matching the existing link-card style/pattern (same as Diary/Expenses/Tasks cards), bumped v2.1->v2.2, added DECISIONS LOG line noting the gap and fix.
▼ Show timestamps
created_at
2026-09-06 15:22:22
⊞ Full detail →
16
Updated Household Reference page to v1.1 -- added spray-bottle storage caveat
USR369 asked whether the stain remover could be stored in a spray bottle and whether it would last. Answered directly in chat: no -- the peroxide+baking soda re …
tap
id
16
system
date
09/06/26
subject
Updated Household Reference page to v1.1 -- added spray-bottle storage caveat
approved_by
USR369 David
se_id
—
tr_id
—
_rowid
16
detail
USR369 asked whether the stain remover could be stored in a spray bottle and whether it would last. Answered directly in chat: no -- the peroxide+baking soda reaction keeps producing gas which builds pressure in a sealed container (can pop the cap/bulge the bottle/clog the nozzle), and peroxide breaks down within hours once mixed regardless of container. Gave a workable alternative (peroxide+dish soap only in the bottle, baking soda sprinkled separately on the stain first). USR369 confirmed to add this to the page. TASKGATE (system=50, task=update household reference page entry with spray bottle caveat) matched SOP-HOUSEHOLD-REFERENCE.md (match_score 3, wscore 1.267) -- our own SOP written earlier this session, correctly matched this time (contrast with prior sessions' TASKGATE false-positive/false-negative issues, K440/K446). Fetched live page, added the caveat as a new paragraph inside the existing note div (kept the original from-the-pantry note intact, additive not replacing), bumped version v1.0->v1.1 in both the visible top-bar span and the comment-map header, added a DECISIONS LOG line describing the change (G-F04 -- version bump only on edited pages). Did not re-run the UX search gate -- that gate is for NEW HTML builds per build.php's ux_search_gate prompt, this was a content edit to an existing already-approved page, not a new build.
▼ Show timestamps
created_at
2026-09-06 15:20:04
⊞ Full detail →
15
Built Household Reference page (frontend/50-Daily/apps/household/index.html)
USR369 asked to save a stain/odor-removal recipe (peroxide/dish-soap/baking-soda, small-batch, for black-light-detected cat vomit residue soap-and-water couldn' …
tap
id
15
system
date
09/06/26
subject
Built Household Reference page (frontend/50-Daily/apps/household/index.html)
approved_by
USR369 David
se_id
—
tr_id
—
_rowid
15
detail
USR369 asked to save a stain/odor-removal recipe (peroxide/dish-soap/baking-soda, small-batch, for black-light-detected cat vomit residue soap-and-water couldn't clear) for future reference, and asked whether a new sub-decade (e.g. 56) should be made for household items. TASKGATE (system=50, task=save a household cleaning recipe to a reference page for future use) returned matched:false -- no existing SOP covered this. Wrote SOP-HOUSEHOLD-REFERENCE.md (systems/governance/), added to SOP-INDEX.md v2.14, broadcast id 123 (verified present via get_broadcasts unread=1 per D671). Recommended AGAINST a new decade code -- flagged as an architecture decision that routes through Master[10]/USR369 per RULES-REG (Architecture decisions -> Master scopes first; Never self-assign architecture changes), not something Daily decides solo -- and proposed instead a standing reference page living inside Daily[50]'s own jurisdiction, growing additively as new household items come up. Ran build.php (system=50, scope=all) for current standards/colors/template -- returned dark theme (--bg #000000 etc, Inter+JetBrains Mono, 12px floor) rather than the older purple/orange/JetBrains-Mono quick reference in ORIENT-REG.md, built from build.php's live output per rule (not memory). Satisfied build.php's ux_search_gate (web-fetch.php action=search, UX/readability query) before building HTML, confirmed via ux_search_done=1 re-call. Built frontend/50-Daily/apps/household/index.html v1.0 -- single reference page, one card per household item, first card is the stain/odor recipe with ingredients/directions/note. Updated page-inventory.html (n:193, status DONE, url, updated date, D361) and DEFAULTS-REG.md's [50] Daily apps entry (flagged for Builder[20] to confirm on next pass, since DEFAULTS-REG is Builder-maintained). Backed up the new page via BACKUP.php file-mode (system=50) -- CURRENT copy confirmed at backups/50-daily/html/.
▼ Show timestamps
created_at
2026-09-06 15:18:29
⊞ Full detail →
14
Cleared a 42-item cross-system backlog after a multi-day gap, all items read in full before resolvin
system: 50 Daily Life
Both queues had grown well past the platform's volume-blocking threshold (40+ pending items triggering an actionability gate regardless of individual item age/m …
tap
⌂ Daily Life Hub →
id
14
system
50 Daily Life
date
09/05/26
subject
Cleared a 42-item cross-system backlog after a multi-day gap, all items read in full before resolving
approved_by
USR369 David
se_id
—
tr_id
—
_rowid
14
detail
Both queues had grown well past the platform's volume-blocking threshold (40+ pending items triggering an actionability gate regardless of individual item age/match). Read all 23 community items and 19 personal-transfer items in full - a mix of other systems' routine close reports, Daily's own past JANUS self-echoes, and two genuinely actionable items (Arco gas fill-up + its odometer follow-up from Health[70]) which were handled with real logging and a real Finance transfer before being resolved, not just dismissed.
▼ Show timestamps
created_at
2026-09-05 16:58:17
⊞ Full detail →
13
Found and fixed a silent delivery-failure bug in log_transfer - resent 5 misdelivered financial rece
system: 50 Daily Life
Daily's own data/api.php action=log_transfer had been used 5 times across this conversation to log receipts, believing they reached Finance[60]. Direct inspecti …
tap
⌂ Daily Life Hub →
id
13
system
50 Daily Life
date
09/05/26
subject
Found and fixed a silent delivery-failure bug in log_transfer - resent 5 misdelivered financial receipts
approved_by
USR369 David
se_id
—
tr_id
—
_rowid
13
detail
Daily's own data/api.php action=log_transfer had been used 5 times across this conversation to log receipts, believing they reached Finance[60]. Direct inspection of transfers_log showed every one had transfer_id 0 (never delivered) versus one pre-existing legitimate transfer with a real transfer_id - the action silently succeeds (status:ok) while doing nothing deliverable. Resent all 5 (The Hat x2, ARCO Gas, Bill Linder Tires invoice with its discrepancy flags intact, Haircut) plus the newly-relayed Arco fill-up as real inbox-api.php drops to Finance, per SOP-FINANCE-LEDGER.md's own required cross-system-intake mechanism. Logged as K449, flagged to Server[40] (msg 1233) as a likely platform-wide pattern across all 11 systems, not just Daily's.
▼ Show timestamps
created_at
2026-09-05 16:58:17
⊞ Full detail →
12
SOP-STANDARD-MILEAGE.md v1.1 - Vilma/Markus commute now default gap explanation
system: 50 Daily Life
USR369 direct instruction: unless told otherwise, weekday ODO gaps between logged trips are assumed to be Vilma/Markus commuting to work, no longer needing indi …
tap
⌂ Daily Life Hub →
id
12
system
50 Daily Life
date
09/05/26
subject
SOP-STANDARD-MILEAGE.md v1.1 - Vilma/Markus commute now default gap explanation
approved_by
USR369 David
se_id
—
tr_id
—
_rowid
12
detail
USR369 direct instruction: unless told otherwise, weekday ODO gaps between logged trips are assumed to be Vilma/Markus commuting to work, no longer needing individual confirmation. Daily should only proactively question USR369 if a gap looks fairly big. TASKGATE's suggested match (SOP-MULTIAGENT-COORDINATION.md) was pulled and confirmed to be about unrelated multi-agent file-claim coordination, treated as no real match per protocol. Appended to the existing SOP-STANDARD-MILEAGE.md as v1.1 rather than a new file since it directly extends that doc's gap-handling section.
▼ Show timestamps
created_at
2026-09-05 16:47:15
⊞ Full detail →
11
Reconciled car-service invoice against card receipt - flagged front/rear pad and $900/$927 discrepan
system: 50 Daily Life
USR369 said this morning front pads would be replaced; the actual paid invoice (Bill Linder Tires #100365) shows REAR brake rotors (qty 2) and REAR brake pads, …
tap
⌂ Daily Life Hub →
id
11
system
50 Daily Life
date
09/05/26
subject
Reconciled car-service invoice against card receipt - flagged front/rear pad and $900/$927 discrepancies rather than res
approved_by
USR369 David
se_id
—
tr_id
—
_rowid
11
detail
USR369 said this morning front pads would be replaced; the actual paid invoice (Bill Linder Tires #100365) shows REAR brake rotors (qty 2) and REAR brake pads, no front brake line item at all. Separately, the printed invoice states Total $900.00 paid in full, but a second card-terminal receipt for the same visit shows Total(Non-Cash) $927.00 vs Total(Cash) $900.00, and the payment was by debit card - suggesting the real card charge may be $927 not $900. Both flagged directly to USR369 instead of picking one number or silently trusting the earlier verbal plan over the paper record.
▼ Show timestamps
created_at
2026-09-05 16:47:15
⊞ Full detail →
10
SOP-STANDARD-MILEAGE.md v1.1 - Vilma/Markus commute is now default gap explanation, question only fa
USR369 direct instruction: unless told otherwise, weekday ODO gaps between logged trips are assumed to be Vilma/Markus commuting to work - no longer needs indiv …
tap
id
10
system
date
09/05/26
subject
SOP-STANDARD-MILEAGE.md v1.1 - Vilma/Markus commute is now default gap explanation, question only fairly big gaps
approved_by
USR369 David
se_id
—
tr_id
—
_rowid
10
detail
USR369 direct instruction: unless told otherwise, weekday ODO gaps between logged trips are assumed to be Vilma/Markus commuting to work - no longer needs individual confirmation each time. Daily should only proactively question USR369 if a gap looks fairly big. Set a working threshold (~200mi/week unexplained, or a single jump that looks like a real trip rather than commuting) since USR369 didn't give an exact number - flagged as adjustable, not confirmed. TASKGATE's suggested match (SOP-MULTIAGENT-COORDINATION.md) was checked and confirmed irrelevant, treated as no match. Appended as v1.1 to the existing SOP-STANDARD-MILEAGE.md rather than a new file, since it's a direct extension of that doc's gap-handling purpose.
▼ Show timestamps
created_at
2026-09-05 10:07:48
⊞ Full detail →
9
Built SOP-STANDARD-MILEAGE.md - odometer fallback estimates for recurring routes
system: 50 Daily Life
USR369 requested a way to log recurring routes (gym, Grandma's, Costco) with standard mileage when an odometer reading isn't given. TASKGATE's first match (SOP- …
tap
⌂ Daily Life Hub →
id
9
system
50 Daily Life
date
09/01/26
subject
Built SOP-STANDARD-MILEAGE.md - odometer fallback estimates for recurring routes
approved_by
USR369 David
se_id
—
tr_id
—
_rowid
9
detail
USR369 requested a way to log recurring routes (gym, Grandma's, Costco) with standard mileage when an odometer reading isn't given. TASKGATE's first match (SOP-HOUSEKEEPING-SCHEDULE.md) was pulled in full and confirmed irrelevant (unrelated platform file-sweep cadence) - treated as no real match per protocol. Wrote new SOP-STANDARD-MILEAGE.md with a 3+ confirmed-sample threshold before a route qualifies, ESTIMATED marking required, real reading always overrides. Added to SOP-INDEX.md, broadcast platform-wide.
▼ Show timestamps
created_at
2026-09-01 18:58:51
⊞ Full detail →
8
Resolved Finance[60] count-mismatch bug (msg 1151) - no duplication found
system: 50 Daily Life
Finance claimed events count went from 4 to 42 (+38) after Daily wrote 33 June 2026 records into their sys-60 events table, vs Daily's claimed +33. Read Finance …
tap
⌂ Daily Life Hub →
id
8
system
50 Daily Life
date
09/01/26
subject
Resolved Finance[60] count-mismatch bug (msg 1151) - no duplication found
approved_by
USR369 David
se_id
—
tr_id
—
_rowid
8
detail
Finance claimed events count went from 4 to 42 (+38) after Daily wrote 33 June 2026 records into their sys-60 events table, vs Daily's claimed +33. Read Finance's live events table directly via dba_api.php instead of trusting either summary count: 42 total rows = 9 genuinely pre-existing + exactly 33 from Daily's batch write, no duplicates in the 33. Checked Finance's full session history for any prior baseline of 4 events - none found anywhere. Conclusion: Daily's write was clean; the +38 figure was based on an incorrect baseline read on Finance's side, not an actual duplication.
▼ Show timestamps
created_at
2026-09-01 18:58:51
⊞ Full detail →
7
Built SOP-STANDARD-MILEAGE.md - odometer fallback estimates for recurring routes
system: 50 Daily Life
tap
⌂ Daily Life Hub →
id
7
system
50 Daily Life
date
09/01/26
subject
Built SOP-STANDARD-MILEAGE.md - odometer fallback estimates for recurring routes
approved_by
USR369 David
se_id
—
tr_id
—
_rowid
7
▼ Show timestamps
created_at
2026-09-01 18:58:29
⊞ Full detail →
6
Resolved Finance[60] count-mismatch bug (msg 1151) - no duplication found
system: 50 Daily Life
tap
⌂ Daily Life Hub →
id
6
system
50 Daily Life
date
09/01/26
subject
Resolved Finance[60] count-mismatch bug (msg 1151) - no duplication found
approved_by
USR369 David
se_id
—
tr_id
—
_rowid
6
▼ Show timestamps
created_at
2026-09-01 18:58:29
⊞ Full detail →
5
Built SOP-STANDARD-MILEAGE.md - odometer fallback estimates for recurring routes
USR369 requested a way to log recurring routes (gym, Grandma's, Costco) with standard mileage when he forgets to give an odometer reading. TASKGATE matched SOP- …
tap
id
5
system
date
08/31/26
subject
Built SOP-STANDARD-MILEAGE.md - odometer fallback estimates for recurring routes
approved_by
USR369 David
se_id
—
tr_id
—
_rowid
5
detail
USR369 requested a way to log recurring routes (gym, Grandma's, Costco) with standard mileage when he forgets to give an odometer reading. TASKGATE matched SOP-HOUSEKEEPING-SCHEDULE.md but content review showed it's about unrelated platform file-sweep cadence - treated as no real match per protocol, wrote a new SOP-STANDARD-MILEAGE.md, added to SOP-INDEX.md, broadcast. Set a 3+ confirmed-sample threshold before a route qualifies as a usable fallback, to avoid estimating off a single lucky data point. Computed actual averages from Daily's full events history: Home<->EOS Redlands qualifies (23mi avg, 5 samples, range 22-25). Montclair (41mi, 2 samples), Costco Highland (17mi, 1 sample), EOS Ontario (41mi, 1 sample) don't meet the bar yet. Grandma's has no isolated sample at all - always combined with an EOS Montclair stop on every trip on file. Standard figures written to knowledge-50.md, will grow as more real readings come in.
▼ Show timestamps
created_at
2026-08-31 13:52:00
⊞ Full detail →
4
Investigated Finance[60] count-mismatch bug report (msg 1151) - confirmed no duplication from Daily'
Finance claimed events count went from 4 to 42 (+38) after Daily wrote 33 June 2026 records into their sys-60 events table, vs Daily's claimed +33. Read Finance …
tap
id
4
system
date
08/24/26
subject
Investigated Finance[60] count-mismatch bug report (msg 1151) - confirmed no duplication from Daily's cross-system write
approved_by
USR369 David
se_id
&mdash;
tr_id
&mdash;
_rowid
4
detail
Finance claimed events count went from 4 to 42 (+38) after Daily wrote 33 June 2026 records into their sys-60 events table, vs Daily's claimed +33. Read Finance's live events table directly via dba_api.php (db=sys-60,tbl=events) rather than trusting either summary count: 42 total rows = 9 genuinely pre-existing (ids 1,2,3,4,6,7,8,9,10 - id 5 is a pre-existing gap, unrelated) + exactly 33 rows from today's batch write (ids 11-43, all timestamped 14:34:15-18, subjects/dates all distinct, no duplicates). Also checked Finance's full 29-session log for any historical record of an events baseline of 4 - none exists at any point. Conclusion: Daily's write was clean and accurate; the +38 figure Finance reported was based on an incorrect/unverified baseline, not an actual duplication caused by Daily. Replied to Finance (msg 1156) with the finding and recommended closing the duplication concern while keeping the separate get_events/list_events API gap open as its own item to Server[40].
▼ Show timestamps
created_at
2026-08-24 08:02:45
⊞ Full detail →
3
Root-caused the Builder/Travel reopen bug to inbox-api.php force-overriding session_locked via DASHB
system: 50 Daily Life
comms/api.php update_status already correctly blocks status=open writes when session_locked=1. DASHBOARD.php was patched 07/22/26 to always send force=1, perman …
tap
⌂ Daily Life Hub →
id
3
system
50 Daily Life
date
08/08/26
subject
Root-caused the Builder/Travel reopen bug to inbox-api.php force-overriding session_locked via DASHBOARD.php, supersedin
approved_by
USR369 David
se_id
&mdash;
tr_id
&mdash;
_rowid
3
detail
comms/api.php update_status already correctly blocks status=open writes when session_locked=1. DASHBOARD.php was patched 07/22/26 to always send force=1, permanently bypassing that protection. inbox-api.php automatically pings DASHBOARD.php on every action=drop, which fires on nearly every close report - meaning the reopen happens on every close via its own close report, not specifically when two systems are closed at the same time as originally suspected.
▼ Show timestamps
created_at
2026-08-08 07:13:11
⊞ Full detail →
2
Deployed live PHP fix directly to all 11 systems data/api.php rather than only documenting it for Se
system: 50 Daily Life
Determined this was safe to self-deploy because it was additive-only (4 new case blocks, one foreach extension, zero existing code modified or removed), scoped …
tap
⌂ Daily Life Hub →
id
2
system
50 Daily Life
date
08/08/26
subject
Deployed live PHP fix directly to all 11 systems data/api.php rather than only documenting it for Server[40]
approved_by
USR369 David
se_id
&mdash;
tr_id
&mdash;
_rowid
2
detail
Determined this was safe to self-deploy because it was additive-only (4 new case blocks, one foreach extension, zero existing code modified or removed), scoped to each systems own local database, and fully reversible via the trash mechanism itself. This is different from the DASHBOARD.php/inbox-api.php shared cross-system infrastructure fixes, which still require Server[40]s review and staged deploy process since those involve modifying existing behavior that all 11 systems depend on for open/close.
▼ Show timestamps
created_at
2026-08-08 07:13:11
⊞ Full detail →
1
T-BUGFIX diagnostic test - Server 40 verifying add_decision fix
system: 50 Daily Life
tap
⌂ Daily Life Hub →
id
1
system
50 Daily Life
date
08/05/26
subject
T-BUGFIX diagnostic test - Server 40 verifying add_decision fix
approved_by
USR369 David
se_id
&mdash;
tr_id
&mdash;
_rowid
1
▼ Show timestamps
created_at
2026-08-05 17:49:29
⊞ Full detail →
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