can't search for roles

Obsolete, fixed, and incorrect bug requests and problems. Browse here before posting a new topic, to avoid duplicates.
Locked
User avatar
Malaprop
Malaprop
Goon
User avatar
User avatar
Malaprop
Goon
Goon
Posts: 231
Joined: September 30, 2003
Location: Chi-town
Contact:

can't search for roles

Post Post #0 (ISO) » Wed May 19, 2004 2:12 pm

Post by Malaprop »

Anytime a search includes the keywords "role" or "roles", I get SQL errors. The number of keywords and other search options do not seem to have any effect.

Warning: mysql_query(): Unable to save result set in /home/mith/public_html/forum/db/mysql4.php on line 118

Warning: Cannot modify header information - headers already sent by (output started at /home/mith/public_html/forum/db/mysql4.php:118) in /home/mith/public_html/forum/includes/page_header.php on line 502

Warning: Cannot modify header information - headers already sent by (output started at /home/mith/public_html/forum/db/mysql4.php:118) in /home/mith/public_html/forum/includes/page_header.php on line 504

Warning: Cannot modify header information - headers already sent by (output started at /home/mith/public_html/forum/db/mysql4.php:118) in /home/mith/public_html/forum/includes/page_header.php on line 505

[the usual page header with logo and links appears here]

General Error

Could not obtain matched posts list

DEBUG MODE

SQL Error : 1030 Got error 134 from table handler

SELECT m.post_id FROM phpbb_search_wordlist w, phpbb_search_wordmatch m WHERE w.word_text LIKE 'role' AND m.word_id = w.word_id AND w.word_common <> 1

Line : 303
File : /home/mith/public_html/forum/search.php
[size=84]gim sumun.bi shà-thir-ma u ba-rì[/size]
User avatar
jeep
jeep
Cappo Bastone
User avatar
User avatar
jeep
Cappo Bastone
Cappo Bastone
Posts: 747
Joined: April 21, 2002
Location: Portland, OR

Post Post #1 (ISO) » Wed May 19, 2004 3:27 pm

Post by jeep »

Yeah, there is a known problem with a work around. I haven't applied it because I hadn't seen it happen here. It's something our host has installed. It's because the term is too common.

-JEEP
Locked

Return to “Solved Requests”