Update broke web interface.

srussell

Tried to update and broke the web interface. tried a git pull. says I and already up to date. Kinda need this to work.

wrongecho

Hey there @srussell,

It may be worth clearing your cache & cookies / trying in a private browser window.

What happens if you navigate directly to itflow.example.com/admin_update.php ?

Do you have any PHP/Apache error logs that are generated when the page load fails?

srussell

from Apache2 error log

From itflow-org/itflow

74aa0e82..c4fd3f74 master -> origin/master

[Sun May 26 10:25:12.408669 2024] [php:error] [pid 516464] [client 206.75.1.34:65292] script '/var/www/support.bossknowledge.com/settings_update.php' not found or unable to stat, referer: https://support.bossknowledge.com/settings_updat>

[Sun May 26 10:25:41.997634 2024] [php:notice] [pid 507649] [client 206.75.1.34:65309] MySQL error: Table 'itflow.user_permissions' doesn't exist

[Sun May 26 10:25:41.999735 2024] [php:warn] [pid 507649] [client 206.75.1.34:65309] PHP Warning: Undefined array key "config_project_prefix" in /var/www/support.bossknowledge.com/get_settings.php on line 62

[Sun May 26 10:25:41.999784 2024] [php:warn] [pid 507649] [client 206.75.1.34:65309] PHP Warning: Undefined array key "config_project_next_number" in /var/www/support.bossknowledge.com/get_settings.php on line 63

[Sun May 26 10:25:41.999806 2024] [php:warn] [pid 507649] [client 206.75.1.34:65309] PHP Warning: Undefined array key "config_stripe_expense_vendor" in /var/www/support.bossknowledge.com/get_settings.php on line 91

[Sun May 26 10:25:41.999822 2024] [php:warn] [pid 507649] [client 206.75.1.34:65309] PHP Warning: Undefined array key "config_stripe_expense_category" in /var/www/support.bossknowledge.com/get_settings.php on line 92

[Sun May 26 10:25:41.999838 2024] [php:warn] [pid 507649] [client 206.75.1.34:65309] PHP Warning: Undefined array key "config_stripe_percentage_fee" in /var/www/support.bossknowledge.com/get_settings.php on line 93

[Sun May 26 10:25:41.999853 2024] [php:warn] [pid 507649] [client 206.75.1.34:65309] PHP Warning: Undefined array key "config_stripe_flat_fee" in /var/www/support.bossknowledge.com/get_settings.php on line 94

[Sun May 26 10:25:41.999903 2024] [php:warn] [pid 507649] [client 206.75.1.34:65309] PHP Warning: Undefined array key "config_ai_enable" in /var/www/support.bossknowledge.com/get_settings.php on line 98

[Sun May 26 10:25:41.999920 2024] [php:warn] [pid 507649] [client 206.75.1.34:65309] PHP Warning: Undefined array key "config_ai_provider" in /var/www/support.bossknowledge.com/get_settings.php on line 99

[Sun May 26 10:25:41.999935 2024] [php:warn] [pid 507649] [client 206.75.1.34:65309] PHP Warning: Undefined array key "config_ai_model" in /var/www/support.bossknowledge.com/get_settings.php on line 100

[Sun May 26 10:25:41.999950 2024] [php:warn] [pid 507649] [client 206.75.1.34:65309] PHP Warning: Undefined array key "config_ai_url" in /var/www/support.bossknowledge.com/get_settings.php on line 101

[Sun May 26 10:25:41.999965 2024] [php:warn] [pid 507649] [client 206.75.1.34:65309] PHP Warning: Undefined array key "config_ai_api_key" in /var/www/support.bossknowledge.com/get_settings.php on line 102

[Sun May 26 10:25:41.999981 2024] [php:warn] [pid 507649] [client 206.75.1.34:65309] PHP Warning: Undefined array key "config_login_remember_me_expire" in /var/www/support.bossknowledge.com/get_settings.php on line 114

[Sun May 26 10:25:41.999997 2024] [php:warn] [pid 507649] [client 206.75.1.34:65309] PHP Warning: Undefined array key "config_destructive_deletes_enable" in /var/www/support.bossknowledge.com/get_settings.php on line 128

