Author
|
Message
|
Senior Member
Join Date: Aug 2013
Location: Argentina, Bs.As.
|
05-15-2024
, 13:33
Re: [req] problem with uq_jumpstats (mysql fix)
|
#1
|
Quote:
Originally Posted by JocAnis
well if it is about uq_players table, try to put PRIMARY KEY to authid, change uq_jumsptats.sql:
Code:
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.
|
|
|
|