System error

error:  DBIx::SQLEngine Query failed: select n.*, to_char(n.pub_date,'Month DD, YYYY') as full_date,
to_char(n.mod_date,'Month DD, YYYY HH12:MI AM') as mod_date_text,
u.alias as author, m.link, m.url,
n.url as st_url, q.cat_id as topic, r.name as topic_name, a.votes,
g.geo_id as geo_id, lower(gf.common_name) as common_name
from user_db u, story n
left outer join story_geo g on (g.story_id=n.story_id)
left outer join ct_geo_categories gf on (g.geo_id=gf.cat_id)
left outer join vote_tally a on (a.item=n.story_id)
left outer join story_resources m on (n.story_id=m.story_id)
left outer join story_category q on (n.story_id = q.story_id)
join ct_categories r on (r.cat_id=q.cat_id)
where n.story_id='C198DB6...0-F3337A10A9B7' and n.uid=u.uid
and pub_stat='p' order by m.disp_order asc, m.link asc


DBD::Pg::st execute failed: ERROR: invalid input syntax for uuid: "C198DB6...0-F3337A10A9B7"
LINE 13: where n.story_id='C198DB6...0-F3337A10A9B7' and n.uid=u...
^

context: 
... 
3587:  };
3588:  if ( my $error = $@ ) {
3589:  my $catch = $self->catch_query_exception($error, @_);
3590:  if ( ! $catch ) {
3591:  die "DBIx::SQLEngine Query failed: $_[0]\n$error\n";
3592:  } elsif ( $catch eq 'OK' ) {
3593:  return;
3594:  } elsif ( $catch eq 'REDO' ) {
3595:  if ( $attempts < 5 ) {
... 
code stack:  /usr/local/lib/perl5/site_perl/5.8.5/DBIx/SQLEngine/Driver.pm:3591
/usr/local/lib/perl5/site_perl/5.8.5/CT/Net.pm:180
/usr/local/lib/perl5/site_perl/5.8.5/CT/Showstory.pm:2010
/common/www/html/read/story/show_story.html:100
/common/www/html/read/story/autohandler:72
/common/www/html/read/autohandler:101
raw error






























DBIx::SQLEngine Query failed:     select n.*, to_char(n.pub_date,'Month DD, YYYY') as full_date,
    to_char(n.mod_date,'Month DD, YYYY HH12:MI AM') as mod_date_text,
u.alias as author, m.link, m.url,
    n.url as st_url, q.cat_id as topic, r.name as topic_name, a.votes, 
            g.geo_id as geo_id, lower(gf.common_name) as common_name
    from user_db u, story n 
    left outer join story_geo g on (g.story_id=n.story_id)
    left outer join ct_geo_categories gf on (g.geo_id=gf.cat_id)
    left outer join vote_tally a on (a.item=n.story_id)
    left outer join story_resources m on (n.story_id=m.story_id) 
    left outer join story_category q on (n.story_id = q.story_id)
    join ct_categories r on (r.cat_id=q.cat_id)
    where n.story_id='C198DB6...0-F3337A10A9B7' and n.uid=u.uid  
     and pub_stat='p'    order by m.disp_order asc, m.link asc


DBD::Pg::st execute failed: ERROR:  invalid input syntax for uuid: "C198DB6...0-F3337A10A9B7"
LINE 13:      where n.story_id='C198DB6...0-F3337A10A9B7' and n.uid=u...
                               ^



Trace begun at /usr/local/lib/perl5/site_perl/5.8.5/HTML/Mason/Exceptions.pm line 129
HTML::Mason::Exceptions::rethrow_exception('DBIx::SQLEngine Query failed: ^I    select n.*, to_char(n.pub_date,\'Month DD, YYYY\') as full_date,^J^I    to_char(n.mod_date,\'Month DD, YYYY HH12:MI AM\') as mod_date_text,^J^Iu.alias as author, m.link, m.url,^J^I    n.url as st_url, q.cat_id as topic, r.name as topic_name, a.votes, ^J            g.geo_id as geo_id, lower(gf.common_name) as common_name^J^I    from user_db u, story n ^J^I    left outer join story_geo g on (g.story_id=n.story_id)^J^I    left outer join ct_geo_categories gf on (g.geo_id=gf.cat_id)^J^I    left outer join vote_tally a on (a.item=n.story_id)^J^I    left outer join story_resources m on (n.story_id=m.story_id) ^J^I    left outer join story_category q on (n.story_id = q.story_id)^J^I    join ct_categories r on (r.cat_id=q.cat_id)^J^I    where n.story_id=\'C198DB6...0-F3337A10A9B7\' and n.uid=u.uid  ^J^I     and pub_stat=\'p\'    order by m.disp_order asc, m.link asc^J^J^JDBD::Pg::st execute failed: ERROR:  invalid input syntax for uuid: "C198DB6...0-F3337A10A9B7"^JLINE 13:      where n.story_id=\'C198DB6...0-F3337A10A9B7\' and n.uid=u...^J                               ^^J^J') called at /usr/local/lib/perl5/site_perl/5.8.5/DBIx/SQLEngine/Driver.pm line 3591
DBIx::SQLEngine::Driver::Default::try_query('DBIx::SQLEngine::Driver::Pg=HASH(0x4e5b070)', '^I    select n.*, to_char(n.pub_date,\'Month DD, YYYY\') as full_date,^J^I    to_char(n.mod_date,\'Month DD, YYYY HH12:MI AM\') as mod_date_text,^J^Iu.alias as author, m.link, m.url,^J^I    n.url as st_url, q.cat_id as topic, r.name as topic_name, a.votes, ^J            g.geo_id as geo_id, lower(gf.common_name) as common_name^J^I    from user_db u, story n ^J^I    left outer join story_geo g on (g.story_id=n.story_id)^J^I    left outer join ct_geo_categories gf on (g.geo_id=gf.cat_id)^J^I    left outer join vote_tally a on (a.item=n.story_id)^J^I    left outer join story_resources m on (n.story_id=m.story_id) ^J^I    left outer join story_category q on (n.story_id = q.story_id)^J^I    join ct_categories r on (r.cat_id=q.cat_id)^J^I    where n.story_id=\'C198DB6...0-F3337A10A9B7\' and n.uid=u.uid  ^J^I     and pub_stat=\'p\'    order by m.disp_order asc, m.link asc^J^J', 'ARRAY(0x1c84e20)', 'fetchall_hashref') called at /usr/local/lib/perl5/site_perl/5.8.5/CT/Net.pm line 180
CT::Net::do_query('CT::Net=HASH(0x4dc24f0)', '^I    select n.*, to_char(n.pub_date,\'Month DD, YYYY\') as full_date,^J^I    to_char(n.mod_date,\'Month DD, YYYY HH12:MI AM\') as mod_date_text,^J^Iu.alias as author, m.link, m.url,^J^I    n.url as st_url, q.cat_id as topic, r.name as topic_name, a.votes, ^J            g.geo_id as geo_id, lower(gf.common_name) as common_name^J^I    from user_db u, story n ^J^I    left outer join story_geo g on (g.story_id=n.story_id)^J^I    left outer join ct_geo_categories gf on (g.geo_id=gf.cat_id)^J^I    left outer join vote_tally a on (a.item=n.story_id)^J^I    left outer join story_resources m on (n.story_id=m.story_id) ^J^I    left outer join story_category q on (n.story_id = q.story_id)^J^I    join ct_categories r on (r.cat_id=q.cat_id)^J^I    where n.story_id=\'C198DB6...0-F3337A10A9B7\' and n.uid=u.uid  ^J^I     and pub_stat=\'p\'    order by m.disp_order asc, m.link asc^J^J') called at /usr/local/lib/perl5/site_perl/5.8.5/CT/Showstory.pm line 2010
CT::Showstory::retrieve_story('CT::Showstory=HASH(0x4e604f0)') called at /common/www/html/read/story/show_story.html line 100
HTML::Mason::Commands::__ANON__('story_id', 'C198DB6...0-F3337A10A9B7', 'session', 'HASH(0x4e748e0)', 'mem', 'CT::MemManage=HASH(0x4e793f0)', 'session', 'HASH(0x4e748e0)', 'mem', 'CT::MemManage=HASH(0x4e6e5b0)', 'use_timer', undef) called at /usr/local/lib/perl5/site_perl/5.8.5/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x31fdcf0)', 'story_id', 'C198DB6...0-F3337A10A9B7', 'session', 'HASH(0x4e748e0)', 'mem', 'CT::MemManage=HASH(0x4e793f0)', 'session', 'HASH(0x4e748e0)', 'mem', 'CT::MemManage=HASH(0x4e6e5b0)', 'use_timer', undef) called at /usr/local/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm line 1262
eval {...} at /usr/local/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm line 1252
HTML::Mason::Request::comp(undef, undef, undef, 'story_id', 'C198DB6...0-F3337A10A9B7', 'session', 'HASH(0x4e748e0)', 'mem', 'CT::MemManage=HASH(0x4e793f0)', 'session', 'HASH(0x4e748e0)', 'mem', 'CT::MemManage=HASH(0x4e6e5b0)', 'use_timer', undef) called at /usr/local/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm line 921
HTML::Mason::Request::call_next('HTML::Mason::Request::ApacheHandler=HASH(0x4dd6e70)', 'session', 'HASH(0x4e748e0)', 'mem', 'CT::MemManage=HASH(0x4e6e5b0)', 'use_timer', undef) called at /common/www/html/read/story/autohandler line 72
HTML::Mason::Commands::__ANON__('story_id', 'C198DB6...0-F3337A10A9B7', 'session', 'HASH(0x4e748e0)', 'mem', 'CT::MemManage=HASH(0x4e793f0)') called at /usr/local/lib/perl5/site_perl/5.8.5/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x34ae750)', 'story_id', 'C198DB6...0-F3337A10A9B7', 'session', 'HASH(0x4e748e0)', 'mem', 'CT::MemManage=HASH(0x4e793f0)') called at /usr/local/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm line 1262
eval {...} at /usr/local/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm line 1252
HTML::Mason::Request::comp(undef, undef, undef, 'story_id', 'C198DB6...0-F3337A10A9B7', 'session', 'HASH(0x4e748e0)', 'mem', 'CT::MemManage=HASH(0x4e793f0)') called at /usr/local/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm line 921
HTML::Mason::Request::call_next('HTML::Mason::Request::ApacheHandler=HASH(0x4dd6e70)', 'session', 'HASH(0x4e748e0)', 'mem', 'CT::MemManage=HASH(0x4e793f0)') called at /common/www/html/read/autohandler line 101
HTML::Mason::Commands::__ANON__('story_id', 'C198DB6...0-F3337A10A9B7') called at /usr/local/lib/perl5/site_perl/5.8.5/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x34c0250)', 'story_id', 'C198DB6...0-F3337A10A9B7') called at /usr/local/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm line 1257
eval {...} at /usr/local/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm line 1252
HTML::Mason::Request::comp(undef, undef, undef, 'story_id', 'C198DB6...0-F3337A10A9B7') called at /usr/local/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm line 466
eval {...} at /usr/local/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm line 466
eval {...} at /usr/local/lib/perl5/site_perl/5.8.5/HTML/Mason/Request.pm line 418
HTML::Mason::Request::exec('HTML::Mason::Request::ApacheHandler=HASH(0x4dd6e70)') called at /usr/local/lib/perl5/site_perl/5.8.5/HTML/Mason/ApacheHandler.pm line 168
HTML::Mason::Request::ApacheHandler::exec('HTML::Mason::Request::ApacheHandler=HASH(0x4dd6e70)') called at /usr/local/lib/perl5/site_perl/5.8.5/HTML/Mason/ApacheHandler.pm line 826
HTML::Mason::ApacheHandler::handle_request('CT::ApacheHandler=HASH(0x11bf640)', 'Apache=SCALAR(0x46112e0)') called at (eval 33) line 8
HTML::Mason::ApacheHandler::handler('CT::ApacheHandler', 'Apache=SCALAR(0x46112e0)') called at /dev/null line 0
eval {...} at /dev/null line 0