Solved [Znote ACC] String Error SQL secret TFS 1.2

[Adm Eddie]

Hello ^^

I compiled TFS 1.2 , but I run into this error:

If anyone has any idea of what could it be I would appreciate so much that you share it

Here's how I have set the config

By the way I was trying to run this server (Just in case this helps in anything)
https://github.com/orts/server


Beforehand
Thankyou very much

 

[Cornex]

ALTER TABLE `znote_accounts`
ADD `secret` CHAR(16) DEFAULT NULL;

 

[Adm Eddie]

Code:
ALTER TABLE `znote_accounts`
ADD `secret` CHAR(16) DEFAULT NULL;

Ugh it didn't work :/
but as you can see the accounts actually get registered:

this string error only shows up when registering

 

[Cornex]

Didn't read the whole query..

ALTER TABLE `accounts`
ADD `secret` CHAR(16) DEFAULT NULL;

 

[Adm Eddie]

Do you have the secret column in accounts?

ALTER TABLE `accounts`
ADD `secret` CHAR(16) DEFAULT NULL;

:´))))) thank you very much it worked ^^

I will change the title of this thread to solved. and again thank you very much

 

[Znote]

Ahh yeah, the official released TFS 1.2 does not have the `secret` column in accounts schema.sql. It was fixed 3 days later. But after you run the server once the engine should automatically alter the table for you.

I recommend you to get the latest commit from github. There are some crash issues with 2FA(Two-factor authentication) that has been resolved.