Home

Forum

Archives

Tags



Plugins:


AddCategory

AjaxRating

Blacklist32

BlacklistStats

BlogJanitor

CommentRegistration

DefineCommentPending

EntryPost

FastSearch

FlickrPhotos

FormatList

MTCategoryCommentCount

MTDisguiseCommentURL

MTDisguiseTrackbackURL

MTDynamic

MTTrackbackEntry

PluginNetwork

SmartRebuild

SpamFirewall

TemplateInheritance

TrustedCommenters







Fast Search v1.5 - Several New Features

Keep track of this discussion by subscribing to the RSS feed for this discussion thread
Author Message
Mark







PostPosted: October 7, 2006 2:53 PM 

Fast Search is a PHP plugin for Movable Type. This means that Fast Search uses Movable Type's dynamic PHP-based publishing system to display search results. However, you can continue to use static publishing for all of your indexes and archives. Fast Search is fast in part because it uses mySQL fulltext indexing -- basically this means that a search index will be created for the entries in your database, making searches much faster. Like the built-in search, Fast Search logs searches to the Movable Type Activity log.

New Features in Version 1.5

Fast Search v1.5 has several new features:

  • Search Method Options. Three methods are available which control how the searches are conducted. Most users will use the default "Fulltext" option, but some installations will beneft from the two new options. More details below.
  • Multi-Byte Language Support. Fast Search can now search entries with languages in multi-byte languages, such as Arabic and Japanese, using the "Non-Fulltext" search method.
  • Total Number of Results Found. A new tag for displaying the total number of results in the database, so you can display "showing 1 - 10 of 256 results".
  • Search Page Links. Display linked page numbers to link directly to multiple pages of search results.
  • Previous Page Link. Links to the previous page of search results.
  • Short Words Searching. Using the "Non-Fulltext" or "Fallback" search methods, you can now search for words under 4 characters in length.
  • Match Partial Words. Search for partial words using the "Non-Fulltext" or "Fallback" methods, you can now search for partial words.
  • "Mixed" Multi-blog Searching. You can now search multiple blogs in the same search. The results are "mixed" together, in one list of search results, not grouped by blog.

What Search Method is Best?

For most cases, "Fulltext" will be the fastest search method. This is the same method used in version 1.0. There are some cases in which you might two options:

  • Non-Fulltext. Technically speaking this method used a LIKE %query% syntax. If you don't know what that means, don't worry about, just read on.
  • Fallback. The Fallback method is a combination method. FastSearch will first try a fulltext search, and if that returns no results, then it will try a Non-Fulltext search.

Non-Fulltext and Fallback are capable of some types of searches that you can't do with mySQL. You might want to use Non-Fulltext or Fallback to:

  1. search multi-byte languages such as Arabic and Japanese.
  2. search words shorter than 3 characters (such as "MTV")
  3. search partial words
  4. search a mySQL database that does not support Fulltext searching

Template Tags

Version 1.5 of FastSearch is designed to easily replace the existing search functionality in Movable Type, but with added features. For example, if you are currently using customized search templates, you can use them with Fast Search, with very few changes in most cases. Many Fast Search template tags have the same names as their CGI counterparts:

  • <MTSearchString> - The search string (query) being searched.
  • <MTSearchResults> - A container tag that displays search results. Arguments include (all are optional):
    • lastn - restricts the search to n results. (example <MTSearchResults lastn="10"> ) The lastn argument, like all arguments for MTSearchResults, can also be specified in the URL (...&lastn=10) or POSTed from a search form)
    • offset - used in coordination with lastn, starts M entries from the start of the list. (example <MTSearchResults lastn="10" offset="10"> will display results 11-20)
    • order - must be either 'date' or 'relevance', the default is 'relevance'. (example $lt;MTSearchResults order="date"> will provide similar results as the CGI search)
    • category - must be a valid category ID for the current blog - restricts the search results to entries from this category.
    • google_highlight - if specified, search words will be highlighted. (example <MTSearchResults google_highlight="1"> )
    • query - the search string (text) to be searched. In normal use, you would NOT include this argument as part of the <MTSearchResults> tag, rather, it would be specified as a URL paramter (example ...query=search+phrase) or POSTed from a search form.
    • blogs - a comma-separated list of blog_ids if you want to search more than one blog. This argument is optional, if excluded, only the current blog will be searched. Example usage: <MTSearchResults blogs="1,3,8">
  • <MTBlogResultHeader> - this is container tag that displays content before the search results.
  • <MTBlogResultFooter> - this is container tag that displays content below the search results.
  • <MTNoSearchResult> - A container tag that displays its content only if zero results are found. Note that this tag must be used after a <MTSearchResults> container.
  • <MTNoSearch> - A container tag that displays its content only if no search phrase was specified.
  • <MTSearchCount> - The number of search results displayed on the current search results page. This tag should be used with a <MTBlogResultHeader> or <MTBlogResultFooter> container.
  • <MTSearchFirst> - The number of the first search result on the current page. This tag should be used with a <MTBlogResultHeader> or <MTBlogResultFooter>container.
  • <MTSearchLast> - The number of the last search result on the current page. This tag should be used with a <MTBlogResultHeader> or <MTBlogResultFooter>container.
  • <MTSearchIfNextPage> - A conditional tag that displays its content if there is a subsequent page of search results. This tag should be used with a <MTBlogResultHeader> or <MTBlogResultFooter>container.
  • <MTSearchNextPageLink> - Output a URL to the next page of search results. This tag should be used within <MTSearchIfNextPage> tags.
  • new - <MTSearchIfPrevioustPage> - A conditional tag that displays its content if there is a previous page of search results. This tag should be used with a <MTBlogResultHeader> or <MTBlogResultFooter>container.
  • new - <MTSearchPreviousPageLink> - Output a URL to the previous page of search results. This tag should be used within <MTSearchIfNextPage> tags.
  • new - <MTSearchTotalResults> - The total number of matching results in the database.
  • new - <MTSearchPages> - A container tag that can display links to multiple pages of search results. Optional arguments include:
    • max - the maximum number of page links to display on each page. Example: <MTSearchPages max="20">
    • glue - a text string that seperates each page. For example, if you wanted to display 1 - 2 - 3 - 4, you could use <MTSearchPages glue=" - ">
  • new - <MTSearchPageNumber> - Displays the page number of each search results page. This must be used within a <MTSearchPages> container.
  • new - <MTSearchPageLink> - Displays the URL to each search results page. This must be used within a <MTSearchPages> container.
  • new - <MTSearchIfCurrentPage> - A conditional tag that only displays its contents if the page number is the same as the current page - you would normally use this is you wanted to highlight the current page in the list of page numbers, etc. This must be used within a <MTSearchPages> container.

