This site is a testing version, but all data is shared with the live forum.


Raised This Month: $ Target: $400
 0% 

[req] problem with uq_jumpstats (mysql fix)


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
sigerman
Senior Member
Join Date: Aug 2013
Location: Argentina, Bs.As.
Old 05-15-2024 , 13:33   Re: [req] problem with uq_jumpstats (mysql fix)
Reply With Quote #1

Quote:
Originally Posted by JocAnis View Post
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.

Click image for larger version

Name:	123.jpg
Views:	4
Size:	22.8 KB
ID:	204388
sigerman is offline
Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 07:47.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode