znote acc problems on account

[wafuboe]

ok when i log my account it appears

string(116) "SELECT `id`, `character_name`, `time` FROM `znote_deleted_characters` WHERE `original_account_id` = 5 AND `done` = 0"
(query - SQL error)
Type: select_multi (select multiple rows from database)

Table 'otserver.znote_deleted_characters' doesn't exist

and on registering acc, but it stills create it

string(117) "INSERT INTO `znote_accounts` (`account_id`, `ip`, `created`, `activekey`) VALUES ('6', '', '1449981649', '756076049')"
(query - SQL error)
Type: voidQuery (voidQuery is used for update, insert or delete from database)

Unknown column 'activekey' in 'field list

 

[waldek0131]

did you put the right tfs version in config.php? cause that was causing most of my problems like that

 

[slavi]

Table 'otserver.znote_deleted_characters' doesn't exist

This means isn't added so.

Add it by the following SQL.

CREATE TABLE IF NOT EXISTS `znote_deleted_characters` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `original_account_id` int(11) NOT NULL,
  `character_name` varchar(255) NOT NULL,
  `time` datetime NOT NULL,
  `done` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

about the other error

Unknown column 'activekey' in 'field list

ALTER TABLE znote_accounts ADD `activekey` int(11) NOT NULL

 

[wafuboe]

thanks