Note: the new default Fast Search template includes pre-formatted template code that displays Google-style search results page links.

As you may have noticed, some of the tags above are identical to the ones used for the existing CGI-based search results. This is by design, so you will easily be able to cut-and-paste your existing search template code into the Fast Search template, though some minor modifications may be required.

Working Examples:

Here are some working examples you can try. Feel free to try additional search queries and note the speed that searches are performed.

  • Mars Rover Blog has over 5,000 entries. Example search: "water on mars". Note that this example shows the default FastSearch template, which is very similar to the default search results template in MT 3.2.
  • Seinfeld Blog has over 8,000 entries, 180 of which consist of the episode descriptions and scripts of all 180 episodes. Fast Search powers the Seinfeld Script Search, which is restricted to a single category containing the episodes. Example search: 'bubble boy'

Requirements:

  • Movable Type 3.2 or 3.3
  • mySQL

Instructions

  1. Download the plugin and expand the zip file.
  2. Upload the contents of the 'plugins' folder to the 'plugins' directory of your MT installation (usually something like /cgi-bin/mt/plugins).
  3. Upload the contents of the 'php' folder to the 'php' directory (usually something like /cgi-bin/mt/php)
  4. Login to the MT admin interface. If you already logged in, choose 'Main Menu'
  5. If your are running MT 3.3, you should be redirected to an 'Upgrade' screen at this point. The Fast Search upgrade process will update your database to add a fulltext index to the table in your database where entries are stored. Note that this may take some time if you have many entries, and this will add to the overall size of your database.
  6. If you are running MT 3.2, you will not see the upgrade screen (as it is a 3.3 feature), so you need to create the index by browsing to the 'Settings' of a blog where you want to use Fats Search. Choose the 'Plugins' tab then find 'Fast Search' and choose 'Settings'. Now click the link in bold that says "Click here to create or rebuild the FastSearch fulltext index". Again, this may take some time, please be patient. After the index has been created, hit the Back button.
  7. Now browse to the 'Publishing' settings tab for the blog, and scroll down to the Setting called "Dynamic Publishing". If the first option, "Build all templates statically", is selected, you should change this setting to "Set each template's Build Options separately" and click "Save Changes" at the bottom of the screen. Otherwise, you don't need to make any changes here.(Note that change this setting will create an .htaccess file in the root path of the blog. Normally you won't notice this and everything will work fine, but if you have an existing.htacces file, you may want to take a look at it to make sure everything looks okay)
  8. If you just changed your Dynamic Publishing settings in the previous step, you should now rebuild all files for this blog by choosing "Rebuild Site" from the left menu, then "Rebuild all Files". You should also ensure that you have a "Dynamic Site Bootstrapper" (mtview.php) index template and make sure that it gets built, if it hasn't been built previously.
  9. Now return to the Fast Search settings ('Plugins' tab within 'Settings') and check the box to enable Fast Search. You may also want to adjust the settings for Maximum Search Results and logging, then click "Save Changes".
  10. Open the Fast Search settings once again and choose "Click here to install the default Fast Search Template." The template will be created and then displayed. This is an dynamic Index template (which can be customized) used to display the search results. (If desired you can also skip this step and create the index template manually, use the template tags as desired, or by cutting and pasting your exisiting search template code)
  11. Upgrading from Fast Search v1.0

    Follow steps 1 to 3 above, then adjust your Fast Search plugin settings and search template, if desired.

The Search Form

If you already have search forms on your blog pages, you need to update them to point to the new Fast Search template. For each template that contains a search form, look for the following (or similar):

<form method="post" action="<$MTCGIPath$><$MTSearchScript$>"

...and change it to:

<form method="post" action="<$MTBlogURL>fastsearch"

...save the template and repeat this step for every template that has a search form.

If you want to insert a new search form on your site, or completely replace existing forms, you can use the following:

<form method="get" action="<$MTBlogURL$>fastsearch">
    <label for="query" accesskey="4">Search this blog:</label><br />
    <input id="query" name="query" size="20" />
    <input type="submit" value="Search" />
</form>

Of course you can also add optional fields to the form such as:

<input type="hidden" name="order" value="date" />

....to sort the results by date, or....

<input type="hidden" name="category" value="5" />

...to restrict the search to category_id = 5.

Once you have the search form(s) on you site, rebuild those pages and start searching. You should notice significant speed and resource improvement, especially on blogs with many entries.

Fast Search Settings

Fast Search settings are on a "per blog" basis. To access the settings, browse to the blog you want to use, then choose "Settings", then "Plugins". Look for Fast Search in the list and click the "Show Settings" button.

Download Fast Search

Non-commercial use - FREE ( although you must include a

Movable Type search results powered by 
<a href="http://mt-hacks.com/fastsearch.html">Fast Search</a>
link on your search results pages.

Also, donations are appreciated:

Commercial use - $97.00

Download Now
Downloads: 481 (since 3/6/07)

As always, suggestions and feedback are appreciated. Please reply to this entry.

Note: FastSearch v1.5 is a suitable replacement for most implementations of the built-in search function in Movable Type. However, there are a few features that Fast Search v1.5 does not include. Fast Search v1.0 does not support comment searches, regexp search, case-senstive search, the use of AND and OR operators, and Edit Entry Links). Also, Fast Search v1.5 does not inlcude MT 3.3 search features such as tag search. Some of these features may be supported in future versions -- please let me know what features you would like to see.

Jake [TypeKey Profile Page]

Posts: 10

Reply: 1



PostPosted: October 9, 2006 2:30 PM 

Good work as always. One question I have, and I've ran into this in other plugins before, but do you know of a way I can check on what type of "order" has been used in the search? Basically, I'm trying to create two radio buttons that allow you to order search by date or relevance, and tried to put in this code to determine what (if any) ordering was done:

<input type="radio" name="order" <? if $_POST['order'] != "date" echo 'checked';?> value="relevance">  Sort By Relevance<br>
<input type="radio" name="order" <? if $_POST['order'] == "date" echo 'checked';?> value="date">  Sort By Date<br>

The php doesn't get executed. Am I doing something wrong? I've tried to execute PHP within MT's dynamic pages before (particularly, the 404 page: http://forums.sixapart.com/index.php?showtopic=59281 ) and had no luck, so this is probably nothing within your control, but I'd figured I'd throw it out there.

Meanwhile, I did make sure I kept the Fast Search credit on my results -- with a bit of editing:

http://utterlyboring.com/fastsearch?query=jake

Wink

Have a good one!

Ot

Jake [TypeKey Profile Page]

Posts: 10

Reply: 2



PostPosted: October 9, 2006 2:44 PM 

