[AndrewD]

Originally Posted by M_A_D

I am also getting that error message in my mail quite frequently. Seems that it is affecting hit recording.
I checked it out today and after i downloaded 4 files it showed that i made 2 hits. Then i checked my mail and i had two of those error mails with my username...

EDIT:
I just got another mail:

I then checked in the DB and the query above would return nothing because in the table local_linksdownloads there is no entry with linkid=221 and userid=136

This SQL squery is a check to see if the same user has made a hit on the same entry within the last few seconds. It's made to prevent double counting if, for example, the user 'double clicks' the url. So most of the time it should not return anything. I will need to investigate why it is generating database errors. However, you should be able to disable the message (and check) by setting the admin value timeout_hit_recording to zero.

Originally Posted by M_A_D

I'm also having another problem. I have restricted the daily download for registered users to a maximum of 5 files yet i can see people having accessed more than 5 files in the last 24 hrs...
For example there is a user who has had 6 hits in the last 24 hrs. All of those 6 hits happend within a 10 minute time frame.

Are all your entries 'downloads' (in the sense that LDM uses - i.e. they have filetypes that appear in the VB attachments table) or are there also some entries which have filetypes that are not in the mimetypes table?

Assuming everything is working ok, LDM *only* places daily limits on the first group, not on the second.

There is a second possibility, since you mention that the hits are in quick succession. Each 'hit' is only recorded when it completes, consequently if a user starts multiple downloads in quick succession, then she may be able to bypass the daily limits. If necessary, we might be able to find ways to prevent that occurring.

Please confirm - I will check the code in more detail if necessary.