bugs at lists
Mar 6, 2009, 10:06 AM
Post #1 of 1
(361 views)
Permalink
|
|
[Bug 1444] New: Can't switch from Show Trail to Show All and back again
|
|
http://bugs.bricolage.cc/show_bug.cgi?id=1444
Summary: Can't switch from Show Trail to Show All and back again
Product: Bricolage
Version: 1.11.1 - Developer Release
Platform: All
URL: /workflow/events/media/1091?filter_by=media_moved
OS/Version: All
Status: NEW
Severity: normal
Priority: P3
Component: Profiles
AssignedTo: bugs [at] lists
ReportedBy: adam [at] rfx-tech
I am using FF3 and Bricolage 1.11.1.
I have followed these steps about a dozen times for both Stories and Media, and
this happens every time I do it.
If I "Find Media", click on the Log link to the right, I see a list of events.
Under the list, there is a link to "Show trail", which changes the Filtered By:
to "Media Moved to Desk" and the link to "Show All".
If I click "Show All", the content isn't filtered and the link changes to "Show
trail".
If I then click Show trail, I get the following SQL error:
Unable to execute SQL statement
DBD::Pg::st execute failed: ERROR: syntax error at or near "LIMIT" at
character 550
[for Statement "
SELECT e.id, t.id, e.usr__id, e.obj_id, e.timestamp, t.key_name,
t.name, t.description, c.pkg_name, CASE WHEN e.id IN (SELECT event__id FROM
alert) THEN 1 ELSE 0 END, ta.name, ea.value
FROM event e LEFT JOIN event_attr ea ON e.id = ea.event__id LEFT JOIN
event_type_attr ta ON ea.event_type_attr__id = ta.id, class c, event_type t
WHERE e.event_type__id = t.id AND t.class__id = c.id AND e.obj_id = ?
AND t.class__id = ? AND (LOWER(t.key_name) LIKE LOWER(?))
ORDER BY e.timestamp DESC, e.id DESC
LIMIT LIMIT LIMIT LIMIT LIMIT LIMIT LIMIT LIMIT LIMIT LIMIT LIMIT LIMIT
1 ;
" with ParamValues: 1='1091', 3='media_moved', 2='46'] at
/usr/local/bricolage/lib/Bric/Util/DBI.pm line 1136.
Stack:
[/usr/local/bricolage/lib/Bric/Util/DBI.pm:1136]
[/usr/local/bricolage/lib/Bric/Util/Event.pm:1478]
[/usr/local/bricolage/lib/Bric/Util/Event.pm:523]
[/usr/local/bricolage/comp/widgets/listManager/listManager.mc:400]
[/usr/local/bricolage/comp/widgets/eventList/eventList.mc:64]
[/usr/local/bricolage/comp/workflow/events/dhandler:22]
[/usr/local/bricolage/comp/autohandler:7]
View Error Details
Error Details (hide)
Fault Class
Bric::Util::Fault::Exception::DA
Description
Data Access Exception
Timestamp
2009-03-06 13:00:45.000000
Package
Bric::Util::DBI
Filename
/usr/local/bricolage/lib/Bric/Util/DBI.pm
Line
1137
Stack:
Trace begun at /usr/local/bricolage/lib/Bric/Util/DBI.pm line 1137
Bric::Util::DBI::execute('DBI::st=HASH(0xb56b2d8)', 1091, 46, 'media_moved')
called at /usr/local/bricolage/lib/Bric/Util/Event.pm line 1478
Bric::Util::Event::__ANON__('Bric::Util::Event', 'HASH(0xb567814)') called at
/usr/local/bricolage/lib/Bric/Util/Event.pm line 523
Bric::Util::Event::list('Bric::Util::Event', 'HASH(0xb567814)') called at
/usr/local/bricolage/comp/widgets/listManager/listManager.mc line 400
eval {...} at /usr/local/bricolage/comp/widgets/listManager/listManager.mc line
400
HTML::Mason::Commands::__ANON__('object', 'event', 'state_key',
'eventmedia1091', 'constrain', 'HASH(0xb5659f4)', 'fields', 'ARRAY(0xb498d50)',
'alter', 'HASH(0xb567af0)', 'profile', 'CODE(0xb57bf50)', 'addition', undef,
'def_sort_order', undef, 'select', undef) called at
/usr/share/perl5/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xaf1d4fc)',
'object', 'event', 'state_key', 'eventmedia1091', 'constrain',
'HASH(0xb5659f4)', 'fields', 'ARRAY(0xb498d50)', 'alter', 'HASH(0xb567af0)',
'profile', 'CODE(0xb57bf50)', 'addition', undef, 'def_sort_order', undef,
'select', undef) called at /usr/share/perl5/HTML/Mason/Request.pm line 1284
eval {...} at /usr/share/perl5/HTML/Mason/Request.pm line 1274
HTML::Mason::Request::comp(undef, undef, 'object', 'event', 'state_key',
'eventmedia1091', 'constrain', 'HASH(0xb5659f4)', 'fields', 'ARRAY(0xb498d50)',
'alter', 'HASH(0xb567af0)', 'profile', 'CODE(0xb57bf50)', 'addition', undef,
'def_sort_order', undef, 'select', undef) called at
/usr/local/bricolage/comp/widgets/eventList/eventList.mc line 64
HTML::Mason::Commands::__ANON__('object', 'media', 'obj_id', 1091, 'alert_uri',
'/workflow/alerts', 'constrain', 'HASH(0xb5659f4)') called at
/usr/share/perl5/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xb49b014)',
'object', 'media', 'obj_id', 1091, 'alert_uri', '/workflow/alerts',
'constrain', 'HASH(0xb5659f4)') called at
/usr/share/perl5/HTML/Mason/Request.pm line 1284
eval {...} at /usr/share/perl5/HTML/Mason/Request.pm line 1274
HTML::Mason::Request::comp(undef, undef, 'object', 'media', 'obj_id', 1091,
'alert_uri', '/workflow/alerts', 'constrain', 'HASH(0xb5659f4)') called at
/usr/local/bricolage/comp/workflow/events/dhandler line 22
HTML::Mason::Commands::__ANON__('filter_by', 'media_moved', 'filter_by',
'media_moved') called at /usr/share/perl5/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xb3ff5b0)',
'filter_by', 'media_moved', 'filter_by', 'media_moved') called at
/usr/share/perl5/HTML/Mason/Request.pm line 1284
eval {...} at /usr/share/perl5/HTML/Mason/Request.pm line 1274
HTML::Mason::Request::comp(undef, undef, undef, 'filter_by', 'media_moved',
'filter_by', 'media_moved') called at /usr/share/perl5/HTML/Mason/Request.pm
line 943
HTML::Mason::Request::call_next('HTML::Mason::Request::ApacheHandler=HASH(0xb51f490)',
'filter_by', 'media_moved') called at /usr/local/bricolage/comp/autohandler
line 7
HTML::Mason::Commands::__ANON__('filter_by', 'media_moved') called at
/usr/share/perl5/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xac7bcb8)',
'filter_by', 'media_moved') called at /usr/share/perl5/HTML/Mason/Request.pm
line 1279
eval {...} at /usr/share/perl5/HTML/Mason/Request.pm line 1274
HTML::Mason::Request::comp(undef, undef, undef, 'filter_by', 'media_moved')
called at /usr/share/perl5/HTML/Mason/Request.pm line 473
eval {...} at /usr/share/perl5/HTML/Mason/Request.pm line 473
eval {...} at /usr/share/perl5/HTML/Mason/Request.pm line 425
HTML::Mason::Request::exec('HTML::Mason::Request::ApacheHandler=HASH(0xb51f490)')
called at /usr/share/perl5/HTML/Mason/ApacheHandler.pm line 168
HTML::Mason::Request::ApacheHandler::exec('HTML::Mason::Request::ApacheHandler=HASH(0xb51f490)')
called at /usr/share/perl5/HTML/Mason/ApacheHandler.pm line 825
HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0xab4e284)',
'Apache=SCALAR(0xb567d90)') called at
/usr/local/bricolage/lib/Bric/App/Handler.pm line 309
eval {...} at /usr/local/bricolage/lib/Bric/App/Handler.pm line 298
Bric::App::Handler::handler('Apache=SCALAR(0xb567d90)') called at /dev/null
line 0
eval {...} at /dev/null line 0
--
Configure bugmail: http://bugs.bricolage.cc/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are watching all bug changes.
|
