• 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!

Lua SQL erros on my websitee ZNOTE ACC

wafuboe

wafuboe

Member
Joined
Dec 24, 2010
Messages
881
Solutions
2
Reaction score
22
I got this erros on my webiste
On my account page
Code: 
string(117) "SELECT `id`, `character_name`, `time` FROM `znote_deleted_characters` WHERE `original_account_id` = 10 AND `done` = 0"
(query - SQL error)
Type: select_multi (select multiple rows from database)

Table 'shoyowar.znote_deleted_characters' doesn't exist

After registering an account

Code: 
string(128) "INSERT INTO `znote_accounts` (`account_id`, `ip`, `created`, `activekey`) VALUES ('11', '2130706433', '1418802372', '182836914')"
(query - SQL error)
Type: voidQuery (voidQuery is used for update, insert or delete from database)

Unknown column 'activekey' in 'field list'

Im using the lastest znote:) 1.5 i guess
OTX TFS 0.4
 
Sort by date Sort by votes
wafuboe said:
I got this erros on my webiste
On my account page
Code: 
string(117) "SELECT `id`, `character_name`, `time` FROM `znote_deleted_characters` WHERE `original_account_id` = 10 AND `done` = 0"
(query - SQL error)
Type: select_multi (select multiple rows from database)

Table 'shoyowar.znote_deleted_characters' doesn't exist

After registering an account

Code: 
string(128) "INSERT INTO `znote_accounts` (`account_id`, `ip`, `created`, `activekey`) VALUES ('11', '2130706433', '1418802372', '182836914')"
(query - SQL error)
Type: voidQuery (voidQuery is used for update, insert or delete from database)

Unknown column 'activekey' in 'field list'

Im using the lastest znote:) 1.5 i guess
OTX TFS 0.4
Click to expand...

config.php
Read this lines: https://github.com/Znote/ZnoteAAC/blob/master/config.php#L2-L9
 
Upvote 0 Downvote
I dont see the problem i got use OTX based con TFS 0.4 so i got in config TFS_03

the first one is a missing table, howerver i dont know how to create querys on mysql to create tables
the second error i dont know

im nooby on websites
 
Upvote 0 Downvote
I got this one too

string(216) "SELECT `id`, `itemtype` AS `item_id`, `amount`, `price`, `created`, `anonymous`, (SELECT `name` FROM `players` WHERE `id` = `player_id`) AS `player_name` FROM `market_offers` WHERE `sale` = 1 ORDER BY `created` DESC;"
(query - SQL error)
Type: select_multi (select multiple rows from database)

Table 'shoyowar.market_offers' doesn't exist

HELP! Im desperate :(
 
Last edited by a moderator:
Upvote 0 Downvote
Run this query on SQL.
Code: 
CREATE TABLE IF NOT EXISTS `market_offers` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `player_id` int(11) NOT NULL,
  `sale` tinyint(1) NOT NULL DEFAULT '0',
  `itemtype` int(10) unsigned NOT NULL,
  `amount` smallint(5) unsigned NOT NULL,
  `created` bigint(20) unsigned NOT NULL,
  `anonymous` tinyint(1) NOT NULL DEFAULT '0',
  `price` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `sale` (`sale`,`itemtype`),
  KEY `created` (`created`),
  KEY `player_id` (`player_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9605 ;
 
Upvote 0 Downvote
narko said:
Run this query on SQL.
Code: 
CREATE TABLE IF NOT EXISTS `market_offers` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `player_id` int(11) NOT NULL,
  `sale` tinyint(1) NOT NULL DEFAULT '0',
  `itemtype` int(10) unsigned NOT NULL,
  `amount` smallint(5) unsigned NOT NULL,
  `created` bigint(20) unsigned NOT NULL,
  `anonymous` tinyint(1) NOT NULL DEFAULT '0',
  `price` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `sale` (`sale`,`itemtype`),
  KEY `created` (`created`),
  KEY `player_id` (`player_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9605 ;
Click to expand...
narko said:
Run this query on SQL.
Code: 
CREATE TABLE IF NOT EXISTS `market_offers` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `player_id` int(11) NOT NULL,
  `sale` tinyint(1) NOT NULL DEFAULT '0',
  `itemtype` int(10) unsigned NOT NULL,
  `amount` smallint(5) unsigned NOT NULL,
  `created` bigint(20) unsigned NOT NULL,
  `anonymous` tinyint(1) NOT NULL DEFAULT '0',
  `price` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `sale` (`sale`,`itemtype`),
  KEY `created` (`created`),
  KEY `player_id` (`player_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9605 ;
Click to expand...
narko said:
Run this query on SQL.
Code: 
CREATE TABLE IF NOT EXISTS `market_offers` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `player_id` int(11) NOT NULL,
  `sale` tinyint(1) NOT NULL DEFAULT '0',
  `itemtype` int(10) unsigned NOT NULL,
  `amount` smallint(5) unsigned NOT NULL,
  `created` bigint(20) unsigned NOT NULL,
  `anonymous` tinyint(1) NOT NULL DEFAULT '0',
  `price` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `sale` (`sale`,`itemtype`),
  KEY `created` (`created`),
  KEY `player_id` (`player_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9605 ;
Click to expand...

how about these two?
on my accuont
Code: 
string(117) "SELECT `id`, `character_name`, `time` FROM `znote_deleted_characters` WHERE `original_account_id` = 10 AND `done` = 0"
(query - SQL error)
Type: select_multi (select multiple rows from database)

Table 'shoyowar.znote_deleted_characters' doesn't exist

after creating an account
Code: 
string(128) "INSERT INTO `znote_accounts` (`account_id`, `ip`, `created`, `activekey`) VALUES ('11', '2130706433', '1418802372', '182836914')"
(query - SQL error)
Type: voidQuery (voidQuery is used for update, insert or delete from database)

Unknown column 'activekey' in 'field list'
 
Upvote 0 Downvote
i have similar problem :s

@Limos
Code: 
string(175) "INSERT INTO `accounts` (`name`, `password`, `email`, `creation`) VALUES ('accname', '49b6209c06860b03edfa2b05b989b6f51c32c4ea', '[email protected]', '1449443095')"
(query - SQL error)
Type: voidQuery (voidQuery is used for update, insert or delete from database)

Unknown column 'creation' in 'field list'
 
Upvote 0 Downvote
hi, i have problem please help :(

HTML: 
string(162) "INSERT INTO `accounts` (`name`, `password`, `email`, `creation`) VALUES ('asdasd', '00ea1da4192a2030f9ae023de3b3143ed647bbab', '[email protected]', '1594984536')"
(query - SQL error)
Type: voidQuery (voidQuery is used for update, insert or delete from database)

Unknown column 'creation' in 'field list'
 
Upvote 0 Downvote
pekiniak said:
hi, i have problem please help :(

HTML: 
string(162) "INSERT INTO `accounts` (`name`, `password`, `email`, `creation`) VALUES ('asdasd', '00ea1da4192a2030f9ae023de3b3143ed647bbab', '[email protected]', '1594984536')"
(query - SQL error)
Type: voidQuery (voidQuery is used for update, insert or delete from database)

Unknown column 'creation' in 'field list'
Click to expand...

Seems that the column creation doesn't exists in the table accounts
 
Upvote 0 Downvote

Similar threads

D
  • Question
Setting up website for OT server
Replies
1
Views
481
Mateus Robeerto
Mateus Robeerto
Back
Top