error using old walk database with new "group-by" dowalk script

Post Reply
edev
Posts: 127
Joined: Wed Sep 14, 2005 5:10 pm

error using old walk database with new "group-by" dowalk script

Post by edev »

Hi,

we just purchased new dowalk and search script to include the "group-by" functionality in our license, and I tried to use both new scripts with one of our old walk data, but got the following error:

Test mode (CultureCa_testAllb) - Back to Administration - Make this appearance live
175 /webinator/search-ch:2032: Table entity not found in data dictionary
115 /webinator/search-ch:2032: No such table: entity in the database: D:\CultureCaWalks\CultureCa_testAllb\db2\
000 /webinator/search-ch:2032: SQLExecute() failed with -1
175 /webinator/search-ch:2079: Table urls not found in data dictionary
115 /webinator/search-ch:2079: No such table: urls in the database: D:\CultureCaWalks\CultureCa_testAllb\db2\
000 /webinator/search-ch:2079: SQLExecute() failed with -1
175 /webinator/search-ch:2079: Table urls not found in data dictionary
115 /webinator/search-ch:2079: No such table: urls in the database: D:\CultureCaWalks\CultureCa_testAllb\db2\
...

The "Result Per Site" max setting is 3, however the results page only shows one site URL and the link to "see more results from...".

I have over 1 million records in my old walk data and I really want to keep using it. Is there anything I can do to get rid of the error? Thanks.
edev
Posts: 127
Joined: Wed Sep 14, 2005 5:10 pm

error using old walk database with new "group-by" dowalk script

Post by edev »

Forgot to add I'm also seeing "Inxight Server Name" under dowalk settings, what does that do?
edev
Posts: 127
Joined: Wed Sep 14, 2005 5:10 pm

error using old walk database with new "group-by" dowalk script

Post by edev »

Thank you John, it worked!

I was hoping to use my old search script since it was customized. I copied every function I thought that had to do with group-by from the new search script to the old search script, including <resultspersiteinit>,<setupsitequery>,<resultspersiteok>,<showresults>,<results>,
<resultspersiteadd>, and changed the settings on the walk profile, but I'm not getting the results. Is there an obvious setting that I missed?
edev
Posts: 127
Joined: Wed Sep 14, 2005 5:10 pm

error using old walk database with new "group-by" dowalk script

Post by edev »

Thanks John, it worked!
edev
Posts: 127
Joined: Wed Sep 14, 2005 5:10 pm

error using old walk database with new "group-by" dowalk script

Post by edev »

Ok now I have another problem:

it seems like doesn't matter how many results are obtained from the same site, the link "more results from..." is always displayed. Idealy, I would like to set the Max result per site to 2, and if only 2 results came from that site, I don't want to display the "more results from..." link. Is there a way to calculate how many results are from the same URL, and display the count beside the parent link as well?

Thanks...
edev
Posts: 127
Joined: Wed Sep 14, 2005 5:10 pm

error using old walk database with new "group-by" dowalk script

Post by edev »

Thank you John. My question is how does the result number reflect the actual total results then? When I click on "more results from...", it performs a search within the existing result set for all matching parent URLs? so whatever number I have as a total result number includes all "children" urls when you click on "more results"? And if that's true, what happens if there are not more results within this web url and you click on "more results from"? Right now the search just hangs and keeps loading forever.
User avatar
mark
Site Admin
Posts: 5519
Joined: Tue Apr 25, 2000 6:56 pm

error using old walk database with new "group-by" dowalk script

Post by mark »

Works for me as they say. Are you perhaps searching for common term that occurs on a ton of pages in the one site?
Try turning on fast result counts.
edev
Posts: 127
Joined: Wed Sep 14, 2005 5:10 pm

error using old walk database with new "group-by" dowalk script

Post by edev »

Thanks Mark,

I did try fast result count and it seems to be faster.
I also want the format result style of the children links to be different than the parent one. Right now all links are displaying using the same result style, is there anything I can change in the <result> function to make $RpsMoreResultsHTML use a different style?

I'm not sure how to change the line below to reflect a new result style.
<if 8 neq $SSc_resultstyle> <!-- not XML output -->
<send $RpsMoreResultsHTML><$RpsMoreResultsHTML = >
</if>

I tried setting <$SSc_resultstyle = resultMore> where I created <a name=resultMore> as the new style but it didn't work...
User avatar
mark
Site Admin
Posts: 5519
Joined: Tue Apr 25, 2000 6:56 pm

error using old walk database with new "group-by" dowalk script

Post by mark »

That's the html that surrounds the persite results. It doesn't control the style of the individual results. You could change

<switch $SSc_resultstyle>
...
</switch>

to something like

<if 1 ge $RpsCount>
<switch $SSc_resultstyle>
...
</switch>
<else>
<resultConcise>
</if>
edev
Posts: 127
Joined: Wed Sep 14, 2005 5:10 pm

error using old walk database with new "group-by" dowalk script

Post by edev »

Thank you Mark, it worked!
Post Reply