ATutor

Learning Management Tools


  1. Home



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


Error while creating course



  • 2005-12-30 10:03:56

    Error while creating course

    I just finished my install of ATutor and I am not able to create a new course. I was able to create users and categories, but when I hit the submit button to create a course I get an error. "Field 'preferences' doesn't have a default valueDB Error"

    operating system - Windows XP Pro
    version of ATutor - 1.5.2
    versions of php - 5.1
    version of mysq l - 5
    webserver & version - Apache 2.0.55
    copies of error messages - Field 'preferences' doesn't have a default valueDB Error
    web browser being used - IE 6.0


  • 2005-12-30 20:32:39

    Re: Error while creating course

    I was able to create my course, but I'm having trouble creating users now. I had in the past created a teacher and a user account, but now I'm getting an error.

    "The following errors occurred:
    Information could not be added to the database. "

    Is there some way I can get a more detailed error message? Or do you have any suggestions as to what is causing this?

    I can add categories and other things, so I am connecting to the database, but my attempts to create users have been unsuccessful.

    My information is the same as in my previous post.

    Let me know if you need more information.

    Thanks!


  • 2006-01-01 21:05:35

    Re: Error while creating course

    Hi Branzt.

    I got the same "Field preferences" error that you were getting.

    What did you do to make it work?


  • 2006-01-03 00:11:12

    Re: Error while creating course

    Actually, I figured it was an error in my configuration, so I uninstalled everything and installed WAMP.

    WAMP is a prebuilt package that installs PHP, APACHE, and MySQL together and they are already configured. It worked wonders for me.

    Here's the link:
    http://www.wampserver.com/en/index.php

    Hope this helps.


  • 2006-03-02 07:15:34

    Re: Error while creating course

    I had the same problem - The error in your configuration you mentioned Branzzt, is the "STRICT_TRANS_TABLES" mode which is enabled on your MySQL-Server.
    Disabling this mode solves the problem. Due to I'm not familiar with MySQL configuration I recommand studying the corresponding part of the MySQL documentation before changing your servers mode randomly. ;)

    http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html

    In this documentation you also find how to change the mode. I changed my servers mode to "NO_AUTO_CREATE_USER" as pseudo-mode because I don't really know a sensefull one. I did this typing:

    set global sql_mode='NO_AUTO_CREATE_USER';

    to the mysql command line after I have logged in. With:

    select @@global.sql_mode;

    you can view which modes are enabled for your server.