TypeError: %b requires a bytes-like object, or an object that implements __bytes__, not 'int'

[Dirk Stöcker]

Report 9 of josm.openstreetmap.de fails when called with format=sql as argument:

Internal Server Error: <RequestWithSession "GET '/report/9?format=sql'">, referrer None
Traceback (most recent call last):
  File "/usr/local/lib/python3.10/dist-packages/trac/web/main.py", line 609, in dispatch_request
    dispatcher.dispatch(req)
  File "/usr/local/lib/python3.10/dist-packages/trac/web/main.py", line 301, in dispatch
    raise e
  File "/usr/local/lib/python3.10/dist-packages/trac/web/main.py", line 247, in dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/local/lib/python3.10/dist-packages/trac/ticket/report.py", line 188, in process_request
    template, data, content_type = self._render_view(req, id)
  File "/usr/local/lib/python3.10/dist-packages/trac/ticket/report.py", line 382, in _render_view
    self._send_sql(req, id, title, description, sql)
  File "/usr/local/lib/python3.10/dist-packages/trac/ticket/report.py", line 941, in _send_sql
    out.write(b'-- ## %s: %s ## --\n\n' % (id, title.encode('utf-8')))
TypeError: %b requires a bytes-like object, or an object that implements __bytes__, not 'int'

report is

SELECT id AS ticket, summary, component, type, owner, status
  FROM ticket t
  WHERE status <> 'closed' 
  AND (owner=$USER OR reporter=$USER)
  ORDER BY id desc

Fix:

report.py

@@ -938 +938 @@
         req.perm(self.realm, id).require('REPORT_SQL_VIEW')
 
         out = io.BytesIO()
-        out.write(b'-- ## %s: %s ## --\n\n' % (id, title.encode('utf-8')))
+        out.write(b'-- ## %s: %s ## --\n\n' % (str(id).encode("utf-8"), title.encode('utf-8')))
         if description:
             lines = description.encode('utf-8').splitlines()
-            out.write(b'-- %s\n\n' % '\n-- '.join(lines))
+            out.write(b'-- %s\n\n' % b'\n-- '.join(lines))
         out.write(sql.encode('utf-8'))
         data = out.getvalue()
 

[Jun Omae]

Thanks for the reporting!

[Jun Omae]

Fixed in [17778] and merged in [17779].

[Ryan J Ollos]

Let me know if we need to do a software release. I have a week off at the beginning of July. I plan to work on Edgewall infrastructure and pushing out new releases. If we need one before July I can help make that happen.

[Jun Omae]

Replying to Ryan J Ollos:

Let me know if we need to do a software release. I have a week off at the beginning of July. I plan to work on Edgewall infrastructure and pushing out new releases. If we need one before July I can help make that happen.

I consider Trac 1.6 has no critical bugs and not needed a new release before beginning of July. I will be fixing tickets in milestone:1.6.1 for a new release on July. Thanks.