Unknown column 'type' in 'where clause' (1054)

[Owner Maydel]

When i Go Open My Server Linux 8.6 i Got This Mysql Error

[20:17:43.440] mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login'; - MYSQL ERROR: Unknown column 'type' in 'where clause' (1054)



I Edit Some Query Wont Fixed Too Can Some One Help Me.

 

[slavi]

Show me the z_ots_comunication structure.

 

[HalfAway]

Type does not exists in z_ots_communication.

Make sure you have the correct table added to the database.

CREATE TABLE IF NOT EXISTS `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 AUTO_INCREMENT=230 ;

 

[Owner Maydel]

Already Do your Create Table @HalfAway And Got The Same Error Too

mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login'; - MYSQL ERROR: Unknown column 'type' in 'where clause' (1054)



Can Please Some One Help Me..

 

[HalfAway]

Did you delete the table before you tried my post?

You need to delete the table or alter/add the type column in z_ots_comunication.

Because that error clearly says that column type is unkown which means it do not exist.

 

[Owner Maydel]

no but i will drop this now and do your's I will Test Now.

 

[Cornex]

ALTER TABLE `z_ots_comunication` ADD `type` varchar(255)