Application error while adding new users

[sourish_BOTW]

Hello All,

I have a new installation of Mantis and I am getting the following error while adding new users. This error only comes up when I try to add a user other than type administrator, with administrator it works perfectly but not for any other type like reporter or developer etc.


APPLICATION ERROR #401
Database query failed. Error received from database was #0: [Microsoft][ODBC SQL Server Driver]Invalid parameter number for the query: SELECT DISTINCT p.id, p.name
FROM mantis_project_table p
LEFT JOIN mantis_project_user_list_table u
ON p.id=u.project_id AND u.user_id=?
WHERE p.enabled = ? AND
u.user_id IS NULL
ORDER BY p.name.

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.

Any help will be appreciated.

Thanks,
Sourish

[graver347]

please make sure your table mantis_project_table and mantis_project_user_list_table is no errors or corrupt

run --> check table in your database

and check the permissions both your table

[Bluebark]

please make sure your table mantis_project_table and mantis_project_user_list_table is no errors or corrupt

run --> check table in your database

and check the permissions both your table

Hi all, new to the forums and to mantis/php. I just set up mantisbt 1.2.14 on IIS7 & MS SQL 2K8R2. Everything went well once I got the sql driver working. Was able to logon as Administrator and create an account for myself w/admin rights. I asked my fellow teammate to logon as admin and create themselves an acount with admin rights or something else if they did not want to help support the site. Accounts created with admin rights seem to work. Three accounts with "reporter" rights do not work and get the error listed above. When I go into manage users and select one of the Reporter accounts to delete, I get the above error. Graver347 says to check for db corruption/permissions. First question other than the obvious one about the error, how could the db be corrupt? The only thing, other than the creation of the 5 accounts that has written to the db is the install script.

As a side note, I am a systems admin on windows platform hoping to use this to make a support tracking site for my group.

Thanks in advance for any input...

[atrol]

Might help: http://www.mantisbt.org/bugs/view.php?id=12674

If you want to use MS SQL you should check also all open issues with category "db mssql".
I recommend using MySQL.