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

Windows Error.

The Governor

LostOT.com
Joined
Feb 16, 2013
Messages
80
Reaction score
1
Location
United States
Error: mysql_real_query(): SELECT * FROM shop_history WHERE `processed` = 0; - MYSQL ERROR: Table 'lostrealm.shop_history' doesn't exist (1146)


Keeps saying that over and over in my consol. Idk what is causing it. Help please!!

Rep++
 
You are missing the shop_history table.
What acc maker are you using?

- - - Updated - - -

I saw your using Gesior.
Import this into your database
SQL:
 CREATE TABLE `lostrealm.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`) );
 
Last edited:
Back
Top