Windows mysql queery to sqlite queery

[nugo]

Anyone know how to convert this

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

So that sqlite will accept it?

 

[Ninja]

http://otland.net/f16/08-06-2013-11...r-no-such-table-z_ots_com-191472/#post1849812

 

[nugo]

http://otland.net/f16/08-06-2013-11...r-no-such-table-z_ots_com-191472/#post1849812

Yea thats exactly what im trying to fix that queery still gives the error

 

[Ninja]

Yea thats exactly what im trying to fix that queery still gives the error

The query is working just fine for me, using SQLite Expert.

What error message do you get while executing the query?

 

[nugo]

Im using SQLlite studio, my console is giving the follow error message. OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_com, its a bit longer but that's the jist of it. Even after runing that queery and making a new table i continue to get the error, how ever if im using mysql it does fix it. But i run my server on sqlite

[9/6/2013 23:36:44] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT "z_ots_comunication".* FROM "z_ots_comunication" inner join players on players.name="z_ots_comunication".name where "players"."online"='1'