search

SignatureBeef / Terraria-s-Dedicated-Server-Mod

TDSM - .NET and Mono compatible Terraria Server Software Mod
MIT License
143 stars 49 forks source link

Mysql table creation throwing key too long error #224

Closed voh closed 8 years ago

voh commented 8 years ago

Setting the database connection to mysql/mariadb and when creating the tables an error is thrown about the specified key being too long

[+] CreateIndex Groups (Name)
!!! Specified key was too long; max key length is 767 bytes
25/05/2016 16:21:01 Run Error> Exception in PreEnable of plugin TDSM Core Module
MySql.Data.MySqlClient.MySqlException: Specified key was too long; max key length is 767 bytes
  at MySql.Data.MySqlClient.MySqlStream.ReadPacket () <0x4104a620 + 0x00193> in <filename unknown>:0
  at MySql.Data.MySqlClient.NativeDriver.GetResult (System.Int32& affectedRow, System.Int64& insertedId) <0x4105ca60 + 0x00037> in <filename unknown>:0

The server will continue to start normally but upon world load there will be a null element found error

SignatureBeef commented 8 years ago

Hi voh

I've made a couple alterations to the migrations, are you able to try again using the latest TDSM.Core.dll?: https://github.com/DeathCradle/Terraria-s-Dedicated-Server-Mod/raw/master/Binaries/Plugins/TDSM.Core.dll

voh commented 8 years ago

After updating TDSM.Core.dll and clearing the DB it does appear it was able to create and populate the tables correctly! Still throws a null element found exception upon loading a world so I guess that is unrelated.

SignatureBeef commented 8 years ago

I'm glad migrations are working. In regards to the other issue, if possible are you able to screenshot it or copy the error into a new issue please.

voh commented 8 years ago

@DeathCradle I don't want to create a whole new issue for what amounts to a minor thing. On the latest update (779c22c) I am getting an error that connector no longer supports versions prior to mysql 5.0, thing is I have MariaDB 10.1, which is most definitely up to date. I don't know if this is just a set-up issue on my end or something else.