Tried, Tested and Proven

Security Advisory 07-006 – The search parameters are vulnerable to SQL injection

Vulnerability discovery and development:

Portcullis Security Testing Services

Credit for Discovery:

Tim Brown – Portcullis Computer Security Ltd.

Affected Systems:

All known versions of Bandersnatch, this vulnerability was discovered for version 0.4.


SQL can be injected into multiple search parameters which will be executed when a user visits URLs containing these parameters. For example both of the URLs shown below have injection points: http://webserver/path/to/index.php?date=[injectionpoint] and http://webserver/path/to/index.php?limit=[injectionpoint].

By modifying these parameters which are passed during a request to the index.php, it is possible to cause error messages to be returned which indicates the presence of an SQL injection vulnerability. This is mitigated when PHP magic quotes are enabled, however Bandersnatch makes no attempt to validate that this is the case.


By injecting SQL functions, such as that described above an attacker could potentially gather information about the SQL server, the databases it holds and data held within these databases.


Exploit code is not required.

Vendor Status:

Vendor contacted.


Copyright © Portcullis Computer Security Limited 2007, All rights reserved worldwide.
Permission is hereby granted for the electronic redistribution of this information. It is not to be edited or altered in any way without the express written consent of Portcullis Computer Security Limited.


The information herein contained may change without notice. Use of this information constitutes acceptance for use in an AS IS condition. There are NO warranties, implied or otherwise, with regard to this information or its use. Any use of this information is at the user’s risk. In no event shall the author/distributor (Portcullis Computer Security Limited) be held liable for any damages whatsoever arising out of or in connection with the use or spread of this information.