[M_A_D]

Originally Posted by Tyegurl

andrewd ... not sure what this is... well i know what it is i just don't understand why.... i moved a folder to another category and ever since i get this error...

Database error in vBulletin 3.5.4:

Invalid SQL:

SELECT * FROM local_linksdownloads
WHERE linkid='510' AND userid='32' AND usertime>'1144511097'
LIMIT 1;

MySQL Error : Lost connection to MySQL server during query
Error Number : 2013
Date : Saturday, April 8th 2006 @ 08:45:45 AM
Script : http://www.teamrespawn.com/vBulletin...d=510&catid=16
Referrer : http://www.teamrespawn.com/vBulletin...N&page=4&pp=10


now the downloaders are telling me they download without a problem....which is what i don't understand. can you possibly shed some light on it?

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:

Database error in vBulletin 3.5.4:

Invalid SQL:

SELECT * FROM local_linksdownloads
WHERE linkid='221' AND userid='136' AND usertime>'1145133833'
LIMIT 1;

MySQL Error : Lost connection to MySQL server during query
Error Number : 2013
Date : Saturday, April 15th 2006 @ 08:58:41 PM
Script : http://world-of-japan.org/forum/loca...d=221&catid=28
Referrer : http://www.world-of-japan.org/forum/...s.php?catid=28
IP Address : 71.139.34.195
Username : edo421
Classname : vb_database

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