ATutor

Learning Management Tools


  1. Home



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


cant create courses and other items



  • 2005-02-12 13:25:31

    cant create courses and other items

    operating system - Red Hat Enterprise Linux
    version of ATutor - 1.4.3
    versions of php - 4.3.2
    version of mysql - 3.23.58
    webserver & version - Apache/2.0.46
    copies of error messages - something about mysql_fetch_assoc() and basedir
    changes to default settings - nope
    web browser being used - IE 6 and Mozilla FireFox 1.0
    and anything else relevant - I had to create the map "content" manually?

    Hello everybody

    My problem is as following:
    Everytime i try creating a new course or other item i get an error about mysql_fetch_assoc() and a little lower an error about basedir something in effect.
    The installation went perfectly no errors at all, only at the end I had to create the map "content" manually.
    I can log in as user and as administrator but im unable to create new items.
    I also tried uninstalling by deleting the entire content from my server but then I get the error: permission denied when I try deleting the map "content". The map content has owner "Apache" which disallows me to delete the map.
    All the rest works superb - great job guys.
    Now if someone can help me figure out how I can solve my irritant error.

    TIA, Fabio Tielen


  • 2005-02-13 09:12:41

    Unable to reproduce

    Can you provide a copy of the exact error messages.

    What do you mean by :
    "I had to create the map "content" manually?"

    What do you mean by:
    "I can log in as user and as administrator but im unable to create new items"

    Admins and users can not create new content. Only instructors can create content.

    Files own by the web server need to be deleted by the system's root user.

    Move the directory with the leftover Apache owned files using the "mv" command, then start with a fresh install.

    See the ATutorHowTo 1.4.3 documentation:
    http://atutor.ca/atutor/docs/howto.php

    Make sure PHP safemode is turned off.


  • 2005-02-13 17:00:14

    my error

    This is the error I get during installation step 5:

    Content Directory:
    It has been detected that your server does not support the protected content directory feature. The content directory stores all the courses' files.

    Due to that restriction your content directory must exist within your ATutor installation directory and cannot be moved. Its path is specified below:
    "/home/httpd/vhosts/exclustudio.be/subdomains/test/httpdocs/content"

    So i manually create this map with my FTP software/file manager in Control Panel.

    Now I log in as instructor and try creating a course and this is the error i get:


    Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/exclustudio.be/subdomains/test/httpdocs/include/classes/ContentManager.class.php on line 147

    Warning: is_file(): open_basedir restriction in effect. File(/atutor_cache_db_test/phpCache.systemXcourses=systemXcourses) is not within the allowed path(s): (/home/httpd/vhosts/exclustudio.be/subdomains/test/httpdocs:/tmp) in /home/httpd/vhosts/exclustudio.be/subdomains/test/httpdocs/include/phpCache/phpCache.inc.php on line 165

    Warning: Cannot modify header information - headers already sent by (output started at /home/httpd/vhosts/exclustudio.be/subdomains/test/httpdocs/include/classes/ContentManager.class.php:147) in /home/httpd/vhosts/exclustudio.be/subdomains/test/httpdocs/users/create_course.php on line 60

    Hope you can help me figure this one out.

    TIA Fabio Tielen


  • 2005-02-13 17:43:03

    error still - double check

    Just double checked everything.
    I get the error but it creates the course. Really weird.

    Also when I try deleting a course I get this error:
    But it also deletes the course.
    Also php safemode is OFF (www.exclustudio.be/info.php)

    Warning: is_file(): open_basedir restriction in effect. File(/atutor_cache_db_test/phpCache.systemXcourses=systemXcourses) is not within the allowed path(s): (/home/httpd/vhosts/exclustudio.be/subdomains/test/httpdocs:/tmp) in /home/httpd/vhosts/exclustudio.be/subdomains/test/httpdocs/include/phpCache/phpCache.inc.php on line 165

    Warning: Cannot modify header information - headers already sent by (output started at /home/httpd/vhosts/exclustudio.be/subdomains/test/httpdocs/include/phpCache/phpCache.inc.php:165) in /home/httpd/vhosts/exclustudio.be/subdomains/test/httpdocs/users/delete_course.php on line 48

    Please help asap

    TIA Fabio Tielen


  • 2005-02-14 10:27:27

    error still - double check

    try disabling cache by either removing that line in the include/config.inc.php file or by setting it to empty.


  • 2005-02-14 10:30:38

    caching is disabled

    Caching is already disabled. During installation i left the field empty to disable caching. But I'll try removing that line.

    Any other helpfull information?

    TIA Fabio Tielen


  • 2005-02-14 10:40:43

    removed line

    Ok I commented out the line that handles cacheing
    AFter a few tests this is result:
    I get no more error when deleting courses. So this part is solved.
    When creating a course this is the error i get:

    Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/exclustudio.be/subdomains/test/httpdocs/include/classes/ContentManager.class.php on line 147

    Warning: Cannot modify header information - headers already sent by (output started at /home/httpd/vhosts/exclustudio.be/subdomains/test/httpdocs/include/classes/ContentManager.class.php:147) in /home/httpd/vhosts/exclustudio.be/subdomains/test/httpdocs/users/create_course.php on line 60

    Any further assistance please

    THanks Fabio Tielen


  • 2005-02-14 11:01:08

    half solved

    I only get the error above when i create a course with this selected below:
    Create basic announcement, content, and forum.

    Then i get the error.
    When I select empty, i don't get an error.

    help asap please

    Fabio Tielen


  • 2005-02-14 11:46:46

    send a link

    Send us a link, and an instructor account so we can have a look.


  • 2005-02-14 11:57:51

    where can i send that link?

    Where can i send that link and login information?


  • 2005-02-14 11:59:55

    nvm

    nevermind, I just found it in the about section.
    Pretty weird place to place it.


  • 2005-02-14 13:48:33

    register globals

    to fix the admin problem you will have to turn register_globals off in your php.ini file or using an .htaccess
    php_flag register_globals off

    that might also fix the other problems you're having.

    the next version of ATutor will have fixes for that problem.


  • 2005-02-14 14:13:50

    admin problems?

    What admin problems are those?
    I only experience problems when creating courses with a basic announcement/content/forum.
    All the rest works perfect.
    Also When i create a new course which is empty, then i don't get an error but when i start adding content i get the same error.
    Adding announcements or forums works perfect.
    I just get errors when adding content.

    TIA Fabio Tielen
    http://test.exclustudio.be


  • 2005-02-14 15:45:39

    register globals

    please disable register globals to see if the problems you are experiencing are fixed.


  • 2005-02-14 15:57:56

    i turned it off

    I turned it off by using an .htaccess file with that line code in it but the error isnt gone

    Any other ideas?

    THanks Fabio Tielen


  • 2005-02-14 16:22:33

    possible fix

    try replacing lines 145-148 in include/classes/ContentManager.class.php

    (which looks like this:
    $sql = "SELECT LAST_INSERT_ID() AS insert_id";
    $result = mysql_query($sql, $this->db);
    $row = mysql_fetch_assoc($result);
    $cid = $row['insert_id'];
    )

    with this:

    $sql = "SELECT LAST_INSERT_ID()";
    $result = mysql_query($sql, $this->db);
    if (!($row = @mysql_fetch_array($result))) {
    echo mysql_error($this-db);
    exit;
    }
    $cid = $row[0];

    if this doesn't work, you'll have to give us access to your server to investigate further.


  • 2005-02-14 20:28:21

    IT WORKS!

    Thank you very much! It works by editing those few lines.
    I will keep testing everything and when i run into an error I will drop a note here.

    Tyvm, Fabio Tielen


  • 2005-07-04 11:55:37

    Same Problem

    I got this same exact error as described by exclustudio.

    The only difference is that my register_globlas was off by default, so that error is ruled out.

    My cache was also left blanked during install. I however commented out the cache line as described above but got the same errors. But when i added the lines of code above, everything now works.

    operating system - red hat
    version of ATutor - 1.4.3
    versions of php - 4.3.10
    version of mysql - 3.23.58
    webserver & version - Apache/2.0.51 (Fedora) Server
    web browser being used - Fire Fox 1.0.4


  • 2005-07-14 03:44:25

    Same Problem, too

    I'm Thailand

    I had same problem.
    After I use that joel's solve problem that work.

    Thank you.


  • 2005-07-19 15:13:53

    Subject: can't create courses and other items

    Was also having this issue when creating content with with basic announcement/content/forum.

    Applied Joels post for correction:
    $sql = "SELECT LAST_INSERT_ID()";
    $result = mysql_query($sql, $this->db);
    if (!($row = @mysql_fetch_array($result))) {
    echo mysql_error($this-db);
    exit;
    }
    $cid = $row[0];

    Everything works great! Thanks!