[freeside-users] cust_main.cgi: relation "objectcustomfieldvalues"
does not exist
Scott Edwards
supadupa at gmail.com
Tue Jan 31 23:43:23 PST 2006
Versions I'm working with:
Freeside 1.5.8cvs-20060201
RT (external) 3.0.12-7
Linux 2.4.30 Debain Stable (pure, maybe a backport or two, but no
comingling with testing/unstable)
Perl v5.8.4
Pg PostgreSQL 7.4.7 on i386-pc-linux-gnu, compiled by GCC
i386-linux-gcc (GCC) 3.3.5 (Debian 1:3.3.5-12)
DBI 1.46
DBD::Pg 1.41
HTML::Mason 1.26
apache-ssl 1.3.33-6sarge1
Seeing as how this appears to be related to RT, I tried turning off RT
in the configuration settings. After saving and reloading, still no
success. This affects the main information page for viewing customers
where the ticket statuses are displayed. Most everything else works
ok...
Cut, Paste and rewrite of a few private tidbits (eg, s/mine.com/foo/)
of the error:
System error
error: ERROR: relation "objectcustomfieldvalues" does not exist
executing SELECT tickets.*, queues.name
FROM tickets
JOIN queues ON ( tickets.queue = queues.id )
JOIN links ON ( tickets.id = links.localbase )
WHERE ( status = 'new' OR status = 'open' OR status = 'stalled' )
AND target = 'freeside://freeside/cust_main/14'
AND 0 = ( SELECT count(*) FROM ObjectCustomFieldValues
WHERE ObjectId = tickets.id
AND ObjectType = 'RT::Ticket'
AND customfield = (
SELECT CustomFields.Id FROM CustomFields
JOIN ObjectCustomFields
ON ( CustomFields.id = ObjectCustomFields.CustomField )
WHERE LookupType = 'RT::Queue-RT::Ticket'
AND name = ?
AND ( ObjectCustomFields.ObjectId = ( SELECT id FROM queues
WHERE queues.name = ? )
OR ( ? = '' AND ObjectCustomFields.ObjectId = 0 ) )
)
)
ORDER BY priority DESC LIMIT 10 at
/usr/local/share/perl/5.8.4/FS/TicketSystem/RT_External.pm line 62.
context:
...
58: my $sql = "SELECT tickets.*, queues.name".
59: ( length($priority) ? ", objectcustomfieldvalues.content" : '' ).
60: " $from_sql ORDER BY priority DESC LIMIT $limit";
61: my $sth = $dbh->prepare($sql) or die $dbh->errstr. "preparing $sql";
62: $sth->execute(@param) or die $sth->errstr. "executing $sql";
63:
64: #munge column names??? #httemplate/view/cust_main/tickets.html has column
65: #names that might not make sense now...
66: $sth->fetchall_arrayref({});
...
code stack: /usr/local/share/perl/5.8.4/FS/TicketSystem/RT_External.pm:62
/usr/local/share/perl/5.8.4/FS/TicketSystem.pm:27
/var/www/hosts/example.com/docroot/dcbams/view/cust_main/tickets.html:20
/usr/local/etc/freeside/handler.pl:241
/var/www/hosts/example.com/docroot/dcbams/view/cust_main.cgi:129
/var/www/hosts/example.com/docroot/dcbams/autohandler:1
raw error
ERROR: relation "objectcustomfieldvalues" does not exist
executing SELECT tickets.*, queues.name
FROM tickets
JOIN queues ON ( tickets.queue = queues.id )
JOIN links ON ( tickets.id = links.localbase )
WHERE ( status = 'new' OR status = 'open' OR status = 'stalled' )
AND target = 'freeside://freeside/cust_main/14'
AND 0 = ( SELECT count(*) FROM ObjectCustomFieldValues
WHERE ObjectId = tickets.id
AND ObjectType = 'RT::Ticket'
AND customfield = (
SELECT CustomFields.Id FROM CustomFields
JOIN ObjectCustomFields
ON ( CustomFields.id = ObjectCustomFields.CustomField )
WHERE LookupType = 'RT::Queue-RT::Ticket'
AND name = ?
AND ( ObjectCustomFields.ObjectId = ( SELECT id FROM queues
WHERE queues.name = ? )
OR ( ? = '' AND ObjectCustomFields.ObjectId = 0 ) )
)
)
ORDER BY priority DESC LIMIT 10 at
/usr/local/share/perl/5.8.4/FS/TicketSystem/RT_External.pm line 62.
Trace begun at /usr/share/perl5/HTML/Mason/Exceptions.pm line 131
HTML::Mason::Exceptions::rethrow_exception('ERROR: relation
"objectcustomfieldvalues" does not exist^Jexecuting SELECT tickets.*,
queues.name ^J FROM tickets^J
JOIN queues ON ( tickets.queue = queues.id )^J JOIN
links ON ( tickets.id = links.localbase )^J ^J
WHERE ( status = \'new\' OR status = \'open\' OR status =
\'stalled\' )^J AND target =
\'freeside://freeside/cust_main/14\'^J AND 0 = ( SELECT
count(*) FROM ObjectCustomFieldValues^J
WHERE ObjectId = tickets.id^J AND
ObjectType = \'RT::Ticket\'^J AND
customfield = ( ^J SELECT CustomFields.Id FROM CustomFields^J
JOIN ObjectCustomFields^J ON (
CustomFields.id = ObjectCustomFields.CustomField )^J WHERE
LookupType = \'RT::Queue-RT::Ticket\'^J AND name = ?^J
AND ( ObjectCustomFields.ObjectId = ( SELECT id FROM queues^J
WHERE queues.name =
? )^J OR ( ? = \'\' AND
ObjectCustomFields.ObjectId = 0 ) )^J )^J
)^J ^J ORDER BY priority DESC LIMIT 10 at
/usr/local/share/perl/5.8.4/FS/TicketSystem/RT_External.pm line
62.^J') called at
/usr/local/share/perl/5.8.4/FS/TicketSystem/RT_External.pm line 62
FS::TicketSystem::RT_External::customer_tickets('FS::TicketSystem::RT_External',
14, 10, '') called at /usr/local/share/perl/5.8.4/FS/TicketSystem.pm
line 27
FS::TicketSystem::AUTOLOAD('FS::TicketSystem', 14, 10, '') called at
/var/www/hosts/example.com/docroot/dcbams/view/cust_main/tickets.html
line 20
HTML::Mason::Commands::__ANON__('FS::cust_main=HASH(0x870ae04)')
called at /usr/share/perl5/HTML/Mason/Component.pm line 134
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x833cbd4)',
'FS::cust_main=HASH(0x870ae04)') called at
/usr/share/perl5/HTML/Mason/Request.pm line 1074
eval {...} at /usr/share/perl5/HTML/Mason/Request.pm line 1068
HTML::Mason::Request::comp(undef, undef, undef,
'FS::cust_main=HASH(0x870ae04)') called at
/usr/share/perl5/HTML/Mason/Request.pm line 1113
HTML::Mason::Request::scomp('HTML::Mason::Request::ApacheHandler=HASH(0x82f2b60)',
'cust_main/tickets.html', 'FS::cust_main=HASH(0x870ae04)') called at
/usr/local/etc/freeside/handler.pl line 241
HTML::Mason::Commands::include('cust_main/tickets.html',
'FS::cust_main=HASH(0x870ae04)') called at
/var/www/hosts/example.com/docroot/dcbams/view/cust_main.cgi line 129
HTML::Mason::Commands::__ANON__('keywords', 14) called at
/usr/share/perl5/HTML/Mason/Component.pm line 134
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x82f71c8)',
'keywords', 14) called at /usr/share/perl5/HTML/Mason/Request.pm line
1074
eval {...} at /usr/share/perl5/HTML/Mason/Request.pm line 1068
HTML::Mason::Request::comp(undef, undef, 'keywords', 14) called at
/usr/share/perl5/HTML/Mason/Request.pm line 760
HTML::Mason::Request::call_next('HTML::Mason::Request::ApacheHandler=HASH(0x82f2b60)')
called at /var/www/hosts/example.com/docroot/dcbams/autohandler line 1
HTML::Mason::Commands::__ANON__('keywords', 14) called at
/usr/share/perl5/HTML/Mason/Component.pm line 134
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x82fc040)',
'keywords', 14) called at /usr/share/perl5/HTML/Mason/Request.pm line
1069
eval {...} at /usr/share/perl5/HTML/Mason/Request.pm line 1068
HTML::Mason::Request::comp(undef, undef, undef, 'keywords', 14) called
at /usr/share/perl5/HTML/Mason/Request.pm line 338
eval {...} at /usr/share/perl5/HTML/Mason/Request.pm line 338
eval {...} at /usr/share/perl5/HTML/Mason/Request.pm line 297
HTML::Mason::Request::exec('HTML::Mason::Request::ApacheHandler=HASH(0x82f2b60)')
called at /usr/share/perl5/HTML/Mason/ApacheHandler.pm line 134
eval {...} at /usr/share/perl5/HTML/Mason/ApacheHandler.pm line 134
HTML::Mason::Request::ApacheHandler::exec('HTML::Mason::Request::ApacheHandler=HASH(0x82f2b60)')
called at /usr/share/perl5/HTML/Mason/ApacheHandler.pm line 793
HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x9de1884)',
'Apache=SCALAR(0x9de19bc)') called at
/usr/local/etc/freeside/handler.pl line 312
eval {...} at /usr/local/etc/freeside/handler.pl line 312
HTML::Mason::handler('Apache=SCALAR(0x9de19bc)') called at /dev/null line 0
eval {...} at /dev/null line 0
Thanks for your help,
Scott Edwards
-- Daxal Communications - http://www.daxal.com/?from=freeside-users
More information about the freeside-users
mailing list