Unable to update via GUI or `git pull`

darrellh

Hello, I have a similar issue as others and have tried all suggested steps except reinstalling then migrating. I do have this running on Proxmox with scheduled backups and manual snapshots when trying to update/upgrade.

Here is my server currently:

Server Info

PHP version: 8.2.20
MySQL Version: 101106
Operating System: Linux support 6.8.12-1-pve #1 SMP PREEMPT_DYNAMIC PMX 6.8.12-1 (2024-08-05T16:17Z) x86_64
Web Server: Apache/2.4.59 (Debian)
Apache/PHP Error Log: Debian/Ubuntu default is usually /var/log/apache2/error.log

File System

Total number of files in uploads and its subdirectories: 20
Total size of files in uploads and its subdirectories: 1.32 MB

ITFlow app

App Version: dcc0d77dd47137874856fb3437b78318f80d1a19
Cron enabled: 1
App Timezone: America/Detroit

Database Structure Check

Database stats

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

/var/log/apache2/error.log before hitting update

[Wed Oct 16 08:42:01.593725 2024] [mpm_prefork:notice] [pid 220] AH00171: Graceful restart requested, doing restart
[Wed Oct 16 08:42:01.641304 2024] [mpm_prefork:notice] [pid 220] AH00163: Apache/2.4.59 (Debian) OpenSSL/3.0.13 configured -- resuming normal operations
[Wed Oct 16 08:42:01.641328 2024] [core:notice] [pid 220] AH00094: Command line: '/usr/sbin/apache2'
[Wed Oct 16 13:50:41.499680 2024] [php:warn] [pid 60321] [client x.x.x.x:0] PHP Warning: Undefined array key "last_visited" in /var/www/support.example.com/login.php on line 221, referer: https://support.example.com/login.php
[Wed Oct 16 14:40:40.983336 2024] [mpm_prefork:notice] [pid 264] AH00163: Apache/2.4.59 (Debian) OpenSSL/3.0.13 configured -- resuming normal operations
[Wed Oct 16 14:40:40.985031 2024] [core:notice] [pid 264] AH00094: Command line: '/usr/sbin/apache2'
[Wed Oct 16 14:40:59.289175 2024] [php:warn] [pid 283] [client x.x.x.x:0] PHP Warning: Undefined array key "last_visited" in /var/www/support.example.com/login.php on line 221, referer: https://support.example.com/login.php
[Wed Oct 16 14:42:15.338039 2024] [php:warn] [pid 285] [client x.x.x.x:0] PHP Warning: Undefined variable $largest_income_month in /var/www/support.example.com/dashboard.php on line 869, referer: https://support.example.com/login.php
[Wed Oct 16 14:42:21.341004 2024] [php:warn] [pid 284] [client x.x.x.x:0] PHP Warning: Undefined variable $largest_income_month in /var/www/support.example.com/dashboard.php on line 869, referer: https://support.example.com/login.php
[Wed Oct 16 14:42:24.667890 2024] [php:warn] [pid 284] [client x.x.x.x:0] PHP Warning: Undefined variable $largest_income_month in /var/www/support.example.com/dashboard.php on line 869, referer: https://support.example.com/dashboard.php?enable_financial=0&enable_technical=0&year=2024&enable_technical=1

So then I hit update:

and get:

After hitting update - /var/log/apache2/error.log

