Ticket #10128 (closed defect: fixed)

Opened 11 months ago

Last modified 10 months ago

drag and drop doesn't work

Reported by: rulbrich@capsher.com Assigned to: robguttman
Priority: normal Component: QueuesPlugin
Severity: normal Keywords:
Cc: Trac Release: 0.12

Description

The drag and drop feature doesn't work. I've tried IE9 and Chrome without success. Javascript is enabled and the jquery scripts seem to be downloaded correctly (according to the chrome developer tool). I'm running trac 0.12.2. QueuesPlugin 0.1.0 (r11706).

Here are the relevant sections in my trac.ini: 

[queues]
reports = 9,10

[ticket-custom]
position = text
effort = select
effort.options = 0-2|3-5|6-10|10+
effort.value = 1

Here is my report definition (I am using an sqlite3 database): 

SELECT p.value AS __color__,
   cp.value AS position, id AS ticket, summary, component, version, milestone, t.type AS type, 
   owner, ce.value AS effort, status,
   time AS created,
   changetime AS _changetime, description AS _description,
   reporter AS _reporter
  FROM ticket t
     LEFT OUTER JOIN ticket_custom cp ON (t.id = cp.ticket AND cp.name = 'position' )
     LEFT OUTER JOIN ticket_custom ce ON (t.id = ce.ticket AND ce.name = 'effort' )
     JOIN enum p ON p.name = t.priority AND p.type = 'priority'
  WHERE status <> 'closed'
  ORDER BY CAST((CASE p.value
                   WHEN '' THEN '0'
                   ELSE COALESCE(p.value,'0') END) AS INTEGER) ASC, milestone, t.type, time

Attachments

Change History

07/02/12 20:17:12 changed by rulbrich@capsher.com

Also, at the top of my report it does have a gray box that states that it is a special queue report.

07/02/12 20:28:52 changed by robguttman

  • status changed from new to assigned.

rulbrich, it sounds like the plugin isn't fully configured yet. The first thing to check is that the plugin is listed in the Plugins list of the Admin section. If it's listed then check that all of its components are enabled.

Next would be double-checking that you're looking at report 9 or 10 - since those are the only two reports where the queue behavior should be enabled according to your trac.ini config above.

Let me know if these tipis don't resolve your issue.

07/02/12 21:10:12 changed by rulbrich@capsher.com

Rob,

The plugin is listed in the admin page. Both QueuesAjaxModule? and QueuesModule? are enabled.

And, I am looking at report 9, which my previous comment should have clarified since I am seeing the gray box at the top of the report. Also, it seems like the plugin is getting loaded, because I am not able to sort the table by the column header as I would be able to in a regular report.

I also just fixed a minor issue with the report code in the ORDER BY clause (but still not working): 

SELECT p.value AS __color__,
   cp.value AS position, id AS ticket, summary, component, version, milestone, t.type AS type, 
   owner, ce.value AS effort, status,
   time AS created,
   changetime AS _changetime, description AS _description,
   reporter AS _reporter
  FROM ticket t
     LEFT OUTER JOIN ticket_custom cp ON (t.id = cp.ticket AND cp.name = 'position' )
     LEFT OUTER JOIN ticket_custom ce ON (t.id = ce.ticket AND ce.name = 'effort' )
     JOIN enum p ON p.name = t.priority AND p.type = 'priority'
  WHERE status <> 'closed'
  ORDER BY CAST((CASE cp.value
                   WHEN '' THEN '0'
                   ELSE COALESCE(cp.value,'0') END) AS INTEGER) ASC, milestone, t.type, time

Finally, I disabled and reenabled the plugin from the admin page, but it still didn't work.

I've restarted apache. Is there anything else you might suggest?

Thanks, Robert

07/02/12 22:05:01 changed by robguttman

Robert, apologies - I read your comment above wrong.

The plugin disables table sorting as the sort order is critical for the plugin to order the queue correctly.

When you say drag-and-drop does not work, are you saying you can't actually drag-and-drop tickets to new locations or that the tickets' position field is not getting updated?

(follow-up: ↓ 6 ) 07/02/12 22:36:33 changed by rulbrich@capsher.com

The actual drag and drop is not working. I've tried grabbing a table row from several different places and it just won't drag.

(in reply to: ↑ 5 ) 07/02/12 22:45:36 changed by robguttman

Replying to rulbrich@capsher.com:

The actual drag and drop is not working. I've tried grabbing a table row from several different places and it just won't drag.

Ok, in that case it could be that there's a JS error somewhere - possibly from a different plugin that's preventing all subsequent JS libs from loading properly. Can you check the JavaScript Console to see what errors you may be getting? In Chrome, for example, it's under View > Developer > JavaScript Console.

07/02/12 23:05:20 changed by rulbrich@capsher.com

The only plugin I have is the QueuesPlugin.

There are no JavaScript? errors in Chrome. I do have a warning about loading insecure content. This is because I am running trac on an SSL server and the logo is being pulled from a non-SSL site.

Any other ideas?

07/03/12 01:10:06 changed by robguttman

Hmm. It sounds like the JS lib isn't loaded. Under View > Developer > Developer Tools > Resources, can you find a queues.js listed somewhere under the Frames section? How about jquery-ui-1.8.16.custom.min.js?

If you're missing either of the above, the issue could be how the package was installed. Doing a straight "easy_install" on the tarball may be the easiest way to install if that's acceptable.

07/03/12 23:23:34 changed by rulbrich@capsher.com

Both scripts show up as resources in Chrome. They seem to be loaded correctly.

I did an easy_install of the Python egg and it installed into the system python directory. I don't know if I should be passing a path or something, because it did not install into the trac plugins directory.

07/08/12 18:04:40 changed by robguttman

(In [11715]) refs #10128: fixing default group behavior to 'reorder' (from 'ignore')

07/08/12 18:06:47 changed by robguttman

Robert, thank you - you found a bug. I was able to reproduce your problem. It seems I had changed the default group behavior to 'ignore' when it should be 'reorder'. I just committed a fix which should resolve the issue for you. Let me know if this works or not for you. Apologies for the problems you had and thank you for your patience and help diagnosing this issue!

08/06/12 14:50:48 changed by anonymous

  • status changed from assigned to closed.
  • resolution set to fixed.

Robert, I am going to assume my latest fix works for you. If it doesn't, please reopen this ticket with more details.

Add/Change #10128 (drag and drop doesn't work)




Change Properties
Action