Integration Testlink/Mantis---Unknown character set: 'utf8'

[summerguo]

I tried to set up bugtracking system (Mantis 1.0.3 integration in Testlink 1.8.4, taking the steps below:

1. set mantis config_inc.php
2. set \cfg\mantis.cfg.php


Then when I go to login to testlink , there is error message as follow :

ERROR ON exec_query() - database.class.php
1115 - Unknown character set: 'utf8' - SET CHARACTER SET utf8

THE MESSAGE :: SQL [1] executed [took 0.0003 secs][all took 0.0003 secs]: SET CHARACTER SET utf8 Query failed: errorcode[1115] errormsg:Unknown character set: 'utf8'
ERROR ON exec_query() - database.class.php
1193 - Unknown system variable 'NAMES' - SET NAMES utf8

THE MESSAGE :: SQL [2] executed [took 0.0002 secs][all took 0.0008 secs]: SET NAMES utf8 Query failed: errorcode[1193] errormsg:Unknown system variable 'NAMES'
ERROR ON exec_query() - database.class.php
1193 - Unknown system variable 'collation_connection' - SET collation_connection = 'utf8_general_ci'


my mantis database is mysql 4.0.27.

I also set the this ,but it not work.
define('BUG_TRACK_DB_CHARSET','UTF-8');

What can I do ?
Thank you very much!!!

[TurboPT]

my mantis database is mysql 4.0.27.

That is the issue, your MySQL version is too old. 4.0.x knows NOTHING about character sets. UTF8 became available in 4.1.x. (this is reflected in the installation manual on page 4)

What can I do ?
Thank you very much!!!

Update the MySQL to something newer.

[summerguo]

Thank you very much.

Only Update the MySQL can solve the problem?

[TurboPT]

Yes. (as long as you also have the basics required for the other things needed by TestLink, such as PHP, for example. Just double-check the manual.)

I would say try to go with highest MySQL version that you can support. [5.0/5.1 if you can]

They have supposedly stopped supporting the 4.x versions. (except for critical patches, of course)