Mysql error in consoule

[Xaiman]

I have everything set up but when i run my server.exe i get this error like ever 15 sec

[12/05/2010 22:29:53] mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login'; - MYSQL ERROR: Table 'myserv.z_ots_comunication' doesn't exist (1146)

 

[MiPo91]

Run this sql query.

create table z_ots_comunication
(
id int(11) not null auto_increment,
name varchar(255) not null,
type varchar(255) not null,
action varchar(255) not null,
param1 varchar(255) not null,
param2 varchar(255) not null,
param3 varchar(255) not null,
param4 varchar(255) not null,
param5 varchar(255) not null,
param6 varchar(255) not null,
param7 varchar(255) not null,
delete_it int(2) not null default 1,
primary key(id)
)
type=innodb;

 

[Xaiman]

Ahh thank you very much

 

[Zerak456]

i just had same problem, just fixed . ty valhalla.