Seems to work without any issues! Thank you very much...should be added to the FAQ :)

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...


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.


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

thanks alot!

i am still getting them too....

what is the file size limit...try to alter that?

btw the jukebox you have works much better than the vJukebox....not as many problems with uploading and playing the files ;) tyvm

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.

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.

Please let me know which versions of php and mysql/mysqli you are using

Thanks, i will try changing that value.


Yes, all my downloads are .zip files, so it seems the second possibility is correct. But i guess i can live with that.


Oh, and if it helps, i am using php 4.4.2 and mysql 5.0.15

(what vbulletin says i use lol)
PHP 4.3.11
MySQL Version 4.0.24-max-log

and my timeout was set to 0
yet i still get the emails but it downloads the file just fine.