my Links_ClickTrack table grows and grows, ending up buggin down mysql.



what is it ? and how do I make it stop growing ?

thanks Dane

It all depends if you want to track your links clicks. Basically, I beleive all the data from users who have made the clicks, is stored here (IP address, ISP, browser etc)...

Not definate though You should be safe to delete all the contents of it, although I believe it gets deleted on its own anyway, after x number of days.

Cheers

Andy (mod)
andy@ultranerds.co.uk

---

Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!

is there no way to make linksql stop adding data ? or do I have to empty it manually ..

This very topic has been discussed before in this forum, please search for Click Track.
========================================
Buh Bye!

Cheers,
Me

nothing relevant showed up searching for Click Track

Really? Search again in this forum (the exact same issue was covered about a month ago!). Using ClickTrack or even DELETE FROM Links_ClickTrack.

Best of luck!
========================================
Buh Bye!

Cheers,
Me

Hi,

I don't know what version of Links SQL you're using, but for later versions (I use 2.1.1) if you look in Build.pm you'll find the following:

$SUBS{build_reset_hits} = <<'END_OF_SUB';

sub build_reset_hits {

------------------------------------------------------------------

Remove old hit and rate tracking information.



Links::init_date();

my $delete_by = GT::Date::date_get ( time() - 172800 ); # 2 days old

my $click_db = $DB->table ('ClickTrack');

$click_db->delete ( GT::SQL::Condition->new ( 'Created', '<', $delete_by ));

}

END_OF_SUB

That automatically deletes records from ClickTrack that are more than 2 days old I think. I like to keep my data for a month and then export it to my own database, and manually empty it, so I comment out this code.

I don't know if this code could be added to Build.pm or nph-build.cgi for older versions of Links SQL.

-Rover

I think you meant to reply to dane, not me. Please try to reply to the correct person within the thread. Thank you.
========================================
Buh Bye!

Cheers,
Me

When I build process occurs, it will update the number of hits in the main database and reset the clicktrack table. If you do a build it should be okay.



I think.