#2689: DataError: invalid input syntax for integer: "263,264,265,266,267"LINE 1:
... WHERE status='pending' AND id>263 AND id NOT IN (E'263,264,...
^
--------------------------+-------------------------------------
Reporter: cybersphinx | Owner: Fastdeath
Type: bug | Status: new
Priority: normal | Milestone: unspecified
Component: Website | Version: unspecified
Keywords: | Operating System: All/Non-Specific
Blocked By: | Blocking:
--------------------------+-------------------------------------
==== How to Reproduce ====
While doing a POST operation on `/moderator`, Trac issued an internal
error.
Tried to approve several moderated tickets/comments at once.
Request parameters:
{{{
{'__FORM_TOKEN': u'6618a397de63fb778f219678',
'button_accept': u'Accept Selected',
'checkall': u'on',
'id': [263, 264, 265, 266, 267]}
}}}
User agent: `Mozilla/5.0 (X11; Linux x86_64; rv:2.0.1) Gecko/20100101
Firefox/4.0.1`
==== System Information ====
|| '''`Trac`''' || `0.12.1` ||
|| '''`Genshi`''' || `0.6` ||
|| '''`GIT`''' || `1.7.5` ||
|| '''`psycopg2`''' || `2.4` ||
|| '''`Pygments`''' || `1.4` ||
|| '''`Python`''' || `2.6.5 (r265:79063, Apr 16 2010, 13:57:41) ` [[br]]
`[GCC 4.4.3]` ||
|| '''`RPC`''' || `1.0.6` ||
|| '''`setuptools`''' || `0.6` ||
|| '''`Subversion`''' || `1.6.6 (r40053)` ||
|| '''`jQuery`''' || `1.4.2` ||
==== Enabled Plugins ====
|| '''`BlackMagicTicketTweaks`''' || `0.12r1` ||
|| '''`changelog`''' || `N/A` ||
|| '''`codetags`''' || `0.3-0.12` ||
|| '''`GithubPlugin`''' || `0.4` ||
|| '''`PhpBBAuth`''' || `0.2` ||
|| '''`TicketNotifications`''' || `0.1-r0` ||
|| '''`TracAccountManager`''' || `0.2.1dev-r7163` ||
|| '''`TracCia`''' || `0.3.9` ||
|| '''`TracGit`''' || `0.12.0.5dev` ||
|| '''`TracHTTPAuth`''' || `1.1` ||
|| '''`TracHttpOnlyAuthCookie`''' || `N/A` ||
|| '''`TracIncludeMacro`''' || `2.1` ||
|| '''`TracPhpBBCookieAuth`''' || `N/A` ||
|| '''`TracSpamFilter`''' || `0.4.7dev-r10633` ||
|| '''`TracTicketDelete`''' || `2.0` ||
|| '''`TracTicketModerator`''' || `0.6.2` ||
|| '''`TracTocMacro`''' || `11.0.0.3` ||
|| '''`TracXMLRPC`''' || `1.0.6` ||
==== Python Traceback ====
{{{
Traceback (most recent call last):
File "/usr/local/lib/python2.6/dist-packages/trac/web/main.py", line
511, in _dispatch_request
dispatcher.dispatch(req)
File "/usr/local/lib/python2.6/dist-packages/trac/web/main.py", line
237, in dispatch
resp = chosen_handler.process_request(req)
File
"/var/www/vhosts/warzone/domains/developer.wz2100.net/trac/plugins/TracTicketModerator-0.6.2-py2.6.egg/ticketmoderator/web_ui.py",
line 146, in process_request
( min(ids), ','.join([str(x) for x in ids]), ) )
File "/usr/local/lib/python2.6/dist-packages/trac/db/util.py", line 65,
in execute
return self.cursor.execute(sql_escape_percent(sql), args)
DataError: invalid input syntax for integer: "263,264,265,266,267"
LINE 1: ... WHERE status='pending' AND id>263 AND id NOT IN (E'263,264,...
^
}}}
--
Ticket URL: <http://developer.wz2100.net/ticket/2689>
Warzone 2100 Trac <http://developer.wz2100.net/>
The Warzone 2100 Project
_______________________________________________
Warzone-dev mailing list
[email protected]
https://mail.gna.org/listinfo/warzone-dev
