Problem using DB2 Database

[scalap]

I install mantisbt with database driver ibm_db2.
mantis version : 1.1.1 on linux server, php4
db2 version : V9.1 on linux server
The schema and tables are well created. The connection is OK.
When I try to access the login page, I have the following error :

Database query failed. Error received from database was #42818: [IBM][CLI Driver][DB2/LINUX] SQL0401N The data types of the operands for the operation "=" are not compatible. SQLSTATE=42818 SQLCODE=-401 for the query: SELECT *
FROM mantis_user_table
WHERE id='1'

The structure of the mantis_user_table has the field id as integer and not as varchar !
The following request works fine
SELECT * FROM mantis_user_table WHERE id=1

What is the solution ? Change the request in mantis code ? Or change the structure of all tables ?
Who have succeeded install with DB2 database ?

Regards

Pascal

[vboctor]

Use http://www.mantis400.com to get support for installing Mantis on DB2.

[judan]

Hi scalap. Can you give me instructions on how to install mantisbt over ibm_db2?