Db query error, i don't undestood PLEASE HELP

[Nubaza]

That's my function globalevent onTImer:

function onTimer()
db.executeQuery('INSERT IGNORE INTO `player_storage` SELECT `id`, 2423, 1 FROM `players` WHERE `online` = 0 ON DUPLICATE KEY UPDATE `value` = 1')
db.executeQuery('INSERT IGNORE INTO `player_storage` SELECT `id`, 2425, 1 FROM `players` WHERE `online` = 0 ON DUPLICATE KEY UPDATE `value` = 0')
local a = getPlayersOnline()
for b = 1, #a do
doCreatureSetStorage(a, 2423, 1)
doCreatureSetStorage(a, 2425, 0)
end
return true
end

I got this error and didn't work anything

[04/01/2014 13:54:00] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: near "IGNORE": syntax error (INSERT IGNORE INTO "player_storage" SELECT "id", 2423, 1 FROM "players" WHERE "online" = 0 ON DUPLICATE KEY UPDATE "value" = 1)
[04/01/2014 13:54:00] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: near "IGNORE": syntax error (INSERT IGNORE INTO "player_storage" SELECT "id", 2425, 1 FROM "players" WHERE "online" = 0 ON DUPLICATE KEY UPDATE "value" = 0)

i'm using 0.36pl1

 

[dominique120]

The syntax of the query in the script is for mysql and you are using sqlite. You must update it to use sqlite, better yet, switch to mysql as it it much better.

 

[Nubaza]

I'm on a beta server
Can u transform it for me? Please man :c
:/
thanks

 

[dominique120]

I'm on a beta server
Can u transform it for me? Please man :c
:/
thanks

Check this tool: http://mysql2sqlite.felipemarques.com.br/

 

[Nubaza]

Umm din't worked
the same error :/

 

[Nubaza]

The Error still