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 #16
Tables
decisions
111
domain
8
events
0
items
16
sessions
71
sqlite_sequence
4
transfers_log
0
decisions — Row #16
10-sys.db · systems/10-master/data/
⌂ Master Hub →
id
16
system
01 Master
date
07/08/26
subject
D100 — add_decision write path fixed
approved_by
USR369 David
se_id
—
tr_id
—
detail
Two independent PHP bugs found blocking all decision writes tonight. (1) systems/10-master/data/api.php add_decision referenced undefined variable $re_id and had a column/placeholder count mismatch in the INSERT — fatal error, HTTP 500 empty body. (2) backend/sys-com/db/api.php getDB() had a malformed CREATE TABLE string with literal escaped newlines and sys_id column defined 4 times — SQLite rejected it on every call that touched schema init; add_decision also referenced pt_now() as a raw SQL function name inside bound values instead of PHP-side binding. Both fixed and redeployed. Verified: writes succeed, reads unaffected, existing decisions table schema on server already matched correct structure (11 columns, no data loss). This blocked D097/D098 pre-close checklist for every system tonight until fixed.
description
D100 — add_decision write path fixed
▼ Show timestamps
created_at
2026-07-08 05:34:03
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