MantisBT - ATutor
View Issue Details
0002670ATutor- no cat -public2006-07-19 13:022006-08-04 08:45
greg 
user2 
normalminorhave not tried
closedfixed 
 
1.5.3.2 
SVN
0002670: mysql 5 join issue
Reported possible sql error in bounce.php

http://atutor.ca/view/7/3590/1.html [^]
for some reason mysql 5 doesn't like this join.

To (new):
$sql = "SELECT G.group_id FROM ".TABLE_PREFIX."groups G, ".TABLE_PREFIX."groups_types T, ".TABLE_PREFIX."groups_members M WHERE G.type_id=T.type_id AND G.group_id=M.group_id AND T.course_id=$course_id AND M.member_id=$_SESSION[member_id]";

From (bad):
$sql = "SELECT G.group_id FROM ".TABLE_PREFIX."groups G INNER JOIN ".TABLE_PREFIX."groups_types T, ".TABLE_PREFIX."groups_members M ON (G.type_id=T.type_id AND G.group_id=M.group_id) WHERE T.course_id=$course_id AND M.member_id=$_SESSION[member_id]";
No tags attached.
Issue History
2006-07-19 13:02gregNew Issue
2006-07-19 13:02gregAffects version => 1.5.3
2006-07-24 08:05user2Affects version 1.5.3 => SVN
2006-07-24 08:05user2Summarybounce sql error? => mysql 5 join issue
2006-07-24 08:05user2Additional Information Updated
2006-07-24 12:37gregNote Added: 0002126
2006-07-27 08:55user2Note Added: 0002129
2006-07-28 09:02user2Statusnew => resolved
2006-07-28 09:02user2Fixed in Version => 1.5.3.2
2006-07-28 09:02user2Resolutionopen => fixed
2006-07-28 09:02user2Assigned To => user2
2006-08-04 08:45user2Statusresolved => closed

Notes
(0002126)
greg   
2006-07-24 12:37   
seems to be happening for others

see:
http://www.atutor.ca/view/7/8464/1.html [^]
(0002129)
user2   
2006-07-27 08:55   
couldn't get mysql 5 to work (on my machine with php).