Problem using DB2 Database
Posted: 11 Feb 2008, 17:18
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
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