[Thu Jul 23 14:39:33 2009] [warning]: DBD::mysql::st execute failed: Column 'Created' in field list is ambiguous at /usr/local/share/perl/5.10.0/DBIx/SearchBuilder/Handle.pm line 509. (/usr/local/share/perl/5.10.0/DBIx/SearchBuilder/Handle.pm:509) [Thu Jul 23 14:39:33 2009] [warning]: RT::Handle=HASH(0x10056678) couldn't execute the query 'SELECT COUNT(main.id) AS id, SUBSTR(Created,1,10) AS createddaily FROM Tickets main JOIN ObjectCustomFieldValues ObjectCustomFieldValues_1 ON ( ObjectCustomFieldValues_1.CustomField = '1' ) AND ( ObjectCustomFieldValues_1.ObjectType = 'RT::Ticket' ) AND ( ObjectCustomFieldValues_1.Disabled = '0' ) AND ( ObjectCustomFieldValues_1.ObjectId = main.id ) WHERE (main.Status != 'deleted') AND (main.Queue = '1' AND ( ( ( ObjectCustomFieldValues_1.Content LIKE '%bar%' OR ( ( ObjectCustomFieldValues_1.Content = '' OR ObjectCustomFieldValues_1.Content IS NULL ) AND ObjectCustomFieldValues_1.LargeContent LIKE '%bar%' ) ) ) ) ) AND (main.Type = 'ticket') AND (main.EffectiveId = main.id) GROUP BY SUBSTR(Created,1,10) ' at /usr/local/share/perl/5.10.0/DBIx/SearchBuilder/Handle.pm line 522 DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x10056678)', 'SELECT COUNT(main.id) AS id, SUBSTR(Created,1,10) AS createdd...') called at /usr/local/share/perl/5.10.0/DBIx/SearchBuilder.pm line 236 DBIx::SearchBuilder::_DoSearch('RT::Report::Tickets=HASH(0x11797620)') called at /opt/rt3/lib/RT/Tickets_Overlay.pm line 2746 RT::Tickets::_DoSearch('RT::Report::Tickets=HASH(0x11797620)') called at /opt/rt3/lib/RT/Report/Tickets.pm line 152 RT::Report::Tickets::_DoSearch('RT::Report::Tickets=HASH(0x11797620)') called at /usr/local/share/perl/5.10.0/DBIx/SearchBuilder.pm line 504 DBIx::SearchBuilder::Next('RT::Report::Tickets=HASH(0x11797620)') called at /opt/rt3/lib/RT/Report/Tickets.pm line 236 RT::Report::Tickets::Next('RT::Report::Tickets=HASH(0x11797620)') called at /opt/rt3/share/html/Search/Elements/Chart line 71 HTML::Mason::Commands::__ANON__('Order', 'ASC|ASC|ASC|ASC', 'ChartStyle', 'bar', 'Query', 'Queue = \'General\' AND \'CF.{foo}\' LIKE \'bar\'', 'Rows', 50, 'SecondaryGroupBy', ...) called at /usr/share/perl5/HTML/Mason/Component.pm line 135 HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x11a8bdb0)', 'Order', 'ASC|ASC|ASC|ASC', 'ChartStyle', 'bar', 'Query', 'Queue = \'General\' AND \'CF.{foo}\' LIKE \'bar\'', 'Rows', 50, ...) called at /usr/share/perl5/HTML/Mason/Request.pm line 1278 eval {...} called at /usr/share/perl5/HTML/Mason/Request.pm line 1268 HTML::Mason::Request::comp(undef, undef, 'Order', 'ASC|ASC|ASC|ASC', 'ChartStyle', 'bar', 'Query', 'Queue = \'General\' AND \'CF.{foo}\' LIKE \'bar\'', 'Rows', ...) called at /opt/rt3/share/html/Search/Chart.html line 85 HTML::Mason::Commands::__ANON__('Rows', 50, 'PrimaryGroupBy', 'CreatedDaily', 'Format', '\' _...', 'ChartStyle', 'bar', 'Query', ...) called at /usr/share/perl5/HTML/Mason/Component.pm line 135 HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x119f12f0)', 'Rows', 50, 'PrimaryGroupBy', 'CreatedDaily', 'Format', '\' _...', 'ChartStyle', 'bar', ...) called at /usr/share/perl5/HTML/Mason/Request.pm line 1278 eval {...} called at /usr/share/perl5/HTML/Mason/Request.pm line 1268 HTML::Mason::Request::comp(undef, undef, undef, 'Rows', 50, 'PrimaryGroupBy', 'CreatedDaily', 'Format', '\' _...', ...) called at /opt/rt3/share/html/autohandler line 311 HTML::Mason::Commands::__ANON__('ChartStyle', 'bar', 'Order', 'ASC|ASC|ASC|ASC', 'Query', 'Queue = \'General\' AND \'CF.{foo}\' LIKE \'bar\'', 'Rows', 50, 'PrimaryGroupBy', ...) called at /usr/share/perl5/HTML/Mason/Component.pm line 135 HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x114dac90)', 'ChartStyle', 'bar', 'Order', 'ASC|ASC|ASC|ASC', 'Query', 'Queue = \'General\' AND \'CF.{foo}\' LIKE \'bar\'', 'Rows', 50, ...) called at /usr/share/perl5/HTML/Mason/Request.pm line 1273 eval {...} called at /usr/share/perl5/HTML/Mason/Request.pm line 1268 HTML::Mason::Request::comp(undef, undef, undef, 'ChartStyle', 'bar', 'Order', 'ASC|ASC|ASC|ASC', 'Query', 'Queue = \'General\' AND \'CF.{foo}\' LIKE \'bar\'', ...) called at /usr/share/perl5/HTML/Mason/Request.pm line 467 eval {...} called at /usr/share/perl5/HTML/Mason/Request.pm line 467 eval {...} called at /usr/share/perl5/HTML/Mason/Request.pm line 419 HTML::Mason::Request::exec('RT::Interface::Web::Request=HASH(0x119ee130)') called at /usr/share/perl5/HTML/Mason/ApacheHandler.pm line 165 HTML::Mason::Request::ApacheHandler::exec('RT::Interface::Web::Request=HASH(0x119ee130)') called at /usr/share/perl5/HTML/Mason/ApacheHandler.pm line 831 HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0xe38ff08)', 'Apache2::RequestRec=SCALAR(0x119752e0)') called at /opt/rt3/bin/webmux.pl line 163 eval {...} called at /opt/rt3/bin/webmux.pl line 163 RT::Mason::handler('Apache2::RequestRec=SCALAR(0x119752e0)') called at -e line 0 eval {...} called at -e line 0 (/usr/share/perl/5.10/Carp.pm:47) [Thu Jul 23 14:39:33 2009] [warning]: DBD::mysql::st execute failed: Column 'Created' in field list is ambiguous at /usr/local/share/perl/5.10.0/DBIx/SearchBuilder/Handle.pm line 509. (/usr/local/share/perl/5.10.0/DBIx/SearchBuilder/Handle.pm:509) [Thu Jul 23 14:39:33 2009] [warning]: RT::Handle=HASH(0x10056678) couldn't execute the query 'SELECT COUNT(main.id) AS id, SUBSTR(Created,1,10) AS createddaily FROM Tickets main JOIN ObjectCustomFieldValues ObjectCustomFieldValues_1 ON ( ObjectCustomFieldValues_1.CustomField = '1' ) AND ( ObjectCustomFieldValues_1.ObjectType = 'RT::Ticket' ) AND ( ObjectCustomFieldValues_1.Disabled = '0' ) AND ( ObjectCustomFieldValues_1.ObjectId = main.id ) WHERE (main.Status != 'deleted') AND (main.Queue = '1' AND ( ( ( ObjectCustomFieldValues_1.Content LIKE '%bar%' OR ( ( ObjectCustomFieldValues_1.Content = '' OR ObjectCustomFieldValues_1.Content IS NULL ) AND ObjectCustomFieldValues_1.LargeContent LIKE '%bar%' ) ) ) ) ) AND (main.Type = 'ticket') AND (main.EffectiveId = main.id) GROUP BY SUBSTR(Created,1,10) ' at /usr/local/share/perl/5.10.0/DBIx/SearchBuilder/Handle.pm line 522 DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x10056678)', 'SELECT COUNT(main.id) AS id, SUBSTR(Created,1,10) AS createdd...') called at /usr/local/share/perl/5.10.0/DBIx/SearchBuilder.pm line 236 DBIx::SearchBuilder::_DoSearch('RT::Report::Tickets=HASH(0x11a993c8)') called at /opt/rt3/lib/RT/Tickets_Overlay.pm line 2746 RT::Tickets::_DoSearch('RT::Report::Tickets=HASH(0x11a993c8)') called at /opt/rt3/lib/RT/Report/Tickets.pm line 152 RT::Report::Tickets::_DoSearch('RT::Report::Tickets=HASH(0x11a993c8)') called at /usr/local/share/perl/5.10.0/DBIx/SearchBuilder.pm line 504 DBIx::SearchBuilder::Next('RT::Report::Tickets=HASH(0x11a993c8)') called at /opt/rt3/lib/RT/Report/Tickets.pm line 236 RT::Report::Tickets::Next('RT::Report::Tickets=HASH(0x11a993c8)') called at /opt/rt3/share/html/Search/Chart line 126 HTML::Mason::Commands::__ANON__('Rows', 50, 'PrimaryGroupBy', 'CreatedDaily', 'Format', '\' _...', 'ChartStyle', 'bar', 'Query', ...) called at /usr/share/perl5/HTML/Mason/Component.pm line 135 HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x119c02c8)', 'Rows', 50, 'PrimaryGroupBy', 'CreatedDaily', 'Format', '\' _...', 'ChartStyle', 'bar', ...) called at /usr/share/perl5/HTML/Mason/Request.pm line 1278 eval {...} called at /usr/share/perl5/HTML/Mason/Request.pm line 1268 HTML::Mason::Request::comp(undef, undef, undef, 'Rows', 50, 'PrimaryGroupBy', 'CreatedDaily', 'Format', '\' _...', ...) called at /opt/rt3/share/html/autohandler line 311 HTML::Mason::Commands::__ANON__('Order', 'ASC|ASC|ASC|ASC', 'ChartStyle', 'bar', 'Query', 'Queue = \'General\' AND \'CF.{foo}\' LIKE \'bar\'', 'Rows', 50, 'SecondaryGroupBy', ...) called at /usr/share/perl5/HTML/Mason/Component.pm line 135 HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x114dac90)', 'Order', 'ASC|ASC|ASC|ASC', 'ChartStyle', 'bar', 'Query', 'Queue = \'General\' AND \'CF.{foo}\' LIKE \'bar\'', 'Rows', 50, ...) called at /usr/share/perl5/HTML/Mason/Request.pm line 1273 eval {...} called at /usr/share/perl5/HTML/Mason/Request.pm line 1268 HTML::Mason::Request::comp(undef, undef, undef, 'Order', 'ASC|ASC|ASC|ASC', 'ChartStyle', 'bar', 'Query', 'Queue = \'General\' AND \'CF.{foo}\' LIKE \'bar\'', ...) called at /usr/share/perl5/HTML/Mason/Request.pm line 467 eval {...} called at /usr/share/perl5/HTML/Mason/Request.pm line 467 eval {...} called at /usr/share/perl5/HTML/Mason/Request.pm line 419 HTML::Mason::Request::exec('RT::Interface::Web::Request=HASH(0x119f1650)') called at /usr/share/perl5/HTML/Mason/ApacheHandler.pm line 165 HTML::Mason::Request::ApacheHandler::exec('RT::Interface::Web::Request=HASH(0x119f1650)') called at /usr/share/perl5/HTML/Mason/ApacheHandler.pm line 831 HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0xe38ff08)', 'Apache2::RequestRec=SCALAR(0x119f3668)') called at /opt/rt3/bin/webmux.pl line 163 eval {...} called at /opt/rt3/bin/webmux.pl line 163 RT::Mason::handler('Apache2::RequestRec=SCALAR(0x119f3668)') called at -e line 0 eval {...} called at -e line 0 (/usr/share/perl/5.10/Carp.pm:47)