Home | Community | Message Board


World Seed Supply
Please support our sponsors.

Feedback and Administration >> Website Announcements and Feature Feedback

Welcome to the Shroomery Message Board! You are experiencing a small sample of what the site has to offer. Please login or register to post messages and view our exclusive members-only content. You'll gain access to additional forums, file attachments, board customizations, encrypted private messages, and much more!

Jump to first unread post. Pages: 1
OfflinekronnyQ
SuperstudExtraordinaire
 User Gallery

Registered: 07/23/04
Posts: 2,488
Loc: Anytown USA
Last seen: 7 months, 6 days
Error when searching.
    #3938119 - 03/19/05 12:49 AM (11 years, 11 months ago)

Get this error when I tried to search Grow Logs forum subjects for word 'casing' for the last 4 years.

Code:

Script: /var/www/shroomery/forums/dosearch.php
Line#: 603
SQL Error: Can't find FULLTEXT index matching the column list
SQL Error #: 1191
Query: SELECT B_Number, MATCH (B_Subject) AGAINST ('(casing) ') AS Relevance FROM w3t_Posts WHERE MATCH (B_Subject) AGAINST ('(casing) ' IN BOOLEAN MODE) AND B_Approved = 'yes' AND B_Status <> 'M' AND B_Board IN ('Growlog') AND B_Posted > '1016603300' ORDER BY Relevance DESC LIMIT 1000

Please use your back button to return to the previous page.




Edited by kronnyQ (03/19/05 12:49 AM)


Post Extras: Print Post  Remind Me! Notify Moderator
InvisibleYthanA
٩(●̮•̃)۶
Male

Registered: 08/08/97
Posts: 16,888
Loc: NY/MA/VT Borderlands, USA Flag
Re: Error when searching. [Re: kronnyQ]
    #3938884 - 03/19/05 05:44 AM (11 years, 11 months ago)

Thanks for the bug report, I believe this should be fixed now. Please let me know if you have any additional problems.

Peace,

-Y


Post Extras: Print Post  Remind Me! Notify Moderator
Jump to top. Pages: 1

Feedback and Administration >> Website Announcements and Feature Feedback

Similar ThreadsPosterViewsRepliesLast post
* Search in Subject Bug Cakes 384 3 03/02/08 09:12 PM
by Cakes
* How to Use the New Search Engine AnnoA 2,774 13 07/18/08 09:23 PM
by toastandjam
* "Advanced Search Tips" Updated YthanA 575 3 03/21/08 09:48 PM
by Legend9123
* Search suggestions ricelicker 1,001 14 10/11/04 08:43 PM
by Joshua
* search error Hippie3 583 3 03/15/06 05:32 PM
by Hippie3
* Search function feedback johnm214 353 1 02/14/08 02:00 PM
by Ythan
* Relevance? dumbfounded1600 599 8 03/21/08 06:36 PM
by dumbfounded1600
* SQL Error and invalid response upstream server Opera 710 2 10/23/04 12:58 AM
by Opera

Extra information
You cannot start new topics / You cannot reply to topics
HTML is disabled / BBCode is enabled
Moderator: Ythan, Thor, Seuss, geokills
358 topic views. 0 members, 4 guests and 1 web crawlers are browsing this forum.
[ Toggle Favorite | Print Topic | Stats ]
Search this thread:
Vaposhop
Please support our sponsors.

Copyright 1997-2017 Mind Media. Some rights reserved.

Generated in 0.032 seconds spending 0.005 seconds on 14 queries.