[Openinteract-help] problem logging errors

[John S. <js...@me...>]

Error logging on my system is croaking because of non-unique keys generated
on insert.  Here's a log trace  for your perusal:

SPOPS::DBI::_save_insert (650) >> Insert failed! Args:  $VAR1 = {
          'db' => bless( {}, 'Apache::DBI::db' ),
          'no_quote' => {},
          'DEBUG' => 0,
          'table' => 'sys_error',
          'field' => [
                       'filename',
                       'notes',
                       'browser',
                       'type',
                       'user_msg',
                       'user_id',
                       'code',
                       'system_msg',
                       'session_id',
                       'referer',
                       'line',
                       'url',
                       'package',
                       'action',
                       'error_time',
                       'error_id'
                     ],
          'value' => [
                       'c:/src/www1/tmplib/Celebrity/Handler/Page.pm',
                       '',
                       'Mozilla/4.0 (compatible; MSIE 5.0; Windows 2000)
Opera 6.0  [en]',
                       'n/a',
                       'Requested file not found or cannot be opened',
                       '1',
                       314,
                       '/intra_menu.html',
                       '6ef2f7dbd4dd355c1b03f74d991fc2bd',
                       'http://127.0.0.1/NoTmpl/intra_menu',
                       210,
                       '/intra_menu.html',
                       'Celebrity::Handler::Page',
                       'n/a',
                       '2001-12-17 ',
                       'AOFVPMJXVTEW'
                     ],
          'return_sth' => 1
        };
 Error: DBD::mysql::st execute failed: Duplicate entry 'AOFVPMJXVTEW' for
key 1 at C:/Perl/site/lib/SPOPS/SQLInterface.pm line 309.

Celebrity::ErrorObject::fail_save (146) >> Error written out to
<<c:/src/www1/error/AOFVPMJXVTEW>>
 Cannot save error 314: Error saving record to database at
C:/Perl/site/lib/SPOPS/DBI.pm line 653.
 at C:/Perl/site/lib/OpenInteract/Error/System.pm line 234

Any thoughts on a workaround?


John Sequeira
http://www.pobox.com/~johnseq
jo...@po...