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

znote acc shop problem

vexler222

vexler222

Active Member
Joined
Apr 22, 2012
Messages
714
Solutions
15
Reaction score
46
hi, i have problem with shop in znote acc.
If i try buy item, after click button "BUY" i see it

Code: 
string(138) "INSERT INTO `znote_shop_orders` (`account_id`, `type`, `itemid`, `count`, `time`) VALUES ('3', '3', '7844', '200 CC Scroll', '1538913478')" 
(query - SQL error) 
Type: voidQuery (voidQuery is used for update, insert or delete from database)

Data truncated for column 'count' at row 1

After it i dont get item in game but points was removed from my account.
 
Sort by date Sort by votes
Try executing this query in Phpmyadmin.
Code: 
CREATE TABLE IF NOT EXISTS `znote_shop_orders` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`account_id` INT(11) NOT NULL,
`type` INT(11) NOT NULL,
`itemid` INT(11) NOT NULL,
`count` INT(11) NOT NULL,
`time` INT(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB;
 
Upvote 0 Downvote
Catalyst said:
Try executing this query in Phpmyadmin.
Code: 
CREATE TABLE IF NOT EXISTS `znote_shop_orders` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`account_id` INT(11) NOT NULL,
`type` INT(11) NOT NULL,
`itemid` INT(11) NOT NULL,
`count` INT(11) NOT NULL,
`time` INT(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB;
Click to expand...


MySQL returned an empty result set (i.e. zero rows). (Query took 0.0017 seconds.)
 
Upvote 0 Downvote
Code: 
INSERT INTO `znote_shop_orders` (`account_id`, `type`, `itemid`, `count`, `time`) VALUES ('3', '3', '7844', '200 CC Scroll', '1538913478')

count = '200 CC Scroll' ???????????????????????

Probably count is an integer so you cant just save a string?????

Or maybe count is a string but your data is too large
 
Upvote 0 Downvote
Raggaer said:
Code: 
INSERT INTO `znote_shop_orders` (`account_id`, `type`, `itemid`, `count`, `time`) VALUES ('3', '3', '7844', '200 CC Scroll', '1538913478')

count = '200 CC Scroll' ???????????????????????

Probably count is an integer so you cant just save a string?????

Or maybe count is a string but your data is too large
Click to expand...

haha, its my fault, i forgott change int to varchar in database, cuz i dont use "count" to show "count" but i using it to show name of item :D
 
Upvote 0 Downvote

Similar threads

Joriku
  • Question
Force wrap item
Replies
2
Views
393
Joriku
Joriku
Back
Top