Updated today, looks like i might have at least fixed it?
[Wed Apr 10 20:46:39.445588 2024] [mpm_prefork:notice] [pid 338] AH00163: Apache/2.4.57 (Debian) OpenSSL/3.0.11 configured -- resuming normal operations
[Wed Apr 10 20:46:39.445692 2024] [core:notice] [pid 338] AH00094: Command line: '/usr/sbin/apache2'
[Wed Apr 10 20:46:58.152801 2024] [php:warn] [pid 435] [client 10.254.253.1:38709] PHP Warning: Undefined array key "config_project_prefix" in /var/<site>/get_settings.php on line 62
[Wed Apr 10 20:46:58.152861 2024] [php:warn] [pid 435] [client 10.254.253.1:38709] PHP Warning: Undefined array key "config_project_next_number" in /var/www/ticket.industrialcamera.com/get_settings.php on line 63
[Wed Apr 10 20:46:58.152872 2024] [php:warn] [pid 435] [client 10.254.253.1:38709] PHP Warning: Undefined array key "config_login_remember_me_expire" in /var/www/<site>/get_settings.php on line 114
[Wed Apr 10 20:46:58.177693 2024] [php:error] [pid 435] [client 10.254.253.1:38709] PHP Fatal error: Uncaught mysqli_sql_exception: Unknown column 'project_completed_at' in 'where clause' in /var/<site>/inc_all.php:24\nStack trace:\n#0 /var/<site>/inc_all.php(24): m>
[Wed Apr 10 20:47:00.628889 2024] [php:warn] [pid 435] [client 10.254.253.1:38709] PHP Warning: Undefined array key "config_project_prefix" in /var/<site>/get_settings.php on line 62
[Wed Apr 10 20:47:00.628929 2024] [php:warn] [pid 435] [client 10.254.253.1:38709] PHP Warning: Undefined array key "config_project_next_number" in /var/www/<site>/get_settings.php on line 63
[Wed Apr 10 20:47:00.628940 2024] [php:warn] [pid 435] [client 10.254.253.1:38709] PHP Warning: Undefined array key "config_login_remember_me_expire" in /var/www/<site>/get_settings.php on line 114
[Wed Apr 10 20:47:00.630193 2024] [php:error] [pid 435] [client 10.254.253.1:38709] PHP Fatal error: Uncaught mysqli_sql_exception: Unknown column 'project_completed_at' in 'where clause' in /var/<site>/inc_all.php:24\nStack trace:\n#0 /var/<site>/inc_all.php(24): m>
I managed to fix this by performing the following:
mysql -u root -p
USE itflow;
ALTER TABLE projects ADD COLUMN project_completed_at DATETIME;
EXIT;