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
[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