[freak.exe_uLow]

Originally Posted by BiohazardLucifer L 05/12/2021 - 05:14:25: [levels_ranks/levelsranks_unusualkills.smx] SQL_Callback: error when sending the request (3 - Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' why ?

you probably have different tables and that should fix their problem...make a backup of the levelranks database and change your tables to utf8_unicode_ci after that check if the message still comes, if you use phpmyadmin you can find it under Operation

[BiohazardLucifer]

Originally Posted by freak.exe_uLow you probably have different tables and that should fix their problem...make a backup of the levelranks database and change your tables to utf8_unicode_ci after that check if the message still comes, if you use phpmyadmin you can find it under Operation

"L 05/12/2021 - 22:43:28: [levels_ranks/levelsranks_unusualkills.smx] SQL_Callback: error when sending the request (36) - Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '="

Same.. I change this in "lvl_base" and "lvl_base_unusualkill" ...


When i make restart server it s swich on lvl_base utf8_unicode_ci in utf8_general_ci auto, why ?

in setting rank i gave:

// (***) Write 4 byte characters (using utf8mb4 encoding) from player nicknames into MySQL database? [ 0 - utf8 will be used, 1 - yes ] // 0 - utf8(mb4)_general_ci . // 1 - utf8(mb4)_unicode_ci (Recommended for MySQL 8.0+). "lr_db_allow_utf8" "1"

[freak.exe_uLow]

Originally Posted by BiohazardLucifer "L 05/12/2021 - 22:43:28: [levels_ranks/levelsranks_unusualkills.smx] SQL_Callback: error when sending the request (36) - Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=" Same.. I change this in "lvl_base" and "lvl_base_unusualkill" ... When i make restart server it s swich on lvl_base utf8_unicode_ci in utf8_general_ci auto, why ? in setting rank i gave:

first if you make it, I would create a seperate databases for each plugin that does need MySQL, that makes managing it easier and this is how

thats my database for levelranks, your problem are the collation that are different, as is the case with me for example, it works without problems

[BiohazardLucifer]

Originally Posted by freak.exe_uLow first if you make it, I would create a seperate databases for each plugin that does need MySQL, that makes managing it easier and this is how thats my database for levelranks, your problem are the collation that are different, as is the case with me for example, it works without problems

thx

[DarenArk]

Servers with this Plugin:

broken counter?

[freak.exe_uLow]

Originally Posted by DarenArk broken counter?

nope, just not registered or no idea if that still works

[thekings4fun]

Originally Posted by BiohazardLucifer "L 05/12/2021 - 22:43:28: [levels_ranks/levelsranks_unusualkills.smx] SQL_Callback: error when sending the request (36) - Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=" Same.. I change this in "lvl_base" and "lvl_base_unusualkill" ... When i make restart server it s swich on lvl_base utf8_unicode_ci in utf8_general_ci auto, why ? in setting rank i gave:

I had the same problem about 15 days ago, I solved it when I left all the tables in utf8mb4_general_ci.

[dztracks]

[0] CS_SetClientClanTag
L 08/03/2021 - 11:49:41: [SM] [1] Line 84, levelsranks_tag.sp::TimerRepeat
L 08/03/2021 - 11:49:42: [SM] Exception reported: SetClientClanTag is not supported on this game
L 08/03/2021 - 11:49:42: [SM] Blaming: levels_ranks/levelsranks_tag.smx
i use this for css v34
and it show me this error

[freak.exe_uLow]

Originally Posted by dztracks [0] CS_SetClientClanTag L 08/03/2021 - 11:49:41: [SM] [1] Line 84, levelsranks_tag.sp::TimerRepeat L 08/03/2021 - 11:49:42: [SM] Exception reported: SetClientClanTag is not supported on this game L 08/03/2021 - 11:49:42: [SM] Blaming: levels_ranks/levelsranks_tag.smx i use this for css v34 and it show me this error

i don't give support for c34, so ask the person on github or on hlmod

[klikk]

I have v 3.1.6 (latest) and i use mysql. Some of my players on server won't have rank and they practically do not exist for LR system. Also i use some modules like LR Chat Prefix, FakeRank and they dont work until LR wont see this kind of players. its problem because out of 500, one always have that problem.

There is a problems face
PHOTO