• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

⚔️ TFS 1.8 Downgrade 8.60 — Open Source Tibia Server Base

try this one with SSE2
Thanks, I love you, it worked.
Post automatically merged:

Now I need a working OTClient or the Tibia 8.6 .DAT/.SPR files.
Post automatically merged:

I'm asking a lot, I know—we finally got it running—but since I couldn't get it to work before, I've now lost the OTClient (along with its DAT/SPR files). Do you happen to have any data with an account—like a "God" account or just a player account—so I can test it?
 

Attachments

Last edited:
install myaac and You will get that account
[2026-06-26 15:10:17.886] [error] [Error - mysql_real_query] Query: SELECT id, name, account_id, group_id, sex, vocation, experience, level, reset, maglevel, health, healthmax, blessings, blessings1, blessings2, blessings3, blessings4, blessings5, blessings6, blessings7, blessings8
Message: Unknown column 'blessings1' in 'field list'
[2026-06-26 15:10:31.435] [error] [Error - mysql_real_query] Query: SELECT id, name, account_id, group_id, sex, vocation, experience, level, reset, maglevel, health, healthmax, blessings, blessings1, blessings2, blessings3, blessings4, blessings5, blessings6, blessings7, blessings8
Message: Unknown column 'blessings1' in 'field list'
[2026-06-26 15:10:43.562] [error] [Error - mysql_real_query] Query: SELECT id, name, account_id, group_id, sex, vocation, experience, level, reset, maglevel, health, healthmax, blessings, blessings1, blessings2, blessings3, blessings4, blessings5, blessings6, blessings7, blessings8
Message: Unknown column 'blessings1' in 'field list'
[2026-06-26 15:10:45.558] [error] [Error - mysql_real_query] Query: SELECT id, name, account_id, group_id, sex, vocation, experience, level, reset, maglevel, health, healthmax, blessings, blessings1, blessings2, blessings3, blessings4, blessings5, blessings6, blessings7, blessings8
Message: Unknown column 'blessings1' in 'field list'
[2026-06-26 15:10:47.954] [error] [Error - mysql_real_query] Query: SELECT id, name, account_id, group_id, sex, vocation, experience, level, reset, maglevel, health, healthmax, blessings, blessings1, blessings2, blessings3, blessings4, blessings5, blessings6, blessings7, blessings8
Message: Unknown column 'blessings1' in 'field list'
Post automatically merged:

try
1234567 / tibia

Error​

Análisis estático:

Se encontraron 2 errores durante el análisis.



  1. Se esperaba un corchete de apertura seguido por un conjunto de valores. (near "CREATE" at position 785)
  2. Símbolo (token) inesperado. (near "CREATE" at position 785)


consulta SQL: Copiar

