Problem With Znote

[waldek0131]

my znote seems not to function properly

[/url][/IMG]

[/url][/IMG] Under Server Information

 

[Codex NG]

CREATE TABLE IF NOT EXISTS `players_online` (
  `player_id` int(11) NOT NULL,
  PRIMARY KEY (`player_id`)
) ENGINE=MEMORY;

 

[waldek0131]

CREATE TABLE IF NOT EXISTS `players_online` (
  `player_id` int(11) NOT NULL,
  PRIMARY KEY (`player_id`)
) ENGINE=MEMORY;

thank you that works and it would be awesome if you could help me with some few more errors

1.string(71) "SELECT `rank_id` FROM `guild_membership` WHERE `player_id`='8' LIMIT 1;"
(query - SQL error)
Type: select_single (select single row from database)

Table 'otsserver.guild_membership' doesn't exist

2.string(133) "SELECT `id`, `name`, `vocation`, `skill_club` AS `value` FROM `players` WHERE `group_id` < 2 ORDER BY `skill_club` DESC LIMIT 0, 100;"
(query - SQL error)
Type: select_multi (select multiple rows from database)

Unknown column 'skill_club' in 'field list'

3.
Register Account
string(160) "INSERT INTO `accounts` (`name`, `password`, `email`, `creation`) VALUES ('lol123', '99efc50a9206bde3d7a8e694aad8e138ca7dc3f7', '[email protected]', '1449800790')"
(query - SQL error)
Type: voidQuery (voidQuery is used for update, insert or delete from database)

Unknown column 'creation' in 'field list'









if you could help thank you

 

[Volrath]

thank you that works and it would be awesome if you could help me with some few more errors

1.string(71) "SELECT `rank_id` FROM `guild_membership` WHERE `player_id`='8' LIMIT 1;"
(query - SQL error)
Type: select_single (select single row from database)

Table 'otsserver.guild_membership' doesn't exist

2.string(133) "SELECT `id`, `name`, `vocation`, `skill_club` AS `value` FROM `players` WHERE `group_id` < 2 ORDER BY `skill_club` DESC LIMIT 0, 100;"
(query - SQL error)
Type: select_multi (select multiple rows from database)

Unknown column 'skill_club' in 'field list'

3.
Register Account
string(160) "INSERT INTO `accounts` (`name`, `password`, `email`, `creation`) VALUES ('lol123', '99efc50a9206bde3d7a8e694aad8e138ca7dc3f7', '[email protected]', '1449800790')"
(query - SQL error)
Type: voidQuery (voidQuery is used for update, insert or delete from database)

Unknown column 'creation' in 'field list'









if you could help thank you

Your tables are missing the columns skill_club and creation. Are you sure you are using the correct schema for your AAC?

 

[Cornex]

You have to set correct TFS version inside your config.php, at this line: https://github.com/Znote/ZnoteAAC/blob/master/config.php#L7

 

[waldek0131]

You have to set correct TFS version inside your config.php, at this line: https://github.com/Znote/ZnoteAAC/blob/master/config.php#L7

ok it seems to work