• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

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

Owner Maydel

Evolera.Tk
Joined
Aug 16, 2015
Messages
302
Reaction score
40
Location
Egypt
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.
 
Type does not exists in z_ots_communication.

Make sure you have the correct table added to the database.
Code:
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 ;
 
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..
 
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.
 
Last edited:
Back
Top