Solved SQL Lite Error

Damon · Feb 27, 2015

I have encountered this strange SQL Lite Error, does anyone know how to fix it?
I will be using mysql once I publish the server but I want to fix this error aswell

I believe I have to add something in SQL Studio Lite, that's atleast what @HalfAway tried last time

Code:

[27/02/2015 21:44:56] The Forgotten Server - Edited By Cyko V8, version 0.3.6 - Edited By Cyko V8 (Crying Damson - Edited By Cyko V8)
[27/02/2015 21:44:56] Compiled with GNU C++ version 3.4.5 (mingw special) at Apr  6 2013, 11:07:44.
[27/02/2015 21:44:56] A server developed by Elf, slawkens, Talaturen, KaczooH, Lithium, Kiper, Kornholijo.
[27/02/2015 21:44:56] Visit our forum for updates, support and resources: http://otland.net.

[27/02/2015 21:45:24] Damon has logged in.
[27/02/2015 21:45:28] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)
[27/02/2015 21:45:58] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetime6 (UPDATE "players" SET "onlinetime7"=players.onlinetime6, "onlinetime6"=players.onlinetime5, "onlinetime5"=players.onlinetime4, "onlinetime4"=players.onlinetime3, "onlinetime3"=players.onlinetime2, "onlinetime2"=players.onlinetime1, "onlinetime1"=players.onlinetimetoday, "onlinetimetoday"=0;)
[27/02/2015 21:45:58] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.exphist6 (UPDATE "players" SET "exphist7"=players.exphist6, "exphist6"=players.exphist5, "exphist5"=players.exphist4, "exphist4"=players.exphist3, "exphist3"=players.exphist2, "exphist2"=players.exphist1, "exphist1"=players.experience-players.exphist_lastexp, "exphist_lastexp"=players.experience;)
[27/02/2015 21:45:58] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimetoday (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1;)
[27/02/2015 21:45:59] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)
[27/02/2015 21:46:30] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)
[27/02/2015 21:46:59] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimetoday (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1;)
[27/02/2015 21:47:01] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)
[27/02/2015 21:47:32] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)
[27/02/2015 21:48:00] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimetoday (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1;)
[27/02/2015 21:48:03] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)
[27/02/2015 21:48:34] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)
[27/02/2015 21:49:01] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimetoday (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1;)
[27/02/2015 21:49:05] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)
[27/02/2015 21:49:36] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)
[27/02/2015 21:50:02] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimetoday (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1;)
[27/02/2015 21:50:07] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)
[27/02/2015 21:50:38] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)
[27/02/2015 21:51:03] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimetoday (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1;)
[27/02/2015 21:51:09] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)
[27/02/2015 21:51:40] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)
[27/02/2015 21:52:04] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimetoday (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1;)
[27/02/2015 21:52:11] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)

Kind regards,
Damon

O.o o.O · Feb 27, 2015

isn't this the same ?
http://otland.net/threads/z_ots_comunication.216200/
http://otland.net/threads/sqlite-error-no-such-table-z_ots_comunication.211503/

Damon · Feb 27, 2015

Nice I will look into this thanks

Edit:
Solved the ots communication now but still getting this error, but found smth on otland, so will try this first

[27/02/2015 22:24:52] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimetoday (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1

O.o o.O · Feb 27, 2015

idk. if this the same xD
http://otland.net/threads/mysql_rea...players-onlinetimetoday-60.76441/#post-784100
http://otland.net/threads/sqlit3-problem.119686/#post-1172930

Damon · Feb 27, 2015

Tried this:
http://otland.net/threads/this-thing-appeared-recently.215815/
and i am still getting this error:

Code:

[27/02/2015 22:35:50] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimetoday (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1;)

Edit
Both your links didnt help

@O.o o.O

Limos · Feb 28, 2015

Code:

ALTER TABLE "players" ADD "onlinetimetoday" INTEGER NOT NULL DEFAULT 0

If you use SQLite, look for queries for SQLite or change the MySQL ones using the sqlite schema as example.

Damon · Feb 28, 2015

Limos said:
Code:

ALTER TABLE "players" ADD "onlinetimetoday" INTEGER NOT NULL DEFAULT 0

If you use SQLite, look for queries for SQLite or change the MySQL ones using the sqlite schema as example.

I have acctually gotten rid of this error by removing a globalevent I saw no need for and now the error doesnt appear anymore

But I will still try to add the queries

@Limos Btw. was the option to edit threadname/mark it as solved removed? I can't find it anymore

Limos · Feb 28, 2015

At the top of the thread you can click Thread Tools, then click Edit Thread and there you can change the prefix.

Damon · Feb 28, 2015

Limos said:
At the top of the thread you can click Thread Tools, then click Edit Thread and there you can change the prefix.

Awesome! Thanks a ton! I just remembered from "old" otland that you could go in "advanced" editing mode and then simply change it, but its easier that way acctually

Damon · Feb 28, 2015

@Limos Im having the same error in mysql now. what to add here as a query to solve this for mysql?

Tarek1337 · Feb 28, 2015

What kind of error ? I maybe know the problem! :S

Damon · Feb 28, 2015

Tarek1337 said:
What kind of error ? I maybe know the problem! :S

Well litterly the exact same errors as above(in first post) just with "mysql" instead of "sqlite"

Maffiaa · Mar 24, 2020

otsys_sqlite3_prepare sqllite error select from z_ots_comunication where type login i have this error in tfs

Addams · Mar 24, 2020

Insert this to your database

SQL:

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'
)

Maffiaa · Mar 24, 2020

M0ustafa said:

Insert this to your database

SQL:

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'
)

otsys_sqlite3_prepare sqllite error select from z_ots_comunication where type login what i do bro?

Solved SQL Lite Error

Damon

Check my status to contact me :)

O.o o.O

Member

Damon

Check my status to contact me :)

O.o o.O

Member

Damon

Check my status to contact me :)

Limos

★

Damon

Check my status to contact me :)

Limos

★

Damon

Check my status to contact me :)

Damon

Check my status to contact me :)

Tarek1337

Legendary OT User

Damon

Check my status to contact me :)

Maffiaa

New Member

Addams

OTMadness.com OTSes Services

Maffiaa

New Member