Jump to ContentJump to Navigation/Login
` ` ` ` ` `

Login
[Register]

Subscribe to Updates

Occasional ATutor release updates


Services

Members Online

No Members Logged In

(5 guests in past 15 min.)

Web Accessibility Course

Access Understanding Web Accessibility to learn about accessibility, or Register to take the course for FREE.

IMS Certified

IMS Global Certified

Home > Forums > ATutor Bug Reports > Can't delete test submissions

Support Forums

ATutor Bug Reports

Can't delete test submissions


You must be signed-in to post.

AuthorSubject
  Page: 1
aizo
Subject: Can't delete test submissionsQuote this post in your reply
Not a single, batch neither.
Role - course instructor.
Shows empty page.
Is this OK? (I mean ";")
.../tools/tests/delete_result.php?tid=18;rid=1082
Posted: 2009-01-15 03:26:51
IndieRect

Avatar for IndieRect
Subject: Re: Can't delete test submissionsQuote this post in your reply
Could you please specify information about your system (what's asked for in "Things to describe"), and at which exactly stage you see the blank page (submission list, after pressing delete, or after confirming deletion).

An empty page might mean a lot of different problems. You may search your web server's error log for the error description (in Linux it's most likely /var/log/httpd/error-log).
Posted: 2009-01-15 03:51:14
aizo
Subject: Re: Can't delete test submissionsQuote this post in your reply
Slackware, 2.4.26
ATutor version - 1.6.2
Patch #s applied - 0
ATutor theme name - ATutor
PHP version - 4.4.9
MySQL version - 4.1.22
Webserver & version - Apache/1.3.41
Copies of error messages - Apache log empty for this
Changes to default settings - no relevant changes
Web browser being used - IE, FF
Posted: 2009-01-15 05:18:42
aizo
Subject: Re: Can't delete test submissionsQuote this post in your reply
Empty page after pressing delete.
Posted: 2009-01-15 05:24:22
aizo
Subject: Re: Can't delete test submissionsQuote this post in your reply
Something wrong with query:

$sql = "SELECT COUNT(*) AS cnt FROM ".TABLE_PREFIX."tests_results LEFT JOIN ".TABLE_PREFIX."tests USING (test_id) WHERE result_id IN ($rid) AND course_id = $_SESSION[course_id] AND test_id = $tid";

because simple query

$sql = "SELECT COUNT(*) AS cnt FROM ".TABLE_PREFIX."tests_results"

works.
Original query with substituded variables looks correctly formed.
Posted: 2009-01-15 06:19:40
aizo
Subject: Re: Can't delete test submissionsQuote this post in your reply
#1052 - Column 'test_id' in where clause is ambiguous
Posted: 2009-01-15 06:34:33
aizo
Subject: Re: Can't delete test submissionsQuote this post in your reply
So, correct SQL looks like this:

$sql = "SELECT count(*) AS cnt FROM ".TABLE_PREFIX."tests_results LEFT JOIN ".TABLE_PREFIX."tests USING (test_id) WHERE result_id IN ($rid) AND course_id = $_SESSION[course_id] AND ".TABLE_PREFIX."tests_results.test_id = $tid";

BTW, I have noticed the same behavior in some other places as well...

Enjoy! smile
Posted: 2009-01-15 06:50:41
aizo
Subject: Re: Can't delete test submissionsQuote this post in your reply
Or, of course, like this:

$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";
Posted: 2009-01-15 07:00:22
harris

Avatar for harris
Subject: Re: Can't delete test submissionsQuote this post in your reply
In your php.ini, did you enable the following?

arg_separator.input = ";&"

In reply to:
Not a single, batch neither.
Role - course instructor.
Shows empty page.
Is this OK? (I mean ";")
.../tools/tests/delete_result.php?tid=18;rid=1082

Posted: 2009-01-15 09:45:08
 Page: 1

You must be signed-in to post.