System Status

Schema health, table availability, row totals, key column detection, and environment checks for 4 P’s.

Settings Activity Log Reports

Core Tables Found

9

Core Tables Missing

0

DB File Check

OK

Nav File Check

OK

Quick Checks

Check	Result
Shared DB connection path	Found
Nav include path	Found
PDO connection object	Connected

Environment

Setting	Value
PHP Version	8.2.30
PDO Loaded	Yes
PDO MySQL Loaded	Yes
Server Software	LiteSpeed
Document Root	/home/truslsca/4psplatform.com
Current Script	/system-status.php
App DB Path Expectation	/home/truslsca/4psplatform.com/app/db.php
Nav Include Path Expectation	/home/truslsca/4psplatform.com/includes/fourps-nav.php

Core Schema Status

Area	Resolved Table	Status	Rows	Columns Found	Columns Missing
Customers	customers	OK	1	id, email	full_name, name, customer_name, display_name, email_address
Properties	properties	OK	1	id, customer_id	client_id, property_name, name, address, street_address
Plans	plans	OK	1	id, customer_id, property_id, plan_name, status	client_id, home_id, name, plan_status
Inspections	inspections	OK	8	id, customer_id, property_id, plan_id, inspection_status	inspection_number, title, status
Inspection Items	inspection_items	OK	90	id, inspection_id, item_name	name, status, item_status, result, inspection_result
Claims	claims	OK	1	id, customer_id, property_id, plan_id, inspection_id, claim_number, claim_status	title, status
Claim Items	claim_items	OK	1	id, claim_id, item_name, status	name, item_status, decision, claim_decision
Invoices	invoices	OK	1	id, customer_id, property_id, plan_id, claim_id, invoice_number, status, total_amount	inspection_id, invoice_total, total
Payments	payments	OK	1	id, invoice_id, customer_id, status, amount	payment_reference, reference_no, payment_status, payment_amount, amount_paid