The reason for crashes and laggs, anyone knows how to fix this? :S

[MrRalphen]

This comes up in console every 2 seconds, it makes the ot crash and lagg, does anyone know how to fix it?

the text:

[03/01/2012 01:30:56] mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login'; - MYSQL ERROR: Table 'vets.z_ots_comunication' doesn't exist (1146)
[03/01/2012 01:31:00] mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login'; - MYSQL ERROR: Table 'vets.z_ots_comunication' doesn't exist (1146)


please help me :/

 

[Vendeliko]

you must create vets.z_ots_communication table in your datebase

 

[Ns Sparkz]

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

Rep+ If i helped you Place This in Your Database.

 

[GM Cloudy]

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

Rep+ If i helped you Place This in Your Database.

i have to execute it in mysql?

 

[Ns Sparkz]

Yes... in Sql

 

[Ns Sparkz]

Worked?

 

[GM Cloudy]

Worked?

omg
ya it worked!
ty ty ty
REP+