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

Solved Shop_orders table

Hokku

Member
Joined
Jul 25, 2013
Messages
95
Reaction score
18
Location
Extremadura, Spain
Hello! I putted Nevix gesior shop system in my server, its TFS 1.1 and all is ok, but when i try to get the item ingame by the command !shop i get this message: 16:04 You have no orders. and shows a error message in console. I created the Shop_orders table because it was droping a error yesterday in console of missing table, so probably i build wrong.

Error in console:
console.png


My Shop_orders in db:

image.png


Thanks btw!

FIXED, go to mysql admin>ur db>sql and write it:
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=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
;)
 
Last edited:
Back
Top