 |
mgdamore
User
Oct 27, 2006, 5:25 PM
Post #1 of 8
(883 views)
Shortcut
|
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
(869 views)
Shortcut
|
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
(867 views)
Shortcut
|
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 30, 2006, 3:20 PM
Post #6 of 8
(824 views)
Shortcut
|
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
|
|
| |
|
Dave
Staff
/ Moderator
Oct 30, 2006, 3:39 PM
Post #7 of 8
(823 views)
Shortcut
|
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
(820 views)
Shortcut
|
Thanks! That seems to have done the trick
Now if we can just get that server of mine under control...
;-)
- Mike
|
|
| |
|