OK, obviously I can't copy/paste code into this field, so you'll have to look for the commented-out source code in my fast search results page above (it's listed there).

Mark Carey [TypeKey Profile Page]

Posts: 150

Reply: 3



PostPosted: October 9, 2006 3:58 PM 

Hi Jake,

I edited you first comment so the code now displays properly.

You need to start your php with <?php instead of just <? - then it should execute.

Ps. I like the credit link, thanks, Wink

Jake [TypeKey Profile Page]

Posts: 10

Reply: 4



PostPosted: October 9, 2006 5:36 PM 

Ah....didn't know I had to long-hand my code in there. That would explain it.

Here's the final code I ended up getting to work (and hopefully I converted all the tags properly):

<input type="radio" name="order" <?php if (isset($_REQUEST['order']) && $_REQUEST['order'] == 'relevance') {echo 'checked';}?> value="relevance">  Sort By Relevance<br>
<input type="radio" name="order" >?php if (isset($_REQUEST['order']) && $_REQUEST['order'] == 'date') {echo 'checked';}?> value="date">  Sort By Date<br>

Hopefully that will be of use to somebody. I also did something similar so that it reads "Search Results for: [search term], sorted by [sort-type]"

THanks again!

Mark Carey [TypeKey Profile Page]

Posts: 150

Reply: 5



PostPosted: October 9, 2006 7:14 PM 

Jake, glad you got it to work.

The key thing to note is that order=date means a date sort and when order is blank/null, the sort is by relevance.

Jake [TypeKey Profile Page]

Posts: 10

Reply: 6



PostPosted: October 10, 2006 1:22 AM 

Which is the reason I checked to see if it's set, or at least that was my thinking. Probably cleaner way to do that, but PHP whiz I am not.

James Bow [TypeKey Profile Page]

Posts: 11

Reply: 7



PostPosted: October 12, 2006 8:47 AM 

I've upgraded to version 1.5, and one installation works. The other, however, is giving me this error on the fastsearch page:

"Page Not Found

Smarty error: [in mt:364 line 8]: syntax error: unrecognized tag 'MTSearchString' (Smarty_Compiler.class.php, line 580)"

I've already turned the EntryExcerpt tag to "convert_breaks=1" to compensate for the fact that the blog might have Markdown/Smartypants formatted posts, but that doesn't seem to have helped.

Mark Carey [TypeKey Profile Page]

Posts: 150

Reply: 8



PostPosted: October 12, 2006 10:20 AM 

James, I would need some more details to help. Ideally, if you could send me a link to the installation (Fast Search form), that would help.

The error suggests a problem with the MTSearchString tag. The obvious thing to check first is that the function.MTSearchString.php file in present in mt/php/plugins. Assuming you have done that, I would need to know more deatils about the install with the error (MT version, mySQL version, difference in templates, Fast Search options, etc.)

James Bow [TypeKey Profile Page]

Posts: 11

Reply: 9



PostPosted: October 12, 2006 2:07 PM 

Bingo.

Mark, the problem is obviously with my FTP system, which failed to upload the entire php/plugins directory. Making sure all of the files were there corrected the problem. Many thanks!

James Bow [TypeKey Profile Page]

Posts: 11

Reply: 10



PostPosted: October 12, 2006 3:10 PM 

I have encountered a different issue. On the new installation, I'm getting search results, but no permalinks. Instead, the links to the individual articles are blank, so clicking on the links just returns you to the query page. Do you need more details?

I must say, though, that this is a remarkable plugin, much better than MT's standard search engine. I hope it gets included as the default when the next version comes out.

James Bow [TypeKey Profile Page]

Posts: 11

Reply: 11



PostPosted: October 12, 2006 3:20 PM 

Okay, how's this for odd behaviour. The problem I identified above isn't consistent. It's only older posts that get this treatment. Newer posts (up to 2 years old on a blog that has over 5000 posts) are fine. Weird, huh?

Mihai Bocsaru [TypeKey Profile Page]

Posts: 2

Reply: 12



PostPosted: October 12, 2006 6:11 PM 

hello Mark,

Wonderful plugin!

I have a couple of questions for you:

1) is it possible to display the entry author with this new version? with the previous one the author tag was simply ignored.

2) can i set the search to look for "internet AND marketing" rather that "internet OR marketing"? if i search for "internet" or "internet marketing" i get the same number of results.

many thanks

Mark Carey [TypeKey Profile Page]

Posts: 150

Reply: 13



PostPosted: October 13, 2006 8:09 AM 

James, I have seen this problem before.

Are you sure you have followed steps 7 and 8 (above) exactly? Specifically, I am referring to the "rebuild all files" part.

Johnny [TypeKey Profile Page]

Posts: 1

Reply: 14



PostPosted: October 13, 2006 6:27 PM 

Running on a Windows Server, which does not read .htaccess.

hence fastsearch will not work, and will lead to an error (file not found).

Can FastSearch work without .htaccess file?

Antony Shen [TypeKey Profile Page]

Posts: 4

Reply: 15



PostPosted: October 14, 2006 12:42 PM 

Thanks for the great plugin.

I just noticed one problem... in Activity Log, all the date were listed as "Less than 1 minute ago". Is this a bug?

Mark Carey [TypeKey Profile Page]

Posts: 150

Reply: 16



PostPosted: October 15, 2006 2:19 PM 

Antony, what version of MT are you using? Do you mean that even hours after a search, it still shows in the log as "less than 1 minute ago"? What happens if you change the "display format" for the the log to absolute dates. What dates shows for each search?

robbo [TypeKey Profile Page]

Posts: 4

Reply: 17



PostPosted: October 15, 2006 4:37 PM 

Hello Mark - this looks like a great plugin, something seriously needed for MT, especially with multiblog search functionality.

I followed your instructions carefully, but keep on getting a "500 Internal Server Error" error. A couple of questions for my multiblog installation:

1. Do I need to change settings, run the plugin, and fastsearch template on every blog?
2. Do I need to tweak the "mt-config.cgi" file in any way (i.e. default or alternative templates, etc.)?
3. Would running a "fulltext index" multiple times (due to upgrade from v1.0) have any negative effect?
4. You say "if you have an existing .htaccess file, you may want to take a look at it to make sure everything looks okay"...what would I be looking for exactly?
5. Also you mention "a comma-separated list of blog_ids" but list an example () that uses different terminology...is the example correct?

Sorry for all the questions, and thanks for your kind reply.

Mark Carey [TypeKey Profile Page]

Posts: 150

Reply: 18



PostPosted: October 15, 2006 8:07 PM 

robbo,

Here are the answers:

1. yes, the settings are on a per-blog basis, so you need to do the setting and template part for each blog.

2. no

3. no, I don't think so.

4. well, it varies. I know that answer doesn't help much. The main thing to look for are pre-existing lines that include "rewrite" in any way. Sometimes things can conflict, and you have change the order of things. .htaccess problems may result in 500 errors.

