SQL error, generic_queries.sql 1.105

[Migrated From Jforum.net]

mysql 4.1.13 is reporting an SQL error on
ForumModel.getModeratorList during startup.

The SQL in question is:

ForumModel.getModeratorList = SELECT DISTINCT u.user_id, u.username, rv.role_value \
FROM jforum_roles r, jforum_role_values rv, jforum_users u, jforum_user_groups ug, jforum_users u2, jforum_roles r2 \
WHERE r.role_id = rv.role_id \
AND r.name = 'perm_moderation_forums' \
AND rv.role_type = 1 \
AND rv.role_value = ? \
AND r.group_id = ug.group_id \
AND ug.user_id = u.user_id \
AND u.user_id = u2.user_id \
AND r2.name = 'perm_moderation' \
AND r2.role_type = 1 \
AND r2.group_id = ug.group_id \
UNION ( SELECT u.user_id, username, rv.role_value \
FROM jforum_roles r, jforum_role_values rv, jforum_users u \
WHERE r.role_id = rv.role_id \
AND name = 'perm_moderation_forums' \
AND rv.role_type = 1 \
AND rv.role_value = ? \
AND r.user_id = u.user_id )
[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

You probably have parenteses () missed around first select.
[originally posted on jforum.net by Anonymous]