Search Error

Einhander

I just got this

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.

Satan.

Einhander wrote: »

I just got this

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.

Einhander

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.

Satan.

Well, searching for //cocks didn't get me an error either. You're probably right, the "http://" is kicking something in the grief bone.

Einhander

Yeah "http://cocks" gives the error.

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

Satan.

Everyone jump up and down and hope alpha or Ramius notices us!

Einhander

Assuming that it is only caused by something related to putting "http://" in your search, it's not really a big deal.

Ramius

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.

Satan.

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?

Einhander

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.