5. I not sure what you mean here. The example was <MTSearchResults blogs="1,3,8">. This example is correct and represents a comma-separatd list of blog ids. The argument name is "blogs", not "blog_ids", if this if what you are driving at.

With respect to the 500 error, does it happen when you go directly to www.blogurl.com/fastsearch (without running a search)? If so, it may be a problem with the .htaccess file. Sometimes your web server error log provides some hints in these cases.

Mark Carey [TypeKey Profile Page]

Posts: 150

Reply: 19



PostPosted: October 15, 2006 8:13 PM 

Johnny, MT's dynamic publishing model does work with MT, so Fast Search should as well. Instead of using .htaccess, on Windows it uses custom error documents. Basically, this means that a custom 404 error document would redirect to the mtview.php script, which would then serve the dynamic page (Fast Search or other dynamic template). I have not installed MT on Windows myself, but there is some additional detail http://www.sixapart.com/movabletype/docs/3.2/06_publishing/here.

robbo [TypeKey Profile Page]

Posts: 4

Reply: 20



PostPosted: October 16, 2006 2:54 PM 

Hello Mark - thank you for your quick reply to my questions.

I am having my MT host check my .htaccess file and web server logs in detail.

My www.blogurl.com/fastsearch result: on some blogs, the fastsearch template shows, but with no results. On other blogs I get 500 errors.

For each blog I have added the fastsearch template, set settings, enabled the plugin, and rebuilt the index but same problem exists.

Can Fast Search work from a blog that has no entries (i.e. aggregated from entries of all other blogs)?

When either my MT host or I figure out the problem, I'll let you know! Cheers -

Mark Carey [TypeKey Profile Page]

Posts: 150

Reply: 21



PostPosted: October 16, 2006 3:23 PM 

robbo, seems liek it might be an .htaccess problem in the case where you get 500 errors. However, in the case where the Fast Search template does display, it means the .htacess is working on those. If those blogs are still showing zero results, there is a problem of some other kind. Can you provide a URL to one of those blogs?

And yes, you can install Fast Search on a blog with no entries. Of course, you will have uses the "blogs" argument and thus specify the blogs you want to search (as previously disucussed).

robbo [TypeKey Profile Page]

Posts: 4

Reply: 22



PostPosted: October 17, 2006 1:18 AM 

Hi Mark - According to my MT host, 500 errors are being caused from too many redirects, which is coming from my .htaccess file. It seems to be a problem with my rewrite rules.

"mod_rewrite: maximum number of internal redirects reached. Assuming configuration error. Use 'RewriteOptions MaxRedirects' to increase the limit if neccessary."

Do you know what exact code I need to place into the .htaccess file? I'm just not technical enough to know this. If you like, I can send you the URL to my beta site offline. Thanks again!

robbo [TypeKey Profile Page]

Posts: 4

Reply: 23



PostPosted: October 17, 2006 1:52 AM 

Hi Mark - thanks for your continued support.

My MT host says the error is caused from too many redirects, which is coming from my htaccess file. There seems to be a problem with my rewrite rules:

mod_rewrite: maximum number of internal redirects reached.

Assuming configuration error. Use 'RewriteOptions MaxRedirects' to increase the limit if neccessary.

As I am not technical, do you know what I need to exactly do within the .htaccess file?

As for the URL to my beta site, I can provide this offline if you wish. Cheers -

robbo [TypeKey Profile Page]

Posts: no

Reply: 24



PostPosted: October 17, 2006 4:21 AM 

Mark - apologies for the double post. Timed out on me, and didn't show up initially. Anyway, I've finally got the baby to rock n' roll! Here is what the problem was:

In my .htaccess file, there was a line of code:
"RewriteRule ^(.*)$ /sales/mtview.php [L,QSA]"

Which when changed to:
"RewriteRule ^(.*)$ /mtview.php [L,QSA]"

fixed the 500 errors. For some strange reason, one blog's title named "sales" was within the rewrite rule. Thanks for your patience, and hopefully this is the last you hear of me! Early indications are that this plugin will win top honours!

Antony Shen [TypeKey Profile Page]

Posts: 4

Reply: 25



PostPosted: October 17, 2006 1:23 PM 

Mark,

What version of MT are you using?

MT 3.33

Do you mean that even hours after a search, it still shows in the log as "less than 1 minute ago"?

Yes.

What happens if you change the "display format" for the the log to absolute dates. What dates shows for each search?

It shows the current time when I request that log. When I view the log again, all the entries in the log will be having a new time (all the same time).

Mark Carey [TypeKey Profile Page]

Posts: 150

Reply: 26



PostPosted: October 18, 2006 11:56 AM 

Antony, thanks for your help. Yes, it is a bug. It is now fixed in version 1.52. Download here.

Antony Shen [TypeKey Profile Page]

Posts: 4

Reply: 27



PostPosted: October 20, 2006 9:40 AM 

Thanks Mark,

However, I still experience the same problem after uploading all the files (v 1.52) to the server. Do I need to make any changes besides overwriting files?

Mark Carey [TypeKey Profile Page]

Posts: 150

Reply: 28



PostPosted: October 20, 2006 2:48 PM 

Antony, the new version fixes the date issue only for new searches, not the old ones in the log. In other words, only searches made after the upgrade to v1.52 will shows the correct date.

Jason Truell [TypeKey Profile Page]

Posts: 3

Reply: 29



PostPosted: October 22, 2006 3:47 AM 

Hi Mark,

I'm having the same problem as James Bow mentions above. The search results are displaying fine but the links are blank, i.e., they point to the search page "fastsearch?search=...". I tried rebuilding all files as you suggested but that did not solve the problem.

Any ideas? Thanks for the awesome plugin!

Mark Carey [TypeKey Profile Page]

Posts: 150

Reply: 30



PostPosted: October 22, 2006 4:16 PM 

Jason, can you provide a link to your search results pages? Also, are you using the default Fast Search template, or a customized one? Is the Dynamic Publishing setting for the blog in question set to "Set each template's Build Options separately"? Are you doing multi-blog search?

Jason Truell [TypeKey Profile Page]

Posts: 3

Reply: 31



PostPosted: October 23, 2006 5:29 AM 

Mark, Sure, here is the link to a sample search results page: http://www.globalchinacenter.org/fastsearch?search=china
A have customed the search results template. I'm tring to create a site-wide multiblog search. Each blogs publishing settings are set to build seperately. I went into the fastsearch plugin setting for each blog and enabled fastsearch and built the index. I am pointing the site-wide search to the same search template so each blog doesn't have its own template. However, I tried giving each blog its own template but that didn't solve the problem. Thanks again for the help!

Mark Carey [TypeKey Profile Page]

Posts: 150

Reply: 32



PostPosted: October 23, 2006 6:27 AM 

