R2 RC3 not compatible with MySQL 4.0?

Hi all (why is this all in Russian all of a sudden?)

Anyway - here is a bug report on the tracker:

http://sourceforge.net/tracker/index.php?func=detail&aid=1777742&group_id=141358&atid=749176

R2 seems to run SQL statements that are just not compatible with MySQL 4.0, which is what i'm stuck on for now, but the installer recognises i have v4.0 and doesn't flag this as a problem.

The first error it get (logging on) is:

1. USER AGENT: Mozilla/5.0 (Macintosh; U; PPC Mac OS X Mach-O; en-US; rv:1.8.1.7) Gecko/20070914 Firefox/2.0.0.7
2. ACCT: ID: 2 - Login: admin - e-mail: admin@nospaces.net
3. URL: http://nospaces.net/bitweaver2/wiki/
4. REFERRER: http://nospaces.net/bitweaver2/users/login.php
5. HOST: nospaces.net
6. IP: 77.102.38.80
7. SQL: SELECT COUNT(mm.`msg_id`) FROM `bit_messages` mm INNER JOIN `bit_messages_system_map` msm ON (mm.`msg_id` = msm.`msg_id` AND msm.`is_read` <> 'y' AND `is_hidden` <> 'y' AND msm.`to_user_id`= '2') WHERE mm.`to_user_id` = 1 AND mm.`group_id` IN (SELECT `group_id` FROM `bit_users_groups_map` WHERE `user_id`= '2') LIMIT 1
8. ERROR CODE: Errno: 1064 Message: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `group_id` FROM `bit_users_groups_map` WHERE `user_id`=

Any SQL gurus out there who can fix this easily? I tried but it did my head in!

cheers

jonny
(now, which one's the submit button...?)

I have closed that bug and updated the installer to warn about the mysql version now. Version 4.1 is pretty much required though there are some packages which could be run without ot.