Skip to content

Creating doesn't allow apostophres (SQL syntax error) #16

Description

@Crowbrammer
 a ca ss 28

Thank you for using the Autoscheduler.

Action, 'ss', added to the template named 'Hi'

Thank you again for using the autoscheduler. Have a nice day!

Choppy@Aaron MINGW64 /
$ a ca yoga 25

Thank you for using the Autoscheduler.

Action, 'yoga', added to the template named 'Hi'

Thank you again for using the autoscheduler. Have a nice day!

Choppy@Aaron MINGW64 /
$ a ca PC 15

Thank you for using the Autoscheduler.

Action, 'PC', added to the template named 'Hi'

Thank you again for using the autoscheduler. Have a nice day!

Choppy@Aaron MINGW64 /
$ a ca D3 15

Thank you for using the Autoscheduler.

Action, 'D3', added to the template named 'Hi'

Thank you again for using the autoscheduler. Have a nice day!

Choppy@Aaron MINGW64 /
$ a ca "ss - What I've done" 40
Error: ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual th
at corresponds to your MySQL server version for the right syntax to use near 've
 done', '40')' at line 1
    at Query.Sequence._packetToError (C:\Users\Choppy\Documents\Clutter\Coding\a
utoscheduler_CLI_v2\node_modules\mysql\lib\protocol\sequences\Sequence.js:47:14)
    at Query.ErrorPacket (C:\Users\Choppy\Documents\Clutter\Coding\autoscheduler
_CLI_v2\node_modules\mysql\lib\protocol\sequences\Query.js:79:18)
    at Protocol._parsePacket (C:\Users\Choppy\Documents\Clutter\Coding\autosched
uler_CLI_v2\node_modules\mysql\lib\protocol\Protocol.js:291:23)
    at Parser._parsePacket (C:\Users\Choppy\Documents\Clutter\Coding\autoschedul
er_CLI_v2\node_modules\mysql\lib\protocol\Parser.js:433:10)
    at Parser.write (C:\Users\Choppy\Documents\Clutter\Coding\autoscheduler_CLI_
v2\node_modules\mysql\lib\protocol\Parser.js:43:10)
    at Protocol.write (C:\Users\Choppy\Documents\Clutter\Coding\autoscheduler_CL
I_v2\node_modules\mysql\lib\protocol\Protocol.js:38:16)
    at Socket.<anonymous> (C:\Users\Choppy\Documents\Clutter\Coding\autoschedule
r_CLI_v2\node_modules\mysql\lib\Connection.js:88:28)
    at Socket.<anonymous> (C:\Users\Choppy\Documents\Clutter\Coding\autoschedule
r_CLI_v2\node_modules\mysql\lib\Connection.js:526:10)
    at Socket.emit (events.js:310:20)
    at addChunk (_stream_readable.js:286:12)
    --------------------
    at Protocol._enqueue (C:\Users\Choppy\Documents\Clutter\Coding\autoscheduler
_CLI_v2\node_modules\mysql\lib\protocol\Protocol.js:144:48)
    at Connection.query (C:\Users\Choppy\Documents\Clutter\Coding\autoscheduler_
CLI_v2\node_modules\mysql\lib\Connection.js:198:25)
    at C:\Users\Choppy\Documents\Clutter\Coding\autoscheduler_CLI_v2\node_module
s\prettyquery\index.js:254:29
    at new Promise (<anonymous>)
    at PQuery.query (C:\Users\Choppy\Documents\Clutter\Coding\autoscheduler_CLI_
v2\node_modules\prettyquery\index.js:253:16)
    at Action.create (C:\Users\Choppy\Documents\Clutter\Coding\autoscheduler_CLI
_v2\dest\models\Action.js:15:38)
    at Create.action (C:\Users\Choppy\Documents\Clutter\Coding\autoscheduler_CLI
_v2\dest\Autoscheduler.js:51:22)
    at CreateActionMessenger.message (C:\Users\Choppy\Documents\Clutter\Coding\a
utoscheduler_CLI_v2\dest\Messenger.js:46:36)
    at main (C:\Users\Choppy\Documents\Clutter\Coding\autoscheduler_CLI_v2\dest\
index.js:115:37)
    at processTicksAndRejections (internal/process/task_queues.js:97:5) {
  code: 'ER_PARSE_ERROR',
  errno: 1064,
  sqlMessage: "You have an error in your SQL syntax; check the manual that corre
sponds to your MySQL server version for the right syntax to use near 've done',
'40')' at line 1",
  sqlState: '42000',
  index: 0,
  sql: "INSERT INTO actions (name, duration) VALUES ('ss - What I've done', '40'
)"
}

