Bug 169785 - errata system cannot handle apostrophes in comment field
Summary: errata system cannot handle apostrophes in comment field
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Fedora Infrastructure
Classification: Retired
Component: update system
Version: unspecified
Hardware: All
OS: Linux
medium
medium
Target Milestone: ---
Assignee: Luke Macken
QA Contact: Bill Nottingham
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2005-10-03 16:23 UTC by William Cohen
Modified: 2016-09-20 02:36 UTC (History)
3 users (show)

Fixed In Version: 1.0
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2005-10-03 16:40:42 UTC
Embargoed:

Attachments (Terms of Use)

Description William Cohen 2005-10-03 16:23:22 UTC 
Description of problem:

The comment field for errata cannot handle apostrophes.


Version-Release number of selected component (if applicable):


How reproducible:

Every time.


Steps to Reproduce:
1. Select and errata, for example
https://porkchop.devel.redhat.com/fedora-updates/show.py?pkg=systemtap-0.3-1&update=Testing

2. In the comments field put in a appostrophe ("'" no quotes around it)
3. Press the "Add Comment" button
  
Actual results:
Mod_python error: "PythonHandler mod_python.publisher"

Traceback (most recent call last):

  File
"/usr/src/build/513032-i386/install/usr/lib/python2.2/site-packages/mod_python/apache.py",
line 332, in HandlerDispatch

  File
"/usr/src/build/513032-i386/install/usr/lib/python2.2/site-packages/mod_python/publisher.py",
line 199, in handler

  File "/mnt/redhat/fedora-updates/comment.py", line 27, in index
    db.query("""

  File "/mnt/redhat/fedora-updates/db.py", line 80, in query
    result = db.query(q)

_pg.error: ERROR:  parser: parse error at or near "wcohen" at character 157

Expected results:

The comment would be added without error


Additional info:
Comment 1 Luke Macken 2005-10-03 16:40:42 UTC 
Fixed.
Note You need to log in before you can comment on or make changes to this bug.