Edgewall Software

Opened 9 years ago

Closed 9 years ago

#11143 closed defect (invalid)

ProgrammingError: invalid input syntax for integer: "trac.wiki.api.WikiSystem.pages"

Reported by: eap@… Owned by:
Priority: high Milestone:
Component: general Version: 0.12.3
Severity: normal Keywords:
Cc: Branch:
Release Notes:
API Changes:
Internal Changes:


How to Reproduce

While doing a GET operation on /wiki, Trac issued an internal error.

Upon upgrading from Trac 0.12 to Trac 1.0.1 we are getting this ProgrammingError when visiting the Wiki

Request parameters:


User agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_3) AppleWebKit/536.28.10 (KHTML, like Gecko) Version/6.0.3 Safari/536.28.10

System Information

Trac 0.12.3
Genshi 0.6
mod_python 3.3.1
psycopg2 2.0.6
Pygments 0.9
Python 2.5.2 (r252:60911, Jan 20 2010, 22:05:59)
[GCC 4.2.4 (Ubuntu 4.2.4-1ubuntu3)]
RPC 1.1.2
setuptools 0.6c12
Subversion 1.4.6 (r28521)
jQuery 1.4.4

Enabled Plugins

BatchModify 0.8.0-trac0.12
TestManager 1.4.6
TracCustomFieldAdmin 0.2.8-r11409
TracGenericClass 1.0.6
TracGenericWorkflow 1.0.2
TracXMLRPC 1.1.2

Python Traceback

Traceback (most recent call last):
  File "build/bdist.linux-i686/egg/trac/web/main.py", line 522, in _dispatch_request
  File "build/bdist.linux-i686/egg/trac/web/main.py", line 243, in dispatch
    resp = chosen_handler.process_request(req)
  File "build/bdist.linux-i686/egg/trac/wiki/web_ui.py", line 173, in process_request
    return self._render_view(req, versioned_page)
  File "build/bdist.linux-i686/egg/trac/wiki/web_ui.py", line 625, in _render_view
    for template in ws.get_pages(prefix)
  File "build/bdist.linux-i686/egg/trac/wiki/api.py", line 248, in get_pages
    for page in self.pages:
  File "build/bdist.linux-i686/egg/trac/cache.py", line 38, in __get__
    return CacheManager(instance.env).get(id, self.retriever, instance)
  File "build/bdist.linux-i686/egg/trac/cache.py", line 157, in get
    cursor.execute("SELECT generation FROM cache WHERE id=%s", (id,))
  File "build/bdist.linux-i686/egg/trac/db/util.py", line 65, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
ProgrammingError: invalid input syntax for integer: "trac.wiki.api.WikiSystem.pages"

Attachments (0)

Change History (2)

comment:1 by eap@…, 9 years ago

All pages on the Wiki return this error.

comment:2 by anonymous, 9 years ago

Resolution: invalid
Status: newclosed

Fixed after restarting apache for a second time.

Modify Ticket

Change Properties
Set your email in Preferences
as closed The ticket will remain with no owner.
The resolution will be deleted. Next status will be 'reopened'.
to The owner will be changed from (none) to the specified user.

Add Comment

E-mail address and name can be saved in the Preferences .
Note: See TracTickets for help on using tickets.