Stefan1200's Forum

JTS3ServerMod Hosting Edition => JTS3ServerMod MySQL & WebInterface => Topic started by: Dream on February 02, 2017, 06:51:33 PM

Title: MySQL instanceconfig row bot_functions
Post by: Dream on February 02, 2017, 06:51:33 PM
Row bot_functions is type varchar(1023). Can I incerase it without any problems?
Title: Re: MySQL instanceconfig row bot_functions
Post by: Stefan1200 on February 02, 2017, 07:38:43 PM
That column don't exists. If you mean the column "configvalue", that was already increased with the Web Interface build 3027.
Title: Re: MySQL instanceconfig row bot_functions
Post by: Dream on February 02, 2017, 10:35:50 PM
Yes, my wrong. I mean configvalue.

I should install new bot and import old data? There was more changes than configvalue length? Should not it be automatically changed during the bot update?


-- Stupid questions. I checked sql and used
ALTER TABLE `jts3servermod_instanceconfig` CHANGE `configvalue` `configvalue` VARCHAR(2048) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL ;

Thank you for support.
Title: Re: MySQL instanceconfig row bot_functions
Post by: Stefan1200 on February 03, 2017, 01:40:41 PM
Of course, if you installed the new files correctly, the web interface will update automatically to build 3027! Never do SQL table changes on your own or you destroy the web interface at the next auto update!

FAQ entry: https://www.stefan1200.de/forum/index.php?topic=264.0