Windows error in the console

[gabra]

I have an error that is this

[11/09/2013 11:08:01] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)

I need help please
PD: I Use Sqlite Studio i need a solution

 

[Frostie]

add this table to ur 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 ;

 

[gabra]

how I add it and that serves to sqlite studio?

 

[gabra]

already solved thanks

 

[Frostie]

np

 

[Phased]

already solved thanks

Please tell me how, I have this problem too

 

[dominique120]

Please tell me how, I have this problem too

Execute that query in your database

 

[Dizznin]

I'm getting this error:

 Error while executing query: near "AUTO_INCREMENT": syntax error

any suggestions? thank you!