Reports: Relate Trackers to Assigned user throws an SQL error #5367

New issue

Open

opened 2026-02-20 17:00:15 -05:00 by deekerman · 0 comments

deekerman commented

2026-02-20 17:00:15 -05:00

Owner

Originally created by @BastianHammer on GitHub (Feb 6, 2026).

Issue

I can build a report on the tracker module without any issues.

When I want to join the username or users last name via the related module, I get an error in the suitecrm.log:

[58990][1][FATAL] Query Failed: SELECT tracker.action AS 'Action0', tracker.date_modified AS 'Date_of_Last_Action1', tracker.item_summary AS 'Item_Summary2', tracker.user_id AS 'User_Id3', tracker.module_name AS 'Trackers4', tracker.session_id AS 'Session_Id5', tracker:assigned_user_link.user_name AS 'Username6', tracker.id AS 'tracker_id' FROM tracker WHERE tracker.deleted = 0 ORDER BYtracker.date_modified DESC LIMIT 0,20: MySQL error 1054: Unknown column 'tracker:assigned_user_link.user_name' in 'SELECT'

and my report stays empty.

(Interesting: The field name of the username disappears after saving the report and editing again)

Possible Fix

No response

Steps to Reproduce the Issue

See screenshot above of report

Context

No response

Version

8.9.2

What browser are you currently using?

Chrome

Browser Version

No response

Environment Information

MariaDB, PHP8.3

Operating System and Version

Ubuntu 24

Originally created by @BastianHammer on GitHub (Feb 6, 2026). ### Issue I can build a report on the tracker module without any issues. When I want to join the username or users last name via the related module, I get an error in the suitecrm.log: `[58990][1][FATAL] Query Failed: SELECT `tracker`.action AS 'Action0', `tracker`.date_modified AS 'Date_of_Last_Action1', `tracker`.item_summary AS 'Item_Summary2', `tracker`.user_id AS 'User_Id3', `tracker`.module_name AS 'Trackers4', `tracker`.session_id AS 'Session_Id5', `tracker:assigned_user_link`.user_name AS 'Username6', `tracker`.id AS 'tracker_id' FROM `tracker` WHERE tracker.deleted = 0 ORDER BY `tracker`.date_modified DESC LIMIT 0,20: MySQL error 1054: Unknown column 'tracker:assigned_user_link.user_name' in 'SELECT'` and my report stays empty. <img width="2468" height="879" alt="Image" src="https://github.com/user-attachments/assets/e417f3d9-0666-4cef-9b3f-1cdf6d6ca119" /> (Interesting: The field name of the username disappears after saving the report and editing again) ### Possible Fix _No response_ ### Steps to Reproduce the Issue ```bash See screenshot above of report ``` ### Context _No response_ ### Version 8.9.2 ### What browser are you currently using? Chrome ### Browser Version _No response_ ### Environment Information MariaDB, PHP8.3 ### Operating System and Version Ubuntu 24