deleted=1

[shaun]

Is option some where i'm not seeing that will tell nictool to stop setting deleted=1 and to just remove the row from the db?

a quick count on just my records table today showed over 8 Million rows with deleted=1  

[LogicX]

be SURE you did you query correct:

select * from nt_zone_record where deleted='1';
NOT
select * from nt_zone_record where deleted=1;


how I clear it:
okay:
delete from nt_zone_record where deleted='1';
NOT OKAY:
delete from nt_zone_record where deleted=1;

I've deleted my nictool DB atleast twice now by making that mistake. (thankfully I run select * first)

[shaun]

thanks for the replay/info, luckily i always wrap my query statments input with ''.  But i can see why you posted that with my above post  

Oh well, guess i'll write up a cron job or somthing that goes through a cleans the db.