can't insert to or delete from querylog

[Thunderstone]

Hello,

My search script stopped working the other day. The error
message told me the problem was at the step where it
inserts into querylog. (This had been working fine before.)

I diked out the inserts and got my search page working
again.

Then, wondering if the querylog table had gotten too big
(it's about 500k), I wanted to try emptying it out. I did a
select to a file with no problem to archive the data. But
when I tried to delete the records, I got this:

bash-2.00$ gw -r- -d- -st "delete from querylog"
000 Got signal 11 - quitting now

Any thoughts? This is 2.1, on Solaris.

Thanks --


Wade Leftwich <wade@demographics.com>
American Demographics / Marketing Tools, a division of Cowles Business Media
tel 607-273-6343 fax 607-273-3196 http://www.demographics.com/

[Thunderstone]

You can drop and recreate the table. First, use the texis cgi program
from the command line to drop the table (gw won't let you do it).
texis -s -d db -u _SYSTEM "drop table querylog"
(replace "db" with the path/name of your database)

Then issue a -create with gw. It will leave your existing tables
alone and recreate any missing ones (the querylog).
gw -d db -create