Jason, have you "rebuilt all files" for every blog being searched? In addition to the dynamic setting, you also must rebuild all files for every blog being searched.

Jason Truell [TypeKey Profile Page]

Posts: 3

Reply: 33



PostPosted: October 23, 2006 8:53 AM 

Mark, I have rebuilt at least several times (and just did it again). I'm out of ideas.

Mark Carey [TypeKey Profile Page]

Posts: 150

Reply: 34



PostPosted: October 23, 2006 11:10 AM 

Thanks, Jason, but you didn't answer my specific question: did you rebuild all files for every blog that is being searched in the multi-blog search?

Other than that, I am not sure why you would have this problem. Have you tried a non-multi-blog search, does that work? What version of MT are you using? Are you using the MTEntryLink or MTEntryPermaLink tag?

Tobias [TypeKey Profile Page]

Posts: 1

Reply: 35



PostPosted: October 29, 2006 3:27 PM 

Hi, thanks for the wonderful plugin!

One question though: Is there any way to pass the "blogs" parameter through the query parameter? I've tried it and it doesn't work. And it seems I can't include a variable I pass through to the template to determine the value of the "blogs" parameter in the tag. I am not too familiar with MT's way of handling and parsing tags, especially with respect to dynamic publishing.

I would like to offer a check box specifying if only the current blogs should be searched or if all blogs should be searched.

Of course I could swap the form when the box is ticked and use a different template for either the single blog or all blog search, but I'd prefer to keep this as simple as possible.

Thanks!

Mark Carey [TypeKey Profile Page]

Posts: 150

Reply: 36



PostPosted: October 30, 2006 10:15 AM 

Tobias, thanks for pointing this out. This was an oversight on my part. I have just released version 1.53 which has this feature. Download here.

Tobias [TypeKey Profile Page]

Posts: 1

Reply: 37



PostPosted: November 4, 2006 8:10 PM 

Thanks for the update Mark. And thanks again for the very impressive plugin.

