Waraxe IT Security Portal
Login or Register
October 20, 2025
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: 295
Members: 0
Total: 295
Full disclosure
CyberDanube Security Research 20251014-0 | Multiple Vulnerabilities in Phoenix Contact QUINT4 UPS
apis.google.com - Insecure redirect via __lu parameter(exploited in the wild)
Urgent Security Vulnerabilities Discovered in Mercku Routers Model M6a
Re: Security Advisory: Multiple High-Severity Vulnerabilities in Suno.com (JWT Leakage, IDOR, DoS)
Security Advisory: Multiple High-Severity Vulnerabilities in Suno.com (JWT Leakage, IDOR, DoS)
[SBA-ADV-20250730-01] CVE-2025-39664: Checkmk Path Traversal
[SBA-ADV-20250724-01] CVE-2025-32919: Checkmk Agent Privilege Escalation via Insecure Temporary Files
CVE-2025-59397 - Open Web Analytics SQL Injection
Re: [FD]Full Disclosure: CVE-2025-31200 & CVE-2025-31201 – 0-Click iMessage Chain ? Secure Enclave Key Theft, Wormable RCE, Crypto Theft
Re: Full Disclosure: CVE-2025-31200 & CVE-2025-31201 – 0-Click iMessage Chain ? Secure Enclave Key Theft, Wormable RCE, Crypto Theft
Re: Defense in depth -- the Microsoft way (part 93): SRP/SAFERwhitelisting goes black on Windows 11
Re: [FD]: "Glass Cage" – Zero-Click iMessage ? Persistent iOS Compromise + Bricking (CVE-2025-24085 / 24201, CNVD-2025-07885)
Re: [FD]Full Disclosure: CVE-2025-31200 & CVE-2025-31201 – 0-Click iMessage Chain ? Secure Enclave Key Theft, Wormable RCE, Crypto Theft
Samtools v1.22.1 Uncontrolled Memory Allocation from Large BED Intervals Causes Denial-of-Service in Samtools/HTSlib
Samtools v1.22.1 Improper Handling of Excessive Histogram Bin Counts in Samtools Coverage Leads to Stack Overflow
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



PCWizardHub - Helping you fix, build, and optimize your PC life
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.025 Seconds