github-starred/better-auth
2
0
Fork 0
mirror of https://github.com/better-auth/better-auth.git synced 2026-05-22 22:32:01 -05:00
Code Issues 2.5k Packages Projects Releases 112 Wiki Activity

[GH-ISSUE #483] mysql: Syntax Error on SQL query #25611

New Issue
Closed
opened 2026-04-17 15:52:30 -05:00 by GiteaMirror · 0 comments
GiteaMirror commented 2026-04-17 15:52:30 -05:00
Owner
Copy Link

Originally created by @MrKepzie on GitHub (Nov 10, 2024).
Original GitHub issue: https://github.com/better-auth/better-auth/issues/483

Describe the bug

Using mysql database, whenever sending verification email, I get the following 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 'returning *' at line 1                                  Better Auth

  at Packet.asError (node_modules/mysql2/lib/packets/packet.js:738:17)
  at Query.execute (node_modules/mysql2/lib/commands/command.js:29:26)
  at PoolConnection.handlePacket (node_modules/mysql2/lib/connection.js:481:34)
  at PacketParser.onPacket (node_modules/mysql2/lib/connection.js:97:12)
  at PacketParser.executeStart (node_modules/mysql2/lib/packet_parser.js:75:16)
  at Socket.<anonymous> (node_modules/mysql2/lib/connection.js:104:25)
  at Socket.emit (node:events:519:28)
  at addChunk (node:internal/streams/readable:559:12)
  at readableAddChunkPushByteMode (node:internal/streams/readable:510:3)
  at Readable.push (node:internal/streams/readable:390:5)
  at MysqlConnection.executeQuery (node_modules/kysely/dist/esm/dialect/mysql/mysql-driver.js:116:41)
  at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
  at async node_modules/kysely/dist/esm/query-executor/query-executor-base.js:35:28
  at async DefaultConnectionProvider.provideConnection (node_modules/kysely/dist/esm/driver/default-connection-provider.js:10:20)
  at async DefaultQueryExecutor.executeQuery (node_modules/kysely/dist/esm/query-executor/query-executor-base.js:34:16)
  at async InsertQueryBuilder.execute (node_modules/kysely/dist/esm/query-builder/insert-query-builder.js:780:24)
  at async InsertQueryBuilder.executeTakeFirst (node_modules/kysely/dist/esm/query-builder/insert-query-builder.js:798:26)
  at async Object.create (node_modules/better-auth/dist/index.js:84:13801)
  at async i (node_modules/better-auth/dist/index.js:84:16919)
  at async Object.createVerificationValue (node_modules/better-auth/dist/index.js:84:22746)

The query being executed is:

"insert into verification (id, identifier, value, expiresAt) values (?, ?, ?, ?) returning *"

Originally created by @MrKepzie on GitHub (Nov 10, 2024). Original GitHub issue: https://github.com/better-auth/better-auth/issues/483 **Describe the bug** Using mysql database, whenever sending verification email, I get the following 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 'returning *' at line 1 Better Auth at Packet.asError (node_modules/mysql2/lib/packets/packet.js:738:17) at Query.execute (node_modules/mysql2/lib/commands/command.js:29:26) at PoolConnection.handlePacket (node_modules/mysql2/lib/connection.js:481:34) at PacketParser.onPacket (node_modules/mysql2/lib/connection.js:97:12) at PacketParser.executeStart (node_modules/mysql2/lib/packet_parser.js:75:16) at Socket.<anonymous> (node_modules/mysql2/lib/connection.js:104:25) at Socket.emit (node:events:519:28) at addChunk (node:internal/streams/readable:559:12) at readableAddChunkPushByteMode (node:internal/streams/readable:510:3) at Readable.push (node:internal/streams/readable:390:5) at MysqlConnection.executeQuery (node_modules/kysely/dist/esm/dialect/mysql/mysql-driver.js:116:41) at process.processTicksAndRejections (node:internal/process/task_queues:95:5) at async node_modules/kysely/dist/esm/query-executor/query-executor-base.js:35:28 at async DefaultConnectionProvider.provideConnection (node_modules/kysely/dist/esm/driver/default-connection-provider.js:10:20) at async DefaultQueryExecutor.executeQuery (node_modules/kysely/dist/esm/query-executor/query-executor-base.js:34:16) at async InsertQueryBuilder.execute (node_modules/kysely/dist/esm/query-builder/insert-query-builder.js:780:24) at async InsertQueryBuilder.executeTakeFirst (node_modules/kysely/dist/esm/query-builder/insert-query-builder.js:798:26) at async Object.create (node_modules/better-auth/dist/index.js:84:13801) at async i (node_modules/better-auth/dist/index.js:84:16919) at async Object.createVerificationValue (node_modules/better-auth/dist/index.js:84:22746) ``` The query being executed is: `"insert into `verification` (`id`, `identifier`, `value`, `expiresAt`) values (?, ?, ?, ?) returning *"`
GiteaMirror added the locked label 2026-04-17 15:52:30 -05:00
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
adapter
astro
awaiting external contributor
blocked
breaking
breaking change
bug
c-devops
core
credentials
database
dependencies
devops
devtools
docs
documentation
duplicate
elysia
enhancement
enterprise
expo
express
fastify
good first issue
help wanted
hono
identity
infra
integration
invalid
javascript
locked
maintenance
need-more-information
needs: info
needs: repro
nextjs
nuxt
oauth
organization
P0
payments
perf
platform
plugin
pull-request
Mirrored from GitHub Pull Request
 question
ready
regression
remix
security
social-provider
solid
stale
svelte
tanstack-start
tracking
version-bump
vue
wontfix
No Label locked
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
GiteaMirror ninjasurge
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/better-auth#25611
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?