ATutor

Error in installation process

• Gino_Schwalbino
  

  2011-02-02 11:55:20

  Error in installation process

  Hello,
  While trying to install Atutor i get on "Step 2: Database" the following error:
  [i]Table AT_language_text creation failed[/i]
  
  I don't know what to do now...
  restarting mysql and apache don't resolve this problem...
  Can somebody help me?
  Thx,
  Gino
  
  Things to describe:
  operating system - Windows XP 32-Bit
  version of ATutor - 2.0.2
  versions of php - 5.3.5
  version of mysql - 5.5.8
  webserver & version - Apache / 2.2.17
  your ATutor location- http://localhost/ATutor/

• cindy
  

  2011-02-02 14:21:08

  Re: Error in installation process

  Check if your mysql is in strict mode. Try turning off the strict mode.

• taylormcc
  

  2011-02-04 09:20:32

  Re: Error in installation process

  To do what Cindy said you need to edit your my.ini file
  
  Search for the sql-mode= statement
  Remove strict_trans_tables from the quoted area
  
  After you do that you may need to restart the mysql service in services.msc
  
  if that still does not allow you to create the tables
  
  then you can try this http://atutor.ca/view/3/21541/1.html

• Gino_Schwalbino
  

  2011-02-04 10:42:16

  Re: Error in installation process

  thx for the answers.
  
  The problem is, there is no sql-mode= statement in the my.ini (c:\xampp\mysql\bin\my.ini).
  And there is no word "strict" in this file...
  
  But in this directory is a file named "mysql_config.pl" an there is a line "use strict;".
  Should i delete this line?
  
  Anyway...i followed your link and changed the word "Type" into "Engine" in line 13 of the file "atutor_language_text.sql"
  
  And now it works... THX!