ATutor

Learning Management Tools







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


Database Default character set


  • 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

  • 2008-05-17 17:26:57

    Re: Database - Default character set

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

  • 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.

  • 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

  • 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

  • 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.

  • 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