Search Error

I just got this
manwhateg0.jpg
Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 262117 bytes) in /www/forums.penny-arcade.com/public/search.php on line 1669

when I tried to use search. I don't know what it is or what it means but I figured I'd let you dudes know.

Einhander on

Posts

  • Satan.Satan. __BANNED USERS
    edited March 2008
    Einhander wrote: »
    I just got this
    manwhateg0.jpg
    Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 262117 bytes) in /www/forums.penny-arcade.com/public/search.php on line 1669

    when I tried to use search. I don't know what it is or what it means but I figured I'd let you dudes know.
    What search criteria? I can try to reproduce it for shits.

    Satan. on
  • EinhanderEinhander __BANNED USERS
    edited March 2008
    I was searching for an image address, because I knew it was posted in a thread, but I didn't want to go through the thread to see which page and who posted it.

    Originally I thought maybe it was just too long (considering an image address has no spaces), but so far it seems like anything with the term "http://" or "http" gives me the same error.

    Unless it finds a match somewhere. So maybe line 1669 has something to do with the "No matches found" message, I don't know.

    "http://www.google.com" gives the error, while "www.google.com" doesn't, for example.

    But "http://www.penny-arcade.com" does.

    Einhander on
  • Satan.Satan. __BANNED USERS
    edited March 2008
    Well, searching for //cocks didn't get me an error either. You're probably right, the "http://" is kicking something in the grief bone.

    Satan. on
  • EinhanderEinhander __BANNED USERS
    edited March 2008
    Yeah "http://cocks" gives the error.

    edit: Oh man let's put some quotes in there so it's not a link.

    Einhander on
  • Satan.Satan. __BANNED USERS
    edited March 2008
    Everyone jump up and down and hope alpha or Ramius notices us!

    Satan. on
  • EinhanderEinhander __BANNED USERS
    edited March 2008
    Assuming that it is only caused by something related to putting "http://" in your search, it's not really a big deal.

    Einhander on
  • RamiusRamius Joined: July 19, 2000 Administrator, ClubPA admin
    edited March 2008
    indeed, I should probably see if there is a way to add that word to a blocklist. It is way way way way way too common, and because of the shitty way vBulletin does sort ordering of results, they basically need to find every single post that ever had that word in it, construct a query in memory which contains reference to every one of those posts, and then send that query to the database engine to grind away at.

    Luckily you're exceeding memory here at the webserver, before sending to the db server, because I'd not like to see the db chew on that query.

    Ramius on
  • Satan.Satan. __BANNED USERS
    edited March 2008
    Ramius wrote: »
    indeed, I should probably see if there is a way to add that word to a blocklist. It is way way way way way too common, and because of the shitty way vBulletin does sort ordering of results, they basically need to find every single post that ever had that word in it, construct a query in memory which contains reference to every one of those posts, and then send that query to the database engine to grind away at.

    Luckily you're exceeding memory here at the webserver, before sending to the db server, because I'd not like to see the db chew on that query.
    Not a fan of DB Queries Gone Wild, Ramius?

    Satan. on
  • EinhanderEinhander __BANNED USERS
    edited April 2008
    If I'm interpreting your post right, then that makes sense.

    Because yeah it just sorta hit me that probably close to every image or link posted on the entire forum has that sequence in it, so it's no wonder searching for it would bork the system.

    Einhander on
Sign In or Register to comment.