Error Mysql

[YugiNao]

Server: Snowz Server 3.0
Gesior AAC 0.3.8

If someone can solve this for me i really appreciate it
thanks.

 

[tatu hunter]

Look the error: 'Table 'otserv.shop_history' doesn't exist'.
That mean the table "shop_history" is missing in your data base.

 

[YugiNao]

do you have a sql query table for me to add?

 

[Zysen]

CREATE TABLE `otserv.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`)
);

 

[YugiNao]

Thank you Zysen, Repp+

 

[Zysen]

Np