Hi,

I have regularly encountered the following error with MySQL 4.1 Alpha running on a Linux i386 platform.

INSERT INTO TEMP SELECT p.Project_ID FROM ms_project AS p, ms_account_user_map AS map, (SELECT U1.User_ID AS id FROM 00DF4895dF577l4ojK.ms_role AS R1, ms_role AS R2 LEFT JOIN ms_user AS U1 ON R2.id=U1.User_RoleId WHERE R1.lft > R2.lft AND R1.lft < R2.rgt AND R2.id=(SELECT U2.User_RoleId FROM ms_user AS U2 WHERE U2.User_ID='12345') ) AS role WHERE p.Project_TypeId=map.Account_ID AND map.User_ID=role.id AND p.Project_Recycle=0 GROUP BY p.Project_ID UNION ALL SELECT p.Project_ID AS ID FROM ms_project AS p, ms_project_team_map AS t, (SELECT U1.User_ID AS id FROM ms_role AS R1, ms_role AS R2 LEFT JOIN ms_user AS U1 ON R2.id=U1.User_RoleId WHERE R1.lft > R2.lft AND R1.lft < R2.rgt AND R2.id=(SELECT U2.User_RoleId FROM ms_user AS U2 WHERE U2.User_ID='12345') ) AS role WHERE p.Project_ID=t.Team_Project_ID AND t.Team_User_ID=role.id AND p.Project_Recycle=0 GROUP BY p.Project_ID

Query 4:

SELECT project.Project_ID, account.Account_Name FROM TEMP AS t LEFT JOIN ms_project AS project on t.tmpId=project.Project_ID LEFT JOIN ms_user AS pm ON pm.User_ID=project.Project_ManagerId LEFT JOIN ms_user AS po ON po.User_ID=project.Project_OwnerId LEFT JOIN ms_account AS account ON account.Account_ID=project.Project_TypeId WHERE project.Project_Status=1 ORDER BY account.Account_Name ASC LIMIT 0,21