Waraxe IT Security Portal
Login or Register
December 11, 2024
Menu
Home
Logout
Discussions
Forums
Members List
IRC chat
Tools
Base64 coder
MD5 hash
CRC32 checksum
ROT13 coder
SHA-1 hash
URL-decoder
Sql Char Encoder
Affiliates
y3dips ITsec
Md5 Cracker
User Manuals
AlbumNow
Content
Content
Sections
FAQ
Top
Info
Feedback
Recommend Us
Search
Journal
Your Account
User Info
Welcome, Anonymous
Nickname
Password
(Register)

Membership:
Latest: MichaelSnaRe
New Today: 0
New Yesterday: 0
Overall: 9144

People Online:
Visitors: 128
Members: 0
Total: 128
Full disclosure
SEC Consult SA-20241204-0 :: Multiple Critical Vulnerabilities in Image Access Scan2Net (14 CVE)
Microsoft Warbird and PMP security research - technical doc
Access Control in Paxton Net2 software
SEC Consult SA-20241127-0 :: Stored Cross-Site Scripting in Omada Identity (CVE-2024-52951)
SEC Consult SA-20241125-0 :: Unlocked JTAG interface and buffer overflow in Siemens SM-2558 Protocol Element, Siemens CP-2016 & CP-2019
Re: Local Privilege Escalations in needrestart
APPLE-SA-11-19-2024-5 macOS Sequoia 15.1.1
Local Privilege Escalations in needrestart
APPLE-SA-11-19-2024-4 iOS 17.7.2 and iPadOS 17.7.2
APPLE-SA-11-19-2024-3 iOS 18.1.1 and iPadOS 18.1.1
APPLE-SA-11-19-2024-2 visionOS 2.1.1
APPLE-SA-11-19-2024-1 Safari 18.1.1
Reflected XSS - fronsetiav1.1
XXE OOB - fronsetiav1.1
St. Poelten UAS | Path Traversal in Korenix JetPort 5601
Log in Register Forum FAQ Memberlist Search
IT Security and Insecurity Portal

www.waraxe.us Forum Index -> Sql injection -> Missing Operator in query error.
Post new topicReply to topic View previous topic :: View next topic
Missing Operator in query error.
PostPosted: Sun Feb 21, 2010 4:29 pm Reply with quote
dasatti
Regular user
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
View user's profile Send private message
PostPosted: Sun Feb 21, 2010 5:26 pm Reply with quote
vince213333
Advanced user
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 Smile
View user's profile Send private message
PostPosted: Tue Feb 23, 2010 4:18 pm Reply with quote
dasatti
Regular user
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
View user's profile Send private message
PostPosted: Tue Feb 23, 2010 5:22 pm Reply with quote
waraxe
Site admin
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.
View user's profile Send private message Send e-mail Visit poster's website
Missing Operator in query error.
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

Post new topicReply to topic


Powered by phpBB © 2001-2008 phpBB Group



Space Raider game for Android, free download - Space Raider gameplay video - Zone Raider mobile games
All logos and trademarks in this site are property of their respective owner. The comments and posts are property of their posters, all the rest (c) 2004-2024 Janek Vind "waraxe"
Page Generation: 0.046 Seconds