id summary reporter owner description type status priority component severity resolution keywords cc release 6512 ticket.query fails to return all matches anonymous osimons "Notice in the trace below (password obfuscated), an XMLRPC client call to ticket.query for all tickets of status ""new"" returns an array which does '''not''' contain ticket #1. When fetched directly, however, ticket 1 is returned... and it's status is, indeed, new. {{{ irb(main):062:0> client = XMLRPC::Client.new2(""http://FOO:BAR@trac.germane-software.com/TimeTracker/login/xmlrpc"") => #> irb(main):063:0> client.call(""ticket.query"", ""status=new"").sort => [6, 9, 10, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108] irb(main):064:0> client.call(""ticket.get"", ""1"") => [""1"", #, #, {""component""=>""TimeTracker Android"", ""cc""=>""cupra.kev@googlemail.com"", ""reporter""=>""www.google.com/accounts/o8/id?id=aitoawkx8pndhvjyausyrhg8m8md8txy_7sju_w"", ""priority""=>""minor"", ""os""=>""Linux"", ""type""=>""enhancement"", ""version""=>"""", ""milestone""=>""2009.3"", ""summary""=>""Back up DB to memory card"", ""description""=>""Copy the whole DB to the memory card. Optionally pack the on-phone DB, moving old times to the DB on the memory card."", ""status""=>""new"", ""owner""=>""somebody"", ""keywords""=>""""}] }}} To eliminate the possibility that the error is in the Ruby XMLRPC library, I've also tried it with the JSONRPC interface: {{{ bean:1121)~% cat body.json {""params"": [""status=new""], ""method"": ""ticket.query"", ""id"": 123} bean:1122)~% curl -H ""Content-Type: application/json"" --data @body.json -u 'FOO:BAR' 'http://trac.germane-software.com/TimeTracker/login/jsonrpc' {""id"": 123, ""result"": [9, 6, 10, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108], ""error"": null} }}} Again, notice that ticket is missing. Actually, there are about 41 tickets missing, as per a count on the server: {{{ haselmaus db # sqlite3 trac.db ""select count(*) from ticket where status='new'"" 141 }}}" defect closed normal XmlRpcPlugin major fixed documentation seanerussell@… 0.11