[Sun May 26 10:25:42.016111 2024] [php:error] [pid 507649] [client 206.75.1.34:65309] PHP Fatal error: Uncaught mysqli_sql_exception: Unknown column 'project_completed_at' in 'where clause' in /var/www/support.bossknowledge.com/inc_all>

[Sun May 26 10:32:15.261567 2024] [php:notice] [pid 507616] [client 206.75.1.34:65489] MySQL error: Table 'itflow.user_permissions' doesn't exist

[Sun May 26 10:32:15.261947 2024] [php:warn] [pid 507616] [client 206.75.1.34:65489] PHP Warning: Undefined array key "config_project_prefix" in /var/www/support.bossknowledge.com/get_settings.php on line 62

[Sun May 26 10:32:15.261962 2024] [php:warn] [pid 507616] [client 206.75.1.34:65489] PHP Warning: Undefined array key "config_project_next_number" in /var/www/support.bossknowledge.com/get_settings.php on line 63

[Sun May 26 10:32:15.261969 2024] [php:warn] [pid 507616] [client 206.75.1.34:65489] PHP Warning: Undefined array key "config_stripe_expense_vendor" in /var/www/support.bossknowledge.com/get_settings.php on line 91

[Sun May 26 10:32:15.261973 2024] [php:warn] [pid 507616] [client 206.75.1.34:65489] PHP Warning: Undefined array key "config_stripe_expense_category" in /var/www/support.bossknowledge.com/get_settings.php on line 92

[Sun May 26 10:32:15.261978 2024] [php:warn] [pid 507616] [client 206.75.1.34:65489] PHP Warning: Undefined array key "config_stripe_percentage_fee" in /var/www/support.bossknowledge.com/get_settings.php on line 93

[Sun May 26 10:32:15.261983 2024] [php:warn] [pid 507616] [client 206.75.1.34:65489] PHP Warning: Undefined array key "config_stripe_flat_fee" in /var/www/support.bossknowledge.com/get_settings.php on line 94

[Sun May 26 10:32:15.261987 2024] [php:warn] [pid 507616] [client 206.75.1.34:65489] PHP Warning: Undefined array key "config_ai_enable" in /var/www/support.bossknowledge.com/get_settings.php on line 98

[Sun May 26 10:32:15.261992 2024] [php:warn] [pid 507616] [client 206.75.1.34:65489] PHP Warning: Undefined array key "config_ai_provider" in /var/www/support.bossknowledge.com/get_settings.php on line 99

[Sun May 26 10:32:15.261996 2024] [php:warn] [pid 507616] [client 206.75.1.34:65489] PHP Warning: Undefined array key "config_ai_model" in /var/www/support.bossknowledge.com/get_settings.php on line 100

[Sun May 26 10:32:15.262030 2024] [php:warn] [pid 507616] [client 206.75.1.34:65489] PHP Warning: Undefined array key "config_ai_url" in /var/www/support.bossknowledge.com/get_settings.php on line 101

[Sun May 26 10:32:15.262035 2024] [php:warn] [pid 507616] [client 206.75.1.34:65489] PHP Warning: Undefined array key "config_ai_api_key" in /var/www/support.bossknowledge.com/get_settings.php on line 102

[Sun May 26 10:32:15.262040 2024] [php:warn] [pid 507616] [client 206.75.1.34:65489] PHP Warning: Undefined array key "config_login_remember_me_expire" in /var/www/support.bossknowledge.com/get_settings.php on line 114

[Sun May 26 10:32:15.262045 2024] [php:warn] [pid 507616] [client 206.75.1.34:65489] PHP Warning: Undefined array key "config_destructive_deletes_enable" in /var/www/support.bossknowledge.com/get_settings.php on line 128

[Sun May 26 10:32:15.264668 2024] [php:error] [pid 507616] [client 206.75.1.34:65489] PHP Fatal error: Uncaught mysqli_sql_exception: Unknown column 'project_completed_at' in 'where clause' in /var/www/support.bossknowledge.com/inc_all>

[Sun May 26 10:32:20.302163 2024] [php:notice] [pid 507613] [client 206.75.1.34:65492] MySQL error: Table 'itflow.user_permissions' doesn't exist

[Sun May 26 10:32:20.302499 2024] [php:warn] [pid 507613] [client 206.75.1.34:65492] PHP Warning: Undefined array key "config_project_prefix" in /var/www/support.bossknowledge.com/get_settings.php on line 62

[Sun May 26 10:32:20.302510 2024] [php:warn] [pid 507613] [client 206.75.1.34:65492] PHP Warning: Undefined array key "config_project_next_number" in /var/www/support.bossknowledge.com/get_settings.php on line 63

[Sun May 26 10:32:20.302514 2024] [php:warn] [pid 507613] [client 206.75.1.34:65492] PHP Warning: Undefined array key "config_stripe_expense_vendor" in /var/www/support.bossknowledge.com/get_settings.php on line 91

[Sun May 26 10:32:20.302518 2024] [php:warn] [pid 507613] [client 206.75.1.34:65492] PHP Warning: Undefined array key "config_stripe_expense_category" in /var/www/support.bossknowledge.com/get_settings.php on line 92

[Sun May 26 10:32:20.302521 2024] [php:warn] [pid 507613] [client 206.75.1.34:65492] PHP Warning: Undefined array key "config_stripe_percentage_fee" in /var/www/support.bossknowledge.com/get_settings.php on line 93

[Sun May 26 10:32:20.302524 2024] [php:warn] [pid 507613] [client 206.75.1.34:65492] PHP Warning: Undefined array key "config_stripe_flat_fee" in /var/www/support.bossknowledge.com/get_settings.php on line 94

[Sun May 26 10:32:20.302527 2024] [php:warn] [pid 507613] [client 206.75.1.34:65492] PHP Warning: Undefined array key "config_ai_enable" in /var/www/support.bossknowledge.com/get_settings.php on line 98

[Sun May 26 10:32:20.302530 2024] [php:warn] [pid 507613] [client 206.75.1.34:65492] PHP Warning: Undefined array key "config_ai_provider" in /var/www/support.bossknowledge.com/get_settings.php on line 99

[Sun May 26 10:32:20.302534 2024] [php:warn] [pid 507613] [client 206.75.1.34:65492] PHP Warning: Undefined array key "config_ai_model" in /var/www/support.bossknowledge.com/get_settings.php on line 100

[Sun May 26 10:32:20.302537 2024] [php:warn] [pid 507613] [client 206.75.1.34:65492] PHP Warning: Undefined array key "config_ai_url" in /var/www/support.bossknowledge.com/get_settings.php on line 101

[Sun May 26 10:32:20.302540 2024] [php:warn] [pid 507613] [client 206.75.1.34:65492] PHP Warning: Undefined array key "config_ai_api_key" in /var/www/support.bossknowledge.com/get_settings.php on line 102

wrongecho

Looks like you're missing database fields from the recent updates.

Go to itflow.example.com/admin_update.php and hit the database update button.

Failing that, navigate directly to itflow.example.com/post.php?update_db (it will fail to load/redirect, but should apply the updates)

srussell

ok so I can get to this page now after navigating to "itflow.example.com/post.php?updatedb". Gave me a blank page, but after I could navigate to admin_update.php

I click the database update button and I get a green update notification.. except it isn't. and if I click "back | Administration" I go back to the orange bar at the top.

If I refresh the admin_update.php page it still tells me that I am on version 0.9.8

srussell

Why is the database update going up by one version each time I click it?

srussell

OK got it sorted.. I am updating after each click until the php calls match the database backend.. and slowly getting more and more windows back on the front end as I do it.. this is too funny.. I promise to run updates weekly from now on.. only like 30 more clicks to go..

srussell

ok you can close this support ticket…

Maybe add to the WIKI at the top of updates that if your behind you have to click update for each release version until you are current?

Anyways, thank you greatly for your assistance.

wrongecho

Perfect, glad you managed to get this fixed 🙂

The idea is that you update regularly, being too far behind on database updates causes annoying issues because the code itself references tables and columns that don't yet exist.

Each database version runs some SQL commands on the database to adjust the schema. If there's a problem, it's much easier to isolate and troubleshoot one database version migration than it is to try and troubleshoot them all at once.

Maybe add to the WIKI at the top of updates that if your behind you have to click update for each release version until you are current?

This is already mentioned here, bottom of the page: https://docs.itflow.org/updates