Solved Tfs 1.0 error migrations-1.lua

[Xarly]

hello guys , im getting this error on mi tfs console [Error - DatabaseManager::updateDatabase - Version: -1] cannot open data/migrations/-1.lua: No such file or directory. im searching on forums but i can't see how to fix it someone knows how to fix that error? thanks guys^^

 

[Limos]

INSERT INTO `server_config` (`config`, `value`) VALUES ('db_version', '18');

If you don't have the table:

CREATE TABLE IF NOT EXISTS `server_config` (
  `config` varchar(50) NOT NULL,
  `value` varchar(256) NOT NULL DEFAULT '',
  PRIMARY KEY `config` (`config`)
) ENGINE=InnoDB;

You can also import the schema.sql from TFS 1.0, so it already has those things.

 

[Xarly]

INSERT INTO `server_config` (`config`, `value`) VALUES ('db_version', '18');

If you don't have the table:

CREATE TABLE IF NOT EXISTS `server_config` (
  `config` varchar(50) NOT NULL,
  `value` varchar(256) NOT NULL DEFAULT '',
  PRIMARY KEY `config` (`config`)
) ENGINE=InnoDB;

You can also import the schema.sql from TFS 1.0, so it already has those things.

Thanks limos! for your help^^

 

[Blasphemy]

Thankful!, but when I execute those lines, now it show me this error "18.lua", what couldit be?

 

[fir3wall]

Hi All

I have sent private message to @

Don Daniello​

And he asked me to ask the question on the forum but I do also have resolution or solution to resolve problems mentioned above.

So when you compile the server using git otland/forgottenserver (https://github.com/otland/forgottenserver/wiki/Compiling-on-Debian-GNU-Linux)

You have to:

1. Import the "schema.sql" to your database.
2. Copy / Move the "key.pem" file from the main folder to Build folder.
3. Copy / Move the "data" folder from the main folder to Build folder.

This problems where detected ruining Debian 10 with mariaDB installed.

I did't have to re-import or change original input of schema.sql

Hope someone finds this useful as I spend 5h trying to resolve the issue with:

>> Loading config
>> Establishing database connection... MySQL 10.3.27
>> Running database manager
[Error - DatabaseManager::updateDatabase - Version: 26] cannot open data/migrations/26.lua: No such file or directory
>> Loading vocations
[Error - Vocations::loadFromXml] Failed to load data/XML/vocations.xml: File was not found
> ERROR: Unable to load vocations!
>> No services running. The server is NOT online.

With Regards

Fir3wall

PS. Might be worth Linking to tutorial or where might be visible to others.

 

[Rizka]

Thankful!, but when I execute those lines, now it show me this error "18.lua", what couldit be?

View attachment 36212

You can create a file called 18.lua and insert this inside it:

function onUpdateDatabase()
return false
end

Post automatically merged: Sep 17, 2021

Thankful!, but when I execute those lines, now it show me this error "18.lua", what couldit be?

View attachment 36212

function onUpdateDatabase()
    return false
end

Post automatically merged: Sep 17, 2021

Thankful!, but when I execute those lines, now it show me this error "18.lua", what couldit be?

View attachment 36212

create this lua copy this :

function onUpdateDatabase()
    return false
end