After Update, Blank Pages

plaguelessio

Hello,

I went to start an update on my ITFlow Install, and it immediately went to a Blank Page (No Database update was performed). The only thing visible with my installation is the Top Nav Bar with Search, but nothing works.

I unfortunately do not have a snapshot and am not able to roll back. Any way to fix this, or is a Reinstall required?

Installed Using: Installation Script

Updated before?: Yes, no issues previously

OS: Debian 6.1

This is my Log from Apache

[Sat Oct 12 00:57:08.603902 2024] [php:warn] [pid 641:tid 641] [client REDACTED] PHP Warning: Undefined array key "config_invoice_paid_notification_email" in /var/www/[REDACTED]/get_settings.php on line 49

[Sat Oct 12 00:57:08.605701 2024] [php:error] [pid 641:tid 641] [client REDACTED] PHP Fatal error: Uncaught mysqli_sql_exception: Table 'itflow.custom_links' doesn't exist in /var/www/[[[REDACTED]]]/top_nav.php:33\nStack trace:\n#0 /var/www/[REDACTED]/top_nav.php(33): mysqli_query()\n#1 /var/www/[REDACTED]/inc_all_admin.php(16): require_once('...')\n#2 /var/www/[REDACTED]/admin_update.php(2): require_once('...')\n#3 {main}\n thrown in /var/www/[REDACTED]/top_nav.php on line 33

Thanks in Advanced! URL and IP Addresses are Redacted for Privacy.

wrongecho

Hey @plaguelessio

Please see this thread: https://forum.itflow.org/d/1167-update-db-problem/

plaguelessio

wrongecho

Hey,

Thanks for the reply! I have already attempted to drop the table, but that has not worked.

Our errors are slightly different.

My Error is:

PHP Fatal error: Uncaught mysqli_sql_exception: Table 'itflow.custom_links' doesn't exist

That users error is:

PHP Fatal error: Uncaught mysqli_sql_exception: Table 'custom_links' already exists in

Thanks!

johnny

Its looking for the custom links table that doesn't exist

Depending on what DB Version you are on your going to have to add these fields if they don't exist and then manually

itflow-org/itflowblob/bfd5973be8b085e31457f3f4cd4b76a846e79dc3/database_updates.php#L2212C5-L2239C1

then increase your database version in the settings table

plaguelessio

johnny

Thanks for the Reply,

I ended up adding in those fields into the Table, but then it called for more in the logs.

So I ended up reinstalling it, not sure why this happened or what step I missed during the Update, but I have now enabled backups on the server just incase this happens again.

Thanks for the Assistance!

johnny

Your welcome @plaguelessio

Im glad reinstalling resolved the issue,

Buy yes backups are always key, it may be worth doing a VM snapshot before updating as well. This is available in all the major hypervisors including Proxmox, VMware, XCP-NG, Hyper V etc

Alan

There should be 96 tables (you've got 94) and more updates than that (but don't look at me for how to fix DBs 😃)

Techtronics

I'm encountering the same issue when attempting to upgrade—it's breaking. Has anyone found a way to successfully update the app without it breaking or requiring extensive debugging and db work? @johnny

Before Update:

Server Info

PHP version: 8.1.29
Database Version: 10.6.18-MariaDB-0ubuntu0.22.04.1 / 100618
Operating System: Linux techtronics-Standard-PC-Q35-ICH9-2009 6.8.0-45-generic #45~22.04.1-Ubuntu SMP PREEMPT_DYNAMIC Wed Sep 11 15:25:05 UTC 2 x86_64
Web Server: Apache/2.4.52 (Ubuntu)
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: 29
Total size of files in uploads and its subdirectories: 0.8 MB

`ITFlow app`

App Version: 0f6ed690088819336e7be2b0acc9b911cf340d4e
Cron enabled: 1
App Timezone: Australia/Melbourne

`Database Structure Check`

`Database stats`

Number of tables: 93
Total number of fields: 919
Total number of rows: 5068
Current Database Version: 1.4.5

After Update:🇫

[Thu Oct 17 15:04:05.184608 2024] [php:warn] [pid 853] [client] PHP Warning: Undefined array key "last_visited" in /path/to/login.php on line 221, referer: /path/to/login.php

[Thu Oct 17 15:10:01.110697 2024] [php:warn] [pid 850] [client] PHP Warning: Undefined variable $comments in /path/to/setting.php on line 985, referer: /path/to/admin_update.php

[Thu Oct 17 15:10:03.477920 2024] [php:warn] [pid 850] [client] PHP Warning: require_once(post/software.php): Failed to open stream: No such file or directory in /path/to/post.php on line 71, referer: /path/to/admin_update.php

[Thu Oct 17 15:10:03.478142 2024] [php:error] [pid 850] [client] PHP Fatal error: Uncaught Error: Failed opening required 'post/software.php' (include_path='.:/usr/share/php') in /path/to/post.php:71\nStack trace:\n#0 {main}\n thrown in /path/to/post.php on line 71, referer: /path/to/admin_update.php

[Thu Oct 17 15:10:03.552786 2024] [php:warn] [pid 1772] [client] PHP Warning: Undefined array key "config_invoice_paid_notification_email" in /path/to/get_settings.php on line 49, referer: /path/to/admin_update.php

[Thu Oct 17 15:10:03.552852 2024] [php:warn] [pid 1772] [client] PHP Warning: Undefined array key "config_whitelabel_enabled" in /path/to/get_settings.php on line 134, referer: /path/to/admin_update.php

[Thu Oct 17 15:10:03.552861 2024] [php:warn] [pid 1772] [client] PHP Warning: Undefined array key "config_whitelabel_key" in /path/to/get_settings.php on line 135, referer: /path/to/admin_update.php

[Thu Oct 17 15:10:03.554004 2024] [php:error] [pid 1772] [client] PHP Fatal error: Uncaught mysqli_sql_exception: Table 'itflow.custom_links' doesn't exist in /path/to/top_nav.php:33\nStack trace:\n#0 /path/to/top_nav.php(33): mysqli_query()\n#1 /path/to/inc_all_admin.php(16): require_once('...')\n#2 /path/to/admin_update.php(2): require_once('...')\n#3 {main}\n thrown in /path/to/top_nav.php on line 33, referer: /path/to/admin_update.php

opensourcefollower

Techtronics

I don't know if is the cause of the issue but if I recall correctly. You might want to upgrade your PHP version to 8.3.

might be worth doing a snapshot and upgrade to 8.3.

wrongecho

Please don't tag onto other peoples threads, start your own.