Latest from Github... 3.44

[Eduardo Debiusi]

Has anyone had success with the latest release (beta)? 

Installs and I can login but that is it.  cannot select any of the buttons or get into the config.

running 8.4.7 PHP

does not load the regions, region types or roads tables (even after update as requested after running diagnose.php)

and has a version info fatal error:   Fatal error: Uncaught mysqli_sql_exception: Unknown column 'key' in 'where clause' in /hermes/bosnacweb05/bosnacweb05al/b686/dot.davis8721/cisg.us/tickets/tools/diagnose.php:146 Stack trace: #0 /hermes/bosnacweb05/bosnacweb05al/b686/dot.davis8721/cisg.us/tickets/tools/diagnose.php(146): mysqli->query() #1 {main} thrown in /hermes/bosnacweb05/bosnacweb05al/b686/dot.davis8721/cisg.us/tickets/tools/diagnose.php on line 146

[Jeff Carrier]

I chose to attempt to upgrade.  The datbase upgrade seems to go as expected.  I need use the password tool to reset the admin password but that was easy.  When I attempt to login I see the buttons at the top.  Clicking on Situation, New, Units, Fac's, Config and Mobile really just provide a blank screen.  Search, Reports, SOP's, Chat, Help, Log, Links, Requests and ICS-Forms seem to work.  Clicking Board does seem to work mostly.  I'll paste the apache 2 errors and the results of the diag tool below. 

[Wed Apr 01 15:56:55.463266 2026] [core:notice] [pid 859] AH00094: Command line: '/usr/sbin/apache2'
[Wed Apr 01 16:05:40.331633 2026] [php:error] [pid 934] [client 10.101.116.123:54263] PHP Fatal error:  Uncaught mysqli_sql_exception: Expression #22 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'tickets.r.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by in /var/www/html/tickets/incs/db.inc.php:103\nStack trace:\n#0 /var/www/html/tickets/incs/db.inc.php(103): mysqli->query()\n#1 /var/www/html/tickets/incs/status_cats.inc.php(332): db_query()\n#2 /var/www/html/tickets/incs/status_cats.inc.php(374): get_sess_boundaries()\n#3 /var/www/html/tickets/incs/all_forms_js_variables.inc.php(289): get_bnd_session()\n#4 /var/www/html/tickets/forms/sit_screen_NM.php(93): require_once('...')\n#5 /var/www/html/tickets/main.php(165): require_once('...')\n#6 {main}\n  thrown in /var/www/html/tickets/incs/db.inc.php on line 103, referer: http://10.0.0.13/tickets/index.php
[Wed Apr 01 16:05:41.093571 2026] [php:error] [pid 933] [client 10.101.116.123:62751] PHP Fatal error:  Uncaught mysqli_sql_exception: Incorrect DATETIME value: '' in /var/www/html/tickets/incs/db.inc.php:103\nStack trace:\n#0 /var/www/html/tickets/incs/db.inc.php(103): mysqli->query()\n#1 /var/www/html/tickets/get_latest_id.php(264): db_query()\n#2 {main}\n  thrown in /var/www/html/tickets/incs/db.inc.php on line 103, referer: http://10.0.0.13/tickets/top.php?stuff=1082233210
[Wed Apr 01 16:05:44.097448 2026] [php:error] [pid 936] [client 10.101.116.123:55252] PHP Fatal error:  Uncaught mysqli_sql_exception: Expression #22 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'tickets.r.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by in /var/www/html/tickets/incs/db.inc.php:103\nStack trace:\n#0 /var/www/html/tickets/incs/db.inc.php(103): mysqli->query()\n#1 /var/www/html/tickets/incs/status_cats.inc.php(332): db_query()\n#2 /var/www/html/tickets/incs/status_cats.inc.php(374): get_sess_boundaries()\n#3 /var/www/html/tickets/incs/all_forms_js_variables.inc.php(289): get_bnd_session()\n#4 /var/www/html/tickets/add.php(754): require_once('...')\n#5 {main}\n  thrown in /var/www/html/tickets/incs/db.inc.php on line 103, referer: http://10.0.0.13/tickets/top.php?stuff=1082233210
[Wed Apr 01 16:05:48.531769 2026] [php:error] [pid 936] [client 10.101.116.123:55252] PHP Fatal error:  Uncaught mysqli_sql_exception: Expression #22 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'tickets.r.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by in /var/www/html/tickets/incs/db.inc.php:103\nStack trace:\n#0 /var/www/html/tickets/incs/db.inc.php(103): mysqli->query()\n#1 /var/www/html/tickets/incs/status_cats.inc.php(332): db_query()\n#2 /var/www/html/tickets/incs/status_cats.inc.php(374): get_sess_boundaries()\n#3 /var/www/html/tickets/incs/all_forms_js_variables.inc.php(289): get_bnd_session()\n#4 /var/www/html/tickets/units.php(253): require_once('...')\n#5 {main}\n  thrown in /var/www/html/tickets/incs/db.inc.php on line 103, referer: http://10.0.0.13/tickets/top.php?stuff=1082233210