I'm currently in the process of integrating a site with multiple blogs and, realizing how difficult that is in the static world of MT despite such efforts as multiblog, I was wondering if your script could not turn out to be the basis for the wonderful world of dynamic display and recombination of MT contents - something even the dynamic "context changing code" I found on movalog doesn't allow (or it does, but I don't know how). You already have category options and blog options, so I'm thinking that adding a date, and a tag parameter would essentially allow to create dynamic archives/combined display through links and simple php includes. I for one would truly appreciate this. Am I making the least bit of sense here? I don't know. Just thought I share my thoughts on this.

Thanks again for the plugin, and the link!

Tobias

Mark Carey [TypeKey Profile Page]

Posts: 150

Reply: 38



PostPosted: November 5, 2006 7:32 AM 

You are correct, Tobias. A dynamic search methodology like this can be used creatively to display (paginiated!) category archives and more. And with some expansion, it could be extended to do the same for tags, authors, etc. In reality, multi-blog stuff shouldn't be so hard, because are entries are in the same table, all comments, in the same table etc.

I definitely have tag search and comment search planned, and per author searching is easy to add. These would be "advanced search" parameters, but one could certainly use them in the way you describe.

However, like all MT PHP-dynamic pages, you are limited to the plugins that you can use on these pages, because most plugins only support static (Perl) MT pages and not dynamic (PHP) ones.

joel [TypeKey Profile Page]

Posts: 1

Reply: 39



PostPosted: November 9, 2006 1:22 PM 

This plugin doesn't seem to support the new "tag" features in 3.33 and the mt-search.cgi script. I'd like to move away from mt-search.cgi altogether, can you add support for the new tag search as related to keywords/tags in version 3.33?

Mark Carey [TypeKey Profile Page]

Posts: 150

Reply: 40



PostPosted: November 9, 2006 2:14 PM 

Joel, you are correct. As stated above in the description, this plugin does not currently support tag search. It is possible that I may add this feature in the future, if there is enough interest. So far, you are the first to request this.

jim [TypeKey Profile Page]

Posts: 1

Reply: 41



PostPosted: November 12, 2006 12:52 AM 

Having some problems - hoping someone can direct me.

I had 1.0 installed on MT v3.2. I went to a dedicated server installed MT v3.3 and copied all my plugins and uploaded them.

Fast Search wouldn't work - so I came here and got FS v1.53. I loaded it, unloaded but can't get it to work. I never get the "installer" with v3.3 as outlined above. I did rebuild the the blog after each time I uninstalled.

Any suggestions are appreciated. One you have Fast search you can't live with MT's version.

I hope I can get it working again.

Thanks
jw

Mark Carey [TypeKey Profile Page]

Posts: 150

Reply: 42



PostPosted: November 12, 2006 9:01 AM 

jim,

Assuming you are using full text search, the first thing I would try is to go to the Fast Search settings for the blog in question and click the "Click here to create or rebuild the FastSearch fulltext index". Given you description, I think this may get things working.

If not, I would need more info. What fast search settings are you using? Is your search result template customized? Are you getting a specific error message, or just "no results" for all queries? What version of mySQL? etc.

jim [TypeKey Profile Page]

Posts: 1

Reply: 43



PostPosted: November 12, 2006 2:21 PM 

Thanks for the input Mark:

Here's where I'm at.

Deleted everything, re-downloaded v1.53 and confirmed installation (rebuilt fulltext). Used default FS template. Tried using Fallback, rebuilt entire site after each change.

Now, all settings are back to default, error message continues (500 Internal).

I double checked .htaccess to make sure MT's standard stuff was in there.

SERVER: Apache/2.0.52
PERL: 5.6.1
mySQL; 2.0419

Perl and mySQL are same as the old shared server.

Jim [TypeKey Profile Page]

Posts: 4

Reply: 44



PostPosted: November 12, 2006 4:36 PM 

In a test blog here:
http://thefuntimesguide.com/test/index.php

I am able to get a blank screen, no error messages.

Mark Carey [TypeKey Profile Page]

Posts: 150

Reply: 45



PostPosted: November 12, 2006 5:33 PM 

jim, thanks for the details. That is a very old version of mySQL. Are you sure the old server had the same version? Fast Search v1.0 does not work with version older than 3.23 (that is the version when fulltext indexing was first available with mysql). Since you mentioned that 1.0 worked for you on the old server, it seems like you had a newer version of mySQL. With 2.0419, only the "Non-fulltext" mode should work.

That said, the blank page does not necessary indicate a mySQL related error. Do other MT "dynamic" templates work? To test, set the main index of the test blog to build dynamically and see if it displays properly. If it doesn't work, it suggests a problem getting MT dynamic publishing to work. Try this and let me know if it works.

Other than that, you your web server logs (access and/or error) contain any error messages when the fastsearch pages try to load?

Jim [TypeKey Profile Page]

Posts: 4

Reply: 46



PostPosted: November 12, 2006 5:41 PM 

Sorry, new server is 2.9004 (old server worked fine with FS1.0 and mySQL 2.0419) - I must have looked wrong. Still not 3.23 - So, first thing to do is Rackspace to upgrade. I am building everything static except Fast Search.

Testing now - back soon. Thanks - I think I tipped you on the old version - but my wife just came in to remind me to make sure I remember for 1.53 -

Thanks

Jim [TypeKey Profile Page]

Posts: 4

Reply: 47



PostPosted: November 13, 2006 3:09 AM 

UPDATE:

I'm suspecting my problems are server related. I'm working with Rackspace to try and figure out why the site won't build dynamically. Server error logs say that fastsearch template doesn't exist.

As a follow up, this is not related to the version of mySQL that I gave you earlier. I was taking it from system info page that mt-check.cgi generates. The version of mySQL installed on my server is 4.0x something.

Thanks for your help. I will update further when I know. Perhaps it will help someone else also

jw

Jim [TypeKey Profile Page]

Posts: 4

Reply: 48



PostPosted: November 13, 2006 7:25 PM 

Hey Mark:

You're right on target. My new server had some background stuff set that wasn't allowing for dynamic rebuilds. Plus some careless .htaccess work on my part.

Everything is great. I swear this is the BEST MT Hack / Plugin I have ever used. I can't believe that Six Apart doesn't buy it and offer it instead of their search.

Check your tip jar. It's only a small token of the appreciation for your hard work on a great plugin.

Jim Walczak

chinchin

Posts: 2

Reply: 49



PostPosted: November 17, 2006 4:02 AM 

I've upgraded to version 1.5
and don't work in page -_-"
้Why searching error
" Warning: main(): open_basedir restriction in effect."

chinchin

Posts: 2

Reply: 50



PostPosted: November 17, 2006 7:39 AM 


my problems
in a test blog here :
http://www.tracli.net/test9/fastsearch?query=1
What wrong !! -_-"

imabug [TypeKey Profile Page]

Posts: 1

Reply: 51



PostPosted: November 29, 2006 10:50 AM 

The requirements don't indicate what version of MySQL is required. Some of the SQL that powers FastSearch requires at least MySQL 4.0

Mark Carey [TypeKey Profile Page]

Posts: 150

Reply: 52



PostPosted: November 30, 2006 6:47 AM 

imabug. you are correct. The "Fulltext" mode of FastSearch does require 4.0+. But the "Non-fulltext" will work for previous versions of mySQL. This is one of the benefits of v1.5 of FastSearch: support for a wider range of mySQL versions. I have not heard of any version of mySQL that has problems with the "Non-Fulltext" mode -- this is why I have not indicated a minimum required version.

Paul Berry [TypeKey Profile Page]

Posts: 1

Reply: 53



PostPosted: December 7, 2006 11:32 PM 

Hi Mark,

I'm hoping this is a simple one, I just installed FastSearch on MT3.3. It looked like it was doing perfect, detected, installed and came back happy. But although the Plugin says its enabled, there's no settings link in that one, where I think I'm missing the step of building the first search template. So right now I get

Page Not Found

Page not found - /blog/fastsearch

Is there a pretty quick way around this one?
Thanks
Paul

Mark Carey

Posts: 150

Reply: 54



PostPosted: December 8, 2006 9:07 AM 

Paul, settings for FastSearch are at the blog level. You have to enable it for each blog. So go to the blog you want, then Settings>Plugins then you should see a Settings link for FastSearch. If things still don't work after that, let me know...

Laurent [TypeKey Profile Page]

Posts: 2

Reply: 55



PostPosted: December 10, 2006 10:28 AM 

Hello.
I'm having a similar problem as Jason Truell above. I have a multiblog search :
MTSearchResults blogs="1,2"
The results coming from the first weblog are fine :
http://embruns.net/fastsearch?search=wagashi
but the permalinks are blank for the results from the second weblog :
http://embruns.net/fastsearch?search=UMP
I have rebuilt every files in the 2 blogs, and the plugin settings are identical for the 2 blogs.
Any idea ?

Mark Carey [TypeKey Profile Page]

Posts: 150

Reply: 56



PostPosted: December 10, 2006 7:15 PM 

Laurent,

Both blogs must have the Dynamic Publishing settings set (as discussed in Step 7 above). Based on your description, it sounds like the second blog does not have the "Set each template's Build Options separately" option selected. After selecting this, then rebuild all files for the second blog. Please reply here if that does work.

Laurent Gloaguen [TypeKey Profile Page]

Posts: 2

Reply: 57



PostPosted: December 11, 2006 1:41 AM 

Thanks for your reply. My publishing settings are the same in the two blogs, "Set each template's Build Options separately", I did a full rebuild for the two.



Posts: no

Reply: 58



PostPosted: December 12, 2006 7:12 AM 

Laurent, can you try something as a test. Go to the first entry listed at:

http://embruns.net/fastsearch?search=UMP

...titled "Mon Puteaux" and save in in the MT admin interface. You don't have to make changes, just open the entry and save it. Then run the search above again. Does it fix the the problem for this particular entry?

I just checked my own system, and multi-blog links seem to be working fine for the most part. But I did find the odd entry that didn't have a proper link. Old entries, but I am sure that rebuilt them after installing Fast Search -- now saving them (and hence rebuilding them) fixes the problem for such entries. I am wondering if the same is true in your situation.

mariano [TypeKey Profile Page]

Posts: 2

Reply: 59



PostPosted: December 14, 2006 2:20 AM 

Mark,
sorry to bother you but is it possible that the FastSearch uses a lot of CPU Load?
Im asking because i´ve installed this plugin and suddenly my host started to complain about the CPU load im consuming..

I have 1500 entries, 12000 comments and 2 search queries per minute (according to the MT3.3 Activity log)

Sorry if this sounds lame.. but i still dont know what changed on my blog :S

Mark Carey

Posts: 150

Reply: 60



PostPosted: December 14, 2006 7:13 AM 

Mariano, FastSearch consumes much, much less CPU compared to the mt-search.cgi search script that comes with MT. You should ask your host what files/scripts are generating the load. A common culprit is the comments script -- floods of spam (even if blocked by filters) can cause significant increases in CPU load.

mariano [TypeKey Profile Page]

Posts: 2

Reply: 61



PostPosted: December 14, 2006 7:26 AM 

Mark, many thanks Smile

Solomon [TypeKey Profile Page]

Posts: 2

Reply: 62



PostPosted: December 25, 2006 11:52 AM 

Merry Christmas!

I have a site with the better part of 10000 entries between two blogs on one installation, and searches have gotten mighty slow (and often come up with a blank page) since MT3.3.

Is it absolutely necessary to enable dynamic publishing? Any other way to get this to work?

I ask because I am having a devil of a time enabling dynamic publishing, even only for selected templates, even when *none of my templates is selected to publish dynamically.* I'm getting a smarty error because my main index template (NOT set to rebuild dynamically) uses the MTSQL plugin.

Any help would be appreciated (or a pointer to an alternative search solution I could try). Many thanks!

Solomon [TypeKey Profile Page]

Posts: 2

Reply: 63



PostPosted: December 25, 2006 2:24 PM 

Cancel that. I've resolved the issue with the help of MT support. Just in case anyone else has a similar problem, I had to add my index file's name to a line in the .htaccess that enabling dynamic publishing created. So I had to find this line:

" DirectoryIndex index.php index.html index.htm default.htm default.html default.asp /blog/mtview.php"

And make it into:

" DirectoryIndex index.shtml index.php index.html index.htm default.htm default.html default.asp /blog/mtview.php"

Note the addition of "index.shtml" -- my index file.

(Also had to chmod mtview.php to 755)

Now at least the site loads (so far). Next up, installing this plug-in. Smile

Laura

Posts: 2

Reply: 64



PostPosted: January 7, 2007 11:34 PM 

I'm experiencing the same problem as Paul Berry. FastSearch is enabled for the blog I am working on, but when I try to go to the search page here, it gives me the "Page not found - /quran/fastsearch" error. The Fast Search template is listed among my index templates and is set to rebuild dynamically.

When I create other pages and set them for dynamic publishing, it works, so it seems like it must be a problem with the plugin somehow. Is there something else I should check for?

Laura [TypeKey Profile Page]

Posts: 2

Reply: 65



PostPosted: January 7, 2007 11:53 PM 

I found that if I copied the template code over to a new index template I created called test.php and changed the search form to point to this, it worked just fine. However, if I changed the same index template to output either fastsearch or fastsearch.php I got the "Page not found" error. Since it works with the other filename, I can just use that, but I'm curious what the problem with the fastsearch filename might be.

Mark Carey [TypeKey Profile Page]

Posts: 150

Reply: 66



PostPosted: January 10, 2007 8:32 AM 

Hi Laura, I am not sure exactly why you were/are having problems with the fastsearch filename. The error on your site suggests that MT does not have a record of that dynamic index. Usually, a rebuild of all indexes will solve this kind of a problem. In my experience, you can name the output file anything at all (as long as you point the search form at it) and it will work.

Alvin

Posts: 2

Reply: 67



PostPosted: January 14, 2007 2:50 AM 

I'm trying to use a checkbox with php to determine which blog to include in the search. I've tried the following but it doesn't seem to work:

<MTSearchResults blogs="<? php echo $blog_id; ?>"<

I've checked and verified that $blog_id is indeed valid and it contains the right values.

Am I not doing it correctly or is this method not supported?

Aaron [TypeKey Profile Page]

Posts: 3

Reply: 68



PostPosted: January 14, 2007 3:50 PM 

I'm having a weird problem--- I can either change the sort order to "date" or restrict the category, but if I try to do both at once it doesn't work.

http://www.tuftsobserver.org/fs?blogs=1&query=jumbo&category=1
(default sort, category restriction works)

http://www.tuftsobserver.org/fs?blogs=1&query=jumbo&category=1&order=date
(added &order=date, suddenly the category restriction stops working)

Any ideas?

Mark Carey [TypeKey Profile Page]

Posts: 150

Reply: 69



PostPosted: January 14, 2007 5:21 PM 

Aaron, you are the first person to report this issue, and indeed it is a bug. It should be fixed in v1.55 which I have just released. Download here.

Alvin, I don't think that method will work. (However, you might try <MTSearchResults blogs="{{$blog_id}}">). I am not sure what you mean by "trying to use a checkbox" and how that relates to the $blog_id variable you are using. Perhaps you can elaborate and/or provide a link to your search form.

Alvin [TypeKey Profile Page]

Posts: 2

Reply: 70



PostPosted: January 14, 2007 9:16 PM 

Hi Mark,

Here's my idea. I've added a few checkbox where each checkbox is "tied" to a blog id.

For example:
<input type="checkbox" name="blog1" value="1">Blog 1<br />
<input type="checkbox" name="blog2" value="2">Blog 2<br />

On form submit (post method), a php script will check which checkbox is checked and get the values of the checkbox accordingly. Assuming that only Blog 1's checkbox is checked, a value of 1 will be stored into the variable $blog_id.

Thus, instead of specifying <MTSearchResults blogs="1,2"> .. I would want it to read the blogs="" values from variable $blog_id.

I have tried the suggested method you mentioned but it doesn't works. All it returned was {{MTSearchResults blogs="{{1,2}}"}} and it can be seen on the HTML page itself.

Aaron [TypeKey Profile Page]

Posts: 3

Reply: 71



PostPosted: January 15, 2007 4:09 PM 

Is there a way to make it return only hits that match ALL the words in a multi-word query, rather than matching ANY (one or more) of the words? I'm using the "fulltext" method.

Mark Carey [TypeKey Profile Page]

Posts: 44

Reply: 72



PostPosted: January 31, 2007 12:49 PM 

Alvin, here's what I would do. After your php script checks the checked boxes and stores the (comma-separated) result in the $blog_id variable, then redirect the user to the search results page while including the value of 'blogs' in the URL:

/fastsearch?query=foo&blogs=$blog_id

If you redirect the user to a URL like this, you don't need to include the 'blogs' argument in the <MTSearchResults> tag at all. Let me knwo if this approach meets your needs.

Aaron, to answer your question, enclosing the phrase in quotes will search for that specific phrase (words in the same order as your query).

Aaron

Posts: 3

Reply: 73



PostPosted: January 31, 2007 2:50 PM 

Alvin,

I know how to use the quotation marks, what I was wondering is how to search for two words that are NOT a phrase, but that both appear on the page. Right now if I search for 'john doe' (no quotes) I'll get pages that have either 'john' or 'doe' somewhere in them--- what I want is to only get pages that have both 'john' and 'doe' (but not necessarily next to each other). Thanks.

Mark Carey [TypeKey Profile Page]

Posts: 44

Reply: 74



PostPosted: February 1, 2007 8:01 AM 

Aaron, no, this version does not support this. A future version may support the use of AND and OR operators in the search query.

jane

Posts: 1

Reply: 75



PostPosted: February 2, 2007 2:27 AM 

I would like to 2nd Aaron's suggestion for ANDed searches. In fact I would go further and say it is vital and is what people expect as this is the default behavior of google, itunes, spotlight, and now vista's search box. Without this the search seems wimpy and unprofessional.

At a minimum I believe users expect the following:

search input: red blue
returns pages with red AND blue

search input: "red blue"
returns pages with the phrase "red blue"

search input: red or blue
returns pages with either red or blue or both

bonus:

search inputt: red not blue
returns pages with red but not blue

darkmoon

Posts: 23

Reply: 76



PostPosted: February 5, 2007 5:13 PM 

hrm... weird. I'm getting a fastsearch: 404 error. I followed it pretty much to the T, but I don't see it creating the dynamic publishing. I even turned on the dynamic bootstrapper and rebuilt the site like ten times.

darkmoon

Posts: 23

Reply: 77



PostPosted: February 7, 2007 6:11 AM 

Figured out the issue. Dynamic bootstrapper was getting created dynamically. You don't want to do that.

Jake [TypeKey Profile Page]

Posts: 10

Reply: 78



PostPosted: February 19, 2007 7:09 PM 

Posting a comment here, even though this happened in old versions, too.

First off, Mark, I've already professed my love of this plugin, so we'll move past that, shall we? Wink

Anyhow, I don't know if I'm doing something wrong here. My install's setup at www.utterlyboring.com/fastsearch . Every thing's running fine, but my question is thus: When I just load that URL into my browser, it appears to run a query on the database and pulls up all my entries, not pulling up my MTNoSearch tag like it should (actually, it DOES pull that up, it just still runs the query as well). Am I missing something really obvious here so I can keep the query count down a tad when I just want to load the page to get to the search form?

My template is here: utterlyboring.com/fastsearch.txt

Thanks!

Mark Carey [TypeKey Profile Page]

Posts: 150

Reply: 79



PostPosted: February 19, 2007 8:07 PM 

Jake, you're not doing anything wrong Wink You are, on the other hand do something I didn't expect, by linking to directly to the fast search script. That said, it turns out you are not the only one. I guess it does work well if you want to simply link to a page with the search form. When this was reported to me a few weeks ago, I realized that there was a minor bug that causes this when you are using the "Fallback" search mode. In any case, I fixed this a few weeks ago, and you have just reminded me that I haven't realized the fix publicly. So, here ya go. Version 1.57 has this fix. Download here.

Jake [TypeKey Profile Page]

Posts: 10

Reply: 80



PostPosted: February 20, 2007 1:06 PM 

That fixed it (as I was using Fallback). Thanks as always, Mark!

Chris

Posts: 2

Reply: 81



PostPosted: March 2, 2007 4:34 PM 

I have been looking for a way to display search results from multiple blogs together for so long!!! This is great. The only thing that is keeping me from using this plugin now is the lack of a way to search for tags.. We use tags extensively on our site to create custom pages (and we do most of this using search templates, although this isn't visible to the user) any idea how far out tag search is!?! I'm ready to buy as soon as this feature is in (please tell me its soon Smile also, comment search would be great, but we don't have a lot of comments yet, so this isn't so much a big deal.

Keep up the great work!

Mark Carey [TypeKey Profile Page]

Posts: 150

Reply: 82



PostPosted: March 3, 2007 7:06 AM 

Thanks for the input, Chris. I do plan to add both tag search and comment search. From the feedback I have received, more people want tag search, so I will that a higher priority. Its definitely one of my goals for FastSearch 2.0. I don't get have an release date estimate. Any other feature suggestions are appreciated.

Chris

Posts: 2

Reply: 83



PostPosted: March 3, 2007 12:38 PM 

Thanks Mark.. Ugh, its the waiting that sucks the most, hopefully we'll see a 2.0 soon

Marleen Zachte

Posts: 4

Reply: 84



PostPosted: March 3, 2007 11:07 PM 

I have just installed FastSearch (version .5Cool and receive the following error message, when I execute a search, using the default template:

SQL/DB Error -- [Unknown column 'mt_entry.entry_id' in 'on clause']

Any idea what might cause this?

Mark Carey [TypeKey Profile Page]

Posts: 150

Reply: 85



PostPosted: March 4, 2007 6:22 PM 

Hi Marleen,

Can you provide some additional details:

version of MT?
version of mySQL?
Fast Search settings?
Can you provide a link to your fast search results?

Marleen

Posts: 4

Reply: 86



PostPosted: March 4, 2007 9:13 PM 

Hi Mark,

MT version: 3.3
mySQL version: 4.0.25-standard
Fast Search setting: I started with Fulltext, tried Fallback and Non-fulltext as well, which made no difference. I haven't made any alterations to the default fastsearch template yet. Link:
http://www.gemm.nl/fastsearch

Mark Carey [TypeKey Profile Page]

Posts: 150

Reply: 87



PostPosted: March 5, 2007 7:15 AM 

Marleen,

That is very strange. To my knowledge, no one else has had this problem. 'mt_entry.entry_id' is a standard table.field. By any chance, are you using a differerent prefix for the tables in the MT database (ie. mt3_author, mt3_entry, etc.)?

Marleen Zachte

Posts: 4

Reply: 88



PostPosted: March 5, 2007 8:38 AM 

Just my luck Wink

I haven't changed any table names and I can see mt_entry.entry_id in PhpMyAdmin.

In your instructions you state: "The Fast Search upgrade process will update your database to add a fulltext index to the table in your database where entries are stored."

How can I check this index has indeed been added?

Mark Carey [TypeKey Profile Page]

Posts: 150

Reply: 89



PostPosted: March 5, 2007 4:11 PM 

Marleen, you can use the "show index" mysql command to list the indexes from a table. Via phpMyAdmin, go to SQL, then:

show index from mt_entry

I am not sure what else to suggest. I am not aware of any incompatibilities with that version of mySQL.

Marleen Zachte

Posts: 4

Reply: 90



PostPosted: March 5, 2007 9:54 PM 

I've checked and the fastsearch index is in the database, so the installation must have gone well. I deinstalled, removed and then reinstalled the plugin, upgraded MT to 3.4, rebuilt all files, but still the same result.
I guess there's a small plugin demon hunting me lately. But thanks for looking into it, anyway, Mark.

David Chiu

Posts: 3

Reply: 91



PostPosted: March 14, 2007 3:04 AM 

I'm experiencing the same error:
SQL/DB Error -- [Unknown column 'mt_entry.entry_id' in 'on clause']

...using FastSearch v2.02, MySQL - 5.0.24a, MT 3.34. Could this possibly be a FastCGI issue?



Subscribe to this discussion: Email | RSS

Join the conversation:









Remember personal info?





Very Happy Smile Sad Surprised
Shocked Confused Cool Laughing
Mad Razz Embarassed Crying or Very Sad
Evil or Very Mad Twisted Evil Rolling Eyes Wink
Powered by MTSmileys
Check to Subscribe to this Comment:
(email field must be filled in)



Subscribe Without Commenting
















Creative Commons License
This weblog is licensed under a Creative Commons License.