Thunderstone Support Forums

Very odd, instead of
Name='SSc_walking'
try
Name matches '%walking%'

Or try reversing the Name and Profile clauses (Name first, Profile second).

OK, using the matches operator ("select Name,String from options where Profile='profilename' and Name matches '%walking%'") returns the data. Unfortunately, if I try to use that operator in a delete statement ("delete from options where Profile='profilename' and Name matches '%walking%'"), I get the following errors:

006 Cannot delete value (SSc_walking) from index /INSTALLDIR/texis/testdb/xoptname.btr
006 Cannot delete value (23219) from index /INSTALLDIR/texis/testdb/xoptstr.btr

Ahah, there's the problem. That index is apparently messed up. That would explain not finding the value. Drop and recreate that index. Let's do a related one as well. Create a file containing the script below. Call it "fixindex" with no extension. Run it with
texis fixindex

<script language=vortex>
<a name=main>
<sql "drop index xoptname"></sql>
<sql "drop index xoptstr"></sql>
<sql "create index xoptname on options(Name)"></sql>
<sql "set max_index_text=128"></sql>
<sql "create index xoptstr on options(String)"></sql>
</a>
</script>

Mark,

Do I need to specify the profile for the fixindex script?

No. The options table contains all profiles and exists in the global database.

Ok, ran the script, but it resulted in a Timeout error.

I guess your options table is rather large. Add
<timeout=-1></timeout>
just below the
<script language=vortex>
line.

That's the ticket. Script finished that time.

Now, getting back to the original problem of never-ending walks. Should I try to run a replace walk on this same profile to clean out anything left over from the obviously corrupt walk?

Probably not a bad idea.

Just as a follow-up: a "new" walk ran smoothly and the profile in question is running better than it has in a long time.

Many thanks for helping to sort this out.