TicketsCAD Diagnostic Report
Generated: 2026-04-02 16:12:02 UTC

1. PHP Environment
PHP Version: 8.3.6 (Warning: utf8_encode/utf8_decode removed in 8.2)

✓ Password hashing (PHP 5.5+) (password_hash)

✓ Password verification (PHP 5.5+) (password_verify)

✓ JSON encoding (json_encode)

✓ JSON decoding (json_decode)

✓ MySQLi extension (mysqli_connect)

✓ OpenSSL extension (openssl_encrypt)

✓ Session support (session_start)

PHP 8.2+ Removed Functions Check
✓ utf8_encode — available (polyfill installed)

✓ utf8_decode — available (polyfill installed)

2. Database Connection
✓ Config file exists

Host: localhost | User: jeff | Database: evraz-tickets

✓ Connected to database: 8.0.45-0ubuntu0.24.04.1

3. Required Tables
Total tables found: 118

✓ user

✓ ticket

✓ responder

✓ in_types

✓ facilities

✓ action

✓ assigns

✓ allocates

✓ log

✓ settings

✓ sound_settings

✓ codes

✗ regions — MISSING

✗ region_types — MISSING

✗ road_info — MISSING

✓ mmarkup

✓ mmarkup_cats

Missing tables detected. Re-run the installer in Upgrade mode to create them.

4. Admin Account
ID Username Level Hash Type
1 admin 1 bcrypt (modern) (len=60)
5 jcarrier 0 bcrypt (modern) (len=60)
5. Version Info

Fatal error: Uncaught mysqli_sql_exception: Unknown column 'key' in 'where clause' in /var/www/html/tickets/tools/diagnose.php:146 Stack trace: #0 /var/www/html/tickets/tools/diagnose.php(146): mysqli->query() #1 {main} thrown in /var/www/html/tickets/tools/diagnose.php on line 146

[Eric Osterberg]

Subject: Re: Upgrade issues — fix available

Hi Jeff,

Thanks for the detailed error logs — that made this easy to diagnose. There are two issues, both caused by MySQL 8.0's strict mode which your Ubuntu 24.04 server uses by default.

What's happening

1. "Expression #22 of SELECT list is not in GROUP BY clause" — MySQL 8.0 enables ONLY_FULL_GROUP_BY by default, which rejects the legacy query pattern used in the Situation, New, Units, Fac's, and Config pages. Older MySQL versions allowed this.

2. "Incorrect DATETIME value: ''" — MySQL 8.0 strict mode also rejects empty strings for date/time columns. The legacy code uses '' instead of NULL in some places.

Both of these break pages that work fine on MySQL 5.7.

The Fix

I just pushed a fix that sets a compatible SQL mode at connection time. To apply it:

Pull the latest code:

cd /var/www/html/tickets
git pull origin main

Or download just the two fixed files:

cd /var/www/html/tickets
curl -L https://raw.githubusercontent.com/openises/tickets/main/incs/db.inc.php -o incs/db.inc.php
curl -L https://raw.githubusercontent.com/openises/tickets/main/incs/functions.inc.php -o incs/functions.inc.php

After that, refresh the page — Situation, New, Units, Fac's, Config, and Mobile should all work.

The diagnose.php error

The "Unknown column 'key'" error in diagnose.php is also fixed in this update. The settings table uses name as the column name, not key. The updated diagnose.php handles both.

Missing tables

Your diagnostic shows regions, region_types, and road_info are missing. After applying the fix above, run the installer in Upgrade mode:

http://your-server/tickets/install.php

Select Upgrade and click Do It. This will create the missing tables without affecting your existing data.

Let me know if you hit any other issues!

Best,
Eric

--
You received this message because you are subscribed to the Google Groups "Open Source CAD" group.
To unsubscribe from this group and stop receiving emails from it, send an email to open-source-c...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/open-source-cad/891bd540-87e5-48c7-bc89-e215b40bc227n%40googlegroups.com.

[Jeff Carrier]

Eric, 

Thank you that did the trick.

To view this discussion visit https://groups.google.com/d/msgid/open-source-cad/CAJLaYFVrCXVBw3Y%3DD7rhgz%3Dn-krppcZX85BezEZd6TKT_v9UMw%40mail.gmail.com.