-- -- Dumping data for table accounts -- INSERT INTO accounts (id, name, password, secret, type, premium_ends_at, email, key, created, rlname, location, country, web_lastlogin, web_flags, email_verified, email_new, email_new_time, email_code, email_next, premium_points, creation, tibia_coins, points_second, vote) VALUES (1, '1', '41da8bef22aaef9d7c5821fa0f0de7cccc4dda4d', NULL, 1, 0, '', '', 0, '', '', '', 0, 0, 0, '', 0, '', 0, 0, 0, 0, 0, 0), (2, '1234567', '41da8bef22aaef9d7c5821fa0f0de7cccc4dda4d', NULL, 6, 1813444262, '[email protected]', '', 1782238563, '', '', 'us', 0, 3, 1, '', 0, '', 0, 0, 0, 5327, 0, 0), -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli account_bans -- CREATE TABLE account_bans ( account_id int(11) NOT NULL, reason varchar(255) NOT NULL, banned_at bigint(20) NOT NULL, expires_at bigint(20) NOT NULL, banned_by int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

MySQL ha dicho: Documentación

#1064 - Algo está equivocado en su sintax cerca 'CREATE TABLE account_bans (<br>&nbsp;&nbsp;account_id int(11) NOT NULL,<br>&nbsp;&nbsp;reason var...' en la linea 15
 
try to make a clean database, import server sql
and do

INSERT INTO accounts (id, name, password, secret, type, premium_ends_at, email, key, created, rlname, location, country, web_lastlogin, web_flags, email_verified, email_new, email_new_time, email_code, email_next, premium_points, creation, tibia_coins, points_second, vote) VALUES
(1, '1', '41da8bef22aaef9d7c5821fa0f0de7cccc4dda4d', NULL, 1, 0, '', '', 0, '', '', '', 0, 0, 0, '', 0, '', 0, 0, 0, 0, 0, 0),
(2, '1234567', '41da8bef22aaef9d7c5821fa0f0de7cccc4dda4d', NULL, 6, 1813444262, '[email protected]', '', 1782238563, '', '', 'us', 0, 3, 1, '', 0, '', 0, 0, 0, 5327, 0, 0),


and

INSERT INTO players (id, name, group_id, account_id, level, reset, vocation, health, healthmax, experience, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, lookmount, currentmount, randomizemount, direction, maglevel, mana, manamax, manaspent, soul, town_id, posx, posy, posz, conditions, cap, sex, lastlogin, lastip, save, skull, skulltime, lastlogout, blessings, onlinetime, deletion, balance, task_hunting_points, bounty_points, soulseals_points, has_weekly_expansion, bonus_rerolls, charmpoints, protection_time, offlinetraining_time, offlinetraining_skill, stamina, xpboost_stamina, xpboost_value, skill_fist, skill_fist_tries, skill_club, skill_club_tries, skill_sword, skill_sword_tries, skill_axe, skill_axe_tries, skill_dist, skill_dist_tries, skill_shielding, skill_shielding_tries, skill_fishing, skill_fishing_tries, token_protected, token_hash, created, hide, comment, blessings1, blessings2, blessings3, blessings4, blessings5, blessings6, blessings7, blessings8) VALUES
(1, 'Account Manager', 1, 1, 1, 0, 0, 150, 150, 0, 0, 0, 0, 0, 110, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 1, 32069, 31901, 6, '', 400, 0, 1782324551, 16777343, 1, 0, 0, 1782324594, 0, 103, 0, 0, 0, 0, 0, 0, 0, 0, 10, 43200, -1, 2516, 0, 0, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 0, '', 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0),
(2, 'Crownots Master', 6, 2, 1, 0, 0, 100, 100, 0, 10, 10, 10, 10, 136, 0, 0, 2, 0, 3, 0, 100, 100, 0, 0, 1, 1023, 1024, 7, '', 0, 0, 1782501128, 16777343, 1, 0, 0, 1782501870, 0, 16580, 0, 0, 0, 0, 0, 1, 0, 0, 10, 43200, -1, 1040, 2640, 50, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 1782238563, 0, '', 1, 1, 1, 1, 1, 0, 0, 0),
 
try to make a clean database, import server sql
and do

INSERT INTO accounts (id, name, password, secret, type, premium_ends_at, email, key, created, rlname, location, country, web_lastlogin, web_flags, email_verified, email_new, email_new_time, email_code, email_next, premium_points, creation, tibia_coins, points_second, vote) VALUES
(1, '1', '41da8bef22aaef9d7c5821fa0f0de7cccc4dda4d', NULL, 1, 0, '', '', 0, '', '', '', 0, 0, 0, '', 0, '', 0, 0, 0, 0, 0, 0),
(2, '1234567', '41da8bef22aaef9d7c5821fa0f0de7cccc4dda4d', NULL, 6, 1813444262, '[email protected]', '', 1782238563, '', '', 'us', 0, 3, 1, '', 0, '', 0, 0, 0, 5327, 0, 0),


and

INSERT INTO players (id, name, group_id, account_id, level, reset, vocation, health, healthmax, experience, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, lookmount, currentmount, randomizemount, direction, maglevel, mana, manamax, manaspent, soul, town_id, posx, posy, posz, conditions, cap, sex, lastlogin, lastip, save, skull, skulltime, lastlogout, blessings, onlinetime, deletion, balance, task_hunting_points, bounty_points, soulseals_points, has_weekly_expansion, bonus_rerolls, charmpoints, protection_time, offlinetraining_time, offlinetraining_skill, stamina, xpboost_stamina, xpboost_value, skill_fist, skill_fist_tries, skill_club, skill_club_tries, skill_sword, skill_sword_tries, skill_axe, skill_axe_tries, skill_dist, skill_dist_tries, skill_shielding, skill_shielding_tries, skill_fishing, skill_fishing_tries, token_protected, token_hash, created, hide, comment, blessings1, blessings2, blessings3, blessings4, blessings5, blessings6, blessings7, blessings8) VALUES
(1, 'Account Manager', 1, 1, 1, 0, 0, 150, 150, 0, 0, 0, 0, 0, 110, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 1, 32069, 31901, 6, '', 400, 0, 1782324551, 16777343, 1, 0, 0, 1782324594, 0, 103, 0, 0, 0, 0, 0, 0, 0, 0, 10, 43200, -1, 2516, 0, 0, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 0, '', 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0),
(2, 'Crownots Master', 6, 2, 1, 0, 0, 100, 100, 0, 10, 10, 10, 10, 136, 0, 0, 2, 0, 3, 0, 100, 100, 0, 0, 1, 1023, 1024, 7, '', 0, 0, 1782501128, 16777343, 1, 0, 0, 1782501870, 0, 16580, 0, 0, 0, 0, 0, 1, 0, 0, 10, 43200, -1, 1040, 2640, 50, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 1782238563, 0, '', 1, 1, 1, 1, 1, 0, 0, 0),

Error​

Análisis estático:

Se encontraron 3 errores durante el análisis.



  1. Se esperaba un corchete de apertura seguido por un conjunto de valores. (near "and" at position 583)
  2. Símbolo (token) inesperado. (near "and" at position 583)
  3. Tipo de declaración desconocida. (near "and" at position 583)


consulta SQL: Copiar

INSERT INTO accounts (id, name, password, secret, type, premium_ends_at, email, key, created, rlname, location, country, web_lastlogin, web_flags, email_verified, email_new, email_new_time, email_code, email_next, premium_points, creation, tibia_coins, points_second, vote) VALUES (1, '1', '41da8bef22aaef9d7c5821fa0f0de7cccc4dda4d', NULL, 1, 0, '', '', 0, '', '', '', 0, 0, 0, '', 0, '', 0, 0, 0, 0, 0, 0), (2, '1234567', '41da8bef22aaef9d7c5821fa0f0de7cccc4dda4d', NULL, 6, 1813444262, '[email protected]', '', 1782238563, '', '', 'us', 0, 3, 1, '', 0, '', 0, 0, 0, 5327, 0, 0), and INSERT INTO players (id, name, group_id, account_id, level, reset, vocation, health, healthmax, experience, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, lookmount, currentmount, randomizemount, direction, maglevel, mana, manamax, manaspent, soul, town_id, posx, posy, posz, conditions, cap, sex, lastlogin, lastip, save, skull, skulltime, lastlogout, blessings, onlinetime, deletion, balance, task_hunting_points, bounty_points, soulseals_points, has_weekly_expansion, bonus_rerolls, charmpoints, protection_time, offlinetraining_time, offlinetraining_skill, stamina, xpboost_stamina, xpboost_value, skill_fist, skill_fist_tries, skill_club, skill_club_tries, skill_sword, skill_sword_tries, skill_axe, skill_axe_tries, skill_dist, skill_dist_tries, skill_shielding, skill_shielding_tries, skill_fishing, skill_fishing_tries, token_protected, token_hash, created, hide, comment, blessings1, blessings2, blessings3, blessings4, blessings5, blessings6, blessings7, blessings8) VALUES (1, 'Account Manager', 1, 1, 1, 0, 0, 150, 150, 0, 0, 0, 0, 0, 110, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 1, 32069, 31901, 6, '', 400, 0, 1782324551, 16777343, 1, 0, 0, 1782324594, 0, 103, 0, 0, 0, 0, 0, 0, 0, 0, 10, 43200, -1, 2516, 0, 0, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 0, '', 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0), (2, 'Crownots Master', 6, 2, 1, 0, 0, 100, 100, 0, 10, 10, 10, 10, 136, 0, 0, 2, 0, 3, 0, 100, 100, 0, 0, 1, 1023, 1024, 7, '', 0, 0, 1782501128, 16777343, 1, 0, 0, 1782501870, 0, 16580, 0, 0, 0, 0, 0, 1, 0, 0, 10, 43200, -1, 1040, 2640, 50, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 1782238563, 0, '', 1, 1, 1, 1, 1, 0, 0, 0),;

MySQL ha dicho: Documentación

#1064 - Algo está equivocado en su sintax cerca 'key, created, rlname, location, country, web_lastlogin, web_flags, email_veri...' en la linea 1
 
ok, so I dont kow what You expect
im compiling on i5 6th gen with 8GB ram for now - that server and otc exe files, running 2 test servers and xampp

so dont tell me Your comp is weak, just go and install myaac on clean database and run it for christ sake
 
ok, so I dont kow what You expect
im compiling on i5 6th gen with 8GB ram for now - that server and otc exe files, running 2 test servers and xampp

so dont tell me Your comp is weak, just go and install myaac on clean database and run it for christ sake
I already have MyAcc... but it won't let me log in... I'm getting this error.
[2026-06-26 15:21:49.340] [error] [Error - mysql_real_query] Query: SELECT id, name, account_id, group_id, sex, vocation, experience, level, reset, maglevel, health, healthmax, blessings, blessings1, blessings2, blessings3, blessings4, blessings5, blessings6, blessings7, blessings8
Message: Unknown column 'blessings1' in 'field list'
[2026-06-26 15:21:54.351] [info] >> Database: opened MySQL connection #5.
[2026-06-26 15:21:54.354] [error] [Error - mysql_real_query] Query: SELECT id, name, account_id, group_id, sex, vocation, experience, level, reset, maglevel, health, healthmax, blessings, blessings1, blessings2, blessings3, blessings4, blessings5, blessings6, blessings7, blessings8
Message: Unknown column 'blessings1' in 'field list'
[2026-06-26 15:21:59.370] [error] [Error - mysql_real_query] Query: SELECT id, name, account_id, group_id, sex, vocation, experience, level, reset, maglevel, health, healthmax, blessings, blessings1, blessings2, blessings3, blessings4, blessings5, blessings6, blessings7, blessings8
Message: Unknown column 'blessings1' in 'field list'
 
Back
Top