View Issue Details

IDProjectCategoryView StatusLast Update
0013648mantisbtdb mssqlpublic2014-05-16 15:00
Reportertonya Assigned Torombert  
PriorityimmediateSeverityblockReproducibilityalways
Status closedResolutionduplicate 
OSWindowsOS Version7 
Product Version1.2.8 
Summary0013648: "Create new account" crashes mantis
Description

Adding a new user crashes on subsequent query with

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

tonya

tonya

2011-12-05 12:47

reporter   ~0030467

This behavior also occurs after adding a project and then attempting to select that project.

grangeway

grangeway

2014-05-16 15:00

reporter   ~0040387

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