ATutor

Learning Management Tools


  1. Home



Pages:1 2 3 4 5 6 7 8 9 10 11 12 13 14 15


Trouble with Submitting Questions for Test



  • 2005-08-10 08:12:30

    Trouble with Submitting Questions for Test

    I receive the following error when trying to submit a test question in order to create a test:

    Submissions

    Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/webadmin/campus.cytopathnet.org/html/ATutor/tools/tests/results.php on line 96

    Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/webadmin/campus.cytopathnet.org/html/ATutor/tools/tests/results.php on line 99

    Any ideas how to troubleshoot?


  • 2005-08-11 09:26:03

    Fixed

    I found a related area in the forums which provided the fix for this. Please disregard.


  • 2005-08-14 12:07:09

    Fixed...well maybe not

    Well, I thought I had this issue resolved. However, when I went in to review submitted exam results, I received the same errors:

    Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/webadmin/campus.cytopathnet.org/html/ATutor/tools/tests/results.php on line 96

    Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/webadmin/campus.cytopathnet.org/html/ATutor/tools/tests/results.php on line 99


    Safemode is off as are registered globals.

    Really need help on this. I haven't found anything about this yet in the forums.


  • 2005-08-14 12:36:49

    Settings

    If you are asking for help, provide lots of detail so problems can be reproduced.

    Things to describe:
    operating system -Linux, Redhat Enterprise AS v.3
    version of ATutor -1.5
    versions of php -4.3.2
    version of mysq l -3.23.58
    webserver & version -Apache, 2.0.46
    copies of error messages -Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/webadmin/campus.cytopathnet.org/html/ATutor/tools/tests/results.php on line 96

    Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/webadmin/campus.cytopathnet.org/html/ATutor/tools/tests/results.php on line 99
    changes to default settings -
    web browser being used -Firefox, 1.0.6
    and anything else relevant -safemode OFF, register_globals OFF


  • 2005-08-15 21:44:30

    Trouble continues

    I tried upgrading to the RC 1.5.1, but am still getting this error when as an instructor, am selecting "submissions" from the Manage test/surveys page.. I get this error:

    Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/webadmin/campus.cytopathnet.org/html/ATutor/tools/tests/results.php on line 96

    Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/webadmin/campus.cytopathnet.org/html/ATutor/tools/tests/results.php on line 99

    See my previous post for my settings.


  • 2005-08-17 12:23:53

    Lack of response usual?

    Well...I have not seen any response to my questions, and I continue to have problems. Now I have additional problems with course import. Does anyone monitor these forums for support???


  • 2005-08-17 12:30:38

    Lack of response usual?

    This is the error message I get on trying to import a chapter that I exported from another course:

    XML error: not well-formed (invalid token) at line 14


  • 2005-08-17 13:19:17

    .

    Try changing the test type to Anonymous and see if the problem still happens.


  • 2005-08-17 14:32:13

    Help needed sooN!

    That got rid of that message. Any ideas about the import problems?

    [reply][b]In reply to:[/b]
    Try changing the test type to Anonymous and see if the problem still happens.
    [op]forums/view.php?fid=7;pid=5409;page=1#5490[/op][/reply]


  • 2005-08-17 20:51:32

    Trouble with Submitting Questions for Test

    If you are asking for help, provide lots of detail so I would also like to know. I'm using the exact system that jsullinger is, and when I go to view test submissions, I get the same errors. If I change to anonymous, no errors. Problem is, I have no idea whose test I'm grading.


  • 2005-08-17 20:53:27

    Trouble with Submitting Questions for Test

    Disregard the "If you are asking for help, provide lots of detail so" part as the idiot (me) who typed this respose failed to erase that part. It's been a long day.


  • 2005-08-18 08:26:28

    MySQL 4.02

    The problem with the test results seems to be some newer SQL language was introduced into that particular sql statement (CAST) that was not available until mysql 4.02. We'll see what we can do about creating a work-around, and post the fix here soon.

    You could also upgrade your mysql to fix the test results problem

    Re: the XML problem, we'd need to see the package you were trying to import. Attach it to this thread.


  • 2005-08-18 10:05:32

    Attached package

    I am attaching the "culprit" package.

    I received an error when trying to import as a package, and then also when trying to import as "content", I received the XML error.

    [reply][b]In reply to:[/b]
    The problem with the test results seems to be some newer SQL language was introduced into that particular sql statement (CAST) that was not available until mysql 4.02. We'll see what we can do about ...
    [op]forums/view.php?fid=7;pid=5409;page=1#5499[/op][/reply]


  • 2005-08-18 10:07:09

    .

    replace the CAST() part on line 92 in ./tools/test/results.php

    with R.final_score+0.0

    such that you end up with R.final_score+0.0 AS fs


  • 2005-08-18 13:40:13

    Attached package

    regarding the content package attached. the problem appears to be the ampersand in the glossary definition.

    ampersands should be represented as & amp; (w/o the space).

    We will try and get a fix out for the next version.


  • 2005-08-18 14:25:15

    Package stuff

    So put R.final_score in the () part so it reads

    (R.final_score)+0.0 AS fs ??

    [reply][b]In reply to:[/b]
    sreplace the CAST() part on line 92 in ./tools/test/results.php

    with R.final_score+0.0

    such that you end up with R.final_score+0.0 AS fs
    [op]forums/view.php?fid=7;pid=5409;page=1#5505[/op][/reply]


  • 2005-08-18 14:34:59

    Package imports

    Did this....still getting error: "problem with package directory". I changed to full write permissions, but same thing happened...so guess not a permissions thing.

    [reply][b]In reply to:[/b]
    So put R.final_score in the () part so it reads

    (R.final_score)+0.0 AS fs ??

    [reply][b]In reply to:[/b]
    sreplace the CAST() part on line 92 in ./tools/test/results.php

    with R.final_score+0....[/reply]
    [op]forums/view.php?fid=7;pid=5409;page=2#5518[/op][/reply]


  • 2005-08-19 10:16:24

    .

    [b]jsullinger you're confusing everyone by including your support post within another thread.[/b]

    next time start a new thread instead of posting unrelated bugs in an existing thread.

    read my last post for a possible cause of your problem.


  • 2005-08-19 12:09:26

    Trouble with Submitting Questions for Test

    I apologize for that....but the reply to thread is confusing, in that it doesn't repeat the subject heading.


  • 2005-09-22 11:28:46

    Similar "old" MySQL Syntax Issue

    Also perhaps caused by the older version of MySQL (per the original bug in this thread), my test instance was returning the following error:

    Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/roarz.com/subdomains/atutor/httpdocs/tools/enrollment/privileges.php on line 86

    This error was produced by navigating to Manage -> Enroll -> Select Student -> Privileges

    The cause was the \"ON\" syntax in the SQL on line 82 of \"tools/enrollment/privileges.php\":
    $sql = \"SELECT cm.privileges, m.login FROM \".TABLE_PREFIX.\"course_enrollment cm JOIN \".TABLE_PREFIX.\"members m ON cm.member_id = m.member_id WHERE m.member_id=($mem_id) AND cm.course_id = $_SESSION[course_id]\";

    Changing this line to:
    $sql = \"SELECT cm.privileges, m.login FROM \".TABLE_PREFIX.\"course_enrollment cm JOIN \".TABLE_PREFIX.\"members m WHERE cm.member_id = m.member_id AND m.member_id=($mem_id) AND cm.course_id = $_SESSION[course_id]\";

    Solved the issue in my environment. I\'m guessing that the \"ON\" syntax is a MySQL 4.x thing. Just like \"CAST()\".