Loading Game Server

[isengwong]

I play fafurion for the first time,i setup fafurion like i setup etina's fate.
Loading LoginServer no problem but when when running gameserver,I got this message :

[05/01 14:43:37] -----------------------------------------------=[ IdFactory ]
[05/01 14:43:37] Updated characters online status.
[05/01 14:43:37] Could not clean up database: (conn=17) Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='
java.sql.SQLException: (conn=17) Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='
   at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:261)
   at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:171)
   at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:248)
   at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:338)
   at org.mariadb.jdbc.MariaDbStatement.executeUpdate(MariaDbStatement.java:527)
   at com.zaxxer.hikari.pool.ProxyStatement.executeUpdate(ProxyStatement.java:120)
   at com.zaxxer.hikari.pool.HikariProxyStatement.executeUpdate(HikariProxyStatement.java)
   at org.l2jmobius.gameserver.idfactory.IdFactory.cleanUpDB(IdFactory.java:177)
   at org.l2jmobius.gameserver.idfactory.IdFactory.<init>(IdFactory.java:98)
   at org.l2jmobius.gameserver.idfactory.BitSetIDFactory.<init>(BitSetIDFactory.java:52)
   at org.l2jmobius.gameserver.idfactory.IdFactory.<clinit>(IdFactory.java:109)
   at org.l2jmobius.gameserver.GameServer.<init>(GameServer.java:213)
   at org.l2jmobius.gameserver.GameServer.main(GameServer.java:501)
Caused by: java.sql.SQLException: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='
   at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1594)
   at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1453)
   at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1415)
   at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:228)
   at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:332)
   ... 9 more

[05/01 14:43:37] Cleaned 0 expired timestamps from database.
[05/01 14:43:37] BitSetIDFactory: 102912 id's available.
[05/01 14:43:37] ----------------------------------------=[ Scripting Engine ]
[05/01 14:43:37] Loaded 793 files to exclude.




Any idea where is the problem ?Still can create character.

[ReynalDev]

If is possible:
1. Delete your database,
2. Create new database using the program or Navicat or any other program, even throught command line could work.
3. game database installer (jar file), in oirder to install you database again.

This possible will resolve the problem. 

I found this on internet if you are a tech person: https://stackoverflow.com/questions/11770074/illegal-mix-of-collations-utf8-unicode-ci-implicit-and-utf8-general-ci-implic

[isengwong]

If is possible:
1. Delete your database,
2. Create new database using the program or Navicat or any other program, even throught command line could work.
3. game database installer (jar file), in oirder to install you database again.

This possible will resolve the problem. 

I found this on internet if you are a tech person: https://stackoverflow.com/questions/11770074/illegal-mix-of-collations-utf8-unicode-ci-implicit-and-utf8-general-ci-implic

You're right.After clean install GS installer,it worked