ATutor

Learning Management Tools


  1. Home



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


Unpossible to create tests in course



  • 2008-09-10 08:47:00

    Unpossible to create tests in course

    I am unable to create any tests in the courses any more.
    Bevore it was running fine
    See in attached file printscreen of the message after trying to creat Test


    Changes since last time
    php version has been upgrded
    The following patches has been installed:
    00002, 00003, 00004, 00007, 00008, 00009, 00010, 0012, 00013, 00014


    Things to describe:
    ATutor Version: 1.6. Check Latest Version.
    PHP Version: 5.2.6
    MySQL Version: 4.1.22-standard
    OS: Linux 2.6.11.4-21.17-default


  • 2008-09-10 09:25:33

    Update:

    I roled back the create_test.php file from the 00002 patch.
    Now I am able to create courses again, but there are new fields witch are not in the language:
    [ test_description ]
    [ pass_score ]
    [ pass_feedback ]
    [ fail_feedback ]
    Are they active now?


  • 2008-09-10 10:21:31

    Re: Update:

    Seems the SQL statements as a part of patch 0002 didn't run successfully. It needs a detail trace to find out why it's failed in your system. For now, if you could run the SQL below manually and revert back the create_test.php after installing patch 0002, you problem should be fixed.

    INSERT INTO `AT_language_text` VALUES
    ('en', '_template', 'pass_score', 'Pass Score', now(), ''),
    ('en', '_template', 'pass_feedback', 'Pass Feedback', now(), ''),
    ('en', '_template', 'fail_feedback', 'Fail Feedback', now(), ''),
    ('en', '_template', 'test_description', 'Test Description', now(), ''),
    ('en', '_template', 'no_pass_score', 'No pass score', now(), ''),
    ('en', '_template', 'percentage_score', 'percentage score', now(), ''),
    ('en', '_template', 'points_score', 'points score', now(), ''),
    ('en', '_template', 'all_passed_students', 'All Passed Students', now(), ''),
    ('en', '_template', 'all_failed_students', 'All Failed Students', now(), '');

    ALTER TABLE `AT_tests`
    ADD `description` TEXT NOT NULL,
    ADD `passscore` MEDIUMINT NOT NULL ,
    ADD `passpercent` MEDIUMINT NOT NULL,
    ADD `passfeedback` TEXT NOT NULL,
    ADD `failfeedback` TEXT NOT NULL;

    Thanks.


  • 2008-09-11 01:40:18

    Re: Update:

    If you mean to add the tables directly into the database, it will be verry difficult to make it, because I have no accses to do it.

    Is there a other way to do it, ore will it be fixed by the upgrade from Version 1.6 to 1.6.1?


  • 2008-09-12 05:11:42

    Re: Update:

    Hi ipool
    When jou dont have acces to your database
    check if you have root-acces (linux) and check as well you shut down the server, because when running it's about security you do not have acces.
    for Kubuntu/Ubuntu go to "Konsole Terminal programm"
    and enter
    for lampp ; sudo/opt/lampp ****
    for xampp ; sudo/opt/xampp ****

    **** =
    stop (to stop)
    start (to start)
    restart (to restart)
    dont forget to start server again after you did your change as mentioned above

    good luck


  • 2008-09-12 09:38:19

    Re: Update:

    I have an external hosting.
    So no acces to the OS


  • 2008-09-12 09:42:12

    Re: Update:

    Generally hosts provide access to the database through a control panel. If not, it should be possible to install phpMyAdmin yourself, perhaps in a directory beside ATutor. You can then use the ATutor phpMyAdmin module to integrate it into ATutor.


  • 2008-09-13 10:46:31

    Re: Update:

    Sorry Greg but the Histing accses is made by our Company IT Support. Even if I Install phpMyAdmin I'll get not the Acces Information.
    So my Question is just to know if the Upgrade to 1.6.1 will set the database ore i do realy have to call our administrators to do it?


  • 2008-09-15 03:15:49

    Re: Update:

    ipool, is that English language that's missing those terms?
    If so, then you can try to run the SQL as the custom patch I've made based on cindy's suggestion. See the attachment.


  • 2008-09-15 08:40:01

    Re: Update:

    Hi IndieRect
    I just dryed to unzip your file but i've found it empty.
    Can you try to upload again?
    When I switch to english it looks fine
    Just when I switch to german ore french it comes up
    See attached Printscreen.


  • 2008-09-15 08:47:22

    Re: Update:

    Thanks for the reply and the patch, Indie. The patch is not fully correct, "AT_" in front of the table names should be removed. ATutor sql utility class generates the table name with prefix specified at ATutor installation.

    ipool, the upgrade to 1.6.1 would solve your problem. These SQL statements have been integrated into 1.6.1. Thanks.


  • 2008-09-15 08:53:37

    Re: Update:

    Thanks indieRect and Cindy
    Have a nice day


  • 2008-09-15 08:57:06

    Re: Update:

    Umm.. I could download Indie's patch without problem.

    The missing of frensh/german terms is because these language packs in 1.6 are not updated. If your terms in english are fine, the SQL should have run successfully. I understand you don't have access to mysql, but in any chance you can see your table structure? Can you see if you have listed fields in table AT_tests:

    description
    passscore
    passpercent
    passfeedback
    failfeedback

    Thanks.


  • 2008-09-18 07:50:42

    Re: Update:

    Right, I've forgotten about the prefix.

    ipool, have you managed to peep into the DB somehow?