Title: deleted=1
Post by: shaun on June 22, 2005, 11:33:27 PM
Post by: shaun on June 22, 2005, 11:33:27 PM
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
a quick count on just my records table today showed over 8 Million rows with deleted=1
Title: Re: deleted=1
Post by: LogicX on June 24, 2005, 03:00:27 PM
Post by: LogicX on June 24, 2005, 03:00:27 PM
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)
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)
Title: Re: deleted=1
Post by: shaun on June 24, 2005, 03:15:55 PM
Post by: shaun on June 24, 2005, 03:15:55 PM
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.
Oh well, guess i'll write up a cron job or somthing that goes through a cleans the db.