[JocAnis]

Hm, can you try with setting: utf8mb4_unicode_520_ci
Maybe it will give you better results than utf8mb4_unicode_ci.

If that doesnt work, i would check config of phpmyadmin if it can handle these sets

[sigerman]

I changed the setting you required, still no success

________________________

________________________

I have another database running in the same machine, with utf8mb4_unicode_ci, and It works just fine

________________________

________________________

Thanks for helping me, even if we don't solve It, I appreciate a lot

Originally Posted by JocAnis Hm, can you try with setting: utf8mb4_unicode_520_ci Maybe it will give you better results than utf8mb4_unicode_ci. If that doesnt work, i would check config of phpmyadmin if it can handle these sets

[JocAnis]

okay, can you go in uqjumpstats/scripting/includes/uq_jumpstats_sql.inc

after:

if(!SqlConnection) 
{
	server_print("uq_jumpstats: Could not connect to SQL database; Error #%d: %s", error, g_error);
	log_amx("uq_jumpstats: Could not connect to SQL database; Error #%d: %s", error, g_error);
	return pause("a");
}

and add one line:
SQL_SetCharset(sql,"utf8")

[sigerman]

I put the line

PHP Code:

SQL_SetCharset(DB_TUPLE,"utf8"); 


Where you told me to, and IT WORKS!!!! : D Thanks!!

Originally Posted by JocAnis okay, can you go in uqjumpstats/scripting/includes/uq_jumpstats_sql.inc after: if(!SqlConnection) { server_print("uq_jumpstats: Could not connect to SQL database; Error #%d: %s", error, g_error); log_amx("uq_jumpstats: Could not connect to SQL database; Error #%d: %s", error, g_error); return pause("a"); } and add one line: SQL_SetCharset(sql,"utf8")

[JocAnis]

Nice man, you are welcome. Im glad i helped!

[sigerman]

Originally Posted by JocAnis Nice man, you are welcome. Im glad i helped!

I found out another problem

Tops get duplicated sometimes. The database is in the same machine than the cs.

Let me show you a picture:

[JocAnis]

well if it is about uq_players table, try to put PRIMARY KEY to authid, change uq_jumsptats.sql:

formatex(CreateInto, 1000, "CREATE TABLE IF NOT EXISTS uq_players (id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,name VARCHAR(64) NOT NULL,ip VARCHAR(39) NOT NULL,authid VARCHAR(35) NOT NULL, lastseen INT(10) NOT NULL,INDEX(name,authid))");

formatex(CreateInto, 1000, "CREATE TABLE IF NOT EXISTS uq_players (id INT NOT NULL AUTO_INCREMENT ,name VARCHAR(64) NOT NULL,ip VARCHAR(39) NOT NULL,authid VARCHAR(35) NOT NULL PRIMARY KEY, lastseen INT(10) NOT NULL,INDEX(name,authid))");

of course delete tables is required

[sigerman]

Originally Posted by JocAnis well if it is about uq_players table, try to put PRIMARY KEY to authid, change uq_jumsptats.sql: formatex(CreateInto, 1000, "CREATE TABLE IF NOT EXISTS uq_players (id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,name VARCHAR(64) NOT NULL,ip VARCHAR(39) NOT NULL,authid VARCHAR(35) NOT NULL, lastseen INT(10) NOT NULL,INDEX(name,authid))"); formatex(CreateInto, 1000, "CREATE TABLE IF NOT EXISTS uq_players (id INT NOT NULL AUTO_INCREMENT ,name VARCHAR(64) NOT NULL,ip VARCHAR(39) NOT NULL,authid VARCHAR(35) NOT NULL PRIMARY KEY, lastseen INT(10) NOT NULL,INDEX(name,authid))"); of course delete tables is required

I did exactly what you said and mysql ended in kind of a loop, I had to restart mariadb and put the previous plugin. I think this duplicated error has something to do with the way the plugin uploads data to the database.