Solved [08/06/2013 11:00:22] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_com

[Imfreezing]

Hello Ot land, As the title says my console constantly gets this error

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

i think its something about website,i dont use website, i dont want to use website,how do i fix this? rep++++ if help
Kind regards Cheeze

 

[Limos]

CREATE TABLE "z_ots_comunication" (
   "id" INTEGER PRIMARY KEY NOT NULL,
   "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" INTEGER(2) NOT NULL DEFAULT '1'
)

 

[Imfreezing]

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;

what shoud i do with that Im nooooob

 

[Ninja]

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;

That's for MySQL,

CREATE TABLE `z_ots_comunication` (
`id` INTEGER(11) NOT NULL,
`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` INTEGER(2) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
)

Follow Evan's tutorial on how you can access and modify SQLite databases.
http://otland.net/f479/sqlite-accessing-modifying-database-189738/

 

[Limos]

Ye, my mistake, edited my post.

@Imfreezing
Go to your database, then click Execute SQL, remove what's there and paste the query, then click run sql or execute query or something like that, depense on what you use.

 

[Imfreezing]

@Limos Hey, You mean Execute By file,Becouse when i press that its come a browser,well can u explain where "execute sql" are? please?
rep+++

 

[Limos]

Which SQLite program do you use?

 

[Imfreezing]

SQLiteStudio 2.1.4

- - - Updated - - -

Please help! it crashed my serrver

- - - Updated - - -

i cant Select a s3db FIle in SQLite MANGAGER
PLease hlep

- - - Updated - - -

NVm worked now!! Thanks To everyone, rep

- - - Updated - - -

NVm worked now!! Thanks To everyone, rep