MSSQL Express 2008 - IIS 7 - PHP 5.3 Problem with ODBC DSN

[ACPIT]

Hi,

i installed MantisBT 1.2.5 today on a Windows 2008 R2 Server. I use PHP 5.3 and IIS 7. I had problems creating the tables with ./admin/install.php. So i searched the web and came along a workaround, using an ODBC DSN. Creating the tables worked, loggin in as administrator worked, creating a project worked, creating an issue worked too. But now i get following error, when i try to open this issue:

APPLICATION ERROR #401
Database query failed. Error received from database was #37000: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'. for the query: SELECT id, name, description FROM mantis_tag_table WHERE id IN ( ) ORDER BY name ASC .
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.

Same goes for new users. Creating a user worked, but manage the user will give me this error:

APPLICATION ERROR #401
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.

Does anyone had this problem before? Does someone know a workaround?

kind regards,

Clemens Horak

[Bernd]

Hi Clemens,

I ran into the same problem. The reason is that the SQL-Script generated by the installer contains all development steps. But some of the databse changes lead to errors: Especially the datetime field that have been changed to INT later but contain a default value as STRING.

Look at my post here http://www.mantisbt.org/forums/viewtopi ... =4&t=19421

Bernd

[ACPIT]

Dear Bernd,

thanks for your research! It works now without any problems.

Kind regards, Clemens