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: |
|
||||||||||||||||||||||
| 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 |
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