Problem with my OT

[Sam]

I moved to a new hosting server and now I get this:

[25/04/2009 09:50:21] mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login';: MYSQL ERROR: Table 'testdb.z_ots_comunication' doesn't exist

Any ideas how to fix?

 

[TriamerA]

Yes?? Add tables to your database, those from sms shop 'z_ots_communication'!! As you can see they are missing now.

 

[Cykotitan]

And the query for adding table `z_ots_comunication`:

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`)
);

Alternatively, you can execute all the queries from this page:
http://wklej.org/id/37481/txt