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

MYSQL Table Problem

GM Inside

New Member
Joined
Jun 16, 2007
Messages
14
Reaction score
2
Hello , sorry for my bad english but i'm spanish ;( xDDD ... i've got one problem with database... I start the OTServ and 1-2 minutes after i see a error message on the console... this it the message :

[16/01/2011 23:35:24] mysql_real_query(): SELECT * FROM shop_history WHERE `processed` = 0; - MYSQL ERROR: Table 'theforgottenserver.shop_history' doesn't exist (1146)

I put on my database this table:

CREATE TABLE `theforgottenserver.shop_history` (
`id` int(11) NOT NULL auto_increment,
`to_name` varchar(255) NOT NULL default '0',
`to_account` int(11) NOT NULL default '0',
`from_nick` varchar(255) NOT NULL,
`from_account` int(11) NOT NULL default '0',
`price` int(11) NOT NULL default '0',
`offer_id` int(11) NOT NULL default '0',
`trans_state` varchar(255) NOT NULL,
`trans_start` int(11) NOT NULL default '0',
`trans_real` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
);


But i have the same error ... i can`t fix it .... ;((( Please Help ???

Thanks... +Rep
 
Code:
CREATE TABLE `shop_history`
(
`id` int(11) NOT NULL auto_increment,
`to_name` varchar(255) NOT NULL default '0',
`to_account` int(11) NOT NULL default '0',
`from_nick` varchar(255) NOT NULL,
`from_account` int(11) NOT NULL default '0',
`price` int(11) NOT NULL default '0',
`offer_id` int(11) NOT NULL default '0',
`trans_state` varchar(255) NOT NULL,
`trans_start` int(11) NOT NULL default '0',
`trans_real` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
);
 
Thanks men ... but now look the message...

[17/01/2011 14:05:06] mysql_real_query(): SELECT * FROM shop_history WHERE `processed` = 0; - MYSQL ERROR: Unknown column 'processed' in 'where clause' (1054)

What's !! ??? ;( Please Help... Thanks.
 
Back
Top