+ Post New Thread
Results 1 to 3 of 3
Virtual Learning Platforms Thread, Illegal mix of collations...(Moodle+MRBS) in Technical; I recently upgraded our Moodle to version Moodle 1.9.12+ (Build: 20110726) and also installed a newer version of MRBS. All ...
  1. #1

    beeswax's Avatar
    Join Date
    Jul 2005
    Location
    England
    Posts
    2,285
    Thank Post
    285
    Thanked 225 Times in 153 Posts
    Rep Power
    131

    Illegal mix of collations...(Moodle+MRBS)

    I recently upgraded our Moodle to version Moodle 1.9.12+ (Build: 20110726) and also installed a newer version of MRBS. All seems fine except when I click on a booking made by a teacher I get the following error message -
    Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' I sort of have an idea what the problem might be, but before I make any rash moves could someone explain, in layman's terms, what the solution could be?

  2. #2

    beeswax's Avatar
    Join Date
    Jul 2005
    Location
    England
    Posts
    2,285
    Thank Post
    285
    Thanked 225 Times in 153 Posts
    Rep Power
    131
    ^BUMP^ Anyone?

  3. #3

    Join Date
    Apr 2006
    Posts
    388
    Thank Post
    23
    Thanked 95 Times in 61 Posts
    Rep Power
    44
    Hi there.

    I am not a MySQList but this looks like the error you get from SQL Server where it tries to compare two columns of incompatible collations (i.e. in a join).


    So, column tableA.column is utf8_general_ci, tableB.column is utf8_unicode_ci, and your're running a SQL statement that attempts to join on these two columns.

    In the SQL world the fixes are to either change the collation of one of the columns or to alter your query so that it's specifying the collation to use.

    The thing to do is *probably* to change the database collation, but it might be worth googling '<appname> change database collation' and see if you can find horror/success stories on doing this . . . .

SHARE:
+ Post New Thread

Similar Threads

  1. 10-minute mix of quips and fun lesson
    By mattx in forum General Chat
    Replies: 0
    Last Post: 23rd January 2010, 06:58 PM
  2. Reviews of US Moodle Partners
    By checkmate in forum Virtual Learning Platforms
    Replies: 1
    Last Post: 22nd September 2009, 07:41 PM
  3. Examples of good Moodle course?
    By gaz350 in forum Virtual Learning Platforms
    Replies: 5
    Last Post: 19th December 2008, 04:12 PM
  4. Ease of installing Moodle
    By secretlife in forum Virtual Learning Platforms
    Replies: 6
    Last Post: 10th March 2008, 08:21 AM
  5. Moodle Help! Lots of Teachers!
    By Disorder in forum Virtual Learning Platforms
    Replies: 2
    Last Post: 12th January 2007, 03:55 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •