ATutor

Learning Management Tools


  1. Home



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


Tests Surveys no longer available after upgrade



  • 2008-01-24 12:39:41

    Tests Surveys no longer available after upgrade

    Hi,

    We have just upgraded to 1.5.5 from 1.5.3 and since have been having trouble with the Tests and Surveys in our courses.

    They previously worked fine but now when one clicks upon a survey it brings up the "Take Test" and "survey title" but informs the user it is "Done!". This is replicated across all tests and surveys.

    Any assistance would be gratly appreciated.

    Many thanks.

    Steve

    Things to describe:
    operating system - Linux 2.6.9-42.0.3.ELsmp
    version of ATutor - v1.5.5
    versions of php - v5.2.2
    version of mysq l - v4.1.22-standard
    webserver & version - Apache v1.3.39 (Unix)
    copies of error messages -
    changes to default settings - none
    web browser being used - Safari v3.0.4 and Firefox v2.0.0.11
    and anything else relevant -


  • 2008-01-25 04:15:06

    Re: Tests & Surveys no longer available after upgrade

    This "Done!" string is probably the same that is always output below the questions when taking a test. If it is, that might mean that question records in the DB are somehow broken (most likely in AT_tests_questions_assoc table). And therefore finding the bug may require direct access to the DB.

    Here's what I would have done in the first place:
    1. Go to Manage -> Tests & Surveys -> [select the test] -> Preview. Are the questions displayed? Are any of them missing?
    2. If (1) fails, then select the test and click the Questions button. Are all the questions displayed?
    3. If (1) and (2) fail, then are the questions present in the Question Database? All of them?
    4. Select the test and click Submissions. Then select any submission (if there're any) and click View & Mark Test. Are all the questions displayed?
    4. Can you please attach here a screenshot of the Take Test page with the error you described?

    If you (or someone you know) are familiar with MySQL and/or phpMyAdmin, there is much more that can be done:
    5. Check the table "AT_tests_questions_assoc". Under the "test_id" of your test (you can peep it in the browser's address bar when clicking buttons at Manage -> Tests & Surveys page), there must be several records, their number corresponding to the number of questions in your test.
    6. If there are some, then check the "AT_tests_questions" for matching "question_id"s and verify these are the correct questions by checking their "question" field.


  • 2008-01-30 10:52:33

    Re: Tests & Surveys no longer available after upgrade

    Thanks for the post.

    OK, I have performed test one to four and the answers are as follows:
    1. Questions missing;
    2. Yes, questions are displayed;
    3. Yes, all of them;
    4. Attached.

    Onto the MySQL part:
    5. Found id 667 with value of 3 which matches number of questions;
    6. In all honesty I am not sure about this last one... checking the "question_id" in "AT_tests_questions_assoc", not all the id's are present (ie the id's start at 14) that are found in AT_tests_questions (where there are 1 - 108).

    Not sure whether I have helped or hindered there... :-)

    If you require access let me know.

    Many thanks.


  • 2008-02-01 05:13:47

    Re: Tests & Surveys no longer available after upgrade

    Well, for now it looks much like one strange bug we've encountered. We didn't attribute it to an upgrade, but the real cause is still unknown.

    To gather more info, please execute the attached SQL file on your system.

    It will probe for some possible reasons of the bug, including verification if it's like the one we've found.
    In a case you have privacy/security concerns here. These five queries perform a read-only access to your DB, getting from it only those data that are needed for the bug identification. No test/question texts are retrieved.


    To run the SQL file:

    1. Replace all the "***"s in the attached probe.sql with the test's id.
    2. Start the Linux shell, go to the directory that probe.sql is in, and type this command:

    [b]mysql -u "user" -p "database" < probe.sql > result.txt[/b]

    where "user" should be replaced with the database user name that you've input when installing ATutor (probably "root"; if not sure, look in file include/config.inc.php),
    "database" -- with the database name (look in the same file).

    3. Press Enter. You'll be asked for the DB password (again, see that very same file).

    If everything runs smoothly, you should see no error messages, and there should appear a non-empty file result.txt.

    4. Attach the result.txt here. Don't forget to select "Public" before posting.


    Also answering some background questions will add up for the clarity:
    1. Does this bug occur in tests created after the upgrade?
    2. Does this bug happen only in randomized tests, or only not randomized, or both?
    3. Does toggling "Randomize Questions" in test properties change anything?
    4. Did you restore tests or entire courses from backups before the bug appeared? If so, do you remember if there were any error messages?
    5. Did you change the structure of the DB tables -- added fields, changed their order, etc.? Or changed the PHP code in the files of the test area?

    Sorry for that many questions. Locating a bug and ruling out its potential sources usually requires a lot of info.


    That should help.
    If it doesn't, then I'll probably be able to log to your installation the next week.
    But before, let it be made clear that I don't represent the ATutor developers; I'm just a community member.


  • 2008-02-01 05:15:07

    Re: Tests & Surveys no longer available after upgrade

    Oh, here's the SQL file.