Aperture-Development / MSync-2

Version 2 of MSync - Fully working and extra steak
https://www.Aperture-Development.de
GNU General Public License v3.0
12 stars 1 forks source link

[MSync] Failed to create server ! #4

Closed Chillstice closed 5 years ago

Chillstice commented 5 years ago

I've been using this actively on 3 servers for a few weeks.

I recently noticed issues with ulib rank syncing and found this error in the console:

[MSync] Failed to create server ! Please report this to the developer: Data too long for column 'server_name' at row 1

I think this might have been caused by changing the server hostname.

Should I reset the database and re-add the servers?

Is there a way to recover from this error?

ApertureDevelopment commented 5 years ago

Hello,

How long is your servers hostname? (characters)

Chillstice commented 5 years ago

hostname "Chill-Servers PropHunt 24/7|RotLock|Outfitter|Taunts|Maps" 57 char

What's the maximum length for MSync?

ApertureDevelopment commented 5 years ago

55 characters, i will extend that by 20 later, and add a check to crop the servername if necessary. Also I will post you a sql script later, to update the table as I found 2 mistakes in it.

Chillstice commented 5 years ago

:D

ApertureDevelopment commented 5 years ago

Run this SQL:

ALTER TABLE tbl_msync_servers
MODIFY server_group INT UNSIGNED NOT NULL, 
MODIFY server_name VARCHAR(75) NOT NULL;

And test this addon branch: https://github.com/Aperture-Development/MSync-2/tree/bugfix

ApertureDevelopment commented 5 years ago

You could also propably just drop the servers table, as it has not much of a function currently and could be replaced easily

ApertureDevelopment commented 5 years ago

Assuming that this is resolved, I am closing this issue. Let me know if you have anymore troubles