Hi,

I've got a new bug today during synchronization:

Bugzilla reported an error during loading xml:

undef error - DBD::mysql:b selectall_arrayref failed: Unknown column 'attachments.modification_time' in 'field list' [for Statement SELECT attachments.attach_id AS id, attachments.bug_id AS bug_id, attachments.description AS description, attachments.mimetype AS contenttype, attachments.submitter_id AS attacher_id, DATE_FORMAT(attachments.creation_ts, '%Y.%m.%d %H:%i') AS attached, attachments.modification_time, attachments.filename AS filename, attachments.ispatch AS ispatch, attachments.isurl AS isurl, attachments.isobsolete AS isobsolete, attachments.isprivate AS isprivate FROM attachments WHERE attach_id IN (1821,1826,1827) ORDER BY attach_id ] at Bugzilla/Attachment.pm line 103 Bugzilla::Attachment::_retrieve('ARRAY(0x8ee2f08)') called at Bugzilla/Attachment.pm line 73 Bugzilla::Attachment::get_list('Bugzilla::Attachment', 'ARRAY(0x8ee2f08)') called at Bugzilla/Attachment.pm line 558 Bugzilla::Attachment::get_attachments_by_bug('Bugzilla::Attachment', 3185) called at Bugzilla/Bug.pm line 2270 Bugzilla::Bug::attachments('Bugzilla::Bug=HASH(0x8e851f8)') called at data/template/template/en/default/bug/show.xml.tmpl line 511 eval {...} called at data/template/template/en/default/bug/show.xml.tmpl line 511 eval {...} called at data/template/template/en/default/bug/show.xml.tmpl line 106 eval {...} called at data/template/template/en/default/bug/show.xml.tmpl line 16 Template::Provider::__ANON__('Template::Context=HASH(0x8d51068)') called at /usr/local/lib/perl/5.10.0/Template/Document.pm line 155 eval {...} called at /usr/local/lib/perl/5.10.0/Template/Document.pm line 153 Template::Document::process('Template::Document=HASH(0x8e68fe0)', 'Template::Context=HASH(0x8d51068)') called at /usr/local/lib/perl/5.10.0/Template/Context.pm line 349 eval {...} called at /usr/local/lib/perl/5.10.0/Template/Context.pm line 319 Template::Context::process('Template::Context=HASH(0x8d51068)', 'Template::Document=HASH(0x8e68fe0)') called at /usr/local/lib/perl/5.10.0/Template/Service.pm line 94 eval {...} called at /usr/local/lib/perl/5.10.0/Template/Service.pm line 91 Template::Service::process('Template::Service=HASH(0x8d50f78)', 'bug/show.xml.tmpl', 'HASH(0x817f9b0)') called at /usr/local/lib/perl/5.10.0/Template.pm line 68 Template::process('Bugzilla::Template=HASH(0x8cfea38)', 'bug/show.xml.tmpl', 'HASH(0x817f9b0)') called at /var/www/bugzilla/auslogics/show_bug.cgi line 141

It happens every time when I try to update the local database and make a synchronization. I have Bugzilla - 3.2.2 and it works througth a browser.

Thank you!

Alexey,

Do you know if your Bugzilla has been modified or customized lately? What happens if you look at a bug in browser and switch to XML view? Try only bugs that have attachments. If it works, then please run Deskzilla in verbose mode, collect logs and send to support as described here.

Igor