Jump to content




Welcome to CreditBoards!


Sign In 

Create Account
Welcome to CreditBoards! Like most online communities, you must register to post in our community, but don't worry - this is a simple process requiring minimal information for you to sign up. Be a part of CreditBoards by signing in or creating an account.
  • Start new topics and reply to others
  • Subscribe to topics to get email updates
  • Get your own profile page and make new friends
  • Send personal messages to other members.
 
Guest Message by DevFuse

Read These Items!

  • If you're getting an Authentication mismatch error: Clear your cache. Log out of CB. Delete your cookie. Close your browser. Open your browser and log back in.

Photo

Search Tips for the new board


  • This topic is locked This topic is locked
24 replies to this topic

#1 Pam

Pam

    Site Owner

  • Admin
  • 12,083 posts

Posted 31 December 2004 - 10:24 PM

:clapping: :yahoo: :blush: :good: :stop: :lol: :P


Use  Means
apple banana  Find posts that contain at least one of these words
+apple +juice  Find posts with both words
+apple -juice  Find posts with 'apple' but not 'juice'
apple*  Find posts with 'apple' and/or 'applesauce'
"Some Words"  Find posts with the phrase 'some words of wisdom', 'some words' but not 'some noise words'


Add your tips here, and in a couple of weeks I'll compile them into one post with search tips.

Thanks!

Pam



#2 chrisndelray

chrisndelray
  • Members
  • 2,268 posts

Posted 01 January 2005 - 09:01 PM

Thank you Pam!

#3 MarvBear

MarvBear

    Administrator

  • Admin
  • 46,991 posts

Posted 02 January 2005 - 09:37 AM

It has been helpfull to me when I remember some pertinent search words AND the member Name. I always click the match exact name check box. This seems to narrow the search down by a fair amount.

#4 De

De
  • Members
  • 1,632 posts

Posted 03 January 2005 - 01:31 PM

It won't let me search for my posts since I have only a 2 letter name. Any suggestions?

#5 Q

Q
  • Members
  • 4,574 posts

Posted 03 January 2005 - 02:28 PM

I can search my posts and look at my name....

#6 Marty716

Marty716
  • Members
  • 2,099 posts

Posted 03 January 2005 - 02:38 PM

I have never had much luck using the search feature, hopefully that'll change with the new board. But then I'm slow...so slow I make frozen molasses look like greased lightning! :)

#7 lbjones

lbjones
  • Members
  • 2,845 posts

Posted 04 January 2005 - 12:13 AM

Use   Means
apple*  Find posts with 'apple' and/or 'applesauce'

<{POST_SNAPBACK}>


I just don't think that asterisk is accurate. "apple*" searches for just that phrase including the asterisk, not words that start with apple. Try it and see. I had a lot of frustration with two letter acronyms (BK, GM, etc) after the site switch. I finally found that I could use the % sign as the wildcard for those.

So when you compile the tips, make sure to specify how two letter acronyms should be searched.

This doesn't work for me: GM* and Household

This DOES work for me: GM% and Household

-LB

#8 Pam

Pam

    Site Owner

  • Admin
  • 12,083 posts

Posted 04 January 2005 - 07:24 PM

Use  Means
apple*  Find posts with 'apple' and/or 'applesauce'

<{POST_SNAPBACK}>


I just don't think that asterisk is accurate. "apple*" searches for just that phrase including the asterisk, not words that start with apple. Try it and see. I had a lot of frustration with two letter acronyms (BK, GM, etc) after the site switch. I finally found that I could use the % sign as the wildcard for those.

So when you compile the tips, make sure to specify how two letter acronyms should be searched.

This doesn't work for me: GM* and Household

This DOES work for me: GM% and Household

-LB

<{POST_SNAPBACK}>


See, that's the kind of thing I'm looking for. What I put was taken directly from the search help files, but I'd noticed that the asterisk wasn't working for some people. That's the reason for this thread :)

#9 chrisndelray

chrisndelray
  • Members
  • 2,268 posts

Posted 04 January 2005 - 10:11 PM

:D  :search:  :search:  :search:  :search:  :search:  :search:


Use   Means
apple banana  Find posts that contain at least one of these words
+apple +juice  Find posts with both words
+apple -juice  Find posts with 'apple' but not 'juice'
apple*  Find posts with 'apple' and/or 'applesauce'
"Some Words"  Find posts with the phrase 'some words of wisdom', 'some words' but not 'some noise words'


Add your tips here, and in a couple of weeks I'll compile them into one post with search tips.

Thanks!

Pam

<{POST_SNAPBACK}>


when I type:

+credit +report

I get an error message.

"credit report" works fine for me, no problems.

#10 lbjones

lbjones
  • Members
  • 2,845 posts

Posted 04 January 2005 - 10:37 PM

