ATutor

Learning Management Tools


  1. Home



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


Questions Missing



  • 2010-12-15 12:31:22

    Questions Missing

    Operating system ATutor is installed on - CentOS
    ATutor version - 2.0.1
    Patch #s applied - none, fresh install
    ATutor theme name - default
    PHP version - 5.2.10
    MySQL version - 5.0.77
    Web browser being used - Any

    This issue occured since I updated the database to the latest version through upgrade. Basically, the questions do not appear on the test, or in the admin backend test preview; however, upon editing the questions, the actual question is still there as illustrated in the attached screenshots.

    I have since tested this on a brand new install, so it must be something in the database, unless there is a setting in php that I am missing.


  • 2010-12-15 14:15:24

    Re: Questions Missing

    What version did you upgrade from?


  • 2010-12-15 15:00:23

    Re: Questions Missing

    Greg,

    I want to say it was 1.6? Here is another caveat for you to think about - I moved this install from an upgrade to 2.0.1 that was functional on a Windows box, running XAMPP to a Linux Box running Centos5.

    Is there any php setting that you can think of that could cause this issue?


  • 2010-12-15 15:27:43

    Re: Questions Missing

    Its important to know the exact version you upgraded from. There was the conversion to UTF-8 at 1.6, and there were various updates to tests in the upgrade from 163 to 164.

    Copying ATutor from one OS to another is always a risky business. Unfortunately we don't have a CentOS system to test on, so we could only guess what might be causing the problem. If you don't have too many courses, you might consider a fresh install, then generating backups from the old install then moving those over one by one and restoring them in the new system.


  • 2010-12-15 16:34:46

    Re: Questions Missing

    Greg,

    Thanks...I may look into the backup/replace option. Is there an easy way to do the same with users in the system? I suppose I could just dump the users/admin table and import into the new database?


  • 2010-12-15 17:18:13

    Re: Questions Missing

    Try setting up a test course on the new site, and importing a backup and just restoring the tests from the backup. If all goes well, you might try restoring the test into an existing course.

    You can also import/export tests on their own, as IMS QTI test packages. That might be another option for moving tests between the systems.

    There is a course list import/export feature, but not one for copying an entire list of registered users. In that case copying over the members table would be the best option, but only if you are copying over from 1.6 or later.

    If you do discover why questions are not showing up, please do let us know.


  • 2010-12-17 14:35:41

    Re: Questions Missing

    Just an update, this also happens with a brand new install...questions don't show up where they should.

    I have looked over php.ini for things that would cause the questions not to render or "pull" from the database, but I honestly can't find anything.


  • 2010-12-17 15:16:11

    Re: Questions Missing

    I suppose I should have been clearer...with a new install, and new questions, this issue occurs.

    [reply][b]In reply to:[/b]
    Just an update, this also happens with a brand new install...questions don't show up where they should.

    I have looked over php.ini for things that would cause the questions not to render or "pull...
    [op]forums/view.php?fid=7&pid=21427&page=1#21445[/op][/reply]


  • 2010-12-17 15:40:07

    Re: Questions Missing

    Hi,

    I am curious why this is happening. Can you open up mods/_standard/tests/html/tests_question.inc.php

    replace line 125~127 to the following:

    echo '<a>'.htmlentities($row[question], ENT_QUOTES, 'UTF-8').'</a>';

    Do the questions show now?


  • 2010-12-17 17:49:53

    Re: Questions Missing

    The questions actually started showing up in the question bank after this change; however, they still aren't showing up when taking or previewing tests.

    [reply][b]In reply to:[/b]
    Hi,

    I am curious why this is happening. Can you open up mods/_standard/tests/html/tests_question.inc.php

    replace line 125~127 to the following:

    echo ''.htmlentities($row[question], ENT...
    [op]forums/view.php?fid=7&pid=21427&page=1#21447[/op][/reply]


  • 2010-12-17 18:38:10

    Re: Questions Missing

    Can you check if you have mbstring enabled in your PHP?


  • 2010-12-17 18:53:33

    Re: Questions Missing

    mbstring is enabled, with the following settings:

    Multibyte Support enabled
    Multibyte string engine libmbfl
    Multibyte (japanese) regex support enabled
    Multibyte regex (oniguruma) version 4.4.4
    Multibyte regex (oniguruma) backtrack check On
    mbstring.detect_order no value no value
    mbstring.encoding_translation Off Off
    mbstring.func_overload 0 0
    mbstring.http_input pass pass
    mbstring.http_output pass pass
    mbstring.internal_encoding no value no value
    mbstring.language neutral neutral
    mbstring.strict_detection Off Off
    mbstring.substitute_character no value no value



    Also, system is running PHP 5.2


  • 2010-12-17 19:00:23

    Re: Questions Missing

    Thanks. If you could also test this for me, revert the changes I suggested earlier.

    Instead, edit the line 126 to the following:

    echo AT_print(htmlentities($row['question']), 'tests_questions.question');

    Do you still see the questions on the question bank?


    Thanks for spending your time to trace this down with me.


  • 2010-12-17 19:05:25

    Re: Questions Missing

    Negative, questions not showing in question bank.


  • 2010-12-17 19:06:26

    Re: Questions Missing

    And thank you for spending your time on this, it has certainly been an odd one.


  • 2010-12-17 20:35:33

    Re: Questions Missing

    Maybe a partial SQL dump of the question could hint at the cause of this bug?


  • 2010-12-20 12:17:52

    Re: Questions Missing

    Not that I mind giving a SQL dump, but this problem occurs on a brand new install as well. If you still think a SQL dump is relevant, I would be happy to post it :)


  • 2010-12-23 18:17:45

    Re: Questions Missing

    Okay,

    After further inspection of my apache error log, I have noticed the following error (this is a brand new installation):

    PHP Warning: preg_replace() [a href='function.preg-replace'>function.preg-replace</a>: Compilation failed: unrecognized character after (? at offset 2 in /removedurl on line 810, referrer: http://removedurl/school/mods/_standard/tests/question_db.php


    Does this help?


  • 2010-12-23 18:37:25

    Re: Questions Missing

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

    Things to describe:
    Operating system ATutor is installed on -
    ATutor version -
    Patch #s applied -
    ATutor theme name -
    PHP version -
    MySQL version -
    Webserver & version -
    Copies of error messages -
    Changes to default settings -
    Web browser being used -
    ...and anything else relevant -

    [reply][b]In reply to:[/b]
    http://atutor.ca/view/3/21206/1.html

    Wow..
    [op]forums/view.php?fid=7&pid=21427&page=2#21472[/op][/reply]


  • 2010-12-23 18:53:34

    Re: Questions Missing

    Did you copy and paste your questions from a word processor?

    If so, do your questions have any special characters, including quotes?

    Also, when you installed, did you upload the tar.gz file and unzip it on the server, or unzip it locally and upload the unzipped files?


  • 2010-12-23 19:29:22

    Re: Questions Missing

    Greg,

    I have tried both wget and unzip on server, and unzipping locally and uploading..

    This issue happens on a "fresh" install, and the one question that I typed in to test was typed by hand, no copy/paste.

    Is there a hidden php setting, apache setting, anything that could affect this?

    I don't have this issue on an XAMPP-based server running PHP 5.3,
    but I have this issue on a CentOS server running PHP 5.2.

    [reply][b]In reply to:[/b]
    Did you copy and paste your questions from a word processor?

    If so, do your questions have any special characters, including quotes?

    Also, when you installed, did you upload the tar.gz file and ...
    [op]forums/view.php?fid=7&pid=21427&page=2#21474[/op][/reply]


  • 2010-12-23 20:08:59

    Re: Questions Missing

    It's hard to say which PHP or MySQL settings might affect that (if any). If your questions use ASCII symbols only (i.e. Latin alphabet, digits and the usual punctuation marks), there's very, very little space for any such errors.

    Whatever the reason, I think there's a good chance that we'll find something in the DB.
    So I'd suggest a few steps for you to try:
    1. Try reducing the question to a bare minimum of characters that would still cause the problem (I imagine you should get a character or two in the end).
    2. Get a SQL dump containing that single question (it's stored in AT_tests_questions table) and post it here.
    3. Using that question, try reproducing the issue on ATutor's demo server: http://atutor.ca/atutor/demo.php

    Please let us know the results.


  • 2011-01-03 12:43:38

    Re: Questions Missing

    I'm working on what you asked for Indie, my only hangup is that I can reproduce this on my box with a new database, and a brand new install of Atutor, with nothing old imported.

    The person in this thread seemed to run into the same problem:

    http://atutor.ca/view/3/21206/1.html

    I suppose since it was taken to priority support, the resolution was never posted; but, if you can find the solution to this user's issue, it might shed a little light.