I'm back with another error that is beyond my knowledge scope and I unfortunately have not been able to find a clear or direct answer/fix for my issue while browsing the forums. Hopefully someone here may be able to shed some light on this!
First, I know Mantis supports MySQL but we are using MSSQL 2016 and it has been working splendidly until this new problem. I appreciate any help that can be given.
System Specs
MantisBT version 2.17.1 on a fresh Hyper-V VM in Server 2012 R2 Standard in IIS 8.5.
2 virtual processors | 4GB of RAM
SQL Server 2016 as database software
PHP versions installed are v5.3 and v7.2 with v7.2 the one being utilized.
The Problem
After enabling the Time Tracking feature, I discovered that it appears to work fine when I go to Time Tracking on the left window area and search, but when I am inside of a ticket (having clicked on a ticket number) and then go to Time Tracking, I get the following error - -
One minor difference I wanted to point out (which may be nothing) was that when I look at the Time Tracking from within the ticket, there is a little box with a + sign in it next to the words "Time Tracking" that I assume was meant to be expanded, but does nothing when I click it.APPLICATION ERROR #401
Database query failed. Error received from database was #8120: SQLState: 42000
Error Code: 8120
Message: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Column 'mantis_user_table.id' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
for the query: SELECT u.id AS user_id, username, realname, SUM(time_tracking) AS sum_time_tracking
FROM mantis_user_table u, mantis_bugnote_table bn
WHERE u.id = bn.reporter_id AND bn.time_tracking != 0 AND
bn.bug_id = ? AND bn.date_submitted >= 1551852000 AND bn.date_submitted <= 1552024799 GROUP BY u.username, u.realname.
Please use the "Back" button in your web browser to return to the previous page. There you can correct whatever problems were identified in this error or select another action. You can also click an option from the menu bar to go directly to a new section.
Thank you in advance for any assistance!