ERROR happened when use SQL Server 2022 on Linux

General discussion of Mantis.

Moderators: Developer, Contributor

Post Reply
qu.ququ
Posts: 5
Joined: 06 Dec 2023, 02:48

ERROR happened when use SQL Server 2022 on Linux

Post by qu.ququ »

SQLServer 2022 Linux (Manager/Users)
-----------------------------------------------------------------------
APPLICATION ERROR #401

Database query failed. Error received from database was #8155: SQLState: 42000
Error Code: 8155
Message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]No column name was specified for column 2 of 'tmp'.
for the query: SELECT lower(email) email, id, username
FROM mantis_user_table
WHERE lower(email) IN (
SELECT email
FROM (
SELECT lower(email) email, COUNT(*)
FROM mantis_user_table
GROUP BY lower(email) HAVING COUNT(*) > 1
) tmp
)
ORDER BY lower(email), username.
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.
qu.ququ
Posts: 5
Joined: 06 Dec 2023, 02:48

Re: ERROR happened when use SQL Server 2022 on Linux

Post by qu.ququ »

It's same issue as https://www.mantisbt.org/bugs/view.php?id=33372

I will try the fixed version 2.26.1
cas
Posts: 1622
Joined: 11 Mar 2006, 16:08
Contact:

Re: ERROR happened when use SQL Server 2022 on Linux

Post by cas »

So which version are you using on which platform:
OS?
PHP?
SQL?
Mantis?

Did you check the ticket mentioned?
Post Reply