Unicode Error on Installation DB Checker

Unicode Error on Installation DB Checker

by Syndi Poston -
Number of replies: 17

I am using BlueHost and have uploaded the zip Moodle v. 1.8 file and have extracted it successfully.  I have followed the steps in the installation guide through setting up a blank database up to the point of "run the installer script to create the config.php" portion.  When the installation wizard walks through the server checks, I get an error that "unicode has to be installed or enabled."  BlueHost tech support says it's an error with the install of Moodle.  But, I do not know what to do to correct the problem.

Any suggestions would be greatly appreciated.  I've attached screen pics of the database setup screen. 

Thanks, in advance, for any help!

Attachment Database_setup.jpg
Average of ratings: -
In reply to Syndi Poston

Re: Unicode Error on Installation DB Checker

by Antonio Carlos Pereira Gomes -
Hi Syndi,
I've experienced the same issue with a CVS installation at HostMonster.com.
I've tried many operations including restoring a database and setting up all the tables to UTF8
(ALTER TABLE adodb_logsql DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;)
but the problem persist.
I think it's a bug in the installer. I've posted 2 messages in this forum, and in the installation problem forum, but I got no answers.
Regards.
Antonio Carlos.

Average of ratings: -
In reply to Antonio Carlos Pereira Gomes

Re: Unicode Error on Installation DB Checker

by Antonio Carlos Pereira Gomes -
I've created a ticket at Moodle Tracker, you can monitor and add comments at
MDL-11743
Regards.
Antonio.


http://tracker.moodle.org/browse/MDL-11743?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_36308
Average of ratings: -
In reply to Antonio Carlos Pereira Gomes

Re: Unicode Error on Installation DB Checker

by Richard Enison -

ACPG,

See my comment in your Tracker issue.

RLE

Average of ratings: -
In reply to Richard Enison

Re: Unicode Error on Installation DB Checker

by Syndi Poston -
Thank you for your comment.  Possibly that may be an issue with the other user, but, I checked my database settings, and it is definitely set to "utf8_unicode_ci".
Average of ratings: -
In reply to Syndi Poston

Re: Unicode Error on Installation DB Checker

by Richard Enison -

SP,

Then you might want to add your comment at MDL-11743 or it may be closed as a non-issue.

RLE

Average of ratings: -
In reply to Antonio Carlos Pereira Gomes

Re: Unicode Error on Installation DB Checker

by Syndi Poston -
Thank you, Antonio, very much.  I was not aware of the Moodle Tracker.  I will keep watch on your posting there as well.
Average of ratings: -
In reply to Syndi Poston

Re: Unicode Error on Installation v. 1.9 DB Checker

by Syndi Poston -
I lost hope with v 1.8 and tried to install v 1.9.  However, I get stuck at the same screen and still continue to get the unicode error.  I would certainly appreciate any help.  I have searched all over trying to find solutions for a unicode error, and have not yet been successful.  Thanks in advance.
Average of ratings: -
In reply to Syndi Poston

Re: Unicode Error on Installation v. 1.9 DB Checker

by Richard Enison -

SP,

See the last few posts at http://moodle.org/mod/forum/discuss.php?d=81369, relating to the query I suggested in the post mentioned in my comment in the tracker issue (yes, I've seen yours), namely http://moodle.org/mod/forum/discuss.php?d=82414#p365142. I will save you the trouble of following that link. The query I am asking everyone with this problem to run is

SHOW VARIABLES LIKE 'character_set_database';

