How to add a database entry? please help!

[Bondy]

Hello, in my .exe i get this error
[16/04/2012 17:02:03] mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login'; - MYSQL ERROR: Table 'enjoy.z_ots_comunication' doesn't exist (1146)

What should I do? thanks a lot!!

 

[Bondy]

Please help me out, people cant loggin because of this :/

 

[Tibiamakers]

create the table "enjoy.z_ots_comunication" it should be in the .sql file or somewhere..

 

[Bondy]

Im sorry, im new into this, can u tell me what is the mysql command to create that table? thanks a lot

 

[Tibiamakers]

never seen that table, i just readed the error and said to you..

 

[Bondy]

Someone please help me, i have no idea how to create this table

 

[ahmed30]

Please help me out, people cant loggin because of this :/

that's not a reason to make people can't login your ot

here its the query but next time search

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;

 

[Tibiamakers]

yes it is