[freeside-users] No schema for table transactions found
Darren Noonan
dazza at reset.net.au
Mon May 24 05:45:41 PDT 2010
Hi,
Have installed 1.9.3 from source with no errors on
CentOS 5.4
MySQL 5.0.77
Perl 5.8.8
Apache 2.2.3
DBI 1.611
DBD::mysql 4.014
While trying to run a 'Time worked report' with or without dates I get the
following error, and all other reports seem to work and RT is OK.
No schema for table transactions found - do you need to run
freeside-upgrade? at /usr/lib/perl5/site_perl/5.8.8/FS/Record.pm line 368.
Trace begun at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Exceptions.pm line
129
HTML::Mason::Exceptions::rethrow_exception('No schema for table transactions
found - do you need to run freeside-upgrade? at
/usr/lib/perl5/site_perl/5.8.8/FS/Record.pm line 368.^J') called at
/usr/lib/perl5/site_perl/5.8.8/FS/Record.pm line 368
FS::Record::qsearch('ARRAY(0xf21b924)', 'order_by', ' ') called at
/var/www/html/search/elements/search.html line 384
HTML::Mason::Commands::__ANON__('title', 'Time worked', 'name_singular',
'transaction', 'query', 'HASH(0xeea1410)', 'count_query', 'SELECT COUNT(*),
SUM(^J CASE transactions.type when \'Set\'^J THEN
(to_number(newvalue,\'999999\')-to_number(oldvalue, \'999999\')) * 60^J
ELSE timetaken*60^J END^J) FROM Transactions JOIN Tickets ON
Transactions.ObjectId = Tickets.Id JOIN Users ON Transactions.Creator =
Users.Id ^J WHERE objecttype=\'RT::Ticket\'^J AND ( (
Transactions.Type = \'Set\'^J AND Transactions.Field =
\'TimeWorked\'^J AND Transactions.NewValue !=
Transactions.OldValue )^J OR ( ( Transactions.Type=\'Create\' OR
Transactions.Type=\'Comment\' OR Transactions.Type=\'Correspond\' )^J
AND Transactions.TimeTaken > 0^J )^J )^J AND Users.name =
\'dazza\' ', 'count_addl', 'ARRAY(0xecf9a60)', 'header', 'ARRAY(0xf1fc460)',
'fields', 'ARRAY(0xf1fc6dc)', 'links', 'ARRAY(0xf1fc754)') called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xf21b79
8)', 'title', 'Time worked', 'name_singular', 'transaction', 'query',
'HASH(0xeea1410)', 'count_query', 'SELECT COUNT(*), SUM(^J CASE
transactions.type when \'Set\'^J THEN
(to_number(newvalue,\'999999\')-to_number(oldvalue, \'999999\')) * 60^J
ELSE timetaken*60^J END^J) FROM Transactions JOIN Tickets ON
Transactions.ObjectId = Tickets.Id JOIN Users ON Transactions.Creator =
Users.Id ^J WHERE objecttype=\'RT::Ticket\'^J AND ( (
Transactions.Type = \'Set\'^J AND Transactions.Field =
\'TimeWorked\'^J AND Transactions.NewValue !=
Transactions.OldValue )^J OR ( ( Transactions.Type=\'Create\' OR
Transactions.Type=\'Comment\' OR Transactions.Type=\'Correspond\' )^J
AND Transactions.TimeTaken > 0^J )^J )^J AND Users.name =
\'dazza\' ', 'count_addl', 'ARRAY(0xecf9a60)', 'header', 'ARRAY(0xf1fc460)',
'fields', 'ARRAY(0xf1fc6dc)', 'links', 'ARRAY(0xf1fc754)') called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1302
eval {...} at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1292
HTML::Mason::Request::comp(undef, undef, undef, 'title', 'Time worked',
'name_singular', 'transaction', 'query', 'HASH(0xeea1410)', 'count_query',
'SELECT COUNT(*), SUM(^J CASE transactions.type when \'Set\'^J THEN
(to_number(newvalue,\'999999\')-to_number(oldvalue, \'999999\')) * 60^J
ELSE timetaken*60^J END^J) FROM Transactions JOIN Tickets ON
Transactions.ObjectId = Tickets.Id JOIN Users ON Transactions.Creator =
Users.Id ^J WHERE objecttype=\'RT::Ticket\'^J AND ( (
Transactions.Type = \'Set\'^J AND Transactions.Field =
\'TimeWorked\'^J AND Transactions.NewValue !=
Transactions.OldValue )^J OR ( ( Transactions.Type=\'Create\' OR
Transactions.Type=\'Comment\' OR Transactions.Type=\'Correspond\' )^J
AND Transactions.TimeTaken > 0^J )^J )^J AND Users.name =
\'dazza\' ', 'count_addl', 'ARRAY(0xecf9a60)', 'header', 'ARRAY(0xf1fc460)',
'fields', 'ARRAY(0xf1fc6dc)', 'links', 'ARRAY(0xf1fc754)') called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1355
HTML::Mason::Request::scomp('FS::Mason::Request=HASH(0xf207fd8)',
'elements/search.html', 'title', 'Time worked', 'name_singular',
'transaction', 'query', 'HASH(0xeea1410)', 'count_query', 'SELECT COUNT(*),
SUM(^J CASE transactions.type when \'Set\'^J THEN
(to_number(newvalue,\'999999\')-to_number(oldvalue, \'999999\')) * 60^J
ELSE timetaken*60^J END^J) FROM Transactions JOIN Tickets ON
Transactions.ObjectId = Tickets.Id JOIN Users ON Transactions.Creator =
Users.Id ^J WHERE objecttype=\'RT::Ticket\'^J AND ( (
Transactions.Type = \'Set\'^J AND Transactions.Field =
\'TimeWorked\'^J AND Transactions.NewValue !=
Transactions.OldValue )^J OR ( ( Transactions.Type=\'Create\' OR
Transactions.Type=\'Comment\' OR Transactions.Type=\'Correspond\' )^J
AND Transactions.TimeTaken > 0^J )^J )^J AND Users.name =
\'dazza\' ', 'count_addl', 'ARRAY(0xecf9a60)', 'header', 'ARRAY(0xf1fc460)',
'fields', 'ARRAY(0xf1fc6dc)', 'links', 'ARRAY(0xf1fc754)') called at
/usr/lib/perl5/site_perl/5.8.8/FS/Mason.pm line 331
HTML::Mason::Commands::include('elements/search.html', 'title', 'Time
worked', 'name_singular', 'transaction', 'query', 'HASH(0xeea1410)',
'count_query', 'SELECT COUNT(*), SUM(^J CASE transactions.type when
\'Set\'^J THEN (to_number(newvalue,\'999999\')-to_number(oldvalue,
\'999999\')) * 60^J ELSE timetaken*60^J END^J) FROM Transactions JOIN
Tickets ON Transactions.ObjectId = Tickets.Id JOIN Users ON
Transactions.Creator = Users.Id ^J WHERE objecttype=\'RT::Ticket\'^J
AND ( ( Transactions.Type = \'Set\'^J AND
Transactions.Field = \'TimeWorked\'^J AND
Transactions.NewValue != Transactions.OldValue )^J OR ( (
Transactions.Type=\'Create\' OR Transactions.Type=\'Comment\' OR
Transactions.Type=\'Correspond\' )^J AND
Transactions.TimeTaken > 0^J )^J )^J AND Users.name =
\'dazza\' ', 'count_addl', 'ARRAY(0xecf9a60)', 'header', 'ARRAY(0xf1fc460)',
'fields', 'ARRAY(0xf1fc6dc)', 'links', 'ARRAY(0xf1fc754)') called at
/var/www/html/search/rt_transaction.html line 43
HTML::Mason::Commands::__ANON__('otaker', 'dazza', 'beginning', '',
'ending', '') called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xf1fc4f
0)', 'otaker', 'dazza', 'beginning', '', 'ending', '') called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1302
eval {...} at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1292
HTML::Mason::Request::comp(undef, undef, undef, 'otaker', 'dazza',
'beginning', '', 'ending', '') called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 955
HTML::Mason::Request::call_next('FS::Mason::Request=HASH(0xf207fd8)') called
at /var/www/html/autohandler line 1
HTML::Mason::Commands::__ANON__('otaker', 'dazza', 'beginning', '',
'ending', '') called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xf1fbbc
0)', 'otaker', 'dazza', 'beginning', '', 'ending', '') called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1297
eval {...} at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1292
HTML::Mason::Request::comp(undef, undef, undef, 'otaker', 'dazza',
'beginning', '', 'ending', '') called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 481
eval {...} at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 481
eval {...} at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 433
HTML::Mason::Request::exec('FS::Mason::Request=HASH(0xf207fd8)') called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm line 168
HTML::Mason::Request::ApacheHandler::exec('FS::Mason::Request=HASH(0xf207fd8
)') called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm
line 825
HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(
0xc29c5d4)', 'Apache2::RequestRec=SCALAR(0xf1cffe8)') called at
/usr/local/etc/freeside/handler.pl line 91
eval {...} at /usr/local/etc/freeside/handler.pl line 91
HTML::Mason::handler('Apache2::RequestRec=SCALAR(0xf1cffe8)') called at -e
line 0
eval {...} at -e line 0
Thanks
Darren Noonan
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://420.am/pipermail/freeside-users/attachments/20100524/0ecc9486/attachment.htm>
More information about the freeside-users
mailing list