clicks.txt crashing regularly

punkdisasters · Post by **punkdisasters** » Wed Apr 20, 2005 3:06 pm

Hi, I have used ccount a while now, and I think it's great apart from one thing. My clicks.txt file keeps crashing. Don't have any idea why, but it does. I have 87 links in the file.

It usually crashes and corrupts things after a link (between 30 and 40) so the links with id of more than 40 almost never work, but the ones with id 1-30 work all the time. What causes the file to be corrupted?

When you try to access a file with id 40+ after the file has crashed, you just get an error saying the id doesn't exist. Then I have to upload a backup to solve the problem temporarily, cause I know it will happen again.

My links have more than 10000 clicks, but that shouldn't have anything to say, right?

Also, is there any way to track where the links have been clicked from? I suspect people to steal my downloads and putting them on their own sites.

thanks

www.punkdisasters.com

Post by **Klemen** » Thu Apr 21, 2005 9:02 am

Hi,

You probably are a living example of what I am explaining to many people here. Text databases are not safe, fast and powerful enough for high-traffic systems and large databases. Because it uses a text database CCount can't handle 10000+ clicks and the most commont problem is a corrupted database file.

I strongly suggest you stop using CCount and find a MySQL based click tracker and you shouldn't have such problems anymore. CCount is not developed for high-traffic websites.

As far as "stealing downloads", this is called "Hotlinking". Try
http://www.google.com/search?q=.htacces ... prevention
or
http://www.google.com/search?q=hotlink+prevention

Regards

Guest · Post by **Guest** » Thu Apr 21, 2005 1:41 pm

thanks man, but do you have any suggestions for mysql scripts that are somewhat similar to ccount? I've been searching for it for a year and not found anything that is better than ccount. i'm looking for something with stats,and if the script has stats for where the link was clicked too that would be great. i've searched through most big script sites.

Post by **Klemen** » Thu Apr 21, 2005 4:29 pm

Don't really know of any such script, sorry!

Hawk · Post by **Hawk** » Tue Mar 27, 2007 9:02 am

Due to the limitations of a text based database, can Ccount be installed in several places on a site.
I have a lot more files available for download than Ccount can handle and I am wondering if I can overcome the limitation by installing Ccount in different folders so that each install can handle a smaller portion of the files.
Thanks!

Post by **Klemen** » Tue Mar 27, 2007 9:32 am

Possible yes, recommended no. You will just have problems in the future, better to start with a MySQL based script.

Hawk · Post by **Hawk** » Tue Mar 27, 2007 9:37 am

Thank you for your reply Klemen.
Much appreciated.
I really like your script and was hoping I could use it. I'm not having any luck with any MySQL scripts I've found. Probably because I don't know how to work in that environment.

Hawk · Post by **Hawk** » Tue Mar 27, 2007 11:05 am

Just out of curiosity, what type of problems could arise?
If I were to reset the counters once a year, effectively keeping the clicks under 10,000-would that work?

Thanks!

Post by **Klemen** » Tue Mar 27, 2007 12:54 pm

The most common problem is a corrupted (empty) clicks file meaning none of your links work. Keeping the count under 10000 won't help because it's the load that causes the problems, not numbers.

Take my advice and go with a MySQL script, CCount was not written to handle such loads because text databases are just not fast and reliable enough.

Hawk · Post by **Hawk** » Tue Mar 27, 2007 7:43 pm

I see. Thanks!