["credit report" works fine for me, no problems.

<{POST_SNAPBACK}>


A thought on that, I'm pretty sure "credit report" searches for that phrase. If you type "credit and report", it searches for both words, but not necessarily as part of the phrase. That was another source of frustration until I realized it.

I still am not sure how to do NOT type searches. Does anyone? "credit and not report" doesn't do what I thought it would, and the - syntax doesn't work either.

-LB

#11 bfarber

bfarber

    bfarber The Great

  • Members
  • 915 posts

Posted 06 January 2005 - 10:50 AM

FYI, including a % sign in your search really does nothing. The search php code strips the % sign specifically, but adds it again in the actual SQL query. :sorry:

 $check_keywords = str_replace( "%", "", $check_keywords );
   $post_like  = " LOWER(p.post) LIKE '%".trim($keywords)."%' ";

I am not really seeing anything in the code to provide for + or - signs.

If you want to search all your own posts (i.e., if you are looking to see if anyone has replied to any of your posts), you can go to the Search section, type your name in under member name field, check match exact name only, and then search with no keywords.

If you want to see all new posts since your last visit, click the "View new posts" link (as if that wasn't obvious).

If you want to search keywords on a page, just add to the address bar "&hl=keyword" at the end of the present url. This will highlight all instances of "keyword" on the page. (Note, until the server is on php5, and IPB is coded for php5, this is case sensitive and thus Credit and credit are not the same thing. They will match in a search, but wouldn't be highlighted by this example).

To the admins: if it hasn't been done already, if you FULLTEXT index the posts in your ibf_posts table, and set IPB to use FULLTEXT in the ACP, this will make searching the forums a LOT quicker. :cry2: On a site like this, with a DB size likely to be around 60-80 MB or larger, you would likely need to FULLTEXT index from command line, through SSH/shell access. But if someone COULD do this, would be a great improvement on the searching system, probably the best thing you could do to it behind the curtains. :(

#12 lbjones

lbjones
  • Members
  • 2,845 posts

Posted 06 January 2005 - 12:40 PM

FYI, including a % sign in your search really does nothing.  The search php code strips the % sign specifically, but adds it again in the actual SQL query. :D

<{POST_SNAPBACK}>


I'd have to argue that point. Maybe it doesn't get included in the search, but to say it does nothing is not true. The site limits search words shorter than three characters. So if you want to have a search that includes a two character acronym (BK, GM, PG, etc.), you need to pad it out to three chars. The percent sign works for this.

If there is a better way to force a search on two letter acronyms, please fill me in.

-LB

#13 Pam

Pam

    Site Owner

  • Admin
  • 12,083 posts

Posted 06 January 2005 - 01:30 PM

  On a site like this, with a DB size likely to be around 60-80 MB or larger, you would likely need to FULLTEXT index from command line, through SSH/shell access.  But if someone COULD do this, would be a great improvement on the searching system, probably the best thing you could do to it behind the curtains. :dance:

<{POST_SNAPBACK}>


60-80MB or larger? :) Ummm that might hold half of our member table. Or a drop in the bucket of the post table.

We've thought about doing the FULTEXT but you're right it would have to be done from the command line. And we would likely have to take the board down for several hours while we did it. We've got a few other bugs we'd like to work out first before doing so.

#14 bfarber

bfarber

    bfarber The Great

  • Members
  • 915 posts

Posted 06 January 2005 - 07:43 PM

@lbjones....hmm, that's very interesting.
I don't test many of the abilities, quirks, etc., so I'll take your word for it.

But the php code IPB uses for searching actually strips the % sign long before it checks the character length, so I should think that this "trick" wouldn't work. :) If it does though, hey, that would be a valuable search tip if you ask me. :P I was mostly pointing out that adding a % to indicate a wildcard isn't necessary, as IPB strips it and then re-adds it as necessary afterwards. ;)

@Pam...wow, this site must be a lot larger than I gauged at first. Let's do some figuring really quickly:

You have about 12,000 members.
(I joined a week or two ago).

My hobby site (bfarber.com) had 26,385.

I have 36,441 posts. Your site I'm guessing has many more, as it is more geared towards discussions.

I was giving a rough guess of the DB size. I'd be pretty interested in knowing the actual size if 60-80MB is that far off. My DB size is 120 MB (site uses approx 1.8 GB of webspace), so I was basing my estimate off of what I had seen in the past. In any event, no worries. Curiousity tends to get the better of me sometimes. :D

And the reason you posted is exactly the reason I haven't fulltext indexed my db too. lol

#15 Pam

Pam

    Site Owner

  • Admin
  • 12,083 posts

Posted 06 January 2005 - 08:35 PM

You have about 12,000 members.
(I joined a week or two ago).

My hobby site (bfarber.com) had 26,385.

I have 36,441 posts.  Your site I'm guessing has many more, as it is more geared towards discussions.

I was giving a rough guess of the DB size.  I'd be pretty interested in knowing the actual size if 60-80MB is that far off.  My DB size is 120 MB (site uses approx 1.8 GB of webspace), so I was basing my estimate off of what I had seen in the past.  In any event, no worries.  Curiousity tends to get the better of me sometimes. :clapping:

And the reason you posted is exactly the reason I haven't fulltext indexed my db too. lol

<{POST_SNAPBACK}>


As of five minutes ago:

Our members have made a total of 528,756 posts


Our database (unzipped) is more than 1.5GB. You can imagine how long it took to convert all the posts when we moved from phpBB2 to IPB. I can only imagine that fulltext indexing would be just as painful. :cry2:

#16 bfarber

bfarber

    bfarber The Great

  • Members
  • 915 posts

Posted 07 January 2005 - 10:44 AM

>.<

Wow, yeah those posts really do drive the db size up.
I can only imagine your hosting costs. :)
Thanks for humoring me. :)

