Get error when Login

[Elac]

Hello.
I get a error when I try to login.

Error - mysql_real_query] Query: SELECT id, name, password, secret, type, premium_ends_at FROM accounts WHERE name = 'name'
Message: Unknown column 'premium_ends_at' in 'field list'

Use Myacc and Tfs 1.5.

Thanks!

 

[Gesior.pl]

Use Myacc and Tfs 1.5.

It looks like you are using TFS 1.2 (or 0.3 / 0.4) database schema with TFS 1.4 server. premium_ends_at column was added between TFS 1.2 and 1.4.
It was added in 26th migration to TFS 1.x schema: TFS-1.5-Downgrades/data/migrations/26.lua at 8.0 · nekiro/TFS-1.5-Downgrades (https://github.com/nekiro/TFS-1.5-Downgrades/blob/8.0/data/migrations/26.lua#L4-L5)

Nekiro 8.0 TFS 1.5 database schema already has it:

TFS-1.5-Downgrades/schema.sql at 8.0 · nekiro/TFS-1.5-Downgrades

Alternative forgottenserver versions for older protocols support - nekiro/TFS-1.5-Downgrades

github.com

 

[Elac]

It looks like you are using TFS 1.2 (or 0.3 / 0.4) database schema with TFS 1.4 server. premium_ends_at column was added between TFS 1.2 and 1.4.
It was added in 26th migration to TFS 1.x schema: TFS-1.5-Downgrades/data/migrations/26.lua at 8.0 · nekiro/TFS-1.5-Downgrades (https://github.com/nekiro/TFS-1.5-Downgrades/blob/8.0/data/migrations/26.lua#L4-L5)

Nekiro 8.0 TFS 1.5 database schema already has it:

TFS-1.5-Downgrades/schema.sql at 8.0 · nekiro/TFS-1.5-Downgrades

Alternative forgottenserver versions for older protocols support - nekiro/TFS-1.5-Downgrades

github.com

Thanks for answer! Will you try to explain how to get it going from that error?

 

[Sorky]

Thanks for answer! Will you try to explain how to get it going from that error?

ALTER TABLE accounts
ADD COLUMN premium_ends_at INT UNSIGNED NOT NULL DEFAULT 0;

 

[Gesior.pl]

ALTER TABLE accounts
ADD COLUMN premium_ends_at INT UNSIGNED NOT NULL DEFAULT 0;

@Elac this should work.
If there will be more errors, you will have to delete database and create new using your OTS database schema (also reinstall acc. maker) ex. https://raw.githubusercontent.com/nekiro/TFS-1.5-Downgrades/refs/heads/8.60/schema.sql