[p4] p4dti and bugzilla

[Ravi Ram]

Hi,

I have setup bugzilla and p4dti. most os the stuff works. I can do 'p4 
jobs' and can see
all the bug lists and can also close jobs in p4. I can also create new 
bugs in bugzilla and it shows
up in p4 jobs. the problem is i can't open the bug i created in 
bugzilla. If i do so i get the
following errors. Any help would be really appreciated.


Thanks.


--ravi


  Internal Error

Bugzilla has suffered an internal error. Please save this page and send 
it to raviram at streamprocessors.com with details of what you were doing 
at the time this message appeared.

URL: http://spi3:8080/show_bug.cgi?id=10

undef error - DBD::mysql::st execute failed: Unknown column 
'p4dti_fixes.changelist' in 'on clause' [for Statement "SELECT 
profiles.realname, profiles.login_name, p4dti_fixes.changelist, 
p4dti_fixes.status, p4dti_changelists.p4date, 
p4dti_changelists.description, p4dti_changelists.rid, 
p4dti_changelists.flags FROM p4dti_fixes, profiles LEFT JOIN 
p4dti_changelists ON 
(p4dti_changelists.changelist=p4dti_fixes.changelist AND 
p4dti_changelists.sid = p4dti_fixes.sid)WHERE p4dti_fixes.bug_id = 10 
AND profiles.userid = p4dti_changelists.user AND p4dti_fixes.rid = 
'replicator0' AND p4dti_changelists.rid = 'replicator0' AND 
p4dti_fixes.sid = 'spi3_perforce' AND p4dti_changelists.sid = 
'spi3_perforce' ORDER BY p4dti_fixes.changelist"] at Bugzilla/DB.pm line 
84 Bugzilla::DB::SendSQL('SELECT profiles.realname, profiles.login_name, 
p4dti_fixe...') called at globals.pl line 1185 main::GetPerforceInfo(10) 
called at Bugzilla/Bug.pm line 752 
Bugzilla::Bug::p4dti('Bugzilla::Bug=HASH(0xaa07564)') called at 
data/template/template/en/extension/hook/bug/comments.html.tmpl/aftercomments/p4dti.html.tmpl 
line 22 eval {...} called at 
data/template/template/en/extension/hook/bug/comments.html.tmpl/aftercomments/p4dti.html.tmpl 
line 22 eval {...} called at 
data/template/template/en/extension/hook/bug/comments.html.tmpl/aftercomments/p4dti.html.tmpl 
line 16 
Template::Provider::__ANON__('Template::Context=HASH(0xa853a6c)') called 
at 
/spi/elephant/colorado/raviram/p4dti/perl-r5.8.8/lib/site_perl/5.8.8/i686-linux/Template/Document.pm 
line 155 eval {...} called at 
/spi/elephant/colorado/raviram/p4dti/perl-r5.8.8/lib/site_perl/5.8.8/i686-linux/Template/Document.pm 
line 153 
Template::Document::process('Template::Document=HASH(0xab26314)', 
'Template::Context=HASH(0xa853a6c)') called at 
/spi/elephant/colorado/raviram/p4dti/perl-r5.8.8/lib/site_perl/5.8.8/i686-linux/Template/Context.pm 
line 350 eval {...} called at 
/spi/elephant/colorado/raviram/p4dti/perl-r5.8.8/lib/site_perl/5.8.8/i686-linux/Template/Context.pm 
line 320 Template::Context::process('Template::Context=HASH(0xa853a6c)', 
'hook/bug/comments.html.tmpl/aftercomments/p4dti.html.tmpl') called at 
Bugzilla/Template/Plugin/Hook.pm line 63 
Bugzilla::Template::Plugin::Hook::process('Bugzilla::Template::Plugin::Hook=HASH(0xaa0d990)', 
'aftercomments') called at 
data/template/template/en/default/bug/comments.html.tmpl line 105 eval 
{...} called at data/template/template/en/default/bug/comments.html.tmpl 
line 105 eval {...} called at 
data/template/template/en/default/bug/comments.html.tmpl line 16 
Template::Provider::__ANON__('Template::Context=HASH(0xa853a6c)') called 
at 
/spi/elephant/colorado/raviram/p4dti/perl-r5.8.8/lib/site_perl/5.8.8/i686-linux/Template/Document.pm 
line 155 eval {...} called at 
/spi/elephant/colorado/raviram/p4dti/perl-r5.8.8/lib/site_perl/5.8.8/i686-linux/Template/Document.pm 
line 153 
Template::Document::process('Template::Document=HASH(0xab0e234)', 
'Template::Context=HASH(0xa853a6c)') called at 
/spi/elephant/colorado/raviram/p4dti/perl-r5.8.8/lib/site_perl/5.8.8/i686-linux/Template/Context.pm 
line 350 eval {...} called at 
/spi/elephant/colorado/raviram/p4dti/perl-r5.8.8/lib/site_perl/5.8.8/i686-linux/Template/Context.pm 
line 320 Template::Context::process('Template::Context=HASH(0xa853a6c)', 
'bug/comments.html.tmpl', 'HASH(0xaa19ecc)') called at 
data/template/template/en/default/bug/edit.html.tmpl line 704 eval {...} 
called at data/template/template/en/default/bug/edit.html.tmpl line 16 
Template::Provider::__ANON__('Template::Context=HASH(0xa853a6c)') called 
at 
/spi/elephant/colorado/raviram/p4dti/perl-r5.8.8/lib/site_perl/5.8.8/i686-linux/Template/Document.pm 
line 155 eval {...} called at 
/spi/elephant/colorado/raviram/p4dti/perl-r5.8.8/lib/site_perl/5.8.8/i686-linux/Template/Document.pm 
line 153 
Template::Document::process('Template::Document=HASH(0xaaaadf0)', 
'Template::Context=HASH(0xa853a6c)') called at 
/spi/elephant/colorado/raviram/p4dti/perl-r5.8.8/lib/site_perl/5.8.8/i686-linux/Template/Context.pm 
line 350 eval {...} called at 
/spi/elephant/colorado/raviram/p4dti/perl-r5.8.8/lib/site_perl/5.8.8/i686-linux/Template/Context.pm 
line 320 Template::Context::process('Template::Context=HASH(0xa853a6c)', 
'bug/edit.html.tmpl') called at 
data/template/template/en/default/bug/show.html.tmpl line 72 eval {...} 
called at data/template/template/en/default/bug/show.html.tmpl line 16 
Template::Provider::__ANON__('Template::Context=HASH(0xa853a6c)') called 
at 
/spi/elephant/colorado/raviram/p4dti/perl-r5.8.8/lib/site_perl/5.8.8/i686-linux/Template/Document.pm 
line 155 eval {...} called at 
/spi/elephant/colorado/raviram/p4dti/perl-r5.8.8/lib/site_perl/5.8.8/i686-linux/Template/Document.pm 
line 153 
Template::Document::process('Template::Document=HASH(0xa95a86c)', 
'Template::Context=HASH(0xa853a6c)') called at 
/spi/elephant/colorado/raviram/p4dti/perl-r5.8.8/lib/site_perl/5.8.8/i686-linux/Template/Context.pm 
line 350 eval {...} called at 
/spi/elephant/colorado/raviram/p4dti/perl-r5.8.8/lib/site_perl/5.8.8/i686-linux/Template/Context.pm 
line 320 Template::Context::process('Template::Context=HASH(0xa853a6c)', 
'Template::Document=HASH(0xa95a86c)') called at 
/spi/elephant/colorado/raviram/p4dti/perl-r5.8.8/lib/site_perl/5.8.8/i686-linux/Template/Service.pm 
line 97 eval {...} called at 
/spi/elephant/colorado/raviram/p4dti/perl-r5.8.8/lib/site_perl/5.8.8/i686-linux/Template/Service.pm 
line 94 Template::Service::process('Template::Service=HASH(0xa82ba68)', 
'bug/show.html.tmpl', 'HASH(0xa397f80)') called at 
/spi/elephant/colorado/raviram/p4dti/perl-r5.8.8/lib/site_perl/5.8.8/i686-linux/Template.pm 
line 71 Template::process('Bugzilla::Template=HASH(0xa7f3ac0)', 
'bug/show.html.tmpl', 'HASH(0xa397f80)') called at 
/usr/local/bugzilla_dbg/show_bug.cgi line 134