Which database server/version are you using?

MySQL: 4.0.25

Then you need to upgrade that: it was decided that mantis 1.1 will require MySQL 4.1 in order to support, among other stuff, SET NAMES and nested queries.

giallu, can you add the requirements file the docs folder. Also we need to update our check.php and install scripts to detect such cases for upgrades / new installations.

I'm running mysql server 4.0.26
I've installed 1.1.0a4 an i did experienced the same error. Then i've made some changes in core/database_api.php, on function db_connect.
Basically, i've changed:

• all !== to !=
• all === to ==

And this worked fine.

Now, i've installed latest release, 1.1.0rc3 and i experienced the same error. I made the same changes and this seems to work perfectly too.

Hope this can help.
Joaquim.

I find your solution quite... interesting: I wonder how your modifications magically made SET NAMES supported in MySQL 4.0.

I think you just managed to skip the "SET NAMES" query, but your installation is doomed to break when it will run the nested queries we have now in the code.

Ah, and of course strange things could also happen with UTF8 characters.

Added a check to ensure mysql is at least version 4.1