ATutor

Database Default character set

• miguelnu
  

  2008-05-15 21:30:23

  Database Default character set

  PHP 4.3.9
  zlib Enabled
  mbstring Enabled
  mysql Enabled
  safe_mode Off
  file_uploads On
  upload_max_filesize 10M
  post_max_size >= 8 MB 8M
  sessions Enabled
  session.auto_start = 0
  session.save_path Directory Writeable
  . in include_path Enabled
  MySQL 4.1.12
  
  Hi!
  
  I'm traing to install the new version of Atutor (1.6 pl1) in a new hosting and I get this error:
  
  Database xxxxxxxxxx_net_-_atutor is not in UTF8. Please set the database character set to UTF8 before continuing by using the following query: ALTER DATABASE `xxxxxxxxxx_-_atutor` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
  
  I've run this command at the DB and check that the character set is utf8 but the error continues.
  
  Any sugesstion?
  Thanks

• harris
  

  2008-05-17 17:26:57

  Re: Database - Default character set

  Hello, do you have permission to perform the alter statement?

• miguelnu
  

  2008-05-17 20:13:40

  Re: Database - Default character set

  hello harris:
  
  yes, I log as DB administrator.
  
  I'v run the ALTER command and set the character set.
  
  I also test the original version 1.6 and the problem persists.

• harris
  

  2008-05-18 12:31:43

  Re: Database - Default character set

  Hello,
  
  Was there any sql error when you ran that statement? Can you please confirm with me that the DB char set was actually changed after the statement was executed?
  
  Thanks!
  
  
  harris

• miguelnu
  

  2008-05-18 20:43:49

  Re: Database - Default character set

  Hello againg!
  
  The sql ran successful, I attach the screen with the set up of the DB.
  
  I'm not sure about the meaning of "No privileges" (in the screen), I believe that I can't create new database.
  
  Thanks harris for your help.
  
  Miguel

• harris
  

  2008-05-20 09:40:30

  Re: Database - Default character set

  Hi,
  Did you successfully created a database (xxxxxxxxxx_net_-_atutor) for ATutor itself? If the database hasn't been created, then the statement wouldn't work.
  
  You may want to ask your database administrator to grant you the create/alter database/table permissions, or have the database administrator create the database for you.

• miguelnu
  

  2008-05-20 17:58:46

  Re: Database - Default character set

  After several tests I believe that the problem is with the length of the name of the database.
  
  In the same server I get the error whit the DB "trainxxxxxx_net_-_atutor", but using the DB named "test" all works fine.
  
  Thanks again