SPY Number of days to keep records:

I have mine set to 1 but i still see there are records that are 6 days old, yes i do have the cron job set correctly and i tried to run the cron manually but still the records are not cleared from spy.
Any idea why.

7.0.6 or 7.0.7 ?

77 new install  06 didn't have this option it used to have number of records in 77 it was chaged to number of days

..?krow siht seod eno yna

siht si ftw

nobody has the spy module installed?..

the code to delete the old posts is in  /modules/boonex/spy/classes/BxSpyDb.php around line 418.

Try to pull the db quary from it and edit it so you can use it directly in phpmyadmin and see what happens.

But no i do not use the spy as its slow and clunky.  I'll install it and test it out to see if i can get it to clear out as it should.

i got it working now. Here's what i did (it worked for me)
uninstall spy module,
open modules/boonex/spy/install/sql  install.sql

    INSERT INTO
        `sys_cron_jobs`
    (`name`, `time`, `class`, `file`)
        VALUES
    ('bx_spy', '1 */12 * * *', 'BxSpyCron', 'modules/boonex/spy/classes/BxSpyCron.php');

changed to

    INSERT INTO
        `sys_cron_jobs`
    (`name`, `time`, `class`, `file`)
        VALUES
    ('bx_spy', '*/30', 'BxSpyCron', 'modules/boonex/spy/classes/BxSpyCron.php');

(i have the cron job set to run twice an hour)

AND THE SPY RECORDS GOT DELETED.