search extra fields - solution

[cruci]

No idea if this is the cleanest way of doing this, but it seems to work.

In your /libs/search.php file, look for first line, and then replace as appropriate with this:

if($SearchMethod == 1){
$where = " AND MATCH (link_url, link_url_title, link_title, link_content, link_tags, link_field1, link_field2, link_field3, link_field4, link_field5, link_field6, link_field7, link_field8) AGAINST ('$words' $mode) ";
}
if($SearchMethod == 2){
$where = " AND (link_url like '%$words%' or link_url_title like '%$words%' or link_title like '%$words%' or link_content like '%$words%' or link_tags like '%$words%' or link_field1 like '%$words%' or link_field1 like '%$words%' or link_field2 like '%$words%' or link_field3 like '%$words%' or link_field4 like '%$words%' or link_field5 like '%$words%') ";
}
}
return $where;

Pretty wordy, but it works for me. I'm not really sure about the difference between search method 1 and 2 (above it mentions something about using method 2 if there are less than 4 characters in the query, but mine seemed to always use method 2), but you can see that it's really just a matter of adding the extra fields into the list of columns that the search looks through.

I have added 8 extra fields to search method 1, but only 5 to search method 2 because it was more work ;> You can of course add as many or as few as you want.

[cruci]

Hmm, found a problem, it doesn't search across fields. So you can't look for a term in field 2 as well as a term in field 3.

I wonder if it is to do with the "or" above. To my logic (Actionscript etc) it needs to be some sort of "and or".

Any PHP guru want to chime in?

I should point out that this is true with the default code, eg if you try to search for a tag & a title (assuming that the tag isn't in the title and vice versa) you will get no results. If you search for either one, you will get results.

[kanedaguy]

I get this error with this edit of search.php

SQL/DB Error -- [Can't find FULLTEXT index matching the column list]

SQL/DB Error -- [Can't find FULLTEXT index matching the column list]

[kanedaguy]

anybody know what i could do to search extra field 1?

[kbeeveer46]

It doesn't really help you now but the next version of Pligg will search all extra fields automatically. thank Ash for this.

[michael12happy]

I used pligg 9.0.1
On the admin,
I select
"3 = is a hybrid, using method 1 if possible, but method 2 if needed."

I just added the extra fields
but the
SQL/DB Error -- [Can't find FULLTEXT index matching the column list]
still occurs
any expert to share some tips ?

[michael12happy]

<code>define('Enable_Extra_Field_1', true);
define('Field_1_Title', 'extra field 1');
define('Field_1_Instructions', 'write your extra field 1.');
define('Field_1_Searchable', true);
//the variables below are not yet used in version 6.02.
define('Field_1_Required', true);
define('Field_1_Validation_Method', '');
define('Field_1_Validation_Error_Message', '');
</code>

Although I select "searchable" as true,
SQL/DB Error -- [Can't find FULLTEXT index matching the column list] still appears.

On http://abetter2007.com/story.php?tit...-story-title-2
I've added one extra field : "extra field 1"
extra field 1: result or outcome for extra field

When I search "result" or "result or outcome" or "result or outcome for extra field"
SQL/DB Error -- [Can't find FULLTEXT index matching the column list] still appears.

Please advise

[tangmonkey]

I just wanted to point out that for the above method to work you need to change Field_X_Searchable to 'true' in /libs/extra_fields.php and change your search method to 2 in admin