Solved Z_Ots_Communication

[Alan Alosh]

Hi, I know that this may be a very common error, but how do I actually fix it? "OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login'"

Thanks.

 

[Eazy M]

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;

 

[Alan Alosh]

Where should I put that if I may ask? Just to make sure.

 

[Eazy M]

Where should I put that if I may ask? Just to make sure.

Download a SQLite browser if you haven't one. SQLite Database Browser | Free Development software downloads at SourceForge.net
Open your database (.s3db file), go to "Execute SQL", paste the code in the "SQL String" box and press "Execute query"

 

[Alan Alosh]

Download a SQLite browser if you haven't one. SQLite Database Browser | Free Development software downloads at SourceForge.net
Open your database, go to "Execute SQL", paste the code in the "SQL String" box and press "Execute query"

Now I see, thanks for helping! Rep+

Edit: Hehe, it still appears?

- - - Updated - - -

Nevermind, it was just that the browser didn't respond.

 

[Eazy M]

Now I see, thanks for helping! Rep+

Edit: Hehe, it still appears?

- - - Updated - - -

Nevermind, it was just that the browser didn't respond.

If it doesn't work using that SQLite browser then I dunno what to use. Since i use MYSQL and not SQLite.

 

[Alan Alosh]

I'm just using sqlite for testing at the moment, so it won't spam my log if I'd use MySQL?

 

[Eazy M]

I'm just using sqlite for testing at the moment, so it won't spam my log if I'd use MySQL?

If you insert the table in the MySQL then it won't spam your log.

 

[Alan Alosh]

Thanks once again.

 

[Devil_Abdo]

i have that problem but when i do that my sqilte database closed bugged

 

[Gertjan300]

Hey sombody still here ?

 

[Limos]

If you need the table for SQLite: https://otland.net/threads/sqlite-error-no-such-table-z_ots_comunication.211503/#post-2027550
If you have an other problem, post that.