Site Info Open forum for the discussion of the S2K International site and organization. If you like what we're doing, post it here. If you don't, post it here too. Get answers to site related questions.

Search is broken.

Thread Tools
 
Old Nov 6, 2004 | 12:59 AM
  #1  
Squeezer's Avatar
Thread Starter
Registered User
20 Year Member
 
Joined: Oct 2000
Posts: 2,307
Likes: 1
From: Jackson
Default Search is broken.

if I click on the search link at the top center it takes me to https://www.s2ki.com/forums/index.php?act=Search

and if I search for the word "anything" (just as a test), I get no results. But if I search for "rear axle" I get:

mySQL query error: INSERT INTO ibf_search_results (id,search_date,topic_id,topic_max,sort_key,sort_o rder,member_id,ip_address,post_id,post_max) VALUES ('5b51362b5e2b8ea91af12f3670a504de','1099735124',' 240992,240194,241134,241203,241229,241207,238603,2 41452,241472,240400,241735,241488,241870,241943,24 0133,241732,241376,240630,241920,232071,242109,242 273,240650,241840,230707,242013,242164,242629,2413 72,242879,243389,243554,242616,243549,243534,24372 6,243576,243627,243608,243507,243873,243823,244017 ,244032,243997,239178,99995,244402,244426,244061,2 43455,244599,244431,244620,244731,244423,244048,24 4870,244002,243905,244287,244871,245336,242758,245 304,245569,245508,245501,245137,245451,245757,2458 81,243361,245915,245371,225993,245990,245885,24620 1,246108,244406,48572,246254,246390,241031,246725, 246774,227808,246761,246777,242205,245186,244638,2 47223,246899,246500,247408,246954,247457,247418,24 6185,247416,247128,247583,247585,247620,247314,247 639,118889,245752','110','last_post','desc','26',' 68.209.223.242','4550422,4550442,4550552,4550562,4 550577,4550643,4550708,4550872,4550981,4551014,455 1149,4551154,4551156,4551224,4551352,4551376,45515 27,4551567,4551656,4551928,4552120,4552153,4552246 ,4552263,4552400,4552499,4552575,4552577,4552615,4 552657,4552704,4552721,4552791,4552844,4552897,455 2979,4552993,4553011,4553148,4553161,4553189,45531 92,4553213,4553247,4553292,4553299,4553316,4553339 ,4553340,4553367,4553389,4553418,4553431,4553512,4 553531,4553638,4553888,4553911,4553984,4554052,455 4078,4554080,4554090,4554249,4554277,4554283,45543 22,4554324,4554334,4554342,4554367,4554393,4554399 ,4554408,4554545,4554596,4554605,4554693,4554740,4 554836,4554913,4554977,4555023,4555043,4555093,455 5274,4555283,4555329,4555350,4555352,4555456,45557 06,4555814,4555875,4555997,4556026,4556045,4556047 ,4556099,4556114','100')

mySQL error:
mySQL error code: 0
Date: Saturday 06th of November 2004 01:58:44 AM

and I tried it with other words...apparently it doesn't like having a space between the words?
Reply
Old Nov 6, 2004 | 01:02 AM
  #2  
yogi's Avatar
Registered User
Gold Member (Premium)
20 Year Member
 
Joined: Oct 2000
Posts: 2,108
Likes: 0
From: Seattle, WA
Default

I just did it and it ran fine

https://www.s2ki.com/forums/index.php?act=S...%22rear+axle%22

This topic was first on the list . Let me know if you're still getting this.
Reply
Old Nov 6, 2004 | 01:11 AM
  #3  
Squeezer's Avatar
Thread Starter
Registered User
20 Year Member
 
Joined: Oct 2000
Posts: 2,307
Likes: 1
From: Jackson
Default

take out the " " around rear axle when you do the search and you get the error
Reply
Old Nov 6, 2004 | 01:13 AM
  #4  
Squeezer's Avatar
Thread Starter
Registered User
20 Year Member
 
Joined: Oct 2000
Posts: 2,307
Likes: 1
From: Jackson
Default

this is a screenshot of the error: http://www.squeezer.net/s2ki.com/searcherror.png
Reply
Old Nov 6, 2004 | 01:57 AM
  #5  
yogi's Avatar
Registered User
Gold Member (Premium)
20 Year Member
 
Joined: Oct 2000
Posts: 2,108
Likes: 0
From: Seattle, WA
Default

Don't need a screenshot - I believe you Looking into it, but don't count on a fix until tomorrow...sorry. Thanks for letting us know.
Reply
Old Nov 6, 2004 | 02:01 AM
  #6  
Squeezer's Avatar
Thread Starter
Registered User
20 Year Member
 
Joined: Oct 2000
Posts: 2,307
Likes: 1
From: Jackson
Default

ok thanks, i'm in no rush, just wanted to make someone higher up aware that there is a problem. thanks
Reply
Old Nov 6, 2004 | 02:43 AM
  #7  
yogi's Avatar
Registered User
Gold Member (Premium)
20 Year Member
 
Joined: Oct 2000
Posts: 2,108
Likes: 0
From: Seattle, WA
Default

Cthree,

For some reason search is using search_mysql_man, not ftextslave - eh? I left it as is cause I'm not sure why that change was made. Weasel takes forever and a half doing these kind of queries (I took out most of the forum id's):

SELECT p.pid
FROM ibf_posts p
WHERE p.post_date >1097149268 AND p.forum_id
IN ( 3, 78, 79, 81, 86.....121, 126 ) AND p.queued <>1 AND
MATCH (
post
)
AGAINST (
'keywords more keywords'
IN BOOLEAN
MODE
)
LIMIT 100

I'm too sleepy to think straight, hopefully you see this when you get up in a few hours
Reply
Old Nov 6, 2004 | 05:23 PM
  #8  
HydnHood's Avatar
Registered User
 
Joined: Aug 2004
Posts: 627
Likes: 0
From: Green Bay WI
Default

The site search has been a thorn in the side for s2ki.com ever since I first found it.

On a good note, I do computer consultant work for $85 an hour. I will work for S2K parts
Reply
Old Nov 6, 2004 | 07:25 PM
  #9  
cthree's Avatar
Administrator
20 Year Member
 
Joined: Oct 2000
Posts: 20,274
Likes: 4
From: Toronto, Canada
Default

Does that mean you're going to charge us for reaffirming it doesn't work?
Reply
Old Nov 6, 2004 | 08:44 PM
  #10  
HydnHood's Avatar
Registered User
 
Joined: Aug 2004
Posts: 627
Likes: 0
From: Green Bay WI
Default

Originally Posted by cthree,Nov 6 2004, 11:25 PM
Does that mean you're going to charge us for reaffirming it doesn't work?
Yeah....I am sure it would only cost a set of tires and rims for that diagnosis.
Reply



All times are GMT -8. The time now is 03:04 AM.