Return to Site Support



Search Issue

Trouble using the site, post your question here.

Post - 1/10/2012

Use, and like, this site enough to make an account when i'm having an issue rather than get my sprays elsewhere (that makes me sound uppity, not my intention).

Anyway. When i attempt to do a search for sprays, after i type in the search keywords and hit enter, a blank page comes up with the text "Error: Duplicate entry '16777215' for key 1". I first encountered this a while ago but passed it off as a temporary issue caused by site maintenance or something of the sort. But several days later i'm still getting this error when i attempt to do a spray search.

I have tried the search in a number of different browsers, all producing the same error. About a week ago i was having no issues at all doing spray searches.

I attempted to do a search on the forums for a topic related to this issue, but searching the terms 'duplicate', 'entry' and '16777215' turn up no results. If this is an issue that has already been discussed i apologize.
Image
User avatar
 
Posts: 1
Joined: 1/10/12

Post - 1/15/2012

I've been having the same issue.

Also, I can't register on the site without getting the message:

"Please do not hammer this site!
You must wait three seconds before trying again.

If you believe this is in error, please mail the webmaster about it!
<info@gamesprays.com>"
User avatar
 
Posts: 1
Joined: 1/15/12

Post - 1/16/2012

I fixed search. I have the site log keyword searches although I've never used them for anything. We hit 16,777,215 searches, the maximum value for a mediumint. I just emptied the database keyword table. I figured one day I'd write a script to display top searches or something but haven't, so mind as well empty the table.

I also disabled the anti-hammer until I can find the time to properly tweak it.
Image
User avatar
 
Says: Don't say it, Spray it!
Posts: 729
Joined: 7/19/09


Return to Site Support

Who is online

Users browsing this forum: No registered users and 0 guests

cron