Arithmetic overflow error converting expression to data type

[mekzeekahn]

Hello,

I just intalled Mantis, check.php gave me the "good to go", but as soon as I log in I get this error:

APPLICATION ERROR #401
Database query failed. Error received from database was #8115: SQLState: 22003
Error Code: 8115
Message: [Microsoft][SQL Server Native Client 11.0][SQL Server]Arithmetic overflow error converting expression to data type datetime.
SQLState: 01000
Error Code: 3621
Message: [Microsoft][SQL Server Native Client 11.0][SQL Server]The statement has been terminated.
for the query: DELETE FROM mantis_tokens_table WHERE ? > expiry.

... it seems to be a problem with how I have my settings configured...

I am running:
Mantis 1.2.11
Microsoft-IIS/7.5
PHP Version 5.4.4
Windows Server 2008 R2 Standard Edition Service Pack 1
Microsoft SQL Server

thanks in advance for your help

[atrol]

Can you try PHP 5.3.x?

[mekzeekahn]

Hello everyone,

I finally got it work after several tries - I modified all the database columns that had data type set to "datetime" by switching it to "int".

I hope this helps someone else, thanks!

[atrol]

Thanks for telling the solution.

There is a reason why I asked for PHP 5.3
You might get problems when using 5.4
http://www.mantisbt.org/bugs/view.php?id=14420 (will be fixed in 1.2.12, or use a nightly build)
http://www.mantisbt.org/bugs/view.php?id=14157 (no problem if you don't use SOAP)
http://www.mantisbt.org/bugs/view.php?id=14339 (no problem if you don't use APC)