Mysql Error

[Ns Sparkz]

[14/12/2011 11:58:42] mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login'; - MYSQL ERROR: Table 'local.z_ots_comunication' doesn't exist (1146)

Could Anyone Help Me Please??

 

[Chuck88]

Hmm, Test:

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`)
);

If that dosen't work, Test do another database.

 

[Ns Sparkz]

Am Sorry,But where Do I Place this Script?? So i could Test it.
I go to my Database AND then Where do i paste the Script??

 

[Chuck88]

In ur database.

Example if ur database name is 'Hello'.

Open the database 'Hello' then press on the button SQL and copy the script and press GO

 

[Ns Sparkz]

It Worked Thank you And
Rep Back please +