This is the query Moodle is using to test MySQL databases for Unicode. So far, Lynn Mole is the only one who has run it and posted the results. The evidence so far is that the problem is not with Moodle, but with MySQL, phpMyAdmin, or cPanel (see Lynn M's comment in the  tracker, just above yours). It might be just in one version (or several) of MySQL. No way to tell until more Moodlers run the above query and post the results along with the version of MySQL (and phpMyAdmin if they are using it) that they have.

RLE

Average of ratings: -
In reply to Richard Enison

Re: Unicode Error on Installation v. 1.9 DB Checker

by Birdie Newborn -
Richard --

That revealed latin1 -- but why? I changed the charset and the collation. What more can I do?

My phpmyadmin is 2.10.0.2, and MySQL is 4.1.21. Localhost is 5.0.37
Average of ratings: -
In reply to Birdie Newborn

Re: Unicode Error on Installation v. 1.9 DB Checker

by Richard Enison -

BN

As I said in my previous post in this discussion (to which yours is a reply), see the last few posts at http://moodle.org/mod/forum/discuss.php?d=81369 (especially the last two from me). They relate directly to both of your questions (to the best of my ability at this time).

RLE

Average of ratings: -
In reply to Richard Enison

Re: Unicode Error on Installation v. 1.9 DB Checker

by Syndi Poston -

A TREMENDOUS BREAKTHROUGH!  My webhost (BlueHost) finally identified the problem.  Their server had a size limit on what I could upload, so, all of my Moodle files were not uploading.  However, they directed to me to a utility they have called "Fantastico" and it is FANTASTIC. I had Moodle set up in a few minutes using Fantastico.

Thanks everyone for your help and suggestions.  I've learned a LOT!!

Average of ratings: -
In reply to Syndi Poston

Re: Unicode Error on Installation v. 1.9 DB Checker

by Richard Enison -

SP,

I'm glad you're happy with Fantisco ... so far. I don't know how much longer this will last (I've got my stopwatch running -- just kidding). I personally wouldn't use it. If you would like to know why, here is a sample of what other Moodlers have reported about their experiences with it over the last few months in this forum, in chronological order, starting with the oldest:

http://moodle.org/mod/forum/discuss.php?d=63765#287608
http://moodle.org/mod/forum/discuss.php?d=64372#290265
http://moodle.org/mod/forum/discuss.php?d=67127#p301944
http://moodle.org/mod/forum/discuss.php?d=67397#p303165
http://moodle.org/mod/forum/discuss.php?d=77219
http://moodle.org/mod/forum/discuss.php?d=80337#p356281
http://moodle.org/mod/forum/discuss.php?d=80672#p362259
http://moodle.org/mod/forum/discuss.php?d=80672#p365671

RLE

Average of ratings: -
In reply to Richard Enison

Re: Unicode Error on Installation v. 1.9 DB Checker

by John Isner -
Hi Richard,
Another nice bibliography. I added it to the Fantastico entry in the Moodle docs.
Average of ratings: -
In reply to John Isner

Re: Unicode Error on Installation v. 1.9 DB Checker

by Richard Enison -

JI,

Thanx, but, as you may have noticed, the purpose for which I compiled this bibliography was to explain why I wouldn't use or recommend Fantastico. So I searched my inbox for occurrances of the word Fantastico (there were over 70) and picked the ones that had something negative to say about it. The others were either positive or neutral. I don't know if it is suitable as a "sample" of opinions about it in the docs, at least not without introducing it as the one-sided list that it is (as I like to think I did in my post).

Anyway, for balance, there is the very positive glossary entry for Fantastico, by Don Hinkelman. If you click on the word in SP's post, it should take you there.

RLE

Average of ratings: -
In reply to Richard Enison

Re: Unicode Error on Installation v. 1.9 DB Checker

by Chris Surridge -
Thanks for the directions, Richard. Your posts outline a very quick fix for the pesky database problem!


Average of ratings: -
In reply to Chris Surridge

Re: Unicode Error on Installation v. 1.9 DB Checker

by asmaa shreif -

I faced that problem before and that is done when you install moodle twise or one time and delete moodle and install it again he appeared that problem

and after some tries on it the problem solved by reinstall iis on your pc or server again it will works fine after doing that (isa)

Average of ratings: -
In reply to Syndi Poston

Re: Unicode Error on Installation DB Checker

by Ricardo Quiroz -

For CPanel Users solution can't be much easier than it is.

Go to phpmyadmin select your database select Operations under the menu and change the character set (Under Collation) to utf8bin and voila!

Average of ratings: -