Skip to content

Instantly share code, notes, and snippets.

@Tjoosten
Created July 20, 2015 13:09
Show Gist options
  • Save Tjoosten/5679fcffce08719ec694 to your computer and use it in GitHub Desktop.
Save Tjoosten/5679fcffce08719ec694 to your computer and use it in GitHub Desktop.
query:
sql = "SELECT * FROM users WHERE password='"+ req.body.password +"' AND WHERE email='"+ req.body.email +"";
error slack
Error: ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE email='Topairy@gmail.com' at line 1
at Query.Sequence._packetToError (/Users/tim/WebstormProjects/untitled3/node_modules/mysql/lib/protocol/sequences/Sequence.js:48:14)
at Query.ErrorPacket (/Users/tim/WebstormProjects/untitled3/node_modules/mysql/lib/protocol/sequences/Query.js:83:18)
at Protocol._parsePacket (/Users/tim/WebstormProjects/untitled3/node_modules/mysql/lib/protocol/Protocol.js:274:23)
at Parser.write (/Users/tim/WebstormProjects/untitled3/node_modules/mysql/lib/protocol/Parser.js:77:12)
at Protocol.write (/Users/tim/WebstormProjects/untitled3/node_modules/mysql/lib/protocol/Protocol.js:39:16)
at Socket.<anonymous> (/Users/tim/WebstormProjects/untitled3/node_modules/mysql/lib/Connection.js:96:28)
at Socket.emit (events.js:95:17)
at Socket.<anonymous> (_stream_readable.js:764:14)
at Socket.emit (events.js:92:17)
at emitReadable_ (_stream_readable.js:426:10)
--------------------
at Protocol._enqueue (/Users/tim/WebstormProjects/untitled3/node_modules/mysql/lib/protocol/Protocol.js:135:48)
at Connection.query (/Users/tim/WebstormProjects/untitled3/node_modules/mysql/lib/Connection.js:201:25)
at router.get.variables.title (/Users/tim/WebstormProjects/untitled3/routes/authencation.js:22:16)
at Layer.handle [as handle_request] (/Users/tim/WebstormProjects/untitled3/node_modules/express/lib/router/layer.js:95:5)
at next (/Users/tim/WebstormProjects/untitled3/node_modules/express/lib/router/route.js:131:13)
at Route.dispatch (/Users/tim/WebstormProjects/untitled3/node_modules/express/lib/router/route.js:112:3)
at Layer.handle [as handle_request] (/Users/tim/WebstormProjects/untitled3/node_modules/express/lib/router/layer.js:95:5)
at /Users/tim/WebstormProjects/untitled3/node_modules/express/lib/router/index.js:277:22
at Function.process_params (/Users/tim/WebstormProjects/untitled3/node_modules/express/lib/router/index.js:330:12)
at next (/Users/tim/WebstormProjects/untitled3/node_modules/express/lib/router/index.js:271:10)
Process finished with exit code 8
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment