Cannot Update.

benmyers

Hi I have been trying to update to a new version for a while. Everytime I try it crashes my instance and I have to restore via backup. (proxmox restore).

tail -f /var/log/apache2/error.log

* [new tag] v25.02 -> v25.02

* [new tag] v25.02.1 -> v25.02.1

* [new tag] v25.02.2 -> v25.02.2

* [new tag] v25.02.3 -> v25.02.3

* [new tag] v25.02.4 -> v25.02.4

* [new tag] v25.03 -> v25.03

[Tue May 20 05:58:09.071744 2025] [php:warn] [pid 770] [client 192.168.186.48:58359] PHP Warning: Undefined variable $comments in /var/www/flow.domain.com.au/post/setting.php on lireferer: http://flow.domain.com.au/admin_update.php

[Tue May 20 05:58:11.801646 2025] [php:warn] [pid 770] [client 192.168.186.48:58359] PHP Warning: require_once(post/software.php): Failed to open stream: No such file or directory www/flow.domain.com.au/post.php on line 71, referer: http://flow.domain.com.au/admin_update.php

[Tue May 20 05:58:11.801752 2025] [php:error] [pid 770] [client 192.168.186.48:58359] PHP Fatal error: Uncaught Error: Failed opening required 'post/software.php' (include_path='.:re/php') in /var/www/flow.domain.com.au/post.php:71\nStack trace:\n#0 {main}\n thrown in /var/www/flow.domain.com.au/post.php on line 71, referer: http://flow.domain.com.au/admin_up

[Tue May 20 05:58:11.857560 2025] [php:error] [pid 770] [client 192.168.186.48:58359] PHP Fatal error: Uncaught mysqli_sql_exception: Unknown column 'role_id' in 'ON' in /var/www/fal.com.au/includes/check_login.php:45\nStack trace:\n#0 /var/www/flow.domain.com.au/includes/check_login.php(45): mysqli_query()\n#1 /var/www/flow.domain.com.au/includes/inc_all_adm): require_once('...')\n#2 /var/www/flow.domain.com.au/admin_update.php(2): require_once('...')\n#3 {main}\n thrown in /var/www/flow.domain.com.au/includes/check_login.php on line rer: http://flow.domain.com.au/admin_update.php

I have also just tried to restore my sql backup,uploads directory, updating config.php to a new instace but connot login( probably as my restored db is too old)
tail -f /var/log/apache2/error.log

[Tue May 20 15:12:15.483377 2025] [core:notice] [pid 18657:tid 18657] AH00094: Command li ne: '/usr/sbin/apache2'

[Tue May 20 15:36:02.738419 2025] [mpm_prefork:notice] [pid 18657:tid 18657] AH00171: Gra ceful restart requested, doing restart

[Tue May 20 15:36:02.953108 2025] [mpm_prefork:notice] [pid 18657:tid 18657] AH00163: Apa che/2.4.62 (Debian) configured -- resuming normal operations

[Tue May 20 15:36:02.953138 2025] [core:notice] [pid 18657:tid 18657] AH00094: Command li ne: '/usr/sbin/apache2'

[Tue May 20 15:36:03.030490 2025] [mpm_prefork:notice] [pid 18657:tid 18657] AH00171: Gra ceful restart requested, doing restart

[Tue May 20 15:36:03.172222 2025] [mpm_prefork:notice] [pid 18657:tid 18657] AH00163: Apa che/2.4.62 (Debian) configured -- resuming normal operations

[Tue May 20 15:36:03.172253 2025] [core:notice] [pid 18657:tid 18657] AH00094: Command li ne: '/usr/sbin/apache2'

[Tue May 20 15:45:22.186257 2025] [php:error] [pid 25251:tid 25251] [client 192.168.186.4 8:56969] PHP Fatal error: Uncaught mysqli_sql_exception: Unknown column 'user_type' in ' WHERE' in /var/www/flow.domain.com.au/login.php:106\nStack trace:\n#0 /var/www/flow.domain.com.au/login.php(106): mysqli_query()\n#1 {main}\n thrown in /var/www/flow.domain.com.au au/login.php on line 106, referer: http://flow.domain.com.au/login.php

[Tue May 20 15:45:29.589735 2025] [php:error] [pid 25207:tid 25207] [client 192.168.186.4 8:57001] PHP Fatal error: Uncaught mysqli_sql_exception: Unknown column 'user_type' in ' WHERE' in /var/www/flow.domain.com.au/login.php:106\nStack trace:\n#0 /var/www/flow.domain.com.au/login.php(106): mysqli_query()\n#1 {main}\n thrown in /var/www/flow.domain.com.au au/login.php on line 106, referer: http://flow.domain.com.au/login.php

[Tue May 20 15:46:40.887995 2025] [php:error] [pid 25204:tid 25204] [client 192.168.186.4 8:57101] PHP Fatal error: Uncaught mysqli_sql_exception: Unknown column 'user_type' in ' WHERE' in /var/www/flow.domain.com.au/login.php:106\nStack trace:\n#0 /var/www/flow.domain.com.au/login.php(106): mysqli_query()\n#1 {main}\n thrown in /var/www/flow.domain.com.au au/login.php on line 106, referer: http://flow.domain.com.au/login.php

Please help

wrongecho

Hello @benmyers and welcome,

Great use of VM snapshots! Could you please confirm:

The current application release version you are on
How you're attempting to perform the update

benmyers

wrongecho

Hi @wrongecho,

Thanks for yoyr help, please see details below. I was just using the update button under Maintenance.

ITFlow app

App Version: dcc0d77dd47137874856fb3437b78318f80d1a19
Cron enabled: 0
App Timezone: Australia/Brisbane

Database Structure Check

Database stats

Number of tables: 94
Total number of fields: 918
Total number of rows: 481
Current Database Version: 1.4.2

wrongecho

benmyers Commit dcc0d77dd47137874856fb3437b78318f80d1a19 was released in July last year. You are incredibly out of date given how fast this project was moving at the time. We have since slowed to a regular release cycle.

I would recommend, after taking a snapshot, that you manually update at the CLI.

Run the following to update the files using git (because I don't think we even had the CLI update script at that point):

cd /var/www/itflow.xxxxx/
sudo -u www-data git pull

Assuming the latest files download successfully, update the the database schema until it says you're latest:

cd /var/www/itflow.xxxxx/scripts/
sudo -u www-data php update_cli.php --update_db

benmyers

wrongecho thank you so much, it's now updated and working. Been meaning to do this for a while but it kept failing so I ignored it until today!

wrongecho

benmyers Great to hear, you're welcome!