Psa Interface Checker Scary Mistake Fix Page

The text "Foreign Key Violation" sounds like you’ve broken the spine of your database. Novice users assume they have to rebuild the entire parts catalog from scratch.

-- Restore the project_id from the audit log UPDATE t SET t.project_id = a.old_value::int FROM time_logs t JOIN audit_log a ON t.entry_id = a.record_id JOIN #corrupted_entries c ON t.entry_id = c.entry_id WHERE a.table_name = 'time_logs' AND a.column_name = 'project_id' AND a.action = 'UPDATE' -- The checker performed an update AND a.changed_at > '2023-10-24 10:00:00'; -- After the patch deploy