MySQL error

[dominique120]

Hi,

When I run my server, after a certain amount of time I get errors like these:

mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login'; - MYSQL ERROR: Table 'otserv.z_ots_comunication' doesn't exist (1146)

And when I create a table called "z_ots_comunication" I get erros like these

[22:30:36.582] mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type`
= 'login'; - MYSQL ERROR: Unknown column 'type' in 'where clause' (1054)

How can I fix this?

thanks

 

[Summ]

CREATE TABLE IF NOT EXISTS `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`)
);

 

[simson361]

or you can also add a separate param

 

[Summ]

or you can also add a separate param

Ehm what?