Choppy@Aaron MINGW64 /
$ a ca "ss - What I\'ve done" 40

Thank you for using the Autoscheduler.

Action, 'ss - What I\'ve done', added to the template named 'Hi'

Thank you again for using the autoscheduler. Have a nice day!

Choppy@Aaron MINGW64 /
$ a ca "ss - What I've done" 40
Error: ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual th
at corresponds to your MySQL server version for the right syntax to use near '\'
ss - What I\'ve done\', \'40\')' at line 1
    at Query.Sequence._packetToError (C:\Users\Choppy\Documents\Clutter\Coding\a
utoscheduler_CLI_v2\node_modules\mysql\lib\protocol\sequences\Sequence.js:47:14)
    at Query.ErrorPacket (C:\Users\Choppy\Documents\Clutter\Coding\autoscheduler
_CLI_v2\node_modules\mysql\lib\protocol\sequences\Query.js:79:18)
    at Protocol._parsePacket (C:\Users\Choppy\Documents\Clutter\Coding\autosched
uler_CLI_v2\node_modules\mysql\lib\protocol\Protocol.js:291:23)
    at Parser._parsePacket (C:\Users\Choppy\Documents\Clutter\Coding\autoschedul
er_CLI_v2\node_modules\mysql\lib\protocol\Parser.js:433:10)
    at Parser.write (C:\Users\Choppy\Documents\Clutter\Coding\autoscheduler_CLI_
v2\node_modules\mysql\lib\protocol\Parser.js:43:10)
    at Protocol.write (C:\Users\Choppy\Documents\Clutter\Coding\autoscheduler_CL
I_v2\node_modules\mysql\lib\protocol\Protocol.js:38:16)
    at Socket.<anonymous> (C:\Users\Choppy\Documents\Clutter\Coding\autoschedule
r_CLI_v2\node_modules\mysql\lib\Connection.js:88:28)
    at Socket.<anonymous> (C:\Users\Choppy\Documents\Clutter\Coding\autoschedule
r_CLI_v2\node_modules\mysql\lib\Connection.js:526:10)
    at Socket.emit (events.js:310:20)
    at addChunk (_stream_readable.js:286:12)
    --------------------
    at Protocol._enqueue (C:\Users\Choppy\Documents\Clutter\Coding\autoscheduler
_CLI_v2\node_modules\mysql\lib\protocol\Protocol.js:144:48)
    at Connection.query (C:\Users\Choppy\Documents\Clutter\Coding\autoscheduler_
CLI_v2\node_modules\mysql\lib\Connection.js:198:25)
    at C:\Users\Choppy\Documents\Clutter\Coding\autoscheduler_CLI_v2\node_module
s\prettyquery\index.js:254:29
    at new Promise (<anonymous>)
    at PQuery.query (C:\Users\Choppy\Documents\Clutter\Coding\autoscheduler_CLI_
v2\node_modules\prettyquery\index.js:253:16)
    at Action.create (C:\Users\Choppy\Documents\Clutter\Coding\autoscheduler_CLI
_v2\dest\models\Action.js:16:38)
    at Create.action (C:\Users\Choppy\Documents\Clutter\Coding\autoscheduler_CLI
_v2\dest\Autoscheduler.js:51:22)
    at CreateActionMessenger.message (C:\Users\Choppy\Documents\Clutter\Coding\a
utoscheduler_CLI_v2\dest\Messenger.js:46:36)
    at main (C:\Users\Choppy\Documents\Clutter\Coding\autoscheduler_CLI_v2\dest\
index.js:115:37)
    at processTicksAndRejections (internal/process/task_queues.js:97:5) {
  code: 'ER_PARSE_ERROR',
  errno: 1064,
  sqlMessage: "You have an error in your SQL syntax; check the manual that corre
sponds to your MySQL server version for the right syntax to use near '\\'ss - Wh
at I\\'ve done\\', \\'40\\')' at line 1",
  sqlState: '42000',
  index: 0,
  sql: "INSERT INTO actions (name, duration) VALUES (\\'ss - What I\\'ve done\\'
