ATutor

Problem with creating courses

• suofagha
  

  2006-02-28 07:35:28

  Problem with creating courses

  I can't create courses as an instructor. ATutor generates this error:"Field 'preferences' doesn't have a default valueDB Error" whenever I attemt to create a course. Is this a bug. Please I need help.
  
  System description:
  
  operating system - Windows XP
  version of ATutor - 1.5.2
  versions of php - 5.1.2
  version of mysq l - 5.0.18
  webserver & version - Apache 2.0.55
  copies of error messages - Field 'preferences' doesn't have a default valueDB Error.
  
  changes to default settings - non
  
  web browser being used - Opera 8.51, IE 6.0
  
  and anything else relevant - Error occurs when instructor attemts to create course.

• byron
  

  2006-05-04 15:16:06

  Re: Problem with creating courses

  I've just experienced this problem myself.
  Its due to sql-mode=STRICT_TRANS_TABLES being the default in mySQL 5.0 (http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html). A similar problem was reported for wordpress (http://wordpress.org/support/topic/52753). You can either edit your my.ini file and remove that setting or change it with php.
  Ideally the SQL calls should be updated in aTutor to specify values for db fields that don't have default values.

• greg
  

  2006-05-04 15:27:19

  Re: Problem with creating courses

  We'll look into this in the future, but currently MySQL 5 is not officially supported in ATutor.
  
  We'll keep of these compatiblity issues and address them as they arrise.
  
  thx for pointing out the problem.

• sleo
  

  2006-12-26 17:09:11

  Re: Problem with creating courses

  look into your php.ini
  your:
  register_globals = on
  
  good luck

• sleo
  

  2006-12-26 17:09:35

  Re: Problem with creating courses

  look into your php.ini
  your:
  register_globals = on
  
  good luck

• sleo
  

  2006-12-26 17:09:35

  Re: Problem with creating courses

  look into your php.ini
  your:
  register_globals = on
  
  good luck

• tom_glebas
  

  2007-01-09 20:42:31

  Re: Problem with creating courses

  If you are asking for help, provide lots of detail so problems can be reproduced.
  
  Things to describe:
  operating system - Windows XP SP 2
  version of ATutor - 1.5.3.3
  versions of php - 4.4.2
  version of mysq l - 5.0
  webserver & version - Bad Blue 2.7
  copies of error messages - Page Cannot Be Found
  changes to default settings - None
  web browser being used - IE 7
  and anything else relevant -
  
  I've had a similar problem and was able to resolve it by removing the strict mode in MySQL as mentioned above.
  
  But, now when I try to create anything: courses, tests, etc. It appears to save, but I get an error message of "Page cannot be found"
  
  Can this be related to using MYSQL5.0 or does anyone have another idea?

• tom_glebas
  

  2007-01-09 20:47:26

  Re: Problem with creating courses

  Update - actually, I'm not having a problem creating courses, but am having a problem creating content.
  
  Also, my content folder is within the web file system.
  
  Thanks

• greg
  

  2007-01-10 08:43:01

  Re: Problem with creating courses

  This is likely a Web server issue. I'm not familiar with Big Blue.
  
  Perhaps someone else can offer some clues.
  
  copy one of the broken links here, so we can see why it might be breaking.
  
  [reply][b]In reply to:[/b]
  Update - actually, I'm not having a problem creating courses, but am having a problem creating content.
  
  Also, my content folder is within the web file system.
  
  Thanks
  [op]forums/view.php?fid=7;pid=7211;page=1#9646[/op][/reply]

• tom_glebas
  

  2007-01-10 15:04:32

  Re: Problem with creating courses

  The problem does appear to be related to BadBlue. I switched to Apache and everthing seems to work fine now.
  
  The content I tried to create was actaully created under BadBlue, but could not be resolved by BadBlue. I was using a link for the htpdocs root in BadBlue, and that might have something to do with it, but I didn't test that theory.
  
  Thanks!