Search still goofy?
For the last couple days I've tried to search for a previous thread that I'd posted to. I don't see it in the Active threads (which of course can simply mean no one else posted to it and it buried itself). However, I *thought* I posted to it. Soooo, I figured I could just perform a Search and use a keyword I know I'd typed (in this case I've tried separately "Sport" and "Distinto") along with poster "w1ngman" and selected "in the last 30 days." And I get...bubcuss....nada
. So I figured I'd widen things a bit...no keyword, just "w1ngman" as poster in last 30 days. That has (in the past) proven to show me all my recent threads I'd posted to. Now?...it gives me 3 threads in the last couple days...but its also definitely *not* including all the threads I've posted to in the last week.
Soooo, it begs the question: Is search still goofy?
. So I figured I'd widen things a bit...no keyword, just "w1ngman" as poster in last 30 days. That has (in the past) proven to show me all my recent threads I'd posted to. Now?...it gives me 3 threads in the last couple days...but its also definitely *not* including all the threads I've posted to in the last week.Soooo, it begs the question: Is search still goofy?
This was reported the other day too
cthree is aware of it - it seems not to be adding all posts to the search database or something.
Try this method and see if you can find it:
https://www.s2ki.com/forums/index.php?act=S...sult_type=posts
cthree is aware of it - it seems not to be adding all posts to the search database or something.Try this method and see if you can find it:
https://www.s2ki.com/forums/index.php?act=S...sult_type=posts
Search is always goofy. It works better at some times than others. Search is performed from a copy of the main database located on an entirely separate server. Searching really bogs down the database so running them both on the same sever killed the site. On a separate server it will only kill other searches but not the site as a whole.
The link which keeps both the master and slave databases in sync and up to date is a bit fragile. There is some amount of fault tolerance but if the link is broken for any extended period of time then it's toast. I may need to rebuild the search copy from scratch which is an ugly and time consuming task I don't look forward to. It could take a whole day to do.
The link which keeps both the master and slave databases in sync and up to date is a bit fragile. There is some amount of fault tolerance but if the link is broken for any extended period of time then it's toast. I may need to rebuild the search copy from scratch which is an ugly and time consuming task I don't look forward to. It could take a whole day to do.
Not sure if it's related or not, but I have been experiencing A LOT of issues with the search functionality.
I get the following error:
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 ('0d60e5d291bebab83ff72a3712e743e4','1107834738',' 258990,261191,261687,262104,262149,257980','6','la st_post','desc','11004','67.171.29.249','4901385,4 901448,4901489,4901492,4901593,4901633,4901900,490 1923,4901966,4901978,4902127,4902282,4902292,49023 02,4902313,4902381,4902629,4902838,4903021,4903165 ,4903294,4903313,4903318,4903350,4903703,4903818,4 903923,4904319,4904337,4904450,4904574,4904622,490 4840,4904861,4904905,4906116,4905091,4905225,49053 76,4905422,4905455,4905514,4905620,4905664,4905749 ,4905842,4906094,4906118,4906123,4906140,4906220,4 906326,4906378,4906431,4906519,4906531,4906634,490 6668,4906779,4906904,4906977,4907002,4907010,49071 86,4907270,4907272,4907336,4907352,4907362,4907436 ,4907454,4907560,4907562,4907604,4907607,4908071,4 908239,4908350,4908403,4908410,4908458,4908528,490 8547,4908905,4909134,4909168,4909170,4909200,49092 56,4909401,4909481,4909806,4909868,4909874,4909938 ,4910246,4910280,4910407,4910422,4910514','100')
mySQL error:
mySQL error code: 0
I get the following error:
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 ('0d60e5d291bebab83ff72a3712e743e4','1107834738',' 258990,261191,261687,262104,262149,257980','6','la st_post','desc','11004','67.171.29.249','4901385,4 901448,4901489,4901492,4901593,4901633,4901900,490 1923,4901966,4901978,4902127,4902282,4902292,49023 02,4902313,4902381,4902629,4902838,4903021,4903165 ,4903294,4903313,4903318,4903350,4903703,4903818,4 903923,4904319,4904337,4904450,4904574,4904622,490 4840,4904861,4904905,4906116,4905091,4905225,49053 76,4905422,4905455,4905514,4905620,4905664,4905749 ,4905842,4906094,4906118,4906123,4906140,4906220,4 906326,4906378,4906431,4906519,4906531,4906634,490 6668,4906779,4906904,4906977,4907002,4907010,49071 86,4907270,4907272,4907336,4907352,4907362,4907436 ,4907454,4907560,4907562,4907604,4907607,4908071,4 908239,4908350,4908403,4908410,4908458,4908528,490 8547,4908905,4909134,4909168,4909170,4909200,49092 56,4909401,4909481,4909806,4909868,4909874,4909938 ,4910246,4910280,4910407,4910422,4910514','100')
mySQL error:
mySQL error code: 0
Originally Posted by JawKnee' date='Feb 7 2005, 10:46 PM
Not sure if it's related or not, but I have been experiencing A LOT of issues with the search functionality.
I get the following error:
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 ('0d60e5d291bebab83ff72a3712e743e4','1107834738',' 258990,261191,261687,262104,262149,257980','6','la st_post','desc','11004','67.171.29.249','4901385,4 901448,4901489,4901492,4901593,4901633,4901900,490 1923,4901966,4901978,4902127,4902282,4902292,49023 02,4902313,4902381,4902629,4902838,4903021,4903165 ,4903294,4903313,4903318,4903350,4903703,4903818,4 903923,4904319,4904337,4904450,4904574,4904622,490 4840,4904861,4904905,4906116,4905091,4905225,49053 76,4905422,4905455,4905514,4905620,4905664,4905749 ,4905842,4906094,4906118,4906123,4906140,4906220,4 906326,4906378,4906431,4906519,4906531,4906634,490 6668,4906779,4906904,4906977,4907002,4907010,49071 86,4907270,4907272,4907336,4907352,4907362,4907436 ,4907454,4907560,4907562,4907604,4907607,4908071,4 908239,4908350,4908403,4908410,4908458,4908528,490 8547,4908905,4909134,4909168,4909170,4909200,49092 56,4909401,4909481,4909806,4909868,4909874,4909938 ,4910246,4910280,4910407,4910422,4910514','100')
mySQL error:
mySQL error code: 0
I get the following error:
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 ('0d60e5d291bebab83ff72a3712e743e4','1107834738',' 258990,261191,261687,262104,262149,257980','6','la st_post','desc','11004','67.171.29.249','4901385,4 901448,4901489,4901492,4901593,4901633,4901900,490 1923,4901966,4901978,4902127,4902282,4902292,49023 02,4902313,4902381,4902629,4902838,4903021,4903165 ,4903294,4903313,4903318,4903350,4903703,4903818,4 903923,4904319,4904337,4904450,4904574,4904622,490 4840,4904861,4904905,4906116,4905091,4905225,49053 76,4905422,4905455,4905514,4905620,4905664,4905749 ,4905842,4906094,4906118,4906123,4906140,4906220,4 906326,4906378,4906431,4906519,4906531,4906634,490 6668,4906779,4906904,4906977,4907002,4907010,49071 86,4907270,4907272,4907336,4907352,4907362,4907436 ,4907454,4907560,4907562,4907604,4907607,4908071,4 908239,4908350,4908403,4908410,4908458,4908528,490 8547,4908905,4909134,4909168,4909170,4909200,49092 56,4909401,4909481,4909806,4909868,4909874,4909938 ,4910246,4910280,4910407,4910422,4910514','100')
mySQL error:
mySQL error code: 0
Originally Posted by cthree' date='Feb 7 2005, 11:13 PM
That may be a transient database error. They happen from time to time. Is this still a problem? What were you searching for?
I've been usually searching by keyword of "deal", "invoice", "2005 invoice" or "good deal" with everything else default most of the times.
In fact, prior to posting this, I got the issue again.
Trending Topics
Originally Posted by JawKnee' date='Feb 8 2005, 10:37 PM
ARGH, sorry to vent my frustration, but I haven't completed a darn search forever and it's really bothering me!!! Anything being done to rectify this?
"site: s2ki.com xx xx"
xx = search terms
That works a WHOLE lot better then trying to use the search tool.








