Solved Database Error

[xx Kami xx]

hey i got this error and i dont know how to fix it can anyone help me?

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

ill Rep++

 

[Limos]

Execute this in your database.

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`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=230 ;

 

[Ninja]

It doesn't hurt to search sometimes.

http://otland.net/f16/mysql-error-139591/#post1344551

- - - Edited - - -

Limos replied faster