Hello,

if you found that it's impossible to to create heraldry tabard with symbols and servers return something like this

 

ERRR 2016-05-15 13:28:09.791 {} <> [81407] Heraldry::Info::saveToDb() - can't save heraldry to DB
ERRR 2016-05-15 13:28:09.791 {} <> [81407] CreateGuildHeraldryReqEvent::process() - can't create heraldry
ERRR 2016-05-15 13:28:10.373 {} <> [81552] DB error #1267: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='. Query: CALL p_addHeraldry(14,8,10, 1,1,1,'true_center','large', 0,0,0,'','');
WARN 2016-05-15 13:28:10.373 {} <> [81552] DB::mfRS(0 ms) CALL p_addHeraldry(14,8,10, 1,1,1,'true_center','large', 0,0,0,'','');

most likely Db was saved/exported without create DB/Table checkbox and Maria use default application collaction instead of correct utf8_unicode_ci

Please check you DB collation and change it to correct one (server shut down will be required) 

 

Was this article helpful?
1 out of 1 found this helpful
Have more questions? Submit a request

1 Comments

  • 0
    Avatar
    Jason Fox

    I have checked all of this and all is fine with the utf8_unicode_ci /general_ci

    However still nothing....it seems my DB has nothing what so ever for Heraldry ??
    Is there a copy n paste Sql / script i can add to my DB to enable this Heraldry function please?

     

    Many thanks

     

Please sign in to leave a comment.