System Information
- Strapi Version: 3.4.5
- Operating System: mac OS Big Sur 11.1
- Database: MySQL
- Node Version: 14.5.1
- NPM Version: 6.14.8
- Yarn Version: 1.22.10
I have the content type product with a field relation to collection-type product_types. (One product has one product_type).
When I try to assign a product_type to a product, the created product_types won’t load and it just infinite loads.
[2021-01-29T01:19:42.059Z] error Error: select distinct `product_types`.* from `product_types` where `product_types`.`id` not in ({}) limit 20 - 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 ') limit 20' at line 1
at Query.Sequence._packetToError (/Users/joshuaolberg/Workspace/elbDevProjects/santras/santras-cms/node_modules/mysql/lib/protocol/sequences/Sequence.js:47:14)
at Query.ErrorPacket (/Users/joshuaolberg/Workspace/elbDevProjects/santras/santras-cms/node_modules/mysql/lib/protocol/sequences/Query.js:79:18)
at Protocol._parsePacket (/Users/joshuaolberg/Workspace/elbDevProjects/santras/santras-cms/node_modules/mysql/lib/protocol/Protocol.js:291:23)
at Parser._parsePacket (/Users/joshuaolberg/Workspace/elbDevProjects/santras/santras-cms/node_modules/mysql/lib/protocol/Parser.js:433:10)
at Parser.write (/Users/joshuaolberg/Workspace/elbDevProjects/santras/santras-cms/node_modules/mysql/lib/protocol/Parser.js:43:10)
at Protocol.write (/Users/joshuaolberg/Workspace/elbDevProjects/santras/santras-cms/node_modules/mysql/lib/protocol/Protocol.js:38:16)
at Socket.<anonymous> (/Users/joshuaolberg/Workspace/elbDevProjects/santras/santras-cms/node_modules/mysql/lib/Connection.js:88:28)
at Socket.<anonymous> (/Users/joshuaolberg/Workspace/elbDevProjects/santras/santras-cms/node_modules/mysql/lib/Connection.js:526:10)
at Socket.emit (events.js:315:20)
at Socket.EventEmitter.emit (domain.js:486:12)
at addChunk (_stream_readable.js:309:12)
at readableAddChunk (_stream_readable.js:284:9)
at Socket.Readable.push (_stream_readable.js:223:10)
at TCP.onStreamRead (internal/stream_base_commons.js:188:23)
at Protocol._enqueue (/Users/joshuaolberg/Workspace/elbDevProjects/santras/santras-cms/node_modules/mysql/lib/protocol/Protocol.js:144:48)
at Connection.query (/Users/joshuaolberg/Workspace/elbDevProjects/santras/santras-cms/node_modules/mysql/lib/Connection.js:198:25)
at /Users/joshuaolberg/Workspace/elbDevProjects/santras/santras-cms/node_modules/knex/lib/dialects/mysql/index.js:134:18
at new Promise (<anonymous>)
at Client_MySQL._query (/Users/joshuaolberg/Workspace/elbDevProjects/santras/santras-cms/node_modules/knex/lib/dialects/mysql/index.js:128:12)
at Client_MySQL.query (/Users/joshuaolberg/Workspace/elbDevProjects/santras/santras-cms/node_modules/knex/lib/client.js:168:17)
at Runner.query (/Users/joshuaolberg/Workspace/elbDevProjects/santras/santras-cms/node_modules/knex/lib/runner.js:151:36)
at /Users/joshuaolberg/Workspace/elbDevProjects/santras/santras-cms/node_modules/knex/lib/runner.js:40:23
at /Users/joshuaolberg/Workspace/elbDevProjects/santras/santras-cms/node_modules/knex/lib/runner.js:277:24
From previous event:
at processImmediate (internal/timers.js:461:21)
From previous event:
at Sync.<anonymous> (/Users/joshuaolberg/Workspace/elbDevProjects/santras/santras-cms/node_modules/bookshelf/lib/sync.js:204:8)
From previous event:
at Child.<anonymous> (/Users/joshuaolberg/Workspace/elbDevProjects/santras/santras-cms/node_modules/bookshelf/lib/collection.js:160:12)
From previous event:
at Child.fetchAll (/Users/joshuaolberg/Workspace/elbDevProjects/santras/santras-cms/node_modules/bookshelf/lib/model.js:878:10)
at Object.find (/Users/joshuaolberg/Workspace/elbDevProjects/santras/santras-cms/node_modules/strapi-connector-bookshelf/lib/queries.js:79:8)
at fn (/Users/joshuaolberg/Workspace/elbDevProjects/santras/santras-cms/node_modules/strapi-database/lib/queries/helpers.js:31:54)
at Object.find (/Users/joshuaolberg/Workspace/elbDevProjects/santras/santras-cms/node_modules/strapi-database/lib/queries/helpers.js:15:24)
at processTicksAndRejections (internal/process/task_queues.js:93:5)
[Error] Failed to load resource: the server responded with a status of 500 (Internal Server Error) (product_type, line 0)
The database is a MySQL Database hosted on AWS RDS (MySQL Major Engine Version 8.0)