Erro to update.... script npc

[stiflerxx]

not getting to see where I went wrong ... the emulator is giving these two error:

 

erro 1:

[SQL]: Erro de banco de dados - Out of range value for column 'timer' at row 1
[Depurar]: em c:\users\usuario\desktop\trabalhos ragnarok\ragna-field\emulador\s
rc\map\script.c:15905 - UPDATE `houses` SET `timer`=`timer`-'1'
erro 2:
[Depurar]: Source (NPC): #controller_house (invisible/not on a map)

 

script:

- script #controller_house -1,{
OnInit:
bindatcmd "house", strnpcinfo(0)+"::OnHouseInfo";
initnpctimer;
end;

OnTimer60000:
query_sql "UPDATE `houses` SET `timer`=`timer`-'1'";
query_sql "SELECT `auto_id`, `name`, `mapname` FROM `houses` WHERE `timer`<='0' AND `status`='1'", .@auto_id, .@name$, .@mapname$;
for( set .@i, 0; .@i < getarraysize(.@auto_id); set .@i, .@i + 1 )
{
query_sql "UPDATE `houses` SET `status`='0', `master_id`='0', `timer`='0', `invitation`='0' WHERE `auto_id`='" + .@auto_id[.@i] + "'";
query_sql "DELETE FROM `houses_members` WHERE `house_id`='" + .@auto_id[.@i] + "'";

announce "A " + .@name$[.@i] + " foi desoculpada.",bc_all,"0x00FF00";
mapwarp .@mapname$[.@i], "prontera", 156, 191;
}
setnpctimer 0;
end;
}

 

 

thank you = D

Edited October 21, 2016 by Emistry
Please use CODEBOX.

[Emistry]

change the data type of your `timer` column ....