sql error

[a7aa7a]

[13:49:48.312] mysql_real_query(): SELECT * FROM `z_ots_comunication` WHERE `typ
e` = 'login'; - MYSQL ERROR: Table 'work.z_ots_comunication' doesn't exist (1146
)

 

[Snavy]

work.z_ots_comunication -> Doesn't exist..

Exec. this

ALERT TABLE `z_ots_comunication` ADD `work` int(11);

 

[Vanderlay]

Don't do that!
The error clearly states that the table does not exist. If you imported a database, please verify that you got all the content from it, or maybe try re-importing it.

What Snavy is thinking of is an undefined column inside a table, but in this case, the table doesn't exist.

'work' in this case is his database name.

 

[Snavy]

@Vanderlay You've just tought me something new XD

 

[a7aa7a]

[17:16:40.140] mysql_real_query(): SELECT * FROM `z_ots_comunication` WHERE `typ
e` = 'login'; - MYSQL ERROR: Table 'work.z_ots_comunication' doesn't exist (1146
)
[17:17:04.203] Account Manager has logged in.
> Broadcasted message: "New record: 1 players are logged in.".
[17:17:10.171] mysql_real_query(): SELECT * FROM `z_ots_comunication` WHERE `typ
e` = 'login'; - MYSQL ERROR: Table 'work.z_ots_comunication' doesn't exist (1146
)

 

[Vanderlay]

I already stated your error in my previous post. Please review it.

 

[dominique120]

Execute this query to fill in the missing tables:

CREATE TABLE IF NOT EXISTS `z_ots_comunication` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `login` 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 AUTO_INCREMENT=230 ;

 

[Limos]

Next time if you are missing a table, you can write CREATE TABLE with the name of the table in search, then you will find posts with the query to create the table.

How to run a query:
http://otland.net/threads/mysql-how-to-run-a-query.177833/