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

edev · Post by **edev** » Fri Apr 13, 2007 10:34 am

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

Table entity not found in data dictionary
115 /webinator/search-ch

No such table: entity in the database: D:\CultureCaWalks\CultureCa_testAllb\db2\
000 /webinator/search-ch

SQLExecute() failed with -1
175 /webinator/search-ch

Table urls not found in data dictionary
115 /webinator/search-ch

No such table: urls in the database: D:\CultureCaWalks\CultureCa_testAllb\db2\
000 /webinator/search-ch

SQLExecute() failed with -1
175 /webinator/search-ch

Table urls not found in data dictionary
115 /webinator/search-ch

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 · Post by **edev** » Fri Apr 13, 2007 10:37 am

Forgot to add I'm also seeing "Inxight Server Name" under dowalk settings, what does that do?

Post by **John** » Fri Apr 13, 2007 12:33 pm

Take out the call to <collectentityresults> from the search script, you can also remove the collectentityresults function. The Inxight Server setting was accidentally included in the scripts we sent, and will not do anything without additional software.

edev · Post by **edev** » Fri Apr 13, 2007 4:31 pm

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?

Post by **John** » Fri Apr 13, 2007 4:53 pm

The collectlocalresults function also needs to be copied as it is the one that collects up results into the groups.

edev · Post by **edev** » Mon Apr 16, 2007 11:55 am

Thanks John, it worked!

edev · Post by **edev** » Mon Apr 16, 2007 12:41 pm

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...

Post by **John** » Mon Apr 16, 2007 1:35 pm

No, as that would require checking through the entire result set for every site to ensure there are no more results.

edev · Post by **edev** » Mon Apr 16, 2007 1:47 pm

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.

Post by **mark** » Mon Apr 16, 2007 2:54 pm

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.