Mysql_real_query bug

[Mjmackan]

[27/06/2011 21:19:20] mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login'; - MYSQL ERROR: Table 'rainyday.z_ots_comunication' doesn't exist (1146)

 

[Alehopper]

[COLOR=#000000][COLOR=#0000BB]Table [/COLOR][COLOR=#DD0000]'rainyday.z_ots_comunication' [/COLOR][COLOR=#0000BB]doesn[/COLOR][COLOR=#DD0000]'t exist[/COLOR][/COLOR]

Add to your database via SQL label
​

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

 

[Mjmackan]

Thanks, trough i got helped from a friend before ^^ ReP++