, \\'40\\')"
}

Choppy@Aaron MINGW64 /
$ a ca D3 15
Error: ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual th
at corresponds to your MySQL server version for the right syntax to use near '\'
D3\', \'15\')' at line 1
    at Query.Sequence._packetToError (C:\Users\Choppy\Documents\Clutter\Coding\a
utoscheduler_CLI_v2\node_modules\mysql\lib\protocol\sequences\Sequence.js:47:14)
    at Query.ErrorPacket (C:\Users\Choppy\Documents\Clutter\Coding\autoscheduler
_CLI_v2\node_modules\mysql\lib\protocol\sequences\Query.js:79:18)
    at Protocol._parsePacket (C:\Users\Choppy\Documents\Clutter\Coding\autosched
uler_CLI_v2\node_modules\mysql\lib\protocol\Protocol.js:291:23)
    at Parser._parsePacket (C:\Users\Choppy\Documents\Clutter\Coding\autoschedul
er_CLI_v2\node_modules\mysql\lib\protocol\Parser.js:433:10)
    at Parser.write (C:\Users\Choppy\Documents\Clutter\Coding\autoscheduler_CLI_
v2\node_modules\mysql\lib\protocol\Parser.js:43:10)
    at Protocol.write (C:\Users\Choppy\Documents\Clutter\Coding\autoscheduler_CL
I_v2\node_modules\mysql\lib\protocol\Protocol.js:38:16)
    at Socket.<anonymous> (C:\Users\Choppy\Documents\Clutter\Coding\autoschedule
r_CLI_v2\node_modules\mysql\lib\Connection.js:88:28)
    at Socket.<anonymous> (C:\Users\Choppy\Documents\Clutter\Coding\autoschedule
r_CLI_v2\node_modules\mysql\lib\Connection.js:526:10)
    at Socket.emit (events.js:310:20)
    at addChunk (_stream_readable.js:286:12)
    --------------------
    at Protocol._enqueue (C:\Users\Choppy\Documents\Clutter\Coding\autoscheduler
_CLI_v2\node_modules\mysql\lib\protocol\Protocol.js:144:48)
    at Connection.query (C:\Users\Choppy\Documents\Clutter\Coding\autoscheduler_
CLI_v2\node_modules\mysql\lib\Connection.js:198:25)
    at C:\Users\Choppy\Documents\Clutter\Coding\autoscheduler_CLI_v2\node_module
s\prettyquery\index.js:254:29
    at new Promise (<anonymous>)
    at PQuery.query (C:\Users\Choppy\Documents\Clutter\Coding\autoscheduler_CLI_
v2\node_modules\prettyquery\index.js:253:16)
    at Action.create (C:\Users\Choppy\Documents\Clutter\Coding\autoscheduler_CLI
_v2\dest\models\Action.js:16:38)
    at Create.action (C:\Users\Choppy\Documents\Clutter\Coding\autoscheduler_CLI
_v2\dest\Autoscheduler.js:51:22)
    at CreateActionMessenger.message (C:\Users\Choppy\Documents\Clutter\Coding\a
utoscheduler_CLI_v2\dest\Messenger.js:46:36)
    at main (C:\Users\Choppy\Documents\Clutter\Coding\autoscheduler_CLI_v2\dest\
index.js:115:37)
    at processTicksAndRejections (internal/process/task_queues.js:97:5) {
  code: 'ER_PARSE_ERROR',
  errno: 1064,
  sqlMessage: "You have an error in your SQL syntax; check the manual that corre
sponds to your MySQL server version for the right syntax to use near '\\'D3\\',
\\'15\\')' at line 1",
  sqlState: '42000',
  index: 0,
  sql: "INSERT INTO actions (name, duration) VALUES (\\'D3\\', \\'15\\')"
}

