Thunderstone Support Forums

I installed version 4 of Texis on our Sparc-Solaris server. Texis worked fine, but my old Webinator search scritps did not. I thought they would continue to work without modification. Did I miss something in the upgrade notes or readme?

Thanks,
David

They should generally work. In what way did they not?
Try viewing the source of a search results page and look for errors/warnings within html comments.

The error occurred at the line where main query is executed. The script itself runs, but all searches showed no results.

100 Jul 25 18:12:37 /webinator/search:484: Call failed length in the function Evaluate

Another question: can I upgrade Texis without upgrading Webinator? It appears you can tweak the install script to do that. However, I would like to be able to upgrade Webinator later without having to upgrade Texis again.

OK, I upgraded Texis w/o Webinator on my development server and it worked fine, except that I had to chown morph3/texis/testdb/SYSSCHEDULE.tbl to the user running Texis. This may be because I am running the install as root.

Yes, the install is supposed to be run as the DBA or the installation will ask for the account name of the DBA when installing as root so that it can make the programs setuid to the DBA.

As long as you have a recent Texis upgrading webinator is mostly a matter of installing new scripts which can be found in the webinator directory under your installation directory.

I am still having this problem with my Webinator search script:

<!-- 100 /webinator/search:484: Call failed length in the function Evaluate -->

Line 484 is:

<SQL ROW SKIP=$jump MAX=10
"select 'http://' + Url Url, Depth, Title, Body, length(Body) Size,
id, $$rank r
from html
where Title\Meta\Body likep $q
and Title like $tq
and Url matches $uq
and Depth <= $dq
">

which I assume is unchanged from the default 2.x script.

Here's the output with TRACESQL turned on:

<!-- 202 /webinator/search:476: select 1 x from SYSDUMMY where `information' = '' and `' = ''; -->
<!-- 202 /webinator/search:305: set likeprows=200; -->
<!-- 202 /webinator/search:309: set likepallmatch=1; -->
<!-- 202 /webinator/search:485: select 'http://' + Url Url, Depth, Title, Body, length(Body) Size, id, $rank r from html where Title\Meta\Body likep `information' and Title like [no arg] and Url matches [no arg] and Depth <= [no arg] ; -->
<!-- 100 /webinator/search:485: Call failed length in the function Evaluate -->

Try changing
length(Body)
to
length(convert(Body, 'varchar' ))

That worked. Thanks!

One last thing. I'd like to confirm that our old gw scripts will continue to work without modification. As I said, we'll probably upgrade Webinator later, but want to get Texis dbs going first.