ATutor

Learning Management Tools







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


utf8


  • 2008-12-02 00:43:44

    utf8

    I am installing 1.6.1 as a fresh install

    I am getting the error
    Database digiboo_atutor is not in UTF8. Please set the database character set to UTF8 before continuing by using the following query: ALTER DATABASE `digiboo_atutor` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci. To use ALTER DATABASE, you need the ALTER privilege on the database.



    I have checked all my info, tried setting up a few differnt database names/user names/passwords, etc... have double checked to make sure it is set to utf8_general_ci in my phpmyadmin, and simply dont understand what is wrong my server uses php 4.4.8.
    and on the first step of install everything has a green check mark next to it saying everything is setup for the requirements..


    any clue why im getting this utf8 error?

  • 2008-12-02 08:35:33

    Re: utf8

    Did you run the query as instructed in the message?

    ALTER DATABASE `digiboo_atutor` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci

    Run it in phpmyadmins SQL window.

  • 2008-12-02 09:19:38

    Re: utf8

    Can you check your database for me and tell me what it says after running the following query on your mysql:

    SHOW CREATE DATABASE `digiboo_atutor`;


    Thanks

  • 2008-12-02 15:50:56

    Re: utf8

    greg, I didnt try that before- but just did with no luck...I got it to execute right and got the message

    Your SQL query has been executed successfully (Query took 0.0004 sec)

    but it didnt help the install at all.



    harris- I get

    CREATE DATABASE `digiboo_atutor` /*!40100 DEFAULT CHARACTER SET utf8 */

  • 2008-12-02 15:55:51

    Re: utf8

    thank you guys very much.

    I dont know what did it or where I went wrong... but I got it working now.

    maybe running the utf query straightened things out

  • 2008-12-02 16:08:23

    Re: utf8

    Glad it is working now, enjoy~ :D