Choppy@Aaron MINGW64 /
$ a ca D3 15

Thank you for using the Autoscheduler.

Action, 'D3', added to the template named 'Hi'

Thank you again for using the autoscheduler. Have a nice day!

Choppy@Aaron MINGW64 /
$ a cs
Error: ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual th
at corresponds to your MySQL server version for the right syntax to use near 've
 done', '2020-10-5 11:9:47', '2020-10-5 11:49:47', 4055)' at line 1
    at Query.Sequence._packetToError (C:\Users\Choppy\Documents\Clutter\Coding\a
utoscheduler_CLI_v2\node_modules\mysql\lib\protocol\sequences\Sequence.js:47:14)
    at Query.ErrorPacket (C:\Users\Choppy\Documents\Clutter\Coding\autoscheduler
_CLI_v2\node_modules\mysql\lib\protocol\sequences\Query.js:79:18)
    at Protocol._parsePacket (C:\Users\Choppy\Documents\Clutter\Coding\autosched
uler_CLI_v2\node_modules\mysql\lib\protocol\Protocol.js:291:23)
    at Parser._parsePacket (C:\Users\Choppy\Documents\Clutter\Coding\autoschedul
er_CLI_v2\node_modules\mysql\lib\protocol\Parser.js:433:10)
    at Parser.write (C:\Users\Choppy\Documents\Clutter\Coding\autoscheduler_CLI_
v2\node_modules\mysql\lib\protocol\Parser.js:43:10)
    at Protocol.write (C:\Users\Choppy\Documents\Clutter\Coding\autoscheduler_CL
I_v2\node_modules\mysql\lib\protocol\Protocol.js:38:16)
    at Socket.<anonymous> (C:\Users\Choppy\Documents\Clutter\Coding\autoschedule
r_CLI_v2\node_modules\mysql\lib\Connection.js:88:28)
    at Socket.<anonymous> (C:\Users\Choppy\Documents\Clutter\Coding\autoschedule
r_CLI_v2\node_modules\mysql\lib\Connection.js:526:10)
    at Socket.emit (events.js:310:20)
    at addChunk (_stream_readable.js:286:12)
    --------------------
    at Protocol._enqueue (C:\Users\Choppy\Documents\Clutter\Coding\autoscheduler
_CLI_v2\node_modules\mysql\lib\protocol\Protocol.js:144:48)
    at Connection.query (C:\Users\Choppy\Documents\Clutter\Coding\autoscheduler_
CLI_v2\node_modules\mysql\lib\Connection.js:198:25)
    at C:\Users\Choppy\Documents\Clutter\Coding\autoscheduler_CLI_v2\node_module
s\prettyquery\index.js:254:29
    at new Promise (<anonymous>)
    at PQuery.query (C:\Users\Choppy\Documents\Clutter\Coding\autoscheduler_CLI_
v2\node_modules\prettyquery\index.js:253:16)
    at Schedule.save (C:\Users\Choppy\Documents\Clutter\Coding\autoscheduler_CLI
_v2\dest\Schedule.js:70:43)
    at processTicksAndRejections (internal/process/task_queues.js:97:5)
    at async Create.schedule (C:\Users\Choppy\Documents\Clutter\Coding\autosched
uler_CLI_v2\dest\Autoscheduler.js:96:9)
    at async CreateScheduleMessenger.message (C:\Users\Choppy\Documents\Clutter\
Coding\autoscheduler_CLI_v2\dest\Messenger.js:139:25)
    at async main (C:\Users\Choppy\Documents\Clutter\Coding\autoscheduler_CLI_v2
\dest\index.js:115:21) {
  code: 'ER_PARSE_ERROR',
  errno: 1064,
  sqlMessage: "You have an error in your SQL syntax; check the manual that corre
sponds to your MySQL server version for the right syntax to use near 've done',
'2020-10-5 11:9:47', '2020-10-5 11:49:47', 4055)' at line 1",
  sqlState: '42000',
  index: 0,
  sql: "INSERT INTO events (summary, start, end, base_action_id) VALUES ('ss - W
hat I've done', '2020-10-5 11:9:47', '2020-10-5 11:49:47', 4055)"
}

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions