View Issue Details

WikiJump to Notes
IDProjectCategoryView StatusDate SubmittedLast Update
0013413mantisbtdb mssqlpublic2011-10-15 12:152014-05-16 15:00
Reporteradityaarora Assigned Torombert  
PriorityurgentSeveritymajorReproducibilityalways
Status closedResolutionduplicate 
PlatformWindowsOSServerOS Version2008
Product Version1.2.8 
Summary0013413: Unable to edit Users/Projects
Description

I've installed Mantis on Windows Server 2008 running MS SQL 2008 R2. The install completed with success. However, as I started to configure the system I'm running into SQL errors:

APPLICATION ERROR 0000401
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.

Steps To Reproduce

  1. Created a user

  2. tried to edit user

  3. Created a project

  4. tried to edit project

Additional Information

http://jupiter/mantisbt/manage_user_edit_page.php?user_id=3 (URL causing the issue)

Error Page:

APPLICATION ERROR 0000401
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.

TagsNo tags attached.

Relationships

duplicate of 0012674 closeddregad APPLICATION ERROR 0000401 on manage_user_edit_page.php and other occasions 

Activities

adityaarora

adityaarora

2011-10-19 23:11

reporter   ~0030000

I managed to get email working to see if I was having configuration issues. The email is working fine, confirmation and reset worked, emails sent. However, when I use the link they generate, it errors out similar to the example provided.

Database query failed. Error received from database was #0: [Microsoft][ODBC SQL Server Driver]Invalid parameter number for the query: SELECT p.id, p.name, ph.parent_id
FROM mantis_project_table p
LEFT JOIN mantis_project_user_list_table u
ON p.id=u.project_id AND u.user_id=?
LEFT JOIN mantis_project_hierarchy_table ph
ON ph.child_id = p.id
WHERE p.enabled = ? AND
( p.view_state=?
OR (p.view_state=?
AND
u.user_id=? )
)
ORDER BY p.name.
grangeway

grangeway

2014-05-16 15:00

reporter   ~0040388

MantisBT currently supports Mysql and has support for other database engines.

The support for other databases is known to be problematic.

Having implemented the current database layer into Mantis 10 years ago, I'm currently working on replacing the current layer.

If you are interested in using Mantis with non-mysql databases - for example, Oracle, PGSQL or MSSQL, and would be willing to help out testing the new database layer, please drop me an email at paul@mantisforge.org

In the meantime, I'd advise running Mantis with Mysql Only to avoid issues.

Thanks
Paul