Random Mysql Error in logs, does not seem to affect function
Hello,
I was just checking my logs when I found an error. my instance seems to be working fine so i am not sure where the problem could be.
sql: SELECT event
.id
, event
.title
, event
.slug
, event
.description
, event
.multidate
, event
.start_datetime
, event
.end_datetime
, event
.image_path
, event
.media
, event
.is_visible
, event
.recurrent
, event
.likes
, event
.boost
, event
.online_locations
, event
.createdAt
, event
.updatedAt
, event
.placeId
, event
.userId
, event
.parentId
, tags
.tag
AS tags.tag
, tags
.createdAt
AS tags.createdAt
, tags
.updatedAt
AS tags.updatedAt
, tags->event_tags
.createdAt
AS tags.event_tags.createdAt
, tags->event_tags
.updatedAt
AS tags.event_tags.updatedAt
, tags->event_tags
.eventId
AS tags.event_tags.eventId
, tags->event_tags
.tagTag
AS tags.event_tags.tagTag
, child
.id
AS child.id
, child
.title
AS child.title
, child
.slug
AS child.slug
, child
.description
AS child.description
, child
.multidate
AS child.multidate
, child
.start_datetime
AS child.start_datetime
, child
.end_datetime
AS child.end_datetime
, child
.image_path
AS child.image_path
, child
.media
AS child.media
, child
.is_visible
AS child.is_visible
, child
.recurrent
AS child.recurrent
, child
.likes
AS child.likes
, child
.boost
AS child.boost
, child
.online_locations
AS child.online_locations
, child
.createdAt
AS child.createdAt
, child
.updatedAt
AS child.updatedAt
, child
.placeId
AS child.placeId
, child
.userId
AS child.userId
, child
.parentId
AS child.parentId
FROM events
AS event
LEFT OUTER JOIN ( event_tags
AS tags->event_tags
INNER JOIN tags
AS tags
ON tags
.tag
= tags->event_tags
.tagTag
) ON event
.id
= tags->event_tags
.eventId
LEFT OUTER JOIN events
AS child
ON event
.id
= child
.parentId
AND child
.start_datetime
>= NaN WHERE event
.is_visible
= true AND event
.recurrent
IS NOT NULL ORDER BY child
.start_datetime
DESC; - parameters:[] Error
at Query.run (/usr/local/share/.config/yarn/global/node_modules/sequelize/lib/dialects/mariadb/query.js:53:25)
at /usr/local/share/.config/yarn/global/node_modules/sequelize/lib/sequelize.js:315:28
at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
at async MySQLQueryInterface.select (/usr/local/share/.config/yarn/global/node_modules/sequelize/lib/dialects/abstract/query-interface.js:407:12)
at async event.findAll (/usr/local/share/.config/yarn/global/node_modules/sequelize/lib/model.js:1140:21)
at async Task._createRecurrent [as method] (/usr/local/share/.config/yarn/global/node_modules/gancio/server/api/controller/event.js:753:20)