• 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!

Mysql error table

gizzzmo

New Member
Joined
Dec 29, 2009
Messages
91
Reaction score
0
It says this; "mysql_real_query<>: SELECT * FROM z_ots_comunication WHERE 'type' = 'login'; - MYSQL ERROR: Table '*****.z_ots_comunication' doesn't exist' <1146>

I understand I have to add this table in the database, but I need help on it. If you can help I would appreciate it.

Thanks.
 
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++
 
I Rep'd you.

But sorry for being noob, but when I go to my database and I go to the bottom where it says "create new table on databse" underneath it I put "z_ots_comunication" then it asks for number of fields, I put 1. The I click go and something like this pops up (Not sure if i'm doing this correctly)


Field _____
Type VARCHAR _____
Length/Values1 _____
Collation
Attributes _____
Null _____
Default2 _____

CURRENT_TIMESTAMP
Extra _____



---

Comments _____
MIME type _____
Transformation options3 _____
 
Back
Top