Skip to content

GitLab

  • Menu
Projects Groups Snippets
    • Loading...
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in / Register
  • A azeero.group
  • Project information
    • Project information
    • Activity
    • Labels
    • Members
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
  • Issues 40
    • Issues 40
    • List
    • Boards
    • Service Desk
    • Milestones
  • Deployments
    • Deployments
    • Releases
  • Packages & Registries
    • Packages & Registries
    • Infrastructure Registry
  • Activity
  • Graph
  • Create a new issue
  • Commits
  • Issue Boards
Collapse sidebar
  • Oliver
  • azeero.group
  • Issues
  • #344

Closed
Open
Created May 12, 2020 by Oliver@ohonigMaintainer

AddableOrders could not be retrieved

{"time":"2020-5-12 10:56:14","errorCode":"SEQUELIZE_ERROR","message":"AddableOrders could not be retrieved","prevError":{"name":"SequelizeDatabaseError","parent":{"code":"ER_PARSE_ERROR","errno":1064,"sqlState":"42000","sqlMessage":"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 '' at line 3","sql":"select seq_id as id, createdAt as date, price from order_info oi\n    \t left join prder_product_details opd on opd.forderinfo_seq_id = oi.seq_id\n    \t  where oi.sum_order_status_kz = \"NEU\" and fperson_contact_seq_id = 119 and opd.receipt_number IS NULL and"},"original":{"code":"ER_PARSE_ERROR","errno":1064,"sqlState":"42000","sqlMessage":"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 '' at line 3","sql":"select seq_id as id, createdAt as date, price from order_info oi\n    \t left join prder_product_details opd on opd.forderinfo_seq_id = oi.seq_id\n    \t  where oi.sum_order_status_kz = \"NEU\" and fperson_contact_seq_id = 119 and opd.receipt_number IS NULL and"},"sql":"select seq_id as id, createdAt as date, price from order_info oi\n    \t left join prder_product_details opd on opd.forderinfo_seq_id = oi.seq_id\n    \t  where oi.sum_order_status_kz = \"NEU\" and fperson_contact_seq_id = 119 and opd.receipt_number IS NULL and"},"route":"/addableOrders"}

und Folgefehler:

2020-5-12 11:09:30:  Konnte Email mit Fehlern nicht speichern. DatabaseError [SequelizeDatabaseError]: Data too long for column 'template_params' at row 1
    at Query.formatError (/home/ohonig/azeero.group/server/node_modules/sequelize/lib/dialects/mysql/query.js:247:16)
    at Query.handler [as onResult] (/home/ohonig/azeero.group/server/node_modules/sequelize/lib/dialects/mysql/query.js:68:23)
    at Query.execute (/home/ohonig/azeero.group/server/node_modules/mysql2/lib/commands/command.js:30:14)
    at Connection.handlePacket (/home/ohonig/azeero.group/server/node_modules/mysql2/lib/connection.js:417:32)
    at PacketParser.onPacket (/home/ohonig/azeero.group/server/node_modules/mysql2/lib/connection.js:75:12)
    at PacketParser.executeStart (/home/ohonig/azeero.group/server/node_modules/mysql2/lib/packet_parser.js:75:16)
    at Socket.<anonymous> (/home/ohonig/azeero.group/server/node_modules/mysql2/lib/connection.js:82:25)
    at Socket.emit (events.js:210:5)
    at addChunk (_stream_readable.js:308:12)
    at readableAddChunk (_stream_readable.js:289:11)
    at Socket.Readable.push (_stream_readable.js:223:10)
    at TCP.onStreamRead (internal/stream_base_commons.js:182:23) {
  name: 'SequelizeDatabaseError',
  parent: Error: Data too long for column 'template_params' at row 1
      at Packet.asError (/home/ohonig/azeero.group/server/node_modules/mysql2/lib/packets/packet.js:712:17)
      at Query.execute (/home/ohonig/azeero.group/server/node_modules/mysql2/lib/commands/command.js:28:26)
      at Connection.handlePacket (/home/ohonig/azeero.group/server/node_modules/mysql2/lib/connection.js:417:32)
      at PacketParser.onPacket (/home/ohonig/azeero.group/server/node_modules/mysql2/lib/connection.js:75:12)
      at PacketParser.executeStart (/home/ohonig/azeero.group/server/node_modules/mysql2/lib/packet_parser.js:75:16)
      at Socket.<anonymous> (/home/ohonig/azeero.group/server/node_modules/mysql2/lib/connection.js:82:25)
      at Socket.emit (events.js:210:5)
      at addChunk (_stream_readable.js:308:12)
      at readableAddChunk (_stream_readable.js:289:11)
      at Socket.Readable.push (_stream_readable.js:223:10)
      at TCP.onStreamRead (internal/stream_base_commons.js:182:23) {
    code: 'ER_DATA_TOO_LONG',
    errno: 1406,
    sqlState: '22001',
    sqlMessage: "Data too long for column 'template_params' at row 1",
Assignee
Assign to
Time tracking