#17 Pam

Pam

    Site Owner

  • Admin
  • 12,083 posts

Posted 07 January 2005 - 02:57 PM

>.<

Wow, yeah those posts really do drive the db size up.
I can only imagine your hosting costs. :rofl:
Thanks for humoring me. :rofl:

<{POST_SNAPBACK}>


LOL, sure :D

And our hosting costs are beyond reasonable. we've really lucked out - excellent support and a price that can't be beat - we've looked, everyone else wants more. We eat a lot of bandwidth, too.

#18 bfarber

bfarber

    bfarber The Great

  • Members
  • 915 posts

Posted 07 January 2005 - 04:27 PM

Yeah, I hear you.
My site was getting up to about 200GB bandwidth a month, but it is primarily an upload/download site.
I sold it recently (at a pretty nice penny too), and only admin it now, but still enjoy being there.

And I don't know WHY you switched exactly from phpbb to IPB, but I'm glad you did. In my opinion, IPB has been the best forum software I've used to date. :D

#19 Pam

Pam

    Site Owner

  • Admin
  • 12,083 posts

Posted 07 January 2005 - 05:53 PM

We've been more than impressed with IPB.

We switched because phpBB simply can't handle the volume and size that we are. It started "eating" things and overwhelming the SQL server with inefficient code. The load on the SQL server was reduced dramatically when we switched to IPB.

#20 munci98

munci98
  • Members
  • 2,522 posts

Posted 09 February 2005 - 02:51 PM

When trying to search for something such as 'repo' I come up with repo, reporting, report, repossession... how do I get it to only find repo? Not variations of the word I type in? Quotes dont' seem to work. Thanks!

#21 Chicago

Chicago
  • Members
  • 554 posts

Posted 10 February 2005 - 03:45 AM

I adore this board but I am VERY frustrated with the search function. I can never get it to work, even while following the different rules and tips in this thread. I don't like posting questions I know can be easily searched for and found and I see (all the time), people replying to questions with "do a search" or "did you do a search". I would love to do searches all day long and not bother people with my newbie questions, but I can't bc the search function is like splitting atoms! Is there anyway to make it more usable? Or is there a fool-proof list of rules someone can post that work?

#22 DiamondEye

DiamondEye
  • Members
  • 348 posts

Posted 13 February 2005 - 11:50 AM

How does one search exact phrase on the new board? Quotes don't seem to work.

#23 tmimages

tmimages
  • Members
  • 993 posts

Posted 16 September 2005 - 08:19 PM

My computer hates boolean search functions, so in order to actually read the results that I find from doing a search, I have to right click and choose "properties" and then copy/paste that URL directly into my browser. Don't know if anyone else ever has that problem, but that's how I've learned to overcome it.

Edited by tmimages, 16 September 2005 - 08:20 PM.


#24 puskits

puskits
  • Newbies
  • 2 posts

Posted 01 October 2005 - 11:41 PM

Thank you for all the great tips! :blink:

#25 ufjoe21

ufjoe21
  • Banned
  • 893 posts

Posted 02 October 2005 - 01:45 AM

My computer hates boolean search functions, so in order to actually read the results that I find from doing a search, I have to right click and choose "properties" and then copy/paste that URL directly into my browser. Don't know if anyone else ever has that problem, but that's how I've learned to overcome it.

<{POST_SNAPBACK}>



sounds like an old broswer or a bad search engine

google works with boolean searches (ie, 'x AND y'), if you're having problems with URLs it could be a broswer issue

use FireFox




0 user(s) are browsing this forum

0 members, 0 guests, 0 anonymous users



© Copyright 2003 - 2013 Creditboards.com. All rights reserved. No portion of this site may be reproduced without explicit permission from the owners. The content of creditboards.com is subject solely to the personal whim of its admins. We reserve the right, at our sole discretion, to remove any and all posts or comments, at any time, for any reason which takes our entirely capricious fancy, or for no particular reason whatsoever, without restriction. Comments or questions regarding the site may be addressed to admin@creditboards.com.