Adding comments to static pages broken

I'm probably the last person to notice and report this, but here goes

anyway... I noticed there haven't been any comments on static pages

for the past few days, which is very unusual. So I tried to add a

comment myself, and got this lovely Oracle error as a reply:

<p>

<pre>

Error in inserting comment

There was an error in inserting your comment into the database.

Here is what the database returned:

ora8.c:4965:lob_dml_cmd: error in `OCIStmtExecute ()': ORA-04098:

trigger 'PHOTONET.COMMENTS_SWS_INSERT_TR' is invalid and failed

re-validation

SQL: insert into comments

(comment_id,page_id, user_id, comment_type, message, rating,

originating_ip, posting_time, html_p)

values (346304,11061, 22693, 'alternative_perspective', empty_clob(),

'', '213.84.88.81', SYSDATE, 'f')

returning message into :1

Don't quit your browser. The database may just be busy. You might be

able to resubmit your posting five or ten minutes from now.

webmaster@photo.net

</pre>

Hope this helps.

The SITE_WIDE_INDEX was obsolete, having been replaced by a different mechanism for site wide search. We deleted it, but apparently we missed some of the old triggers. I fixed this.

I think some of the site-wide-search features in the Admin area and various other "secret" parts of photo.net known only to old-timers were also using the SWS index, and are now also broken. (Actually they were actually pretty broken before -- they just didn't look it.)