MantisBT - ATutor
View Issue Details
0003729ATutorSessionpublic2009-03-28 22:562009-07-21 08:50
IndieRect 
harris 
normalminoralways
closedfixed 
1.6.2 
1.6.3 
SVN
0003729: Submissions not deleted: MySQL 4.1 compatibility issue
A user reports: under his MySQL 4.1.22 a SQL request on the submission deletion page fails rendering the page unusable.

It is a MySQL compatibility issue. To fix it, please apply the change suggested in http://www.atutor.ca/view/3/17001/1.html [^] on 2009-03-24.

Tested to work in my MySQL 5.0.22, more testing is desired.
No tags attached.
Issue History
2009-03-28 22:56IndieRectNew Issue
2009-03-28 22:56IndieRectAffects version => SVN
2009-05-29 10:27harrisNote Added: 0003534
2009-05-29 10:27harrisStatusnew => resolved
2009-05-29 10:27harrisResolutionopen => no change required
2009-05-29 10:27harrisAssigned To => harris
2009-05-29 10:27harrisNote Added: 0003535
2009-06-12 09:32gregStatusresolved => new
2009-06-12 09:33gregStatusnew => resolved
2009-06-12 09:33gregFixed in Version => 1.6.3
2009-06-12 09:33gregResolutionno change required => fixed
2009-07-21 08:50gregStatusresolved => closed

Notes
(0003534)
harris   
2009-05-29 10:27   
This has been fixed in 1.6.2
line 27 in tools/tests/delete_result.php

$sql = "SELECT count(*) AS cnt FROM ".TABLE_PREFIX."tests_results R LEFT JOIN ".TABLE_PREFIX."tests USING (test_id) WHERE result_id IN ($rid) AND course_id = $_SESSION[course_id] AND R.test_id = $tid";
(0003535)
harris   
2009-05-29 10:27   
have already been fixed.