Error loading relation - EL_PARSE_ERROR

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)