Impossible to add license

jabad

All the modals works except the license one working on internet with https. ITflow was installed manually over LAMP stack, that's running other sites for example wordpress sites.

php version is 8.0 8.1 causes server error 500

wrongecho

Do you get any PHP errors (/var/log/apache2/error.log) when you load the licenses page?

jabad

i cleaned the error log and i started since begining entering to it flow and going to clients section and then licenses.

here are the errors that appears

[Mon Jul 08 08:40:11.640427 2024] [:error] [pid 411834:tid 139939534132992] [remote x.x.x.xFastCGI: server "/usr/lib/cgi-bin/php80-fcgi-www" stderr: PHP message: PHP Warning: Undefined variable $software_created_at in /var/www/html/client_software_add_modal.php on line 157PHP message: PHP Fatal error: Uncaught TypeError: mysqli_fetch_array(): Argument #1 ($result) must be of type mysqli_result, bool given in /var/www/html/client_software_add_modal.php:159, referer: https://mysite/client_overview.php?client_id=1

[Mon Jul 08 08:40:11.640441 2024] [:error] [pid 411834:tid 139939534132992] [remote x.x.x.xFastCGI: server "/usr/lib/cgi-bin/php80-fcgi-www" stderr: Stack trace:, referer: https://mysite/client_overview.php?client_id=1

[Mon Jul 08 08:40:11.640444 2024] [:error] [pid 411834:tid 139939534132992] [remote x.x.x.xFastCGI: server "/usr/lib/cgi-bin/php80-fcgi-www" stderr: #0 /var/www/html/client_software_add_modal.php(159): mysqli_fetch_array(), referer: https://mysite/client_overview.php?client_id=1

[Mon Jul 08 08:40:11.640446 2024] [:error] [pid 411834:tid 139939534132992] [remote x.x.x.xFastCGI: server "/usr/lib/cgi-bin/php80-fcgi-www" stderr: #1 /var/www/html/client_software.php(183): require_once('...'), referer: https://mysite/client_overview.php?client_id=1

[Mon Jul 08 08:40:11.640448 2024] [:error] [pid 411834:tid 139939534132992] [remote x.x.x.xFastCGI: server "/usr/lib/cgi-bin/php80-fcgi-www" stderr: #2 {main}, referer: https://mysite/client_overview.php?client_id=1

[Mon Jul 08 08:40:11.640718 2024] [fastcgi:error] [pid 411834:tid 139938616043264] [client x.x.x.xFastCGI: server "/usr/lib/cgi-bin/php80-fcgi-www" stderr: thrown in /var/www/html/client_software_add_modal.php on line 159/html/client_software_add_modal.php on line 157PHP message: PHP Fatal error: Uncaught TypeError: mysqli_fetch_array(): Argument #1 ($result) must be of type mysqli_result, bool given in /var/www/html/client_software_add_modal.php:159, referer: https://mysite/client_overview.php?client_id=1

E-werd

I wanted to piggy back off of this, as I'm having the same issue on 2 of 4 clients. My error messages look a little different, but similar--maybe more descriptive? A couple lines apart from @jabad

I am on PHP 8.3, nginx 1.27.0, ITFlow up-to-date.

2024/07/08 10:13:23 [error] 3106831#3106831: *87443 FastCGI sent in stderr: "PHP message: PHP Warning: Undefined variable $software_created_at in /opt/itflow/client_software_add_modal.php on line 157; PHP message: PHP Fatal error: Uncaught mysqli_sql_exception: Incorrect DATETIME value: '' in /opt/itflow/client_software_add_modal.php:157

Stack trace:

#0 /opt/itflow/client_software_add_modal.php(157): mysqli_query()

#1 /opt/itflow/client_software.php(182): require_once('...')

#2 {main}

thrown in /opt/itflow/client_software_add_modal.php on line 157" while reading upstream, client: <ipv6prefix>:a45d:722:24f0:d41a, server: <domain>, request: "GET /client_software.php?client_id=1 HTTP/3.0", upstream: "fastcgi://unix:/var/run/php/php-fpm.sock:", referrer: "https://<domain>/client_overview.php?client_id=1"

And then on the other client…

2024/07/08 10:16:22 [error] 3106830#3106830: *87480 FastCGI sent in stderr: "PHP message: PHP Warning: Undefined variable $software_created_at in /opt/itflow/client_software_add_modal.php on line 157; PHP message: PHP Fatal error: Uncaught mysqli_sql_exception: Incorrect DATETIME value: '' in /opt/itflow/client_software_add_modal.php:157

Stack trace:

#0 /opt/itflow/client_software_add_modal.php(157): mysqli_query()

#1 /opt/itflow/client_software.php(182): require_once('...')

#2 {main}

thrown in /opt/itflow/client_software_addmodal.php on line 157" while reading upstream, client: <ipv6prefix>:a45d:722:24f0:d41a, server: <domain>, request: "GET /client_software.php?client_id=2 HTTP/3.0", upstream: "fastcgi://unix:/var/run/php/php-fpm.sock:", referrer: "https://<domain>/client_overview.php?client_id=2"

wrongecho

Hey both @jabad @E-werd

Helpful logs, thanks.

What database are you guys running - MariaDB or MySQL?

Would either of you be up for sharing a database dump of your software table over DM?

E-werd

wrongecho

MySQL 8.0.37-0ubuntu0.22.04.3

There's nothing sensitive in the table right now, so here's a dump: https://pastebin.com/jAFmqLWM

jabad

MySql

jabad

identically output

johnny

I think we may have a fix please stay tuned for an update then we will need you to test. Seems to be related to MySQL only and not MariaDB

johnny

Pushed out a possible fix can you please update and confirm @E-werd and @jabad

itflow-org/itflow50bdeae

jabad

Seem's that now is working thankyou very much

johnny

jabad Awesome! Gonna mark this completed.

wrongecho

Thanks for sticking with us!

Ideally I'd recommend moving to MariaDB, we seem to run into these weird MySQL issues a lot.