When i join my own ot it crashes (8.60)

Senzation96

Hoster - Scripter
Joined
Jul 17, 2008
Messages
90
Best answers
0
Reaction score
5
Location
Sweden
TFS ERRORS
[17:47:50.633] [Error - GlobalEvent Interface]
[17:47:50.635] data/globalevents/scripts/start.lua:eek:nStartup
[17:47:50.636] Description:
[17:47:50.637] data/globalevents/scripts/start.lua:2: attempt to call field 'executeQuery' (a nil value)
[17:47:50.641] stack traceback:
[17:47:50.642] data/globalevents/scripts/start.lua:2: in function <data/globalevents/scripts/start.lua:1>

Tibia Crash report
3527735278
 

Mister Budex

BudexOT.com
Joined
Jun 22, 2016
Messages
1,165
Best answers
18
Reaction score
201
send here start.lua script, and please tell what TFS you are using.
 
OP
Senzation96

Senzation96

Hoster - Scripter
Joined
Jul 17, 2008
Messages
90
Best answers
0
Reaction score
5
Location
Sweden
function onStartup()
db.executeQuery("UPDATE players SET online = 0 WHERE world_id = " .. getConfigValue('worldId') .. ";")
return true
end
 
OP
Senzation96

Senzation96

Hoster - Scripter
Joined
Jul 17, 2008
Messages
90
Best answers
0
Reaction score
5
Location
Sweden
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'
);
 

Mister Budex

BudexOT.com
Joined
Jun 22, 2016
Messages
1,165
Best answers
18
Reaction score
201
How can i fix this..? *Sorry for being retarded
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'
);
 
OP
Senzation96

Senzation96

Hoster - Scripter
Joined
Jul 17, 2008
Messages
90
Best answers
0
Reaction score
5
Location
Sweden
18:3:00.164] sqlite3_step(): SQLITE ERROR: database is locked
[18:3:00.165] > Houses synchronization time: 0.359 seconds.
[18:3:00.168] > Content unserialization time: 0.001 seconds.
[18:3:00.169] >> Checking world type... Open PvP
[18:3:00.171] >> Initializing game state and binding services...

[18:3:00.186] [Error - GlobalEvent Interface]
[18:3:00.187] data/globalevents/scripts/start.lua:eek:nStartup
[18:3:00.189] Description:
[18:3:00.190] data/globalevents/scripts/start.lua:2: attempt to call field 'executeQuery' (a nil value)
[18:3:00.193] stack traceback:
[18:3:00.194] data/globalevents/scripts/start.lua:2: in function <data/globalevents/scripts/start.lua:1>
 
OP
Senzation96

Senzation96

Hoster - Scripter
Joined
Jul 17, 2008
Messages
90
Best answers
0
Reaction score
5
Location
Sweden
i've added that to the database that's what started the crashing
 
OP
Senzation96

Senzation96

Hoster - Scripter
Joined
Jul 17, 2008
Messages
90
Best answers
0
Reaction score
5
Location
Sweden
SQLITE ERROR: database is locked

This might be the issue?

sqlite3_step(): SQLITE ERROR: database is locked
[18:46:07.598] > Houses synchronization time: 0.13 seconds.
[18:46:07.601] > Content unserialization time: 0.001 seconds.
[18:46:07.603] >> Checking world type... Open PvP
[18:46:07.606] >> Initializing game state and binding services...

Edit Fixed by not using SQLDATABASE AT THE SAME TIME!

did not resolve the issue of crashing though..
 
OP
Senzation96

Senzation96

Hoster - Scripter
Joined
Jul 17, 2008
Messages
90
Best answers
0
Reaction score
5
Location
Sweden
Solved with using a fresh copy of original database.
Jokes on me not solved.
 
Top