#7001: [Microsoft][ODBC SQL Server Driver]COUNT

Get help from other users here.

Moderators: Developer, Contributor

Post Reply
Markus1234
Posts: 5
Joined: 10 Jun 2010, 13:16

#7001: [Microsoft][ODBC SQL Server Driver]COUNT

Post by Markus1234 »

Hello!
I need help.

I've installed:
MantisBT-Version 1.2.2
php_version 5.2.13
MantisBT-Datenbankinformationen
Schema-Version 183
adodb_version 5.1

Everything is working fine so far. We had the MSSQL failure and did the workaround with the odbc driver.
here a part of the config_inc.php:
$g_hostname = 'MantisBT';
$g_db_type = 'odbc_mssql';
$g_database_name = 'Bugtracker';
$g_db_username = 'sa';
$g_db_password = '********';

The Problem is, if i navigate to Mange Projects and want to edit a existing project, then I get the following failure(german):
APPLICATION ERROR #401
Datenbankabfrage fehlgeschlagen. Die Reportmeldung lautet #7001: [Microsoft][ODBC SQL Server Driver]COUNT field incorrect or syntax error für die Abfrage: SELECT DISTINCT u.id, u.username, u.realname
FROM mantis_user_table u
LEFT JOIN mantis_project_user_list_table p
ON p.user_id=u.id AND p.project_id=?
WHERE u.access_level<? AND
u.enabled = ? AND
p.user_id IS NULL
ORDER BY u.realname, u.username.
The URL of this failure message is:
http://localhost/mantisbt/manage_proj_e ... oject_id=1

Please help me :) All other things are working fine so far. Add an user, add a project and so on.
Post Reply