[Wed Oct 16 14:42:21.341004 2024] [php:warn] [pid 284] [client x.x.x.x:0] PHP Warning: Undefined variable $largest_income_month in /var/www/support.example.com/dashboard.php on line 869, referer: https://support.example.com/dashboard.php
Wed Oct 16 14:42:24.667890 2024] [php:warn] [pid 284] [client x.x.x.x:0] PHP Warning: Undefined variable $largest_income_month in /var/www/support.example.com/dashboard.php on line 869, referer: https://support.example.com/dashboard.php?enable_financial=0&enable_technical=0&year=2024&enable_technical=1
[Wed Oct 16 14:51:19.755625 2024] [php:warn] [pid 549] [client x.x.x.x:0] PHP Warning: Undefined variable $comments in /var/www/support.example.com/post/setting.php on line 985, referer: https://support.example.com/admin_update.php
[Wed Oct 16 14:51:21.264587 2024] [php:warn] [pid 549] [client x.x.x.x:0] PHP Warning: require_once(post/software.php): Failed to open stream: No such file or directory in /var/www/support.example.com/post.php on line 71, referer: https://support.example.com/admin_update.php
[Wed Oct 16 14:51:21.264829 2024] [php:error] [pid 549] [client x.x.x.x:0] PHP Fatal error: Uncaught Error: Failed opening required 'post/software.php' (include_path='.:/usr/share/php') in /var/www/support.example.com/post.php:71\nStack trace:\n#0 {main}\n thrown in /var/www/support.example.com/post.php on line 71, referer: https://support.example.com/admin_update.php
[Wed Oct 16 14:51:21.329021 2024] [php:warn] [pid 549] [client x.x.x.x:0] PHP Warning: Undefined array key "config_invoice_paid_notification_email" in /var/www/support.example.com/get_settings.php on line 49, referer: https://support.example.com/admin_update.php
[Wed Oct 16 14:51:21.329098 2024] [php:warn] [pid 549] [client x.x.x.x:0] PHP Warning: Undefined array key "config_ticket_email_parse_unknown_senders" in /var/www/support.example.com/get_settings.php on line 72, referer: https://support.example.com/admin_update.php
[Wed Oct 16 14:51:21.329112 2024] [php:warn] [pid 549] [client x.x.x.x:0] PHP Warning: Undefined array key "config_whitelabel_enabled" in /var/www/support.example.com/get_settings.php on line 134, referer: https://support.example.com/admin_update.php
[Wed Oct 16 14:51:21.329137 2024] [php:warn] [pid 549] [client x.x.x.x:0] PHP Warning: Undefined array key "config_whitelabel_key" in /var/www/support.example.com/get_settings.php on line 135, referer: https://support.example.com/admin_update.php
[Wed Oct 16 14:51:21.329903 2024] [php:error] [pid 549] [client x.x.x.x:0] PHP Fatal error: Uncaught mysqli_sql_exception: Table 'itflow.custom_links' doesn't exist in /var/www/support.example.com/top_nav.php:33\nStack trace:\n#0 /var/www/support.example.com/top_nav.php(33): mysqli_query()\n#1 /var/www/support.example.com/inc_all_admin.php(16): require_once('...')\n#2 /var/www/support.example.com/admin_update.php(2): require_once('...')\n#3 {main}\n thrown in /var/www/support.example.com/top_nav.php on line 33, referer: https://support.example.com/admin_update.php

I have also tried doing git pull in the web dir and no change. I have not customized anything in the web dir or db table aside from in GUI - adding customers, tickets, etc. Any help would be appreciated.

wrongecho

App Version: dcc0d77dd47137874856fb3437b78318f80d1a19

Commit dcc0d77dd47137874856fb3437b78318f80d1a19 is from July. You're pretty far behind on updates.

darrellh

wrongecho I've been working to get updates working since. Always the same behavior.

wrongecho

darrellh

That would probably be helpful to note initially, your post made it sound as though this was something more recent.

After running git pull at the CLI, are you then able to navigate to https://demo.itflow.org/post.php?update_db (obviously replace the domain name)?

Isaac

wrongecho

With todays git pull I also end up in 500 errors - post.php?update_db redirects to login and after login the 500 error appears again. So do I have to manually perform the mysql db update via phpmyadmin or something else or is there another method?

[Wed Oct 23 09:28:23.213369 2024] [proxy_fcgi:error] [pid 2868961:tid 2869015] [client xx.yy.zz.142:0] AH01071: Got error 'PHP message: PHP Fatal error:  Uncaught mysqli_sql_exception: Unknown column 'user_type' in 'where home/mydomain/web/helpdesk.mydomain.com/public_html/login.php:106\nStack trace:\n#0 /home/mydomain/web/helpdesk.mydomain.com/public_html/login.php(106): mysqli_query()\n#1 {main}\n  thrown inerei/web/helpdesk.mydomain.com/public_html/login.php on line 106', referer: https://helpdesk.mydomain.com/login.php?last_visited=L3RpY2tldHMucGhw

wrongecho

Isaac

Do you have a way to reverting to before the upgrade? E.g. A snapshot of the disk?

Isaac

wrongecho

Wouldn't it be easiest to checkout git from Oct 21 for example? Have to find the git command for it 😊

Update: Just updated the db manually with the three commands. Login worked after that so I could make the other outstanding db updates up to v1.5.8 via the GUI 👍

ALTER TABLE `users` ADD `user_type` TINYINT(1) NOT NULL DEFAULT 1 AFTER `user_password`
ALTER TABLE `user_roles` ADD `user_role_type` TINYINT(1) NOT NULL DEFAULT 1 AFTER `user_role_description`
UPDATE `settings` SET `config_current_database_version` = '1.5.5'

wrongecho

Isaac

I was going to suggest rolling back and just downloading the update files, but that works too.

If you go on Settings > Debug, you should now have:

Number of tables: 96
Total number of fields: 939

darrellh

Isaac Can you details the steps you took? I am getting the same 500 page after running the three commands.

Isaac

darrellh just updated the db manually with above shownw SQL commands (used phpMyAdmin)

P.S. But check before if you are at the same db status/version, If not you eventually need more/other SQL commands. I checked the git commits on github for that to find the DB update commands.