AAC Using Znote ACC for 1.3tfs

[Blez]

I setup the server for localhost configured the config and got the website setup for a second to make an account and got this error and can no longer access the wesbite without receiving this.
string(122) "SELECT ip, created, points, cooldown, flag, active_email FROM znote_accounts WHERE account_id = 2 LIMIT 1;"
(query - SQL error)
Type: select_single (select single row from database)

Table 'otserv.znote_accounts' doesn't exist

Post automatically merged: Dec 15, 2019

Receiving this error when trying to make a character

string(741) "INSERT INTO players(name, group_id, account_id, level, vocation, health, healthmax, experience, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, maglevel, mana, manamax, manaspent, soul, town_id, posx, posy, posz, conditions, cap, sex, lastlogin, lastip, save, skull, skulltime, lastlogout, blessings, balance, skill_fist, skill_club, skill_sword, skill_axe, skill_dist, skill_shielding, skill_fishing) VALUES ('Test', '1', '2', '8', '1', '185', '185', '4200', '68', '76', '78', '58', '128', '0', '0', '40', '40', '0', '100', '1', '5', '5', '2', '', '470', '1', '0', '0', '1', '0', '0', '0', '0', '0', '10', '10', '10', '10', '10', '10', '10');"
(query - SQL error)
Type: voidQuery (voidQuery is used for update, insert or delete from database)

Unknown column 'manaspent' in 'field list

Post automatically merged: Dec 15, 2019

using this

The Forgotten Tibia (no vocations, new skills, skills by points, dual wield, auto loot, quiver, etc)

The Forgotten Tibia https://github.com/GustavoContreiras/TheForgottenTibia The Forgotten Tibia is a free and open-source MMORPG written in C++ and LUA. It is a fork from the The Forgotten Server 1.3 (3b63f65) and OTClient (07b4b78) projects. What makes it different from Tibia / The Forgotten...

otland.net

And noticed the dude removed these from the db.
manaspent
skill_fist_tries
skill_club_tries

 

[Joriku]

You're missing the tables, add them.
Q: Did you even insert tables while installing the znote acc?
First one

CREATE TABLE IF NOT EXISTS `znote_accounts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `account_id` int(11) NOT NULL,
  `ip` int(10) NOT NULL,
  `created` int(10) NOT NULL,
  `points` int(10) DEFAULT 0,
  `cooldown` int(10) DEFAULT 0,
  `active` tinyint(4) NOT NULL DEFAULT '0',
  `activekey` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

Check

Solved - Znote AAC problem Table 'evo.players_online' doesn't exist

Server Information Players online: string(59) "SELECT COUNT(`player_id`) AS `value` FROM `players_online`;" (query - SQL error) Type: select_single (select single row from database) Table 'evo.players_online' doesn't exist how i can fix this?

otland.net

 

[Blez]

This is the error i receive when i try to make an account or login
string(122) "SELECT ip, created, points, cooldown, flag, active_email FROM znote_accounts WHERE account_id = 2 LIMIT 1;"
(query - SQL error)
Type: select_single (select single row from database)

Unknown column 'active_email' in 'field list'

Post automatically merged: Dec 18, 2019

Last issue
string(173) "INSERT INTO accounts (name, password, email, creation) VALUES ('9069978', '0247cc8424795bc1700c7f2cfaeaa5084bc4d368', '[email protected]', '1576628880')"
(query - SQL error)
Type: voidQuery (voidQuery is used for update, insert or delete from database)

Field 'id' doesn't have a default valu