start.lua error (with pics)

[calum69]

this error comes up when starting the server

function onStartup()
	db.executeQuery("UPDATE `players` SET `online` = 0 WHERE `world_id` = " .. getConfigValue('worldId') .. ";")
	return true
end

<globalevent name="serverstart" type="start" event="script" value="start.lua"/>

 

[Fallen]

try and run the query itself in the database if it worked then idk else mysql will say the error and that is it end

 

[calum69]

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'db.executeQuery("UPDATE `players` SET `online` = 0 WHERE `world_id` = " .. getCo' at line 1

 

[Fallen]

omg not like this, like this;
UPDATE `players` SET `online` = 0 WHERE `world_id` = "0"; <- put ur world id

 

[calum69]

SQL query:

< - put ur world id

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<- put ur world id' at line 1


i havent changed the world id

 

[Fallen]

ffs, copy/paste this:
UPDATE `players` SET `online` = 0 WHERE `world_id` = "0";

 

[calum69]

UPDATE `players` SET `online` = 0 WHERE `world_id` = "0"; went through but it still came up the again on running the server like in pic 1

 

[Fallen]

did it give errors_?!_!?_

 

[calum69]

nope tried setting the world id to 1 also, ran fine also started the server, still came up

 

[calum69]

does it matter that much with it not running correctly?

 

[Cykotitan]

add this in your config.lua:

worldId = 0

 

[calum69]

love you cyko xD