×
  • remind me tomorrow
  • remind me next week
  • never remind me
Subscribe to the ANN Newsletter • Wake up every Sunday to a curated list of ANN's most interesting posts of the week. read more

Forum - View topic
forum search busted?




Anime News Network Forum Index -> Site-related -> Bugs & Technical Questions
View previous topic :: View next topic  
Author Message
patch



Joined: 25 Mar 2005
Posts: 677
Location: New York, NY
PostPosted: Thu Mar 30, 2006 3:15 pm Reply with quote
Get the following error trying to do a search on text and by username:

Quote:

Could not obtain matched posts list

DEBUG MODE

SELECT m.post_id FROM phpbb_en.search_wordlist w, phpbb_en.search_wordmatch m WHERE w.word_text LIKE 'bleach' AND m.word_id = w.word_id AND w.word_common <> 1

Line : 313
File : /usr/domains/animenewsnetwork.com/htdocs/bbs/phpBB2/search.php
Back to top
View user's profile Send private message
patch



Joined: 25 Mar 2005
Posts: 677
Location: New York, NY
PostPosted: Wed Apr 05, 2006 12:14 pm Reply with quote
Still busted if anyone cares? Laughing
Back to top
View user's profile Send private message
Tempest
I Run this place.
ANN Publisher


Joined: 29 Dec 2001
Posts: 10425
Location: Do not message me for support.
PostPosted: Wed Apr 05, 2006 2:04 pm Reply with quote
hmmm, it's just the word "Bleach" that it doesn't like.

That's ODD!
Back to top
View user's profile Send private message Send e-mail My Anime My Manga
patch



Joined: 25 Mar 2005
Posts: 677
Location: New York, NY
PostPosted: Wed Apr 05, 2006 4:17 pm Reply with quote
tempest wrote:
hmmm, it's just the word "Bleach" that it doesn't like.

That's ODD!


Very much so Smile

Don't know anything about PHPBB's data model/app design, but is it possible that there might be a NULL post_id (deleted post?) in the search_wordmatch table that's coming back from the query and somehow not being handled in the code?
Back to top
View user's profile Send private message
Dan42
Chief Encyclopedist


Joined: 02 Jan 2002
Posts: 3783
Location: Montreal
PostPosted: Thu Apr 06, 2006 5:04 am Reply with quote
Wow, that was really... interesting. It turns out that the search_wordmatch table was corrupted so it was spitting out errors, but *only* for the few corrupted rows. Rolling Eyes
Back to top
View user's profile Send private message Visit poster's website AIM Address My Anime My Manga
patch



Joined: 25 Mar 2005
Posts: 677
Location: New York, NY
PostPosted: Thu Apr 06, 2006 9:55 am Reply with quote
Yeah very strange, never seen anything like that before myself with a relational DB (we Sybase/MS SQL server at work)

Good to see you got the issue resolved though, thanks guys Smile
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic    Anime News Network Forum Index -> Site-related -> Bugs & Technical Questions All times are GMT - 5 Hours
Page 1 of 1

 


Powered by phpBB © 2001, 2005 phpBB Group