Main
Index 		Search
Posts 		Who's
Online 		Log
In

Home: Discontinued/Classic Products: Article Manager 2:
Search Error?

 
 


mgdamore
User

Oct 27, 2006, 5:25 PM

Post #1 of 8 (1952 views)
Shortcut
Search Error? Can't Post
I really need to search a specfic field in order for the results to turn out correctly. So, I'm trying to convert my "simple" search link from 1.x - but I am getting the following error:

Error: couldn't find field 'Source' in table 'lvn_article'! at (eval 77) line 7, <DATA> line 181.

My link code is:

"$settings.searchurl$?&action=search&keywordSearchFields=Source&keyword=$article.art_field1$">Click Here</a> for more news from $article.art_field1$


If I change "Source" to "art_field1" - there is an error shown in the status bar before I even start the search.

Suggestions?

- Mike


Theo
Project Manager / Moderator


Oct 28, 2006, 10:23 AM

Post #2 of 8 (1938 views)
Shortcut
Re: [mgdamore] Search Error? [In reply to] Can't Post
Instead of art_field1, try article.art_field1 - the syntax was changed in Article Manager 2, so the placeholders were converted appropriately.


Theo Wiersma
Project Manager


mgdamore
User

Oct 28, 2006, 12:00 PM

Post #3 of 8 (1936 views)
Shortcut
Re: [Theo] Search Error? [In reply to] Can't Post
In Reply To
Instead of art_field1, try article.art_field1 - the syntax was changed in Article Manager 2, so the placeholders were converted appropriately.

Theo;

If I use article.art_field1 I get:

Error: couldn't find field 'article.art\_field1' in table 'lvn_article'! at (eval 77) line 7, <DATA> line 181.

If I use "$" - i.e. $article.art_field1$ the search string is definitly wrong...

http://www.lasvegas-tsg.com/cgi-bin/nevada/search.cgi?&action=search&keywordSearchFields=Station%20Casinos,%20Inc.&keyword=Station%20Casinos,%20Inc.

and of course I end up with:

Error: couldn't find field 'Station Casinos' in table 'lvn_article'! at (eval 77) line 7, <DATA> line 181.

BTW: I am testing this from the preview screen on an individual article - of which I know what the results should be. That should be OK...no?

- Mike


(This post was edited by mgdamore on Oct 28, 2006, 12:01 PM)


Damon
Staff / Moderator


Oct 28, 2006, 1:01 PM

Post #4 of 8 (1929 views)
Shortcut
Re: [mgdamore] Search Error? [In reply to] Can't Post
Hi Mike,

Here is the correct search query:

http://www.lasvegas-tsg.com/cgi-bin/nevada/search.cgi?action=search&fields=article.art_field1&keyword=Station%20Casinos,%20Inc.

I tested this and it seems to work.

Also, it's better to test on a published page or by just entering the search query into the browser address field directly instead of testing with a preview page.

I hope that helps. Let us know if you have any other questions. :)

--------------------------------------------------- 
Cheers
Damon Edis
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/


mgdamore
User

Oct 28, 2006, 3:14 PM

Post #5 of 8 (1925 views)
Shortcut
Re: [Damon] Search Error? [In reply to] Can't Post
In Reply To
I tested this and it seems to work.

Damon;

Yes - the search in and of itself does work, however, the results should only reflect those articles in which the "Source" - art_field1 = Station Casions Inc.

Now I realize that most results should reflect "Station + X" but, there are many that don't even start with "Station"

- i.e. the third one from the top Source =

Source: Las Vegas Monorail Co.

4th result...

Source: Fitch Ratings

NOTE: These articles do in fact have the word "station" within the body - but NOT within art_field1. Which leads me to say that the search "doesn't work." As the results reflect both art_feild1 OR the description field - which is not what I'm looking for.

- Mike


Damon
Staff / Moderator


Oct 30, 2006, 3:20 PM

Post #6 of 8 (1893 views)
Shortcut
Re: [mgdamore] Search Error? [In reply to] Can't Post
Hi Mike,

After doing some testing it seems that if the author field (or art_field1) is set to memo instead of string as the Stored As option (in Admin > Database Editor - edit table & feilds for articles), the search by field query doesn't match any results.

We are looking into this further right now and I will post again as soon as we determine the best way to get this working the way it should.

--------------------------------------------------- 
Cheers
Damon Edis
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/


Dave
Staff / Moderator


Oct 30, 2006, 3:39 PM

Post #7 of 8 (1892 views)
Shortcut
Re: [mgdamore] Search Error? [In reply to] Can't Post
Looks like you're right. There's seems to be an issue when keywordSearchFields have underscores in their names.

I was just working on your server from an earlier support request you submitted so I've upgraded your search.cgi with a fixed version and also updated your searchResults.html templates to added the keyword and keywordSearchFields to the "prev" and "next" links so they'd get passed forward for the subsequent search result pages.

The link should work now:
http://www.lasvegas-tsg.com/cgi-bin/nevada/search.cgi?&action=search&keywordSearchFields=art_field1&keyword=Station%20Casinos,%20Inc.

Hope that helps. Let us know if you run into anything else.

Edit: Fixed typo in link

Dave Edis - Senior Developer
interactivetools.com
 

(This post was edited by Dave on Oct 30, 2006, 5:38 PM)


mgdamore
User

Oct 30, 2006, 4:35 PM

Post #8 of 8 (1889 views)
Shortcut
Re: [Dave] Search Error? [In reply to] Can't Post
Thanks! That seems to have done the trick

Now if we can just get that server of mine under control...

;-)

- Mike