Mysql Error

[sytniowski]

When I start my server everything is fine but then this shows up:

mysql_real_query≤>: SELECT * FROM z_ots_comunication WHERE `type` = ´login´ ; - MYSQL ERROR: Table ´fts2.z._ots_comunication´ doesn't exist ≤1146>

Do anybody know what it means? :S

 

[bolero]

Try with this..

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=745 ;