Code:
[20/05/2014 15:35:03] mysql_real_query(): SELECT * FROM shop_history WHERE `processed` = 0; - MYSQL ERROR: Table 'otserv.shop_history' doesn't exist (1146)
[20/05/2014 15:35:07] mysql_real_query(): SELECT * FROM shop_history WHERE `processed` = 0; - MYSQL ERROR: Table 'otserv.shop_history' doesn't exist (1146)
[20/05/2014 15:35:11] mysql_real_query(): SELECT * FROM shop_history WHERE `processed` = 0; - MYSQL ERROR: Table 'otserv.shop_history' doesn't exist (1146)
Plzz HeLp
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`)
);
ALTER TABLE `shop_history` ADD `processed` int(11) NOT NULL default '0';