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 #132
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 #132
40-sys.db · systems/40-server/data/
⌂ Server Hub →
id
132
system
40 Server
date
08/25/26
subject
old-zips-search-api.php: fixed a real silent-failure bug (invalid UTF-8 -> empty 200 response)
approved_by
USR369 David
se_id
—
tr_id
—
_rowid
132
detail
USR369 said the tool was "definitely working now" after his own tweaks; re-tested more thoroughly than the earlier one-word-query smoke test and found query=handoff (very common word) returned HTTP 200 with a completely empty body -- no error, no JSON at all. Root cause: search() built a snippet from raw extracted file content and passed it straight to json_encode() with no encoding safety; json_encode() returns false (silently) on any array containing invalid UTF-8 bytes, and echoing false produces an empty string. Some of the 261 extracted old files are not clean UTF-8 (legacy encodings from Feb 2026 era files). Fixed two ways: (1) added JSON_INVALID_UTF8_SUBSTITUTE flag to every json_encode() call in the file (11 total) so encoding issues degrade to substitution characters instead of failing outright, (2) added mb_convert_encoding($snippet, "UTF-8", "UTF-8") on the snippet itself as a second layer before it ever reaches json_encode. Re-tested query=handoff (25 results, correct), query=governance (25, still correct), query=master (25, correct), ping (unchanged, clean).
▼ Show timestamps
created_at
2026-08-25 10:31: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