MySql Error

[a7aa7a]

I get this error in console please help
([05/08/2011 20:22:41] mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login'; - MYSQL ERROR: Table 'myot.z_ots_comunication' doesn't exist (1146)
[05/08/2011 20:23:05] mysql_real_query(): UPDATE `players` SET `onlinetimetoday`=players.onlinetimetoday+60, `onlinetimeall`=players.onlinetimeall+60 WHERE `online` = 1; - MYSQL ERROR: Unknown column 'onlinetimetoday' in 'field list' (1054)
[05/08/2011 20:23:12] mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login'; - MYSQL ERROR: Table 'myot.z_ots_comunication' doesn't exist (1146)
[05/08/2011 20:23:43] mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login'; - MYSQL ERROR: Table 'myot.z_ots_comunication' doesn't exist (1146)

 

[Korrex]

Download and run server?
Install gesior.
If you already have Gesior.

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;

REP++ HURR DURR.

 

[a7aa7a]

but when i make a new account and i try to login to account manager it says wrong account or password
what do i do to fix it?

 

[ahmed30]

localhost/phpmyadmin > sql

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;

 

[a7aa